test_db
A sample MySQL database with an integrated test suite, used to test your applications and database servers (by datacharmer)
bh_aust_postcode
A single endpoint web API to search for Australian postcodes based on locality aka suburb. (by behai-nguyen)
| test_db | bh_aust_postcode | |
|---|---|---|
| 12 | 1 | |
| 3,872 | 1 | |
| - | - | |
| 1.7 | 7.1 | |
| about 2 months ago | 10 months ago | |
| Shell | Python | |
| - | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
test_db
Posts with mentions or reviews of test_db.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-09-21.
-
SQL Database Index Basics
For this tutorial I am using a sample database available from https://github.com/datacharmer/test_db.
-
Docker on Ubuntu 22.10: running mysql:8.0.34-debian with custom config, socket, database and log files reside on host machine.
We will use the employees Oracle Corporation MySQL test data database.
-
Rust & MySQL: executing MySQL stored procedures which return multiple result sets using crate sqlx.
We'll use the same Oracle Corporation MySQL test data database. This time, we'll use the departments and the dept_manager tables.
- I'm getting WinError 32 when trying to run a file.
-
Python: executing PostgreSQL stored functions which return multiple result sets.
To recap, the source database is the MySQL test data released by Oracle Corporation. Downloadable from https://github.com/datacharmer/test_db. I've migrated it over to PostgreSQL as discussed in pgloader Docker: migrating from Docker & localhost MySQL to localhost PostgreSQL, please see command ❷.
-
pgloader Docker: migrating from Docker & localhost MySQL to localhost PostgreSQL.
The employees database is a MySQL test data database released by Oracle Corporation. Downloadable from https://github.com/datacharmer/test_db. It is a simple database with only a few tables, easy to setup. The main tables have several hundreds thousand records, which is very good for testing purposes.
-
Python: executing MySQL stored procedures which return multiple result sets.
The source database is the MySQL test data released by Oracle Corporation. Downloadable from https://github.com/datacharmer/test_db. It is a simple database with only a few tables, easy to setup.
-
Streaming Large JSON Response in Spring.
As a sample data set i am using datacharmer/test_db. It has following tables
- Fellow unemployed SREs/DevOps Engineers, what projects are you working on at the moment to stay busy? How do you keep yourself motivated to learn new things?
-
Optimizing your MySQL queries
The database we'll use here is the employees db from MySQL itself. This repo has a docker-compose setup on how to start and run the database so you can run the commands along.
bh_aust_postcode
Posts with mentions or reviews of bh_aust_postcode.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-09-21.
-
Docker on Ubuntu 22.10: running mysql:8.0.34-debian with custom config, socket, database and log files reside on host machine.
Python, Flask: Railway.app deployment and Railway's Nixpacks Docker image build tool. -- I've successfully deployed my Australian postcodes API project to https://railway.app. I did have some problem during deployment. I'm describing how I've addressed this problem. In the process, we're also covering the following: ⓵ running Railway's own Nixpacks Docker build tool locally on Ubuntu 22.10. ⓶ Override the Nixpacks-built Docker image's CMD: we look at three (3) ways to run the Flask CLI command venv/bin/flask update-postcode, and similarly, we look at how to override the start command gunicorn wsgi:app --preload specified in the Nixpacks required Procfile.
What are some alternatives?
When comparing test_db and bh_aust_postcode you can also consider the following projects:
db-samples - Northwind sample database for MySql, PostgresQL etc.
templates - Railway starters
sample-database - This is a sample database used for my SQL course on Udemy.
Jackson - Core part of Jackson that defines Streaming API as well as basic shared abstractions
rust - Empowering everyone to build reliable and efficient software.
mysql-example
stream-json-response