northwind-SQLite3

master

SQLite3 version of Microsoft's Northwind Database
jpwhite3/northwind-SQLite3

Northwind-SQLite3

This is a version of the Microsoft Access 2000 Northwind sample database, re-engineered for SQLite3.

The Northwind sample database was provided with Microsoft Access as a tutorial schema for managing small business customers, orders, inventory, purchasing, suppliers, shipping, and employees. Northwind is an excellent tutorial schema for a small-business ERP, with customers, orders, inventory, purchasing, suppliers, shipping, employees, and single-entry accounting.

All the TABLES and VIEWS from the MSSQL-2000 version have been converted to Sqlite3 and included here. Included is a single version prepopulated with data. Should you decide to, you can use the included python script to pump the database full of more data.

Download here

Structure

alt tag

Build Instructions

Prerequisites

  • You are running in a unix-like environment (Linux, MacOS)
  • Python 3.6 or higher (python3 --version)
  • SQLite3 installed sqlite3 -help

Build

make build  # Creates database at ./dist/northwind.db

Populate with more data

make populate

Print report of row counts

make report

Description

  • Swift Tools
View More Packages from this Author

Dependencies

  • None
Last updated: Tue Jan 31 2023 14:47:33 GMT-0500 (GMT-05:00)