SQLite - my journey starts

I do C++ programming in my free time and one of the challenges I am facing at the moment is databases. I have a project that require me to use a database for storing data.

Most of my development is taking place on my gaming PC with Windows XP Professional (Although I also work a bit on Fedora Linux)

My search led met to Sqlite

Sqlite is :

• Free as in the public domain which means that everybody can use and modify it.
• Small, very small. The binary is about 427KB on my PC, unzipped
• Fast, Faster than other popular client/server database engines for most common operations.
• SQL support although some features are not supported.
• Cross-Platform: Linux (unix), MacOSX, OS/2, Win32 and WinCE are supported out of the box
• Accessible through C++
• Used in one way or another by well known companies

and has many more features...

I downloaded the Windows command-line version and started it up.

SQLite version 3.5.4
Enter ".help" for instructions
sqlite>

Figuring out how to create a database was very easy using the Sqlite language syntax as on the Sqlite website

sqlite> ATTACH DATABASE 'myDB.fl' AS myDB;

That command created a database for me and I was able to see where it is located by entering .databases at the Sqlite command prompt.

sqlite> .databases
seq name file
--- ---- ---------------------
0 main
2 myDB C:\sqlite-3_5_4\myDB.fl

So far I like Sqlite allot. It's easy to use and it just simply works.