Average Ratings

  • Overall
    4.5 /5
  • Ease of Use
    4.5 /5
  • Customer Service
    3.6 /5

About SQLite

Open source database engine used by applications due to its compact size, cross platform stability and serverless functionality.

Learn more about SQLite

Showing 86 reviews

Umut K.
Game Developer
Entertainment, 11-50 Employees
Used the Software for: 2+ years
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    4 /5
  • Customer Support
    3 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    7/10
  • Reviewer Source 
  • Reviewed on 20/08/2020

"Fast Embedded database"

Pros: Compact
Fast
Easy to use
Preinstalled in most platform

Cons: Do not support nosql features
Do not support multi client

  • Reviewer Source 
  • Reviewed on 20/08/2020
Carl H.
Software Developer
Computer Software, Self Employed
Used the Software for: 2+ years
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    5 /5
  • Customer Support
    Unrated
  • Value for Money
    5 /5
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 28/02/2019

"Great for simple persistent storage"

Pros: SQLite is great because it is really easy to interface with a number of languages, my preference being C#. This allows me to create persistent storage for my applications or Unity games. SQLite is also great because it does not require an installation, either on the developers side nor the players side, it is a simple DLL which can be embedded into the application with ease. It also has great support with database management GUIs allowing me to debug the database very quickly.

Cons: Off the top of my head, there are no glaring issues with SQLite. However it is important to know when a system like this is needed as opposed to another simple storage option such as XML/JSON etc.

  • Reviewer Source 
  • Reviewed on 28/02/2019
Verified Reviewer
Software Developer
Information Technology & Services, 11-50 Employees
Used the Software for: 1+ year
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    5 /5
  • Customer Support
    5 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 02/04/2019

"A very efficient way to store certain kinds of data."

Comments: 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.

  • Reviewer Source 
  • Reviewed on 02/04/2019
Ali O.
Analyst
Information Technology & Services, 11-50 Employees
Used the Software for: 2+ years
  • Overall Rating
    4 /5
  • Ease of Use
    4 /5
  • Features & Functionality
    4 /5
  • Customer Support
    4 /5
  • Value for Money
    4 /5
  • Likelihood to Recommend
    8/10
  • Reviewer Source 
  • Reviewed on 08/05/2019

"Small, Fast And Efficient RDBMS"

Pros: SQLite is a great RDBM solution if you need a database for embedded devices, IoT, websites or cache management. It is small, fast and efficient. It doesn't require any setup or administration. It provides easy to use APIs.

Cons: if what you need is a client-server database, it's not for you.

  • Reviewer Source 
  • Reviewed on 08/05/2019
Danoosh D.
Metadata Specialist
Used the Software for: 1+ year
  • Overall Rating
    4 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    3 /5
  • Customer Support
    Unrated
  • Value for Money
    Unrated
  • Likelihood to Recommend
    8/10
  • Reviewer Source 
  • Reviewed on 17/05/2018

"A suitable light weight for small applications (and learning)"

Pros: I use this for teaching SQL and databases to beginners. It is very easy to setup and navigate (command line and DB browser). It has reasonable power to deal with mid-range databases for developing and supporting small applications

Cons: If you are working with enterprise scale data (even small in enterprise realm), it will crash on you quite easily. You can not have multiple connections and it does not have many features of free MySQL

  • Reviewer Source 
  • Reviewed on 17/05/2018
Jimcarl S.
Data Analyst
Information Technology & Services, 1,001-5,000 Employees
Used the Software for: 6-12 months
  • Overall Rating
    4 /5
  • Ease of Use
    4 /5
  • Features & Functionality
    4 /5
  • Customer Support
    4 /5
  • Value for Money
    4 /5
  • Likelihood to Recommend
    8/10
  • Reviewer Source 
  • Reviewed on 09/09/2018

"Good choice for portable database"

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.

  • Reviewer Source 
  • Reviewed on 09/09/2018
