🌐
GitHub
github.com › pthom › northwind_psql
GitHub - pthom/northwind_psql: Northwind sample database for postgres · GitHub
A simple sql script that will populate a database with the famous northwind example, adapted for postgres.
Starred by 1K users
Forked by 990 users
🌐
Wikiversity
en.wikiversity.org › wiki › Database_Examples › Northwind › PostgreSQL
Database Examples/Northwind/PostgreSQL - Wikiversity
HAR(255) ); CREATE TABLE Customers ( CustomerID INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, CustomerName VARCHAR(50), ContactName VARCHAR(50), Address VARCHAR(50), City VARCHAR(20), PostalCode VARCHAR(10), Country VARCHAR(15) ); CREATE TABLE Employees ( EmployeeID INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, LastName VARCHAR(15), FirstName VARCHAR(15), BirthDate TIMESTAMP, Photo VARCHAR(25), Notes VARCHAR(1024) ); CREATE TABLE Shippers( ShipperID INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, ShipperName VARCHAR(25), Phone VARCHAR(15) ); CREATE TABLE Suppliers( Suppli
Discussions

sql - Where can I download the Northwind sample database for SQLite? - Stack Overflow
After looking at: Where can I download Northwind database for Postgresql? it looks like the best place for Northwind data, outside of the Microsoft itself, is: https://code.google.com/archive/p/ More on stackoverflow.com
🌐 stackoverflow.com
Help Needed with Northwind dataset on Postgresql. for the first query, I can see all columns but for the second query with specific column, it says the colum does not exist. what am I missing here? thanks
Postgres is case sensitive, and it needs double quotes around a column that uses caps. More on reddit.com
🌐 r/SQL
4
1
May 9, 2022
Trying to query against a "Northwind" database. Is my query incorrect, or the problem set?
by the way, i'm surprised the query ran with this -- GROUP BY EmployeeID that's an ambiguous reference More on reddit.com
🌐 r/learnSQL
14
5
December 16, 2021
exercise on sample database like Northwind

A website you might want to check out for this.

Sqlzoo.net

More on reddit.com
🌐 r/learnSQL
3
0
May 29, 2020
🌐
GitHub
github.com › sealbro › northwind
GitHub - sealbro/northwind: Northwind sample database for MySql, PostgresQL etc. · GitHub
Northwind sample database for MySql, PostgresQL etc. - sealbro/northwind
Starred by 6 users
Forked by 2 users
Languages   JavaScript 88.0% | Shell 12.0%
🌐
DZone
dzone.com › data engineering › databases › the northwind postgresql sample database running on a distributed sql database
The Northwind PostgreSQL Sample Database Running on a Distributed SQL Database
July 17, 2019 - $ ./bin/ysqlsh --echo-queries ysqlsh (11.2) Type "help" for help. postgres=# What’s YSQL? It’s YugaByte DB’s PostgreSQL-compatible, distributed SQL API. We are now ready to build the Northwind database.
🌐
Yugabyte
yugabyte.com › blog › how-to-the-northwind-postgresql-sample-database-running-on-a-distributed-sql-database
Running the Northwind Sample Database on Distributed SQL | YugabyteDB
December 2, 2022 - $ ./bin/ysqlsh --echo-queries ysqlsh (11.2) Type "help" for help. postgres=# What’s YSQL? It’s YugabyteDB’s PostgreSQL-compatible, distributed SQL API. We are now ready to build the Northwind database. You can download the Northwind database that is compatible with YugabyteDB from our GitHub repo. Here’s the two files you’ll need: northwind_ddl.sql which creates tables and other database objects · northwind_data.sql which loads the sample data into Northwind
🌐
GitHub
github.com › neslihanyetik › Northwind-Postgresql
GitHub - neslihanyetik/Northwind-Postgresql: Northwind sample database for postgres · GitHub
A simple sql script that will populate a database with the famous northwind example, adapted for postgres.
Author   neslihanyetik
🌐
GitHub
github.com › harryho › db-samples
GitHub - harryho/db-samples: Northwind sample database for MySql, PostgresQL etc. · GitHub
Northwind sample database for MySql, PostgresQL etc. - harryho/db-samples
Starred by 185 users
Forked by 135 users
Languages   TSQL 95.9% | Shell 1.8% | PowerShell 1.4% | JavaScript 0.9%
🌐
Alaska-software
doc.alaska-software.com › content › pgdbe_h2_the_northwind_example_database.cxp
The northwind example database
Database Engines pgdbe First steps The northwind example database · Xbase++ comes with a sample data model named northwind. The data model is available for the PostgreSQL server, for free dbf tables, Visual FoxPro dbc, ADS dictionary and SQLite databases. Two steps are required to load this ...
Find elsewhere
🌐
Medium
medium.com › yugabyte › how-to-the-northwind-postgresql-sample-database-running-on-a-distributed-sql-database-the-21773bc6aa0e
How-to: The Northwind PostgreSQL Sample Database Running on a Distributed SQL Database | by Jimmy Guerrero | The Distributed SQL Blog | Medium
July 22, 2019 - How-to: The Northwind PostgreSQL Sample Database Running on a Distributed SQL Database The Northwind database is a sample database that was originally created by Microsoft and used as the basis for …
🌐
GitHub
github.com › u2mejc › northwind_psql
GitHub - u2mejc/northwind_psql: Northwind sample database for postgres · GitHub
A simple sql script that will populate a database with the famous northwind example, adapted for postgres.
Author   u2mejc
🌐
YugabyteDB
docs.yugabyte.com › stable › develop › sample-data › northwind
Northwind sample database | YugabyteDB Docs
May 7, 2026 - Install the PostgreSQL-compatible version of the Northwind dataset on the YugabyteDB distributed SQL database. You can install and use the Northwind sample database using:
🌐
DevGenius
blog.devgenius.io › postgresql-008-install-the-northwind-database-in-postgresql-go-retro-38760e462b5d
PostgreSQL 008: Install the Northwind Database in PostgreSQL — Go Retro! 🌐💾 | by M Business Solutions | Dev Genius
December 4, 2024 - 🎮 While it’s not a game, this classic sample database has been used for decades to teach and test relational database concepts. Originally created for Microsoft Access, Northwind contains everything you need to simulate a small business’s operations — like customers, orders, products, ...
🌐
GitHub
github.com › adriano-fonseca › sql
GitHub - adriano-fonseca/sql: Northwind sample database for postgres
A simple sql script that will populate a database with the famous northwind example, adapted for postgres.
Author   adriano-fonseca
🌐
Colorstech
colorstech.net › sql-training › northwind-dataset-for-postgresql
Northwind Dataset for PostgreSQL, MySQL and CSV - Colorstech.net
August 11, 2025 - The Northwind dataset is a sample database that has been widely used for learning and testing database concepts, particularly relational database management systems (RDBMS). It originated as a Microsoft Access template and has since been adapted ...
🌐
LinkedIn
linkedin.com › pulse › northwind-postgresql-database-schema-exploration-using-koźlicki-bdvzf
Northwind in PostgreSQL Database schema exploration using system catalogs and views
February 22, 2024 - The Northwind database is a sample database used by Microsoft to demonstrate the features of some of its products, including SQL Server and Microsoft Access. The database contains the sales data for Northwind Traders, a fictitious specialty ...
🌐
GitHub
github.com › avkis › northwind_psql
GitHub - avkis/northwind_psql: The Northwind database adapted for PostgreSQL
A simple sql script that will populate a database with the famous northwind example, adapted for postgres.
Author   avkis
🌐
GitHub
github.com › yugabyte › yugabyte-db › wiki › Northwind-Sample-Database
Northwind Sample Database
July 22, 2019 - In this post we are going to walk you through how to install the PostgreSQL-compatible version of Northwind onto the YugaByte DB distributed SQL database. The latest instructions on how to get up and running are on our Quickstart page here: ...
Author   yugabyte
Top answer
1 of 2
10

See https://github.com/jpwhite3/northwind-SQLite3

"All the TABLES and VIEWS from the MSSQL-2000 version have been converted to Sqlite3 and included here. Also included are two versions prepopulated with data - a small version and a large version"

2 of 2
3

You can download a version of sqlite3 database from

https://code.google.com/archive/p/northwindextended/downloads

Advantage: It is available immediately. Click and use.

If it's simply to get a sample database for general testing, then just use what's immediately available. If you require an exact copy to match testing results (for instance), then download and convert MS data yourself to ensure exactness since the file's header indicates modifications and added foreign keys and contains no other certification of content. You really need to answer this for yourself based on your own requirements.

Without knowing anything about the conversion process, I would at least guess that the date values are not precisely the same since sqlite has no native DateTime type, rather such values would have needed to be converted to string values and/or Julian numeric values. Of course the values themselves may represent the same dates and times, but processing of query data would certainly require special handling. BLOB values for images should also produce the same images, but retrieving and using those values will likely be different than getting them from other databases. I suppose there could be other data values/types that different handling would apply since sqlite really has no distinct, strict numeric types, rather just type affinities.

🌐
GitHub
github.com › TemitopeoluwaGiwa › northwind
GitHub - TemitopeoluwaGiwa/northwind: Northwind sample database for MySql, PostgresQL etc.
Northwind sample database for MySql, PostgresQL etc. - TemitopeoluwaGiwa/northwind
Author   TemitopeoluwaGiwa
🌐
GitHub
github.com › pthom › northwind_psql › blob › master › northwind.sql
northwind_psql/northwind.sql at master · pthom/northwind_psql
Northwind sample database for postgres. Contribute to pthom/northwind_psql development by creating an account on GitHub.
Author   pthom