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.

Felipe N.

Analista Mobile Senior

Internet

Enterprise (> 1000 emp.)

1/10/2018

"Simple and useful for Mobile development"

3.5/5

What do you like best about SQLite?

All the basic sql options are present, so it's very useful for small mobile projects. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Some commands are different, so I needed to check the documentation to change them. Review collected by and hosted on G2.com.

Zil S.

Business Analyst/Product Owner

Food & Beverages

Mid-Market (51-1000 emp.)

3/7/2018

"SQLite is pretty good"

4/5

What do you like best about SQLite?

Easily accessible and same as like SQL server Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The scheme pattern is bit hard to manage as compare to SQL Review collected by and hosted on G2.com.

Sarneet C.

Software Developer Intern

Management Consulting

Small-Business (50 or fewer emp.)

8/9/2016

"Best native database solution for beginners"

4.5/5

What do you like best about SQLite?

SQLite has the following features I like the most

- Ease of Use

- Open Source

- Native and Portable

- Good performance for small applications

- easy to learn and apply

- supported by almost all frameworks

- great documentation Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There are some caveats to using SQLite

- Stores data on raw files. Not safe from security point of view

- For large applications, it fails due to high storage space and poor speed as compared to NoSQL

- SQLite databases don't support encryption Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

SQLite is best suited for small scale applications. It is supported by almost all frameworks and very easy to use. Great place to start for a beginner in database. Review collected by and hosted on G2.com.

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

SQLite is really easy to use and good for storing data natively. I have used it for storing data in small scale apps. Review collected by and hosted on G2.com.

David A.

Software Engineer

International Affairs

Small-Business (50 or fewer emp.)

4/18/2017

"Best embedded database. I use it everyday!"

5/5

What do you like best about SQLite?

It is embedded. It is fast. It is customizable. It is fully featured. I use it everyday, not only supports standard SQL but also: ridiculously fast, interoperable between systems (same binary format), supports plugins, supports advanced operations (Full-text search, custom functions, JSON, etc.) and support for multi-type columns (each value, a type not tied to the schema). Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Nothing, really. If you use it correctly, you won't find any issue. Of course, if you want to use a client/server model you have to ship your own, but being embeddable is the big plus for me. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Please, review features thoroughly against current versions. Most websites (stackoverflow included) state information that is no longer valid or false, because these opinions/information was deprecated. It is important to check current version and do proper testing. Review collected by and hosted on G2.com.

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

Lots! I use it for:

- Storing configuration parameters.

- Crunching data that does not fit in RAM.

- Store big amounts of data, in a queryable format.

- Mimic production environments for testing, without the use of a full database server.

- (and the list goes on and on...) Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

12/27/2017

"SQL Lite - Great Open tool "

4/5

What do you like best about SQLite?

Open tool that I could used for development of my personal projects. Also could used it for analysing some of my the data. Database itself is embedded into end program Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It's NOT a client server DB tool; nor is it meant as highly scalable tool like the conventional MS SQL or Oracle DB Review collected by and hosted on G2.com.

Verified User in Biotechnology

Small-Business (50 or fewer emp.)

12/15/2017

"Great cross platform database"

4/5

What do you like best about SQLite?

That the database the I use in my mobile app can be imported into my desktop app with no changes and it just works. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Lack of some more advanced features like store procedures limits ease of use. Lack of free full featured UI for design and development. Review collected by and hosted on G2.com.

Jeremy B.

Enterprise (> 1000 emp.)

1/10/2018

"A great companion for web app prototypes"

5/5

What do you like best about SQLite?

It's very very easy to setup and change with or without a gui tool. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It doesn't have the advanced options of other sql implementations. Review collected by and hosted on G2.com.

Chris W.

Network Engineer

Enterprise (> 1000 emp.)

1/29/2018

"Great software"

4/5

What do you like best about SQLite?

Easy interface and good database for links Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I do not have any dislikes for sql lite. Review collected by and hosted on G2.com.

Verified User in Higher Education

Mid-Market (51-1000 emp.)

1/18/2018

"SQL Lite - Good Database for Mobile Apps or Lightweight Database Work"

5/5

What do you like best about SQLite?

It is very easy to install and to deploy. Easy user interface Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The database itself is stored as a file, which can be confusing Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

I would recommend SQLite, particularly for mobile application development. It is a very easy to install and to administer. The file system implementation can be confusing but works well with Android platforms Review collected by and hosted on G2.com.

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

I have used this to store data on an Android phone for an app

I have also used it for teaching courses Review collected by and hosted on G2.com.