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 Computer Software

Enterprise (> 1000 emp.)

10/25/2018

"Great product for right project"

5/5

What do you like best about SQLite?

This works extremely well for small projects, easy to use, and easy to manage. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The documentation I have found seems to make things harder than it actually is. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

7/30/2018

"Easy to use for Mobile or Hybrid app development"

4.5/5

What do you like best about SQLite?

It is very light weight database and easy to integrate with the angular based mobile apps. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There are some limitation compared with the traditional or full veraion databases. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

7/31/2018

"Perfect for smaller sites without need for comcurrency"

5/5

What do you like best about SQLite?

Exactly what my title says. Very nice and simple DB. Great command line features as well to make it very easy to use. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It’s not concurrent, but it’s honestly not that big of an issue for most small to medium sized corps Review collected by and hosted on G2.com.

Fedor P.

Co-Founder/CEO

Computer Software

Small-Business (50 or fewer emp.)

11/8/2017

"Very well-developed and researched."

4.5/5

What do you like best about SQLite?

There is a lot of obvious research that was put into making the language, which makes it a very good choice to use in small scale projects that don't require the corporate/advanced features that regular SQL has to offer. This software is also available for many different platforms, which is great for small-time developers that want to use professional database software like this for free. It is also extremely fast, as I've never personally had issues with the speed of retrieving data regardless of the platform I am using. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

A lot of people dislike the SQL language in general, and often specifically the difficulty to create one-to-many relationships in SQLite, or just the difficulty of the SQL language in general. There also isn't any default encryption, which is a huge flaw for any product that is going to be used publicly and commercially. SQLite is also a single-user system. So, if it is a requirement that your company using a collection of accounts to manage the database, this could become an issue very quickly. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

SQLite is a great option for those that are looking for an entry-level database management system that doesn't require any commercial licensing. However, be aware that some issues might arise in the later stages of product development, especially if you are looking to release a product like this publicly. Review collected by and hosted on G2.com.

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

IT is really nice to be able to use a platform like this free-of-charge. I suppose this solves the problem of having to finance database software or possibly receive licensing for commercial use of some type of database software. Review collected by and hosted on G2.com.

Verified User in E-Learning

Small-Business (50 or fewer emp.)

7/17/2018

"Godd"

4/5

What do you like best about SQLite?

the best is the performance since the operations are more efficient and it is faster than MySQL and PostgreSQL and the portability is executed on many platforms and its databases can be easily carried out without any configuration or administration. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Lack of documentation in Spanish: although there is already a Spanish-speaking community of SQLite, it would be important to find much more. documentation, books, review, etc. as many other database engines count today. Review collected by and hosted on G2.com.

Verified User in Military

Small-Business (50 or fewer emp.)

7/31/2018

"Easy to learn with sql background"

4.5/5

What do you like best about SQLite?

I like the NaviCat GUI. It is easy to learn and follow. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I do low level troubleshooting but I struggle with C. I would prefer they use a more widely used language like C++ in sql server. Review collected by and hosted on G2.com.

Stefania S.

IT Specialist

Automotive

Enterprise (> 1000 emp.)

12/20/2017

"Great database tool for applications"

4.5/5

What do you like best about SQLite?

I made numerous portable applications, and I frequently workd with SQLite, and it is nice to work with SQLite to spare my in-application information. It is easy to use, quick and smooth.

With this tool I can simple find information, seek and sort. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

For the moment I like all, no dislikes, and exceptionally content with SQLite for applications. I don't utilize SQLite for site for work area application since I think it is too little for those sorts of application. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

SQLite is a must-have in your versatile application to spare data, stacking information and finding - arranging information, incorporating data spared with information in it. Review collected by and hosted on G2.com.

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

Versatile applications.Simple to spare information, connecting information, and discovering, arranging information. All that I have to work with information can be simple do with SQLite Review collected by and hosted on G2.com.

Jorge G.

It Manager

Information Technology and Services

Mid-Market (51-1000 emp.)

1/10/2018

"The best solution for mobile apps"

5/5

What do you like best about SQLite?

SQLite is the easy way to develop mobile apps, you can use in Android, iOS and even Windows UWP, is lightweight, and bring almost all the need for local storage. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Some function could be better specially the rules for update data, but is enough for resolve almost any kind of apps Review collected by and hosted on G2.com.

Kat F.

Executive Administrator

Mid-Market (51-1000 emp.)

2/16/2018

"Simple, Portable, Open Source, Deploy Anywhere"

4.5/5

What do you like best about SQLite?

See title! One disk image, run on any system or smartphone, bindings for any language I've ever looked for (base is ANSI-C), stability Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There really isn't anything about SQLite to dislike. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

I'd recommend it even if you're put off by the "Lite" terminology...fully configured, it's a powerhouse, plain and simple. Review collected by and hosted on G2.com.

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

Single file can be combined quite quickly and easily into current project. There's help available for any questions you run into - someone's already solved your problem, so there's no down time, isolated transactions saved our bacon after destructive Hurricane. Review collected by and hosted on G2.com.

Scott S.

Chief Technology Officer

Computer Software

Small-Business (50 or fewer emp.)

12/27/2017

"Excellent dev database environment "

5/5

What do you like best about SQLite?

This database has everything you need to get a web application up and running without the hassle of setting up a full database environment, it’s all in one easy file Review collected by and hosted on G2.com.

What do you dislike about SQLite?

If your coming from a MySQL background you will quickly realize the simplified data types and if your deepening on your database to enforce those requirements you will be out of luck. SQLite doesn’t support dates, times, or timestamps Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you need the power of MySQL on a mobile device use SQLite, it is the best solution around! Review collected by and hosted on G2.com.

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

SQLite is my go to solution for both local development and for mobile offline development. As long as you understand it’s limitations it is an excellent database Review collected by and hosted on G2.com.