test_db
db-samples
| test_db | db-samples | |
|---|---|---|
| 12 | 1 | |
| 3,872 | 119 | |
| - | - | |
| 1.7 | 2.6 | |
| about 2 months ago | over 3 years ago | |
| Shell | JavaScript | |
| - | - |
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
-
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.
db-samples
What are some alternatives?
sample-database - This is a sample database used for my SQL course on Udemy.
MikroORM - TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, MS SQL Server, PostgreSQL and SQLite/libSQL databases.
Jackson - Core part of Jackson that defines Streaming API as well as basic shared abstractions
denodb - MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
bh_aust_postcode - A single endpoint web API to search for Australian postcodes based on locality aka suburb.
LifeLog - CGI web application written in the perl language using an local SQLite database.
rust - Empowering everyone to build reliable and efficient software.
ElectroCRUD - Database CRUD Application Built on Electron | MySQL, Postgres, SQLite
mysql-example
database-js - Common Database Interface for Node