Sunday, December 02, 2012

Chinook Sample Database 1.4 Released

The Chinook Database is a sample database available for multiple database systems. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.

The Chinook Database represents a media store, including tables for artists, albums, media tracks, invoices and customers. The media information was generated from my iTunes library file, but anyone can download its source code and use their own iTunes library information. The sales information is auto-generated for a 4 years period. You can see the Chinook data model here.

This new version includes support for DB2 and PostgreSQL. Thanks to @brice_lambson for implementing the PostgreSQL support! Chinook database is available for:

  • DB2 (new)
  • EffiProz
  • MySQL
  • Oracle
  • PostgreSQL (new)
  • SQL Server
  • SQL Server Compact
  • SQLite

You can download the latest release from here. There are available SQL scripts for each database system and also embedded database files for SQL Server Compact and SQLite.

2 comments:

Anonymous said...

Thanks for providing Chinook Sample Database for Postgres.

The bad news is that, the Postgres Sample is geared towards Postgres 9, but there are quite a few Postgres 8 users out there.

The good news is that, one of the Postgres 8 user, Ron Savage, has ported the Chinook Postgres Sample Database to Postgres 8. Check out http://blogs.perl.org/users/ron_savage/2013/03/graphviz2-and-the-chinook-test-database.html.

Could you use that for your future Postgres release please?

Thanks

Tong

Luis Rocha said...

Hi Tong,
Thanks for letting me know. I will definitely use it in the next release. Thanks a lot!
Luis