Where I can find example of SQLite database file or dump of it? [closed]

Question

I really need a sqlite database file for studies. I'm creating an application in C# and I need a database with many tables, field, views, indexes, constraints and so on. And I don't want to create it myself using sqlite command line tool.

So I suppose may be someone can say where I can find such file, may be different applications or examples, or even can send me their own database file. I will appreciate any help.

Answer 1

There is a nice sample database called Chinook. It's trying to be the modern example to replace NorthWind. They have versions for different database servers including SQLite.

• Homepage, DB diagram, etc.. http://chinookdatabase.codeplex.com/
• Github (seems more updated than CodePlex) https://github.com/lerocha/chinook-database
• Latest SQLite download to date of post: https://chinookdatabase.codeplex.com/releases/view/55681#fileDownload6
• Download SQLite Sample Database to get the Chinook database file directly http://www.sqlitetutorial.net/sqlite-sample-database/
• More SQLite related projects and samples on CodePlex http://www.codeplex.com/site/search?query=sqlite&ac=8

Also, check this sample in the SQLite .NET client forums (attached to first post)

• Getting the Microsoft EFQuerySamples project to work with SQLite

Maybe a GUI tool to create database stuff will make starting easier, check this one, free for personal use

• http://www.sqliteexpert.com/

Personally, I create SQLite databases for testing NHibernate mappings. Usually I create my classes and mappings then use the mappings to generate schema to a new SQLite file (or in memory database, more often) and use that. Most NHibernate introduction articles do that as well.