The foremost thing I like about this software is that it is super light-weighted, portable, and relatively faster than other databases like MYSQL, Postgresql, etc. Another thing I like about this is that you don't need to install and made any configuration in order to use this database. You can simply, download the SQLite libraries and use this in your application. The query is also quite similar to MYSQL, so this software can be easily learned and used by the user who has experienced with MYSQL. It can be easily used to built mobile applications. Storing the data as local storage in the android applications can be one of the best use of this SQLite. With its fast performance and light weightiness, SQLite stand out to be a good database for small applications that require minimum data storage. Review collected by and hosted on G2.com.
However, due to its light weightiness, SQLite does not have many features including store procedure. It is not suitable for complex and large system architecture. It has a limited data storage capacity of only 2 GB which is a bit unsatisfying. Despite, its weakness, it is still a good choice for a small application that requires minimum data storage and has simple architecture. Review collected by and hosted on G2.com.
