Northwind

1.0.8

Swift Fork of the SQLite3 version of Microsoft's Northwind Database
Lighter-swift/NorthwindSQLite.swift

What's New

Initially

2022-08-24T14:42:48Z

A version of the database that uses Lighter 1.0.8.

The only visible change is the DocC fix for columns w/o a default value (they've been incorrectly reported as having a default value).

Northwind-SQLite3.swift

2022-08-04: A fork of Northwind-SQLite3 which packages Northwind as a Swift module.


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 5.7.0
View More Packages from this Author

Dependencies

Last updated: Tue Nov 22 2022 22:22:32 GMT-0500 (GMT-05:00)