test_db
A sample MySQL database with an integrated test suite, used to test your applications and database servers (by datacharmer)
sample-database
This is a sample database used for my SQL course on Udemy. (by michaljuhas)
| test_db | sample-database | |
|---|---|---|
| 12 | 1 | |
| 3,872 | 19 | |
| - | - | |
| 1.7 | 10.0 | |
| about 2 months ago | about 6 years ago | |
| Shell | Shell | |
| - | 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.
sample-database
Posts with mentions or reviews of sample-database.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-09-23.
What are some alternatives?
When comparing test_db and sample-database you can also consider the following projects:
db-samples - Northwind sample database for MySql, PostgresQL etc.
Jackson - Core part of Jackson that defines Streaming API as well as basic shared abstractions
bh_aust_postcode - A single endpoint web API to search for Australian postcodes based on locality aka suburb.
rust - Empowering everyone to build reliable and efficient software.
mysql-example
stream-json-response