SQLite Rocks!

SQLite, what is that? If you are not a programmer, then you probably don't know about it, even most of the programmers don't know about it. So, what is it?

It's a small database created only to be used on an embedded application. Mostly like Ms. Access, only it available widely for every platform. It has a very large number data connector for many programming languages.

Unlike Windows programming that uses ADODB or DSN, sqlite embed the data connector library into the application and let the application use it to connect to the database. What is that means? It means you don't have to worry anymore about drivers or DSN settings.

Well it's an added value for non Windows users who dreamt about a portable database that runs anywhere.

I use it to build an application that works in Windows Mobile 2003 and 2005 using C#.Net CF 2.0.