I liked how easy it was to set up and connect to my company's database. Also pretty easy as far as access controls for different employees. Overall navigation is nice and not hard to start new projects to query things Review collected by and hosted on G2.com.

Sometimes it was really hard to understand error messages if things were typed wrong. And it was hard to pinpoint issues to troubleshoot them. Slowed down quite a bit if I had too many projects opened Review collected by and hosted on G2.com.

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.

Query writing is very easy and SQLite is very easy for the new comers and also for the existing users Review collected by and hosted on G2.com.

Product costing little expensive compare to other tool Review collected by and hosted on G2.com.

Great tool to have to look into the data , and it is a freeware. Review collected by and hosted on G2.com.

It is not fully available with all the features untill you take a professional version and that is for a price. Review collected by and hosted on G2.com.

The performance,optimization, and for backup is best to use SQLite. Review collected by and hosted on G2.com.

The main reason to dislike is that it doesn't support concurrency. Review collected by and hosted on G2.com.

What I like the most about SQLIte is that it is so lightweight and is readily available to use in Android applications. Looks like it is tailored to work on small devices, leaving a small footprint. It is opensource as well. The installation and setup is done really quick as there are no server configuration required.

Any developer familiar with MySQL syntax can easily and quickly catch-up on SQLite as well. Execution of query is also really fast, thanks to the small footprint. Above all it is totally free to use. Review collected by and hosted on G2.com.

Functionality wise, certain features are limited in SQLite when compared to MySQL, Oracle or PostgreSQL. When it comes to its scalability to a larger application and requires some security features, SQLIte is not a very good choice. As much as I know, it does not come with built-in data encryption. Sometimes it is hard to design a complex architecture due to limitations. Also, I didn't find much helpful documentation for SQLite as well. Review collected by and hosted on G2.com.

Easy to implement and manage SQLite in Mobile applicatons both Android and iOS. It provides API support as welll as query support to use basic CRUD operations. Review collected by and hosted on G2.com.

It works fine with low data storage but it takes time in seconds for basic operations with big data storage in Mobile applications. Review collected by and hosted on G2.com.

Ease of use is what wins SQLite for me. I have used SQLite for a lot of my smaller projects and in development branches.

It has a handy CLI tool to interact directly with the database. A plus point is the community support, I used SQLite with python which has a great community of developers. Review collected by and hosted on G2.com.

As far as I know, there's nothing much to dislike about SQLite since it does its job well. Review collected by and hosted on G2.com.

It is cross platform database.

Just a smaller queries can do the big things.

It is updated very frequently. Review collected by and hosted on G2.com.

It is lacking in multiuser compatibility.

It's transaction is slow.

It handles low medium traffic. Review collected by and hosted on G2.com.

The fast and reliable solution which could be used on desktop and mobile. Review collected by and hosted on G2.com.

Requires some SQL background. Limited scripting abilities. Review collected by and hosted on G2.com.