Julio S.
Developer
Computer Games, 11-50 Employees
Used the Software for: 2+ years
  • Overall Rating
    5 /5
  • Ease of Use
    4 /5
  • Features & Functionality
    4 /5
  • Customer Support
    5 /5
  • Value for Money
    Unrated
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 26/04/2019

"Database on the go!"

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.

  • Reviewer Source 
  • Reviewed on 26/04/2019
Rita N.
Software Engineer
Computer Software, 501-1,000 Employees
Used the Software for: 2+ years
  • Overall Rating
    4 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    4 /5
  • Customer Support
    4 /5
  • Value for Money
    4 /5
  • Likelihood to Recommend
    9/10
  • Reviewer Source 
  • Reviewed on 09/06/2019

"Invaluable offline database"

Pros: SQLite is great for rapid applications development and testing out how your application works without having to connect to a server.
It serves as a decent local cache of data.

Cons: Understandably not suitable for large data content

  • Reviewer Source 
  • Reviewed on 09/06/2019
Denis D.
Ph.D. Student
Research, Self Employed
Used the Software for: 2+ years
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    4 /5
  • Customer Support
    Unrated
  • Value for Money
    5 /5
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 24/12/2019

"Very good for studying SQL, small projects and local storage"

Comments: Sometimes I use it as a stand alone application to make queries in the terminal or as a driver/library that is easily embedded into some of my software.

Pros: Very small footprint and overhead, battle-tested in real-world applications (which indicates that it’s pretty reliable) and well supported by several major companies.
It’s also very good for people learning SQL due to its simplicity.

Cons: Cannot handle very large datasets well. It’s not ideal for concurrently running or distributed software.

  • Reviewer Source 
  • Reviewed on 24/12/2019
Kyle J.
Web Developer
Education Management, 11-50 Employees
Used the Software for: 1-5 months
  • Overall Rating
    4 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    5 /5
  • Customer Support
    5 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    6/10
  • Reviewer Source 
  • Reviewed on 05/05/2018

"Small Scale Sql Engine"

Comments: Side projects with a SQL database engine.

Pros: SQLite is a great option for those that are looking for an low level database management system that doesn't require licensing which makes it a very good choice to use in small scale projects that don't require the enterprise level features that regular SQL has to offer. Available for many different platforms, good for small development teams that want to use professional database software. It is also extremely fast, as I've never personally had issues with the speed of retrieving data regardless of the platform I am using.

Cons: Not good for large scale or data warehousing. I would recommend only for small projects or personal use for side projects.

  • Reviewer Source 
  • Reviewed on 05/05/2018
Alafia V.
Analista de programas
Used the Software for: 6-12 months
  • Overall Rating
    4 /5
  • Ease of Use
    4 /5
  • Features & Functionality
    4 /5
  • Customer Support
    4 /5
  • Value for Money
    4 /5
  • Likelihood to Recommend
    8/10
  • Reviewer Source 
  • Reviewed on 28/06/2018

"I used it while I was in a Java programming course in the practical exercises and final project"

Comments: Practices and test projects

Pros: It is a portable and lightweight database to handle small data quantities or parameters of an application without complicated configurations

Cons: If there is no continuous debugging process and the database scale may present synchronization problems, you do not have the option to have stored procedures

  • Reviewer Source 
  • Reviewed on 28/06/2018
Marco R.
Coordinatore Area Business Intelligence
1,001-5,000 Employees
Used the Software for: 2+ years
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    5 /5
  • Customer Support
    3 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    9/10
  • Reviewer Source 
  • Reviewed on 07/05/2018

"Database small and effective"

Comments: If you need a small and robust DB it is the right choice

Pros: Given its size, it is almost an obligatory choice for small databases to be distributed, for example through an app. The latest releases have also made it very robust.

