SQLite

4.4 (118)
Write a Review!
Open-source database engine to store and modify data

Overall rating

4.4 /5
(118)
Value for Money
4.5/5
Features
4.1/5
Ease of Use
4.4/5
Customer Support
3.6/5

92%
recommended this app
Sort by

118 Reviews

Carlos Hugo Martin
Carlos Hugo Martin
Overall rating
  • Industry: Computer Software
  • Company size: 11–50 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 10.0 /10

Experience with SQLite

Reviewed on 2021/05/23

Describe your general experience with SQLite
It is very useful for me to be able to store informatio...

Describe your general experience with SQLite
It is very useful for me to be able to store information and consume it from different sources without having to implement specific software to do so. Its portability capacity has allowed us to distribute work effectively.

Pros

The few resources you need and its portability. This allows us to use the stored data from any medium.

Cons

That there is no native way to make it multi-user. That there is no native way to merge files from the same database, when they have been modified by different users and platforms.

Stephen
Stephen
Overall rating
  • Industry: Computer Software
  • Company size: 11–50 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Perfect database tool for embedded software

Reviewed on 2019/03/22

I work a lot with SQLite as it is the primary medium of local storage in Android devices (and by...

I work a lot with SQLite as it is the primary medium of local storage in Android devices (and by extension, Android applications) which I work with on a daily basis, and SQLite is just perfect for the purpose it serves on these devices. It's lightweight so you don't have to worry most times about how much of the user's storage space your database is going to take up.

There's not much difference between the standard SQL commands and those used in SQLite, and many have reported that SQLite is a good starting and training resource for SQL in general.

Pros

Doesn't need a separate server.
Lightweight and portable.
Integrates most of the commands, functions and syntax of other SQL software.
Optimized for use on devices that need to store data locally.
Large user base and community (support).

Cons

All operations are locked to a single process, so it's not suitable for large scale database operations (which is not what you should be doing locally on a device anyway).

Wechuli
Wechuli
Overall rating
  • Industry: Computer Software
  • Company size: 1,001–5,000 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 6.0 /10

Good but Limited Use

Reviewed on 2020/03/14

I use it to quickly test applications that need some form of data storage without needing to...

I use it to quickly test applications that need some form of data storage without needing to install database software.

Pros

- Very lightweight database products that you can quickly set up to without needing to install complicated tooling so can be used in mobile forms or embedded devices.

Cons

- Does not support the full features of SQL
- SQLite does not have support for multi-client concurrency access and can't be used in applications that need this.
- Validation of data to input fields is limited

Manuel Eduardo
Manuel Eduardo
Overall rating
  • Industry: Computer Software
  • Company size: Self Employed
  • Used Weekly for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

A complete and productive database manager

Reviewed on 2022/06/17

As a student, I have used SQLite in several projects, in which my experience has been good. Thanks...

As a student, I have used SQLite in several projects, in which my experience has been good. Thanks to its interface, understanding all its specific functions was not so difficult for me and at the same time working with its tools is an effective and fast process.

Pros

Access to databases created in SQLite is fast and easy, because it works as its own independent server. Its connection and management with computer and mobile applications is one of the best, its interface is quite simple and easy to use for the user.

Cons

It seems to me the most complete program in its field of work, so I don't see any cons about this program.

Anderson
Anderson
Overall rating
  • Industry: Information Technology & Services
  • Company size: 201–500 Employees
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 7.0 /10

Easy to become a problem

Reviewed on 2018/11/08

On a Windows Forms app we used to query services thousand times for data that does not change so...

On a Windows Forms app we used to query services thousand times for data that does not change so frequently. We also had to store some business information (imagine as storing a wizard progress) and that used to be handled using TXT files (and it was a mess). We changed to SQLite and it worked almost like a charm but as the app grew and we decided to create an architecture similar to Google Chrome (multiple processes) it became a major problem for all of them to both read and write at it (we had to create a proxy app to write).

Pros

Integrates nicely with .NET (specially Windows Forms) applications, it's really easy to use (specially if you're already familiar with SQL Server) and deployment is really easy (copy/paste required files).

