It's been two months since this profile received a new review

SQLite Reviews & Product Details

SQLite is a C-language library that provides a self-contained, serverless, and zero-configuration SQL database engine. Renowned for its small footprint and high reliability, SQLite is the most widely deployed database engine globally, embedded in billions of devices and applications. Its cross-platform database file format ensures seamless data transfer across different systems, making it a preferred choice for developers seeking an efficient and dependable database solution. Key Features and Functionality: - Self-Contained and Serverless: Operates without a separate server process, reading and writing directly to disk files. - Zero-Configuration: Requires no setup or administration, facilitating easy integration into applications. - Full-Featured SQL Implementation: Supports advanced capabilities like partial indexes, indexes on expressions, JSON, common table expressions, and window functions. - Single-File Database: Stores the entire database, including multiple tables, indices, triggers, and views, in a single cross-platform disk file. - Scalability: Handles databases up to 281 terabytes and supports row sizes up to 1 gigabyte. - Compact Size: With all features enabled, the library size can be less than 900KiB, depending on the target platform and compiler optimization settings. - High Performance: In some cases, SQLite is faster than direct filesystem I/O. - Cross-Platform Compatibility: Supports various operating systems, including Android, iOS, Linux, Mac, and Windows. - Public Domain Source Code: The source code is in the public domain, allowing free use for any purpose. Primary Value and User Solutions: SQLite offers a lightweight, reliable, and easy-to-use database solution that eliminates the complexities associated with traditional database management systems. Its serverless architecture and zero-configuration setup make it ideal for applications where simplicity and efficiency are paramount. By storing data in a single file, SQLite simplifies data management and portability, addressing the needs of developers and organizations seeking a robust database engine without the overhead of a full-fledged RDBMS.

Seller

SQLite

Discussions

SQLite Community

Value at a Glance

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

13 months

View More Pricing Information

Top-Rated Alternatives

View All Alternatives

SQLite Integrations

(2)

Integration information sourced from real user reviews.

G2 reviews are authentic and verified.

Here's how.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

1/7/2018

"SQLite is User friendly"

5/5

What do you like best about SQLite?

SQLite is User friendly. High performance. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Nothing to dislike because I like everything with this. Review collected by and hosted on G2.com.

Miguel Angel A.

Instructor Professor

Enterprise (> 1000 emp.)

5/17/2016

"The simplest yet most useful database I have used."

5/5

What do you like best about SQLite?

The fact that it doesn't need a server process and yet is still a complete full-featured ACID database is it's best feature. That it's also public domain and supported pretty much anywhere with a C compiler is just icing on the cake.

Other great things? It can be statically linked and it's databases can be bundled with applications like any other file, and it's also bundled with CPython so it's part of the Python standard library! Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Nothing really. Sqlite meets all my requirements beautifully. I'm aware that SQLite doens't have any form of secutiry functionality on it's own but I don't use SQLite on high security environments so it hasn't been a concern to me.

Only thing I can think of that I actually dislike is the lack of official Java wrappers, though the SQLjet project covers that (SQLjet is an independently produced 100% interoperable Java implementation of SQLite). Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Do not use it for full scale backend deployments, SQLite is not designed for that. As a data store for applications and games, or as a quick prototyping tool for backend development it's great.

Also Sqlite itself doens't have any form of access control or security features, so be mindful about that. Review collected by and hosted on G2.com.

What problems is SQLite solving and how is that benefiting you?

I use SQLite as data storage when developing application prototypes with Python's Web.py framework, the Android SDK or the C/C++ API directly depending on the requirements. I have also used SQLite as a data store proper when developing final applications for Android outside the prototyping phase.

In my research center we are using SQLite for an internal web application used to register students for the practice schedules of the subjects we teach. Review collected by and hosted on G2.com.

Marc S.

VP Product Development

Information Services

Small-Business (50 or fewer emp.)

3/22/2016

"SQLite, when simple matters"

4.5/5

What do you like best about SQLite?

The best thing about SQLite - and main reason i'm using it - is the lightweight footprint. It's also dead simple to setup, & even simpler to use. It's great for small projects that require the use of a datastore. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It's not exactly what i DISLIKE about the software, it's more about when NOT to use SQLite.

I think you want to avoid using it for large scale applications, or if you're looking for a full-featured relational database. SQLite is not your solution in cases like this. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Download/install the software, and play around on the command line to get used to the syntax.

Great for development environments, and even lightweight production apps (SQLite embedded). Review collected by and hosted on G2.com.

What problems is SQLite solving and how is that benefiting you?

