SQLite

By SQLite

Re-claim Profile

Re-claim your company’s G2 profile

This profile hasn’t been active for over a year.
If you work at SQLite, you can re-claim it to keep your company’s information up to date and make the most of your G2 presence.

    Once approved, you can:

  • Update your company and product details

  • Boost your brand's visibility on G2, search and LLMs

  • Access insights on visitors and competitors

  • Respond to customer reviews

  • We’ll verify your work email before granting access.

Re-claim
4.3 out of 5 stars

How would you rate your experience with SQLite?

It's been two months since this profile received a new review
Leave a Review

SQLite Reviews & Product Details

Value at a Glance

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

13 months

SQLite Integrations

(2)
Integration information sourced from real user reviews.
Product Avatar Image

Have you used SQLite before?

Answer a few questions to help the SQLite community

SQLite Reviews (260)

View 1 Video Reviews
Reviews

SQLite Reviews (260)

View 1 Video Reviews
4.3
260 reviews

Review Summary

Generated using AI from real user reviews
Users consistently praise SQLite for its ease of use and lightweight design, making it ideal for small projects and mobile applications. The straightforward setup and integration with various programming languages enhance its appeal, allowing developers to quickly implement database solutions. However, many note that it is not suitable for large-scale applications due to limited scalability and performance issues under heavy traffic.

Pros & Cons

Generated from real user reviews
View All Pros and Cons
Search reviews
Filter Reviews
Clear Results
G2 reviews are authentic and verified.
Verified User in Information Technology and Services
AI
Small-Business (50 or fewer emp.)
"Best choice for testing purpose"
What do you like best about SQLite?

I like sqlite3 because it does not require a server to work with. And also it is much faster when compared to other databases. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The one think I didn't like it because it is not much secure and not a best choice for production. Review collected by and hosted on G2.com.

AG
MR
Small-Business (50 or fewer emp.)
"Super easy"
What do you like best about SQLite?

Easy to install, configure, and administer on Linux, Mac, or Windows. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

We don't dislike anything. Even the performance is good enough for many purposes. We can easily switch to MySQL, MariaDB, or PostgreSQL, and rarely do so. Review collected by and hosted on G2.com.

Verified User in Education Management
UE
Enterprise (> 1000 emp.)
"Good, but limited "
What do you like best about SQLite?

The database client is pretty straight forward to use, compare to other, larger name enterprise SQL clients. Extremely easy to dump a client on a workstation quickly and pass around entire databases during development Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Interface in client seems "smooshed". Everything is being crammed into a small viewing pane out of the box. Haven't played with reconfiguring the view settings, but I feel like I shouldn't have to. Review collected by and hosted on G2.com.

Verified User in Utilities
UU
Small-Business (50 or fewer emp.)
"SQLite as old MSSQL DBA"
What do you like best about SQLite?

Easy to use, manage and keep updated, simple to attach on your Projects, simple VS integration and develompent is good recived.

Easy to package with your application, and fast compresion with you are packaging with a new App.

Large compatibility with so mane OS and platforms, like Android, or IOS, well in my case I used with C# and embeded my DB with the application was easy, the idea to be just a simple file make my work easy in some many ways, you don't need a full RDBMS or install a portable server to use it, just a DLL and that's all.

With a couple of payed tools you can sync data or even make a big data repository. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

No relative ubication path, the files are needed to use full path, thats sometimes hard to determinate and use.

Reduced features like Unions and Joins by side for example, Right Join or even Triggers arn't well implemented.

Reduced Data types are a Disadvantage too, Text works well but sometimes you need somenting more complete

Numeric is usefull but you need more Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"LightWeight Database"
What do you like best about SQLite?

It is light weight db. We can use it in Mobile Applications. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Some Queries does not work in this. We can not delete a column. Review collected by and hosted on G2.com.

Carson W.
CW
CTO
Small-Business (50 or fewer emp.)
"Fantastic for what it is."
What do you like best about SQLite?

It is a flat file database so its portable, and simple. It is great if you are looking for those features. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It has query limitations, but otherwise there isn't much to complain about, just don't use it for a main data intensive application database. Review collected by and hosted on G2.com.

Sachintha H.
SH
Software Engineer
Computer Software
Small-Business (50 or fewer emp.)
"Most effective local database for my android mobile application developments"
What do you like best about SQLite?

Easy to work and configuration, it is database management tool for web developments. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

some SQL syntax are not support .string concatenation of schema it is difficult. Review collected by and hosted on G2.com.

Joan L.
JL
Data Analyst
Information Technology and Services
Enterprise (> 1000 emp.)
"No setup, quick and easy to implement database"
What do you like best about SQLite?

SQLite requires no setup. Create the sqlite or db file and you're good to go. It allows you to write and execute SQL scripts. It has ACID transactions that are reliable even on server crashes. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

SQLite is best used when studied carefully. Using it on medium-sized application might not be recommended. Review collected by and hosted on G2.com.

Verified User in Utilities
UU
Small-Business (50 or fewer emp.)
"My SQLite Review"
What do you like best about SQLite?

The best database for beginners to learn how to tinker with database management systems. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

For being a lightweight version database they lack enough functions that normally a robust database has. Review collected by and hosted on G2.com.

Verified User in Computer Software
CC
Enterprise (> 1000 emp.)
"lite as the name says"
What do you like best about SQLite?

saving data in the app is easy using sqllite. supporting offline features made simple with sqllite Review collected by and hosted on G2.com.

What do you dislike about SQLite?

nothing to dislike apart from writing those queries. Queries are at time complex to write. Review collected by and hosted on G2.com.

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

13 months

Average Discount

15%

SQLite Comparisons
Product Avatar Image
Microsoft Access
Compare Now
Product Avatar Image
MariaDB
Compare Now
Product Avatar Image
firebase
Compare Now
SQLite Features
Storage
Availability
Stability
Data Types
Languages
Operating Systems
Database Locking
Authentication
Data Schema
Query Language
Data Replication
Product Avatar Image
SQLite