Cons

It's locking architecture enables only a single process to write at a time so building a more complex application may cause hard-to-solve problems.

Ramindu
Ramindu
Overall rating
  • Industry: Computer Software
  • Company size: 10,000+ Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

The best solution for small, pre-packaged databases

Reviewed on 2019/11/26

We included SQLite alongside web and mobile applications where a small database was needed with...

We included SQLite alongside web and mobile applications where a small database was needed with minimum latency. Most commonly, this use case involved storing dynamic configuration values and user preferences.

Pros

SQLite is a great database solution when you have a small database that you need to package alongside an application, for example a database that stores user preferences. As it is local to the application, it bypasses issues you would have with other, larger database servers in terms of network latency. Its conformity (in the large part) to MySQL syntax and features make it easy to use as well.

Cons

While SQLite's lack of scaling features is forgivable (that wasn't what it was built for after all) some SQL features that are not implemented make it a hassle to write queries to SQLite databases in some instances.

Nera Joy
Nera Joy
Overall rating
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support

A good choice for storing small and local data

Reviewed on 2018/06/19

Pros

I love how SQLite is so portable, and can be used in different platforms. I doesn't need any bulky installation for me to use. It is so lightweight and there is no learning curve when you came from MS SQL.

Cons

Maybe when opening a large sqlite file around 1GB above, it hangs up and sometimes fails to load. But maybe that's my fault because SQLite is not intended for storing large data. Good product anyway.

Rahul
Rahul
Overall rating
  • Industry: Information Services
  • Company size: 11–50 Employees
  • Used Weekly for 1+ year
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 10.0 /10

A lightweight relational database management system especially for offline mobile applications...

Reviewed on 2019/01/18

We have used SQLite in developing many mobile apps, mostly Android App and as a database at back...

We have used SQLite in developing many mobile apps, mostly Android App and as a database at back end we integrated this light weight DB system. The processing speed of queries is exceptionally fast. All the databases are working well.

Pros

SQLite is object based relational query language which keeps and maintained the whole databases in a very light weight, usually within 500kb to 1mb size, depending on size of databases.

This database system has everything which a standard databases must have like relationships, events, all operations, etc.

SQLite is very helpful in building application for Mobiles which stores databases in locally.

Cons

1. No dedicated server required.
2. Very light weight and easy to follow commands with knowledge.
3. Large community support makes learning this language even more fast and easy
4. Easy to keep backups as the whole database stored in single file.
5. Easy to implement and integrate.

Yngrid
Yngrid
Overall rating
  • Used Weekly for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Database manager very functional, fast and easy to use for different programming languages

Reviewed on 2018/07/08

It is a public domain tool that when created with the C ++ language gives those who have experience...

It is a public domain tool that when created with the C ++ language gives those who have experience in programming the facility to adapt it to their requirements, SQLite is independent of the platform. The operations are carried out very efficiently with a single library and a small memory

Pros

This Database Manager is really very functional, transactions are fast and its simple interface makes it easy to use, you can work with different programming languages such as PHP and phyton. It is much less complex than other handlers such as Postgres or MySQL

Cons

It is not recommended for systems that use a large amount of data, rather for medium-sized applications or for websites whose number of transactions is very high. It also does not support systems under the client-server platform

Kaleb-John
Kaleb-John
Overall rating
  • Industry: Computer Networking
  • Company size: 201–500 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 8.0 /10

Exactly what the name says SQL lite

Reviewed on 2019/06/12

Whenever I need a database, SQLite is always a top option. Local storage is needed in most projects...

Whenever I need a database, SQLite is always a top option. Local storage is needed in most projects and the ability to use SQLite on almost any platform in almost any language means I always have the ability to execute the project with ease.

Pros

SQLite is a go to for when I need a quick lite weight database. It provides the ability to create local storage with the ability to integrate into most programming languages. It uses the familiar SQL structure and doesn't require any administration.

Cons

There are some areas where it deviates from using SQL language, but it is usually easily fixed by a quick Google search.