I'm using SQLite in a phone application i'm working on (right now an iOS app, but no reason it wouldn't work just as well for an android application).

SQLite meets my requirement for an embedded, lightweight datastore. Review collected by and hosted on G2.com.

Verified User in Airlines/Aviation

Small-Business (50 or fewer emp.)

11/9/2017

"pretty decent if you don't need much"

2.5/5

What do you like best about SQLite?

It is pretty performant if you don't use a big amount of data or need advanced features. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It is insufficient for more than trivial applications Review collected by and hosted on G2.com.

Alex M.

Software Engineer (Technology R&D)

Research

Enterprise (> 1000 emp.)

10/25/2016

"Great for Spatial data exploration"

5/5

What do you like best about SQLite?

SQLite is as simple as a database gets - it's not a network accessible server like PostgreSQL or MS SQL, but a very fast, standards compliant* step above using a flat file directly. It's fantastic for geospatial processing using the Spatialite extensions, which makes exploring geo data as nice a using SQL can be. It is probably the world's most widely used database, you've probably got several applications installed which rely on it, no matter what operating system. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Concurrency can be an issue, but concurrent access isn't really the goal of SQLite, and despite that, if you enable the write ahead log, performance can be quite good. Their interpretation of the SQL standard means some unexpected features - types on columns aren't enforced, but this is because close examination of the SQL spec means this must be the case. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Spatialite could be considered a superclass of SQLite, and is the obvious choice if you need fast access to geospatial data on the desktop. There are several other options if you need a single machine/desktop database, including very fast key-value stores such as LMBD and Tokyo and Kyoto Cabinet. It is possible that your app already is taking advantage of SQLite through API's like Apple's Core Data API, or via the Web SQL Database, which is implemented in most modest browsers by using SQLite underneath. Review collected by and hosted on G2.com.

What problems is SQLite solving and how is that benefiting you?

Geospatial data processing, indexing of text based documents, faster access to data than a CSV would give me. Review collected by and hosted on G2.com.

Tyler W.

Programmer

Internet

Small-Business (50 or fewer emp.)

10/21/2016

"Great For Development and Mobile"

4/5

What do you like best about SQLite?

SQLite is very easy to install and use. There is probably no better database for beginners to start learning about running and using a database. This also makes it an excellent choice for persistent data in a development environment. The quick setup and ease of use keep it from being a blocker for setting up a development environment.

It is lightweight—under 500kb for the full featured version and under 300kb for a stripped down version—and well suited to applications that need to run with limited resources, like mobile applications and embedded systems.

It is in the public domain, so it is freely available for any use.

SQLite has excellent documentation. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It is not well suited to large scale applications. It is designed for lightweight systems, not for enterprise applications, or applications that need to scale significantly. It also lacks some features of the larger scale databases like MySQL including security, permissions, and type features.

If you are using SQLite for its intended purpose—persistent data in lightweight systems—these downsides don't really come into play. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Know what you need from a persistent data source. If you are looking for something lightweight and easy to use, this is a great option. If you need something that will scale with a large application, you might want to consider something else. Review collected by and hosted on G2.com.

What problems is SQLite solving and how is that benefiting you?

Personally, I have used SQLite to persist data in development environments where I am not as concerned with performance or feature issues. It works great for this purpose because you can get steup up quickly, and get into the actual development work. Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

11/8/2017

"My sql"

3.5/5

What do you like best about SQLite?

My sql it is good technology for quering the data Review collected by and hosted on G2.com.

What do you dislike about SQLite?

lot of innee joint to reyry the data it is should be simple Review collected by and hosted on G2.com.

Nico C.

Web Developer

Small-Business (50 or fewer emp.)

9/26/2016

"SQLite for Cordova mobile apps"

5/5

What do you like best about SQLite?

It is very reliable, doesn't require a server and is wide supported across major platform.

If well setted can have very good performances. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It has few types. Although you can do everything with types provided, having bigger control over numbers (specifying the byte length) can lead to some performance boosts.

Plus I really missed the lack of a boolean/bit type which is often very useful.

Another annoying thing is that you can't save your PRAGMAs directly to database but you have to query them every time, so on every connection you have to specify that the DBMS has to check foreign keys constraint (which are disabled by default), the journaling engine, and so on. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Before writing your DDL check the documentation as SQLite slightly differs from SQL standars.

For instance if you have a table with a primary key, you may want to specify the "WITHOUT ROWID" clausole onto that table in order to gain more performances.

Furthermore take a look to PRAGMAs, they are connection based and not saved on disk, but they can be very useful in you application. Review collected by and hosted on G2.com.

What problems is SQLite solving and how is that benefiting you?

I was developing a Cordova based app. It provides a good WebSQL and IndexedDB abstraction layer via JavaScript, but support is too much fragmented as some enviroments supports WebSQL, some IndexedDB and some both.

As SQLite is a standard de facto for mobile app persistence, I moved to it, grating cross platform full support. Review collected by and hosted on G2.com.