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:
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
Hi Tong,
Thanks for letting me know. I will definitely use it in the next release. Thanks a lot!
Luis
Post a Comment