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.

SQLite Reviews (260)

View 1 Video Reviews

G2 reviews are authentic and verified.

Here's how.

Andrew F.

Founder

Small-Business (50 or fewer emp.)

1/24/2019

"SQLite "

4/5

What do you like best about SQLite?

SQLite is a very important database library that many open source software uses. It also has a self contained database system as well. SQLite is very small and fast. It also can be run and embedded in specific applications. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I do not dislike much about SQLite except the fact that its difficult to use at times. Also sometimes its slow especially with big Databases Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Use only for embedded databases to make small scale applications work. (I.e. locally installed programs with no LAN or WAN connection) Review collected by and hosted on G2.com.

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

SQLite is just another free database and interface. It does what I need it to do. Review collected by and hosted on G2.com.

Prince K.

Mid-Market (51-1000 emp.)

10/16/2018

"sqlite, a light and easy to use software"

5/5

What do you like best about SQLite?

Sqlite is a very light software for database management. Due to its light feature it can be easily used on mobile devices. It is very easy to install. Sqlite functions can be called very easily through small functions which reduces latency or any kind of delay. It is a server less software so require less or zero configuration. It is best suitable for embedded devices where no human intervention is required. It is the best software for relational database management for mobile users. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

As it is not multi user type so only one user can write at one time. It is not secure. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

I would recommend users to use Sqlite in case of small devices to handle the relational database. It is very compact and easy to use. Review collected by and hosted on G2.com.

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

I have this to handle the database in my embedded devices in my projects. It is best for this because it doesn't require any kind of administration. It is the light version of SQL so very effective in case of small devices. It is very fast in its work as there is negligible amount of latency. It is very compact and easy to use software. Review collected by and hosted on G2.com.

Verified User in Financial Services

Enterprise (> 1000 emp.)

8/8/2019

"Standard now in this day and age"

5/5

What do you like best about SQLite?

Stores data as objects and not as relational data Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Can use up a lot of space very quickly because you’re storing objects Review collected by and hosted on G2.com.

George G.

GIS & Database Developer

Small-Business (50 or fewer emp.)

7/10/2018

"Compact, light and easy to deploy"

3.5/5

What do you like best about SQLite?

SQLite is a full-featured SQL implementation which you can start using with zero configuration as no setup or administration is needed. It is a serverless compact database in a single cross-platform disk file with a really small code footprint. It is free and it comes with SpatiaLite - an open source library which expands it's capabilities to handling spatial data. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The The old school SQLite management systems and a number of lacking features: database level locking (SQLite only supports one writer at a time per database file), materialized views, intricate spatial indexes (GIST, GIN). Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

You should by all means use SQLite (and SpatiaLite) for device-local storage, for application file formating and as a website database to back small to medium-sized websites.

SQLite is fast and reliable and it requires no configuration or maintenance.

You should avoid SQLite (and SpatiaLite) if you are developing Client/Server Applications, if you plan to handle very large datasets and if you expect high user writing concurrency. Review collected by and hosted on G2.com.

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

I use SQLite to hold user/program settings, preferences or other front end related data needed for programms I develop, to store spatial data on GIS in mobile devices (tablets & smartphones) and to transfer data from my other client/server databases, edit them offline and synchronize them with the live databases again. Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

7/21/2019

"Used for Android"

5/5

What do you like best about SQLite?

It is very light weight and easy to use. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There is nothing to put as a dislike. I like the features I used for development. Review collected by and hosted on G2.com.

Raja B.

Power BI & Tableau Developer

Small-Business (50 or fewer emp.)

3/2/2019

"SQLite certified from Coursera"

3.5/5

What do you like best about SQLite?

It a very innovative and fast with respect to performance and debugging. More like. Microsoft sql server but still helpful for creating insights Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Nothing much new if we see the other databases like oracle ibm db2 sql server and MySQL.. But still okay Review collected by and hosted on G2.com.

Julio G.

Software engineer

Mid-Market (51-1000 emp.)

9/12/2018

Business partner of the seller or seller's competitor, not included in G2 scores.

"SQL for mobile phones"

4/5

What do you like best about SQLite?

There are many things I like so much about Sqlite.

We work with mobile devices and Sqlite is the best database administrator for that pruposes.

We mostly deploy sales force automation solutions in mobile devices, so we need a light and free solution for our clients, because they have many devices and it not feasible buying licenses for all.

Sqlite covers all our needs considering: speed, scalability, easy-to-use, SQL language based.

It is very easy to install and to administrate.

You don't need to have big knowledge to create a new database from scratch.

It is portable, each database is only one file which you can copy and move easily.

There are lots of free administrator software to open, manage and query a SQlite database.

You can share this type of datebases between different OS devices, such us iOS or Android.

They can be set in quite different ways, for showing the same data in different structures.

Well, what more can I say, let's try it.

Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It is not a type based database, this make it very flexible but sometimes it offers problems witn number precission.

Sqlite offers a limited set of SQL language, which means you can not do some queries that you would do without any problem in other platforms. In that cases, you have to find workarounds to solve your issue. Review collected by and hosted on G2.com.

Himanshu K.

Manager

Enterprise (> 1000 emp.)

10/24/2018

"Database architecture"

5/5

What do you like best about SQLite?

This software is used for database management. It is the light version of SQL. It is self- contained, serverless and require no setup. It is suitable for small embedded devices like cell phone, mp3 player, etc. It is based on command line interface. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Sometimes it poses a risk on security. It is gets slow when data being handled increases. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

I would recommend this software to those who needs to handle small database for small embedded device or small websites. It is very simple, compact and easy to learn. Review collected by and hosted on G2.com.

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

I use this software to manage database for my embedded projects. It is very simple and easy to use. It requires no setup and is full featured like SQL. It has no extra dependency. It is best for small sized websites. Review collected by and hosted on G2.com.

Krishna C.

Senior Consultant

Enterprise (> 1000 emp.)

3/20/2019

"SQLite - Embedded version"

4/5

What do you like best about SQLite?

We use SQLite in an embedded mode within our java application as a temporary storage before streaming out to our external message broker. Very low memory footprint and handy. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

While I am not expecting a full blown database, it is just an OK for embedded database compared to H2. Review collected by and hosted on G2.com.

Eduardo A.

Game Programmer

Small-Business (50 or fewer emp.)

1/20/2019

"The best for quick database development "

5/5

What do you like best about SQLite?

Is built in directly on mobile devices.

If you know Sql, this is pretty straightforward to follow in development.

Is fast development for quick databases. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

May be a bit "hard" if you want to develop bigger databases with more complex relationships. It doesn't have a direct desktop IDE or something that helps you with the database creation (like mysql). Review collected by and hosted on G2.com.