Semih
Overall rating
  • Industry: Program Development
  • Company size: Self Employed
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 6.0 /10

My SQLite Experience

Reviewed on 2023/05/06

Its average in my opinion. The data management are good but complicated

Its average in my opinion. The data management are good but complicated

Pros

The using of tools, tables and manage datas

Cons

The less functions compare other programs(etc. SSMS)

Verified Reviewer
Overall rating
  • Industry: Telecommunications
  • Company size: 11–50 Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

No server required, used for standalone application and less configuration

Reviewed on 2019/04/25

We are using SQLite for java and android application. SQLite is use for small and mid level...

We are using SQLite for java and android application. SQLite is use for small and mid level organization as well because its cost affordable for any one. There is no required to back up every time because SQLite make a file for backup .

Pros

SQLite is very faster then other database as performance wise. we are using SQLite for mobile application and desktop application. Mose imp feature i like in SQLite is at the time of deployment on production it not required any space. SQLite is lightweight. select query is very faster in standalone application.

Cons

There is no reporting functionality in SQLite. At the time of multiple insert query perform in queue that its goes slow for some time. There is administration in SQLite,so its very difficult to manage for multiple user.

Gareth
Overall rating
  • Industry: Computer Software
  • Company size: 11–50 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 9.0 /10

A standard for testing

Reviewed on 2019/09/14

SQLite allows us to setup and test all our database structures, it's quick and easy to get going...

SQLite allows us to setup and test all our database structures, it's quick and easy to get going and it stays out of your way. Most of the time you'll forget that it's even part of your tech stack.

Pros

I like that SQLite for the most part stays out of your way. As soon as you have your desired config set up, you can transfer it with ease to most other projects and it just works. We use SQLite for testing purposes as it speeds up the entire process. You can either spin a local instance up or have it run in-memory to speed up your tests. The fact that it's usage is so ubiquitous, finding help or answers online isn't an issue at all.

Cons

If I had to fault it at something, there is an edge case with how it builds your database structure, especially with how it handles foreign keys. It's easily handled by adjusting your test setup structure. That's the only hiccup we ever had and resolved with ease.

Barış
Overall rating
  • Industry: E-Learning
  • Company size: 11–50 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Database easily with SQLite

Reviewed on 2022/06/06

I used this application to learn database systems. I transferred the excel data I had, created...

I used this application to learn database systems. I transferred the excel data I had, created tables, and transferred this data to the external environment with an external connection.

Pros

The application is very easy to use. The interface is simple and user friendly. The convenience of the download process is amazing. Very little space on the computer

Cons

There is nothing wrong with the application, it is suitable for learning purposes.

Prince
Overall rating
  • Industry: Computer Software
  • Company size: 2–10 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Best Lightweight Relational Database for Small Applications and Websites.

Reviewed on 2021/06/03

We always use SQLite as our database when building software and web application prototypes and when...

We always use SQLite as our database when building software and web application prototypes and when deploying basic websites and apps that are not data-intensive.

Pros

SQLite does not run on a server like MySQL but is part of the end application thus making data storage and retrieval very fast.

Cons

It is not reliable when deploying it with applications with multi-user access to database.
With websites, SQLite can only handle sites with low to medium traffic.

Verified Reviewer
Overall rating
  • Industry: Logistics & Supply Chain
  • Company size: 201–500 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 8.0 /10

Great lightweight database for simple use cases

Reviewed on 2022/06/06

Overall, SQLite allows us to build tools more rapidly. We've had a productive overall experience...

Overall, SQLite allows us to build tools more rapidly. We've had a productive overall experience with SQLite.

Pros

I like how easy it is to use SQLite. It allows us to have a database backend without the usual set up and configuration steps needed for more complex RDBMS.

Cons

I don't really have anything I dislike about SQLite. It does its job well on its intended use cases.

Mehak
Overall rating
  • Industry: Computer Software
  • Company size: 1,001–5,000 Employees
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

Free and quick to setup and use.

Reviewed on 2019/12/28

The use-case I used SQLite was fairly simple I had to set up some small application quickly so this...

