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.

Harini R.

Principal Technical Analyst

Government Administration

Enterprise (> 1000 emp.)

4/8/2015

"Automotive Industry - Toolds development - Java application with JDBC calls to SQLite"

3.5/5

What do you like best about SQLite?

I wanted a database that is simple enough to configure and did not require whole lot of administration. This was used to store huge file information after parsing. Though it is a light weight database it had all the capability as any real time database. All the database calls were quick as the database is deployed with the application. It solved the purpose. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I have really nothing to dislike this product as this solved the purpose. Review collected by and hosted on G2.com.

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

We wanted a lightweight database as the application performance was crucial as this application will be executed during the build process. This application was designed to parse the codes and display any inefficient access of memory. This mem application was called as part of Make process this cannot take whole lot of time executing while trying to build the core application. We had to keep the application lightweight in order to do so we needed database support to parse store and access as required. This SQLite database solved this problem and worked efficiently. This application is live from 2007 and it's still running efficiently. Review collected by and hosted on G2.com.

Tatiana G.

Senior Software Engineer / Consultant

Information Technology and Services

Small-Business (50 or fewer emp.)

3/30/2015

"SQLite database with c# applications ans Asp.net websites"

5/5

What do you like best about SQLite?

It is very lightweight database that is embedded with your application. Since all it is a single database file is very easy to package.

SQLite does not need to be installed before it is used.

Also, lots of help docs and big community. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There was a limited IDEs for it, although recently the SQLiteStudio is out and it's quite good.

Depends on your task, SQLite should be only used for for small databases.

Not great for multi-user applications. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Choosing the right tool depends on your task Review collected by and hosted on G2.com.

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

Embedded applications that need to be portable.

Local applications, such as internal tools applications for single user.

Asp.Net websites to persist controls states per user.

Unit tests. Review collected by and hosted on G2.com.

Rafael B.

Sr. Principal Programmer / Analyst

Semiconductors

Enterprise (> 1000 emp.)

4/9/2015

"Simple and useful as embedded database"

5/5

What do you like best about SQLite?

SQLite is a great database for web applications with low write concurrency. It is perfect as an embedded database since it does not require a commercial license.

It is is easy to install and back up, these advantages are derived from it storing the data as a single file. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Since it only stores data, not code, any data processing logic needs to be done on the code layer.

Regarding security, it is very easy to open the file and review its contents since there is no security layer attached to the file. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

The database does not come with a GUI. I recommend you use Firefox's convenient SQLite Tool. Review collected by and hosted on G2.com.

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

Before implementing SQLite, I evaluated other options, but found this to be the best choice for a commercial PHP application running on Apache/IIS and used by a small team reading and writing to the database. Review collected by and hosted on G2.com.

Ethan O.

Frontend Developer

Human Resources

Mid-Market (51-1000 emp.)

4/9/2015

"SQLite is a mini postgres, does everything in a feather-lite package."

4/5

What do you like best about SQLite?

SQLite is very compact and light. As a rails developers SQLite is the default db for all environments because it is so compact you can ship a rails app and do everything you need to do with a db for any environment, although that isn't entirely recommended. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I'm not a fan of SQL databases in general. I much prefer NOsql dbs like mongo. The only other complaint I could imagine about sqlite is it isn't as fast as postgres, although for good reason. Postgres is a huge bulky application designed for production environments. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

SQLite is great as a compact SQL DB, for production environments, if your going to use a sql db instead of nosql, (which is my real recommendation) Postgres is a little faster.

AND ITS FREE, hell ya! Review collected by and hosted on G2.com.

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

Any kind of relational db issues can be solved with sqlite3. Review collected by and hosted on G2.com.

Bert S.

Chief technology Officer

Enterprise (> 1000 emp.)

4/16/2015

"best embedded database choice bar none"

5/5

What do you like best about SQLite?

very light install and memory footprint - plus does not require a Microsoft Windows service running 24x7 in the background. SQLite also implement the SQL language syntax very well so that switching from another database is often quite easy. The database engine and SQL optimizer also seem to run very efficiently, handling even the most complex SQL use cases with ease. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

as freeware, SQLite sometimes does not evolve as quickly as one might like - but given the cost it's hard to hold that against the product. Review collected by and hosted on G2.com.

Raju M.

Application System Analyst II

Information Technology and Services

Enterprise (> 1000 emp.)

3/26/2015

"Simple but enough to do a lot"

5/5

What do you like best about SQLite?

Light weight and simple but beautiful piece of software

Simple to learn and use within 20 minutes

Have enough features to perform data analysis on small and medium data sets

Useful for quick testing, Hassle free setup and ready to use within minutes

Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Integrated GUI interface is lacking . SQL server management studio (SSMS) like interface would be great so that user can avoid writing the code and have the work done with few clicks. Advance analytic functions within SQLLite will be very helpful Review collected by and hosted on G2.com.

Juan M.

Systems Engineer

Entertainment

Enterprise (> 1000 emp.)

4/9/2015

"Powerful, simple, embedded database that packs a punch!"

5/5

What do you like best about SQLite?

Powerful, simple, embedded database that packs a punch! Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Its really hard to find something not to like! Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you are looking for a light database for embedded systems or to test local web based scripts while skipping the installation and configuration of bigger databases look no further! Review collected by and hosted on G2.com.

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

SQLite is great for embedded devices, testing applications locally without having to install bigger database packages or spend time to properly configure said packaged (MySQL, postgres I'm looking at you!) Review collected by and hosted on G2.com.

Kartik N.

Software Developer

Computer Hardware

Mid-Market (51-1000 emp.)

4/6/2015

"I had good experience whilst using the product "

5/5

What do you like best about SQLite?

Easy to understand,

Ease of use once it learnt,

Is very fast,

Supports advanced features like taking snapshot of the database Review collected by and hosted on G2.com.

What do you dislike about SQLite?

They way the database is used by the user is different from the usual mysql ,oracle usage so can take up some time to start using it Review collected by and hosted on G2.com.

Michael F.

Senior Technical Account Manager, Team Lead

Computer Software

Enterprise (> 1000 emp.)

9/25/2012

"Name Says It All"

3/5

What do you like best about SQLite?

SQLite is a very lightweight DB, and it is extremely simple to get installed, and it is free. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

SQLite lacks most DB functionalities, which is be design, but it is hard to leverage even in a small packaged application. Review collected by and hosted on G2.com.

Jared T.

Solutions Architect

Enterprise (> 1000 emp.)

11/6/2012

"Great database tool for development, not quite a full blown db solution"

4/5

What do you like best about SQLite?

Ease of use, free, simple to install, less hassle when starting web development on local machine as it allows for skipping some of the dependencies required for more professional sql database solutions. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Not known for performance, does not have all features of a real database Review collected by and hosted on G2.com.