Cons: From the name it is clear that the database is not designed to accommodate large amounts of data, so we need to evaluate the adoption well.

  • Reviewer Source 
  • Reviewed on 07/05/2018
Verified Reviewer
Game Developer
Computer Networking, Self Employed
Used the Software for: 6-12 months
  • Overall Rating
    4 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    5 /5
  • Customer Support
    5 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    8/10
  • Reviewer Source 
  • Reviewed on 14/09/2018

"Database for as storage"

Comments: 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.

  • Reviewer Source 
  • Reviewed on 14/09/2018
Sean B.
Student
Computer Software, Self Employed
Used the Software for: 1-5 months
  • Overall Rating
    4 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    4 /5
  • Customer Support
    Unrated
  • Value for Money
    Unrated
  • Likelihood to Recommend
    8/10
  • Reviewer Source 
  • Reviewed on 20/09/2019

"Get the job done quickly"

Comments: Small scale projects that just need an external datastore with more sophistication than a simple JSON file and with minimal friction to setup.

Pros: The best choice for setting up an entire database in a jiffy for those quick projects, with all the simple functionality you would expect from larger databases.

Cons: I still need a recommend having a separate database navigation tool to view and edit data quickly, especially for the occasional quick dirty fixes

  • Reviewer Source 
  • Reviewed on 20/09/2019
Verified Reviewer
Big Data Developer
Computer Software, Self Employed
Used the Software for: 6-12 months
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    3 /5
  • Customer Support
    3 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    7/10
  • Reviewer Source 
  • Reviewed on 12/10/2018

"Sqlite for backend app"

Pros: It's free and open source.
easy to use - plug and play,

Cons: low documentation level.
decode problems.

  • Reviewer Source 
  • Reviewed on 12/10/2018
James francis K.
Software Engineer
Computer Software, 1,001-5,000 Employees
Used the Software for: 1+ year
  • Overall Rating
    4 /5
  • Ease of Use
    4 /5
  • Features & Functionality
    4 /5
  • Customer Support
    4 /5
  • Value for Money
    4 /5
  • Likelihood to Recommend
    9/10
  • Reviewer Source 
  • Reviewed on 09/05/2019

"Light, Server-less database solution"

Pros: It is robust, easy to set up locally without having to install any server. It is supported on so many platforms

Cons: There is nothing really to dislike because I set it up for small projects with little data management requirements

  • Reviewer Source 
  • Reviewed on 09/05/2019
Rayla S.
Software development
Information Technology & Services, 201-500 Employees
Used the Software for: 6-12 months
  • Overall Rating
    3 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    3 /5
  • Customer Support
    3 /5
  • Value for Money
    4 /5
  • Likelihood to Recommend
    7/10
  • Reviewer Source 
  • Reviewed on 25/07/2019

"great for learning"

Pros: Sqlite is great for learning sql for android. For an application that will have data stored only in the app is perfect.

Cons: If your application has to store data in clouds or needs separate management is not the best option.

  • Reviewer Source 
  • Reviewed on 25/07/2019
Verified Reviewer
Développeur indépendant
Used the Software for: 6-12 months
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    5 /5
  • Customer Support
    5 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    9/10
  • Reviewer Source 
  • Reviewed on 01/02/2018

"For a specific use."

Pros: I love sqlite it's easy to start with for small projects, I for myself use it with none important data like website informations (phone, email, address...)

  • Reviewer Source 
  • Reviewed on 01/02/2018
Xavier B.
Programador Gis
Computer Software, 11-50 Employees
Used the Software for: 1-5 months
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    4 /5
  • Customer Support
    Unrated
  • Value for Money
    Unrated
  • Likelihood to Recommend
    9/10
  • Reviewer Source 
  • Reviewed on 09/12/2018

"An extended db software"

Pros: It's a light database software that have a lot of funcionalities

Cons: It dont allows to be used by multiple users at the same time

  • Reviewer Source 
  • Reviewed on 09/12/2018