The use-case I used SQLite was fairly simple I had to set up some small application quickly so this was the best possible solution for me.

Pros

The fact that it requires no installation makes it suitable for a quick application setup. It's a very lightweight tool that makes it useable across many systems. SQLite does not require a separate location that can be on the same server location which makes the I/O processing really fast and reliable.

Cons

Due to the lightweight, there ought to be some restrictions one of them is that a large number of concurrent access might let to a system crash. One more issue is that is works with whole DB lock while performing a write operation so all the write operations are sequential.

Jimcarl
Jimcarl
Overall rating
  • Industry: Information Technology & Services
  • Company size: 1,001–5,000 Employees
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

Good choice for portable database

Reviewed on 2018/09/09

Pros

I like how SQLite offer T-SQL despite of being a portable database. I can create moderately complex queries and still runs fine.

Cons

There's nothing I really don't like with SQLite. It's free and does the job.

Verified Reviewer
Overall rating
  • Industry: Information Technology & Services
  • Company size: 5,001–10,000 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

Best relational database system for embedded applications.

Reviewed on 2019/09/28

Bets choice to choose SQL for store data on embedded application instead of connecting Server and...

Bets choice to choose SQL for store data on embedded application instead of connecting Server and get data.

Pros

SQLite support almost ANSI standard SQL, If you know PostgreSQL it is very much easy to adapt SQLite, Best thing it supports ACID properties.Its embedded database software so its faster than client-Server databases.

Cons

As it's a lightweight database software , it works perfect when your database size is smaller , but your Database size is more you can see performance issues.

Steve
Overall rating
  • Industry: Electrical/Electronic Manufacturing
  • Company size: 11–50 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 8.0 /10

Very good local database.

Reviewed on 2022/06/30

Pros

We use it in our software when we need little local database. The API with c# is very easy to learn. I recommand this if you need local database.

Cons

There is no data viewer include. You need to find an alternative.

Verified Reviewer
Overall rating
  • Industry: Information Technology & Services
  • Company size: 11–50 Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

A very efficient way to store certain kinds of data.

Reviewed on 2019/04/02

We use it for storing certain data.

We use it for storing certain data.

Pros

You get all the benefits of using sql statements without having to set up a sql server online.

Cons

SQL syntax varies between the different versions of sql so the syntax you are familiar with may or may not be available in sqlite.

Sadia
Overall rating
  • Industry: Computer Software
  • Company size: 201–500 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

Lightweight, Easy to integrate

Reviewed on 2021/01/15

Pros

If the application is not an ERP sort of then Sqlite is the best choice, it's easy to integrate and fast if the data is small. Best choice for beginners as well.

Cons

Its performance is really impacted if the data gets large overtime. Not a good choice for applications with many users.

Verified Reviewer
Overall rating
  • Industry: Computer Networking
  • Company size: Self Employed
  • Used for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

Database for as storage

Reviewed on 2018/09/14

SQLite is perfect for a certain kind of usage. Not for massive access but amazing for compact...

SQLite is perfect for a certain kind of usage. Not for massive access but amazing for compact traditional database.

Pros

SQLite is fast and durable due to it's file-as-database approach. SQL Dump is very much compliant with most other databases.

Cons

The bottle-neck on concurrency makes SQLite unsable for server/client use.

John D.
Overall rating
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

SQLite made pulling, manipulating and evaluating data from multi-relational databases a breeze!

Reviewed on 2018/07/25

Ease of accessing data for Ad-Hoc reports.

Ease of accessing data for Ad-Hoc reports.

Pros

Linking SQLite to the internal database was quite simple; setting up authorized users was as well.

Cons

SQLite could be finicky on my company's database, I would sometimes switch over to Sandbox to run quicker queries.

Julio
Overall rating
  • Industry: Computer Games
  • Company size: 11–50 Employees
  • Used for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Database on the go!

Reviewed on 2019/04/26

Pros

SQLite is a great solution when your application needs a small footprint database with all the powers from relational SQL. It integrates with any language you need and is available in any platform!

Cons

Being a smaller library, it misses some features from bigger database systems.