Wikipedia says: “SQLite is a relational database management system (RDBMS) contained in a C library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program.” This is very important. As a software developer, know that SQLite can be inserted into your project so that you can ship your DB right in the EXE file! For more information you can go to the SQLite website.

There is an educational YouTube video on SQLite called Using SQLite in C# – Building Simple, Powerful, Portable Databases for Your Application. Tim Corey shows us how to create a small simple Windows program with a list of people’s names. Tim uses SQLite in a C# project. He first talks about SQLite at time 4:30 in the video. He then talks about DB Browser for SQLite at time 5:09.

There is a program called DB Browser for SQLite that allows you to easily create, design, and edit SQLite database files. Who is “you”? DB4S is for users and developers who want to create, search, and edit databases. The DB Browser for SQLite website has lots of information.

Tutorial

Have a look at the SQLite tutorial at www.sqlitetutorial.net. There is also a SQLite sample database that is the Chinook database.