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.

Ricardo M.

Small-Business (50 or fewer emp.)

4/18/2016

"My preferred database management system"

4.5/5

What do you like best about SQLite?

SQLite is one the best database management systems out there. It is lightweight and really, really easy to use and install. Just create a database and, voi lá, you're ready to use what you want to communicate with it. No need to use something phpMyAdmin or something like it. Absolutely the best option to be embedded inside applications or websites. Works with every SQL code there is, as far as I know. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There's nothing I really dislike about SQLite, but the lack of access privileges management may not be suitable for every situation. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Absolutely use SQLite as your main database management system, specially if it is an embedded solution (e.g., Android app). Review collected by and hosted on G2.com.

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

I used SQLite in my univerysity projects, like desktop software and web platforms. It was really useful. Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

1/17/2017

"amazing"

5/5

What do you like best about SQLite?

DB in a file, no configuration, great for small teams with medium sized data sets too big for Excel. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Not ideal for production webapps, cannot scale to millions of users so will get modified by most engineering orgs if feature is productized. Review collected by and hosted on G2.com.

Thejdeep G.

Mid-Market (51-1000 emp.)

1/22/2016

"Great for beginners"

4/5

What do you like best about SQLite?

- Small

The DB engine can run on any smartphone or any PC for that matter. All this because of its size and memory consumption.

- Portable

It is easy to share databases between multiple OS's. All that needs to be done is to copy the file and share it with the target system and that is it.

- Open Source and in the public domain

SQLite is freely accessible and available for download. No one is the owner or co-owner of the product, the public holds all rights to the product. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

- Scalability

SQLite is unable to support large databases and also is unable to handle requests from a large number of users. This means to say that a large number of transactions is unable to be handled by SQLite

- SQL support

Not all features of SQL are present or implemented in SQLite. Some of the required concepts such as Outer Joins and Inner Joins are yet to be implemented. Although, support for this is in the works, it might take a small amount of time before a fully functional SQL language support is added into SQLite.

- Does not support data types such as Timestamps and date amongst the others. This is a major setback for people beginning to learn SQL through SQLite. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

It's one of the best DB's to consider when building mobile applications and also when programming for embedded systems since its very light in size. The only drawback is scalability. If you have a small application, you can consider SQLite without any other considerations. However, if you have a large database and/or a large number of users, you might want to stay away from SQLite because of its scalability issues. Review collected by and hosted on G2.com.

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

SQLite does what it is meant for. Hence, using it as a primary database when building android applications or any other mobile applications seems to be the right choice because of its light-weightedness and ability to run on most of the PC's and smartphones. Since there is nothing to configure, it also runs right out of the box. Review collected by and hosted on G2.com.

M. Serhat D.

Senior Software Developer

Information Technology and Services

Small-Business (50 or fewer emp.)

1/8/2016

"Native Database of Ruby on Rails Projects"

4.5/5

What do you like best about SQLite?

SQLite supports almost all the SQL commands. It is a well documented database management system and also easy to use and easy to integrate with applications. I use SQLite in Ruby on Rails projects during the development because it is quite faster to test applications with SQLite than MySQL. Also SQLite is a native database management system for Ruby on Rails projects. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It stores data on raw files which is not the best practice for security reasons. Also SQLite databases don't support data encryption and stores all the data as plain-text. Because of these reasons most of the people prefer SQLite only in development rather than production. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you are a developer who is looking for easy to use, fast and reliable database management system during your development process, SQLite is the best option so far. Most of the programming languages and web frameworks are supporting SQLite natively. Review collected by and hosted on G2.com.

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

SQLite is quite handy when it comes to development. It is easy to setup and manage a SQLite databases. SQLite truly makes development process faster. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

12/31/2015

"Used in Android app"

5/5

What do you like best about SQLite?

+ comes pre-installed with Android

+ supports many SQL commands

+ it is a library/API - in the sense that you don't have to install/configure the database backend

+ SQLite is free of cost and the source code is free available

+ SQLite is well supported - there is a lot of documentation and experienced users out there

+ For desktop there are several utilities allowing browsing SQLite databases Review collected by and hosted on G2.com.

What do you dislike about SQLite?

- On Android: you can not browse SQLite content easily

- On Android: you can not preload database content (unless you use a hack like: SQLiteAssetHelper library) and are often forced to download the content from a website first

- SQLite is not a full-fledged database and for example does not support checks, triggers and stored procedures. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Check out the vast documentation available for SQLite.

You can ask sqlite-tagged questions at the Stackoverflow website Review collected by and hosted on G2.com.

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

Developing a multiplayer word game with 700,000 words in the dictionary (stored in SQLite) Review collected by and hosted on G2.com.

Brett N.

CTO

Computer Software

Small-Business (50 or fewer emp.)

5/13/2016

"A great quick soluton, but not a long term solution"

1/5

What do you like best about SQLite?

It is good for something quick and simple. Easy to deploy, easy to use and link to object. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Everything else.

It gets you up an running, and looks like an SQL database, but it is not really. ACID principles are missing.

Query optimisation is joke. Performance tends to scale with DB size (in the bad way).

For real production work you need something better. For a receipe app, it's probably okay. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Carefully check your scaling and persistence requirements and test them.

There are lots of people who rave about it, but there a number of big traps in the background. Review collected by and hosted on G2.com.

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

We use for a large database or nutrition information. Previously we used it for photo tags and other meta data. Review collected by and hosted on G2.com.

Verified User in Higher Education

Enterprise (> 1000 emp.)

1/2/2017

"Light Fast and easy to implement database"

4/5

What do you like best about SQLite?

SQLite is a light, fast, and remarkably easy to implement and use in our project. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Nothing to explain here. Sqlite does it's job. Review collected by and hosted on G2.com.

Verified User in Management Consulting

Enterprise (> 1000 emp.)

6/3/2016

"SQLite used as database in my app developments"

3.5/5

What do you like best about SQLite?

I use SQLite used as database in my app developments. Very easy to use. You can quickly learn to use this and create simple to complex queries. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Nothing really to dislike. If required it can be enriched in user experience. Although no complains!! Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

I use SQLite used as database in my app developments. Very easy to use. You can quickly learn to use this and create simple to complex queries. Review collected by and hosted on G2.com.

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

I use this for a app development . It is very simple to use and can be effectively embedded. Review collected by and hosted on G2.com.

Joe C.

Programmer Analyst

Government Administration

Enterprise (> 1000 emp.)

1/15/2016

"Just as strong as SQL"

4/5

What do you like best about SQLite?

I like that this lets you get files direct. no database server required. This is a very great program made for smaller devices, like moblie phones and tablets. I like that its an embedded relational batabase management system, and that it uses sql syntax.

I know that most will disagree but i like to think that its like a third party open sourced software.

I love that this is avalible for many platforms. OSX, Windows and Linux.

If you need more versions, on their website, there is many precompiled versions like Binaries for .NET, Windows Runtime, Windows Phone 8 & Universal App Platform.

There is so much information and help that its so easy to jump into and get help when stuck. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I tend to have issues when i dont map all my request through my database.

Other than its a great program, i tend to have issues when i need to have my oracle db to connect to it so it can have more functionality, since sqlite its a little limited. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

SQLite is just like SQL just made for tablets and mobile devices. Its suitable for storing small amounts of data locally and this mobile based application is where there is little to no need for web.

Easy to use. Review collected by and hosted on G2.com.

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

Coding applications and migrating to other languages. Runs great but have to rewrite and debug some issues. not sure if its just on conversion or bad programming. Review collected by and hosted on G2.com.