SQLite Reviews & Product Details

I like SQLite's availability and that it is serverless. This makes it extremely portable and lightweight (considering alternatives). This bridges a gap between the always connected tech landscape and the increases needs for efficient and portable devices. Review collected by and hosted on G2.com.

Security is lacking by design which significantly increases the risk of implementing sqlite Review collected by and hosted on G2.com.

SQLITE is very portable! you can easily ship it along with your code without having to worry about configuring and maintaining servers. Review collected by and hosted on G2.com.

Sometimes it might be unperformant but it is totally understandable Review collected by and hosted on G2.com.

One of the easy and cool database to setup for mobile data store, we were exploring couple of options and found SQLite is the best one which you can use for mobile database. Review collected by and hosted on G2.com.

Scaling of database is not that great. Security also needs to improve Review collected by and hosted on G2.com.

I love how simple and easy to use SQLite is. It doesn’t require administration and is very reliable. You don’t have to think or worry about it. Did I mention it’s free? Review collected by and hosted on G2.com.

Nothing! The product serves its purpose very well. Review collected by and hosted on G2.com.

It is so easy to work with the SQLite. It is great for testing, personal or single user purpose as it is lightweight and can be used stand alone, with some IDE like DB Browser, Beaver DB, or through the Python as well... Light and powerful. Review collected by and hosted on G2.com.

Well, there are not too many things to dislike in SQLite. Only if I compare it to the other (but bigger ) db systems like Oracle, SQL Server... But that is not properly comparable. Review collected by and hosted on G2.com.

The SQLite is a good database for a small application. It is very easy to use and very light and fast. Review collected by and hosted on G2.com.

SQLite cannot be used for a very big database to store a lot of information. It is better for internal applications. Review collected by and hosted on G2.com.

Ease of standup, lightweight and good for small-scale apps Review collected by and hosted on G2.com.

Some software limitations that make it less extensible Review collected by and hosted on G2.com.

It's versatile and can use in various platforms and mobile/desktop applications. In-memory database option is one of my favourite feature that can create database on-the-fly. Review collected by and hosted on G2.com.

I can't really think of major drawbacks of SQLite DB but one thing that lacks is the incapability to run as the main thread process. Review collected by and hosted on G2.com.

It's a great database that does everything you need all in one file. Review collected by and hosted on G2.com.

It can't necessarily handle extremely large data sets. Review collected by and hosted on G2.com.

It's a serverless database system. You just need an API library to access the database, which is stored in a single file. Most common SQL operations are available. For small projects it works better than other file formats like JSON or INI. You can relate data and make SQL queries, with some little differences.

Because it's in a single file, this means that it should work in memory, giving it speed. You can also create databases in memory, without storing them on the filesystem. It's quite useful when you have matrices and complex operations that you prefer to do using SQL. Review collected by and hosted on G2.com.

Although it's ideal for small projects, as soon as you grow you need to move to a proper RDBMS. Since SQLite uses a file, only one process should be accessing the database at any given time or you'll loose data. Also, having the database on a file means that your systems need access to the filesystem, which creates many security problems. Using another database system like MYSQL you can expose only the databases and tables you want by granting specific permissions. Review collected by and hosted on G2.com.