Alexandra S.
Teaching Assistant
Higher Education, 5,001-10,000 Employees
Used the Software for: 1-5 months
  • Overall Rating
    5 /5
  • Ease of Use
    4 /5
  • Features & Functionality
    5 /5
  • Customer Support
    Unrated
  • Value for Money
    Unrated
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 15/04/2020

"Free and Easy SQL System"

Comments: I would recommend it for a free SQL database management system.

Pros: I used this for an introduction to SQL databases for my data analytics class and loved using it. It was easy to set up databases and had many useful features. It was easy to make queries and locate information.

Cons: You cannot work on it simultaneously with others. I did not experience any other issues with the software.

  • Reviewer Source 
  • Reviewed on 15/04/2020
Elena P.
Programmer
Used the Software for: 1-5 months
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    5 /5
  • Customer Support
    4 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    9/10
  • Reviewer Source 
  • Reviewed on 03/05/2018

"Great tool, really easy to use"

Pros: I really enjoy the GUI of the program instead of writing commands in Command Prompt, it's well organised and intuitive for use. All through requires some knowledge.

Cons: Only thing that i don't like is the documentation i find it confusing, but I found video tutorials out there to find it helpful

  • Reviewer Source 
  • Reviewed on 03/05/2018
Stephen O.
Lead Android Developer
Computer Software, 11-50 Employees
Used the Software for: 2+ years
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    5 /5
  • Customer Support
    4 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 22/03/2019

"Perfect database tool for embedded software"

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

  • Reviewer Source 
  • Reviewed on 22/03/2019
Verified Reviewer
General Manager
Information Technology & Services, 2-10 Employees
Used the Software for: 1+ year
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    3 /5
  • Customer Support
    Unrated
  • Value for Money
    Unrated
  • Likelihood to Recommend
    8/10
  • Reviewer Source 
  • Reviewed on 03/10/2019

"Great Database For Smaller Loads"

Comments: This is definitely a great option when we are working on smaller projects that require and embedded database rather than the whole database setup. You quickly get up and running but security is definitely a concern when working on more sensitive work

Pros: It doesn't required installing an extra software.
Provides the essentials in terms of structured query language which is often better than having to use a text file, especially when relations are involved.
It is very cross-platform from mobile, desktop etc which makes life easier.

Cons: When it comes to systems that may have a lot of concurrent actions it, in my experience, often tends to lock up.
It doesn't give much in terms of allowing to tune performance for more complex scenarios.
There is no user management in place thus there are not permissions, it may not be the best option for more sensitive data
Last I checked there was no date data type which means enforcing that date formats conformity is often on the developer's side.

  • Reviewer Source 
  • Reviewed on 03/10/2019
Luis miguel R.
Software Developer
Computer Software, 10,000+ Employees
Used the Software for: 1+ year
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    5 /5
  • Customer Support
    5 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 30/08/2019

"Great tool to have lightweight data bases."

Comments: I was a part of team developing micro-services in python, and we used SQL Lite to store persistent information on each microservice. It is a great option because the setup it's really simple.

Pros: * Really easy to install.
* It has compatibility with different operating systems.
* It can be used in many programming languages.
* The command line is easy to use.

Cons: * It's a light weight database if you are trying to save too much data you will face some problems.

  • Reviewer Source 
  • Reviewed on 30/08/2019
Kaleb-john L.
Senior Firmware Engineer
Computer Networking, 201-500 Employees
Used the Software for: 2+ years
  • Overall Rating
    4 /5
  • Ease of Use
    4 /5
  • Features & Functionality
    4 /5
  • Customer Support
    Unrated
  • Value for Money
    4 /5
  • Likelihood to Recommend
    8/10
  • Reviewer Source 
  • Reviewed on 12/06/2019

"Exactly what the name says SQL lite"

Comments: 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.

  • Reviewer Source 
  • Reviewed on 12/06/2019