{"repo":"harryho/db-samples","free":true,"listed":false,"github":"https://github.com/harryho/db-samples","clone":"git clone https://github.com/harryho/db-samples.git","description":"Northwind sample database for MySql, PostgresQL etc.","language":"TSQL","stars":185,"topics":["northwind","mysql","postgresql","mongodb","sqlite","sqlite3","json","mssql","mssqlserver","postgres"],"license":null,"category":"databases-storage","readme_excerpt":"Northwind sample database for MySQL, PostgreSQL, and more ==== This project is inspired by Microsoft Sample Databases, but it mainly focuses on other open-source databases, such as MySQL and PostgreSQL. This repository contains scripts to create and load the sample databases. If you are looking for the original MS SQL Server scripts, please check out Microsoft's repository on GitHub. This project lets you create a sample CRM-like demo database, populated with test data, in a few seconds. Which sample should I use? ecommerce (recommended for new development) northwind (classic) --- --- --- Dialects PostgreSQL, MySQL, MongoDB (document model) MySQL, PostgreSQL, MS SQL Server, SQLite, MongoDB Schema style Modern: foreign keys, identity/auto-increment columns, CHECK constraints, JSON columns, generated columns, full-text search; embedded documents on MongoDB 1990s Northwind port, kept close to the original Domain Core e-commerce: users, addresses, catalog with variants/SKUs, carts, orders with status lifecycle, payments, shipments, inventory ledger Classic CRM/ERP: customers, employees, orders, suppliers, territories Use it when You are building or learning against a contemporary database design You follow a tutorial/book that expects Northwind, or need the well-known dataset New to this repo? Start with ecommerce on PostgreSQL: Prefer MySQL? Prefer MongoDB? The same data ships as an embedded-document model (addresses inside users; variants, images and stock inside products; item","default_branch":null,"files":null,"tree":[],"storefront":"/r/harryho","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/harryho/db-samples/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}