There are many things I like so much about Sqlite.
We work with mobile devices and Sqlite is the best database administrator for that pruposes.
We mostly deploy sales force automation solutions in mobile devices, so we need a light and free solution for our clients, because they have many devices and it not feasible buying licenses for all.
Sqlite covers all our needs considering: speed, scalability, easy-to-use, SQL language based.
It is very easy to install and to administrate.
You don't need to have big knowledge to create a new database from scratch.
It is portable, each database is only one file which you can copy and move easily.
There are lots of free administrator software to open, manage and query a SQlite database.
You can share this type of datebases between different OS devices, such us iOS or Android.
They can be set in quite different ways, for showing the same data in different structures.
Well, what more can I say, let's try it.
It is not a type based database, this make it very flexible but sometimes it offers problems witn number precission.
Sqlite offers a limited set of SQL language, which means you can not do some queries that you would do without any problem in other platforms. In that cases, you have to find workarounds to solve your issue.