The very first thing anyone should know about “SQLite” is that the “Lite” in SQLite does not refer to its capabilities or limitations. It’s just called “Lite” because the of its simple usage and “lite” size.
Benefits of SQLite:
- Serverless – SQLite does not have a client/server relationship. The entire database is integrated into whatever application needs access to it.
- NO setup required – Unlike MySQL server setup, there is nothing you need to do server side when in comes to installation
- Small runtime – should be self explanatory
- uses dynamic-type system in SQLite (this means that data types aren’t restricted to any column/row e.g number, date, string,etc)
This simplicity makes it easy to use with smart phones, touch pads, etc where no traditional database system can reach.This works easily because SQLite is built right into the application itself.
SQLite is very easy to setup and easy to use. It also uses the core of SQL language and best of all it requires no server setup or administration.
You can download SQLite at: www.sqlite.org/download.html
Short comings to SQL Lite
-No real time replication
-Not ideal for extremely large datasets – because SQ Lite is 1 file if a large dataset is crunched into 1 file it may not be wise to use SQ Lite.