Sunday, August 17, 2008

Chinook Sample Database is Alive!

During the past two weeks, I've been working on a sample database in order to test ORM tools and make a quick demos. The idea is to have a simple database that can be created by a single script, and provide versions of this script for more than one database server: SQL Server, Oracle and MySQL.

With this idea in mind, I created the Chinook Database in Codeplex. Its first release is available here. I will be using it in order to create some tests for the other project I am working on, the Repository Factory, which supports SQL Server and Oracle. Having the same sample database for different servers, make testing the Repository Factory easier since unit tests can be common.

The Chinook Database represents a media store, digital 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 information. The sales information is random generated for a 4 years period.

I will be working on adding more customers to it. I just added a few so far, but with address that can be located by Google maps, and probably by other map engines. The idea is to have customers from different countries and address formats. So far, we only have for Canada, USA, and Brazil, but more to come.

I hope this database will be useful for other folks and I will keep updating it constantly.

Enjoy it!

1 comment:

Evoluteur said...

Very useful project. Thanks.

I've used your database for a demo of Evolutility CRUD Framework.

http://evolutility.org/Chinook/Chinook_by_Evolutility.aspx