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.)

1/9/2016

"Fantastic Implementation of SQL"

4.5/5

What do you like best about SQLite?

SQLite is a great implementation of SQL for multiple platforms. It's a great choice for both web applications and mobile (Android and iOS in particular). I'm a big proponent of open-source software, and SQLite doesn't disappoint in this department. It can be used freely both for personal and commercial uses. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Configuration of SQLite can be a little bit daunting and confusing to new users without any experience. Luckily, there's a lot of community support and documentation on the web to help with this concern. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you are having trouble setting up a database using SQLite, I would recommend browsing the internet for documentation and help. I've found a lot of good resources on Stackover and other helpful web forums. Review collected by and hosted on G2.com.

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

I'm using SQLite as a backend with a local database stored on an iOS application. The iOS SDK supports both SQLite and another Apple-specific technology called Core Data. Core Data's backing end happens to be an SQLite database.

While I can manipulate and configure the data objects using a front end GUI in Xcode, I have used the sqlite3 tool from the command line in the past. Review collected by and hosted on G2.com.

André M.

Small-Business (50 or fewer emp.)

1/15/2016

"Simple and useful"

5/5

What do you like best about SQLite?

Definitely the ease of use. The library is already built in PHP, so you don`t need to setup a thing, everything is already done, just use it. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Being small and simple it is not so scalable, but I guess you wouldn't use it to store large DBs. Furthermore, don't expect it to have all the resources a powerful DBMS has, like stored procedures. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Since SQLite stores all data unencrypted and in plain-text in a regular file, be sure you are not storing this file in a public place, otherwise it can be access by people with malicious intents. Review collected by and hosted on G2.com.

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

I have used SQLite for many projects from web sites to mobile apps and it always served me well. Review collected by and hosted on G2.com.

Jodi R.

Photographer

Photography

Small-Business (50 or fewer emp.)

1/11/2016

"Easy, simple, and free!"

4.5/5

What do you like best about SQLite?

- Its free!

- Easy to install

- Easy to Maintain

- Fast!

- Has great querying capabilites Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Doesn't quite have all the features of a full db but it isn't a full db so I rally can't complain too much. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you need something that is face and not too cumbersome this is your product. Review collected by and hosted on G2.com.

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

We use this for our internal website with a relatively small user base and have had no issues, also great for people with little db experience. Review collected by and hosted on G2.com.

Verified User in Internet

Mid-Market (51-1000 emp.)

3/26/2016

"Quick development database"

5/5

What do you like best about SQLite?

1. No configuration requried

2. Can be kept in source control due to low size

3. ORMs can easily switch between SQLite and Postgres, so SQLite is mostly used in development and small to medium size applications. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

1. Restricted database size.

2. No caching mechanism of it's own. Review collected by and hosted on G2.com.

D. Gregory P.

EMR

Enterprise (> 1000 emp.)

1/5/2016

"SQLite is a great tool for maintaining our Databases"

4/5

What do you like best about SQLite?

Simple, and easy to use API and CLI

Once setup is complete, it is very easy to use

Can have mutiple databases worked on at one time Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I found it very difficult to setup, I know the instructions stated to just copy sqlite3.exe to target and run it, but found there were other programs that interfreerd with it. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Great tool. Allow lots of time before implemtning, dont have a tight schedule Review collected by and hosted on G2.com.

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

Using it for databases on our website. we have a smaller website that our employees use for communication and this was a great tool to replace the Fwrite we were using Review collected by and hosted on G2.com.

Verified User in Real Estate

Enterprise (> 1000 emp.)

3/10/2016

"Perfect for quick MVPs "

3.5/5

What do you like best about SQLite?

The best part of sqlite is that I don't need to have databases created beforehand. Like tables , it can create a database automatically when you use it with Django/Rails. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

No user management in the database and not the best option when you have to scale Review collected by and hosted on G2.com.

Michael M.

Cloud Specialist

Information Technology and Services

Small-Business (50 or fewer emp.)

5/24/2016

"Easy, light, good for testing"

3.5/5

What do you like best about SQLite?

Ease of setup; low resource consumption; great for testing Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Not as good performance as a "full" SQL installation Review collected by and hosted on G2.com.

Robin S.

Senior Consultant

Computer Software

Mid-Market (51-1000 emp.)

4/20/2015

"SQLite with Windows 8 Apps"

5/5

What do you like best about SQLite?

I have used SQLite in two fairly complicated Windows 8 store apps without any major issues at all. I would use it again in a heartbeat. It is extremely useful for Windows 8 Apps because it is serverless, lightweight and operates within the 'sandboxed' environment as required by the Windows 8 store. Needless to say, SQLite is also free. :-) Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I started out using SQLite Manager, which is a Firefox Add-in for SQLite. I found it really unpredictable and it would sometimes block the app from running correctly if I had the db open in SQLite Manager and the app solution debugging in Visual Studio at the same time.

SQLite Expert, a free, stand-alone tool that does not run as a browser plugin, seems to be a lot easier to work with and has more features. I would recommend it over SQLite Manager.

One thing that I have recently found was that if you plan to export data from SQLite to SQL Server, you need to be careful about the string lengths. For example, if you collect a string in a multi-line text box control in Win 8 XAML with a maxlength value set to match the corresponding field in your SQLite table, everything will work as expected. However, if you then export this string via some sort of service-based process and try to insert it to a varchar field in SQL Server with the same field length, you can run into overflow problems. This is because SQL Server counts the new line characters "\r\n" as four characters and XAML/SQLite count them as two. I am sure there must be other issues related to this difference, but this is the only one that has caused me problems thus far.

I can't think of anything I really strongly dislike about SQLite itself. I vaguely remember experiencing some stumbling blocks early on when trying to configure foreign keys, but it was probably because I wasn't familiar with the syntax. Review collected by and hosted on G2.com.

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

Both of the Windows 8 Apps that I personally used SQLite for used Guids as primary keys and that worked very well. Both apps required a fair number of tables (25-35). In some cases, the tables needed to be relatively dynamic. Some were loaded on the fly with text files, etc. I can't remember any problems with SQLiite. Overall, it worked very well. Review collected by and hosted on G2.com.

Isaac Z.

Product Specialist

Small-Business (50 or fewer emp.)

1/7/2016

"SQLite as Storage is Everywhere"

5/5

What do you like best about SQLite?

1. very slightly

2. Ease to use. need not configure, use it directory.

3. Portable. SQLite is everywhere, Linux, Windows, Mobile... Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Actually, my dislike is nothing.

It is not fair if said SQLite has some disadvantage that compared with other database. because SQLite is simply. Review collected by and hosted on G2.com.

Sulabh B.

Small-Business (50 or fewer emp.)

4/4/2015

"Perfect for mobile application"

4.5/5

What do you like best about SQLite?

While developing a Xamarin based application, we used SQLite as our backend for local data. SQLite is very light and easy to integrate with Xamarin (and with any other language or framework). You can write the uber-popular SQL language to read/write data as opposed to a home-baked flat file based data storage. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Because it is a local database, remote access is not possible. But SQLite was not designed to be accessed remotely anyway. I also had to struggle to find a right database management tool. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Find a good management tool. 0xDBE or SQLiteStudio (both cross-platform) are my suggestions. Review collected by and hosted on G2.com.

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

I was developing a mobile app to manage events in a festival in our local town. I initially planned for a REST based backend service to store data for the app. But for the initial release I used SQLite which decreased the development time significantly as I would not have to worry about backend at all. It also allowed the app to function even without internet connection. The app now uses a REST based backend that is used to synchronize the SQLite database. So SQLite is still the main data source for the app and it has worked out very well. Review collected by and hosted on G2.com.