SQLite Ratings

Overall
4.5/5
Ease of Use
4.5/5
Customer Service
3.5/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 Most Helpful

Showing 50 of 64 reviews

Showing Most Helpful

Showing 50 of 64 reviews

Sort by:

Filter By:

Rating
Company Size
Reviewer's Role
Length of Use
Frequency of Use
Gareth N.
Web Developer
Computer Software, 11-50 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
4/5
Features
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
September 14, 2019

“A standard for testing”

OverallSQLite 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.
ProsI 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.
ConsIf 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.
Reviewer Source 
Source: Capterra
September 14, 2019
Avatar Image
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
Customer Service
4/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
March 21, 2019

“Perfect database tool for embedded software”

OverallI 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.
ProsDoesn'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).
ConsAll 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 
Source: Capterra
March 21, 2019
Verified Reviewer
Telecommunications, 11-50 employees
Used the software for: 1-2 years
Overall Rating
5/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
April 25, 2019

“No server required, used for standalone application and less configuration”

OverallWe 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 .
ProsSQLite 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.
ConsThere 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.
Reviewer Source 
Source: Capterra
April 25, 2019
Verified Reviewer
Information Technology and Services, 1-10 employees
Used the software for: 1-2 years
Overall Rating
5/5
Ease of Use
5/5
Features
3/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
October 3, 2019

“Great Database For Smaller Loads”

OverallThis 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
ProsIt 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.
ConsWhen 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 
Source: Capterra
October 3, 2019
Avatar Image
Anderson M.
Senior Software Engineering
Information Technology and Services, 201-500 employees
Used the software for: 6-12 months
Overall Rating
4/5
Ease of Use
3/5
Customer Service
3/5
Features
2/5
Value for Money
5/5
Likelihood to Recommend
7/10
Reviewer Source 
Source: Capterra
November 8, 2018

“Easy to become a problem”

OverallOn 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).
ProsIntegrates 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).
ConsIt'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.
Reviewer Source 
Source: Capterra
November 8, 2018
Avatar Image
Chaya W.
Trainee Software Engineer
Computer Software, 51-200 employees
Used the software for: 1-2 years
Overall Rating
3/5
Ease of Use
3/5
Customer Service
2/5
Features
3/5
Value for Money
3/5
Likelihood to Recommend
6/10
Reviewer Source 
Source: Capterra
April 2, 2019

“SQLite - compatability at it's best level”

OverallSQLite has become more and more popular among the users because of its easy installation and easy accessing . As it is compatible with most of the programming languages and its light weight it is more popular among mobile application developers
ProsSQLite is a light weighted data base which could be embedded with any software. Due to the light weightage of the product the data base is more popular In mobile application development. With it's light weight it is also fast. SQLite is almost 35% faster than any other file system. SQLite is easy to use and there is not special installation or configurations needed to be done in order to use the product. All user have to do is download the libraries and run them in the computer. It is compatible which is why the product can be used with many programming languages with out any issues. Users are given a chance to extend their data base in future by adding new tables or new columns to the existing tables which is a great help for the ongoing projects.
ConsSQLite is not a multi-user platform where the users can handle concurrent writes. There for SQLite is not good for intensive applications with rapid data logging. If the system has concurrent transactions where lot of users keep accessing the same set of data simultaneously then SQLite is not a good choice for the project. SQLite data bases are restricted to maximum of 2GB in most of the cases.
Reviewer Source 
Source: Capterra
April 2, 2019
Avatar Image
Nera Joy C.
Software Programmer
Unspecified
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
4/5
Customer Service
3/5
Features
2/5
Value for Money
3/5
Reviewer Source 
Source: Capterra
June 18, 2018

“A good choice for storing small and local data”

ProsI 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.
ConsMaybe 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.
Reviewer Source 
Source: Capterra
June 18, 2018
Verified Reviewer
Computer Software, 11-50 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
March 6, 2019

“The perfect landscape to train and test SQL”

OverallIntegrates well with SQL learning tool. Followed many guides in my quest to learn SQL and almost all suggested SQLite. This is mostly for training and testing.
ProsAbout as simple as it gets -- as the name suggests. Made learning SQL easy knowing I wouldn't be affecting my own database.
ConsI truly enjoyed using the product although I never use it anymore. It sits dormant on my computer now that I have a grasp of SQL.
Reviewer Source 
Source: Capterra
March 6, 2019
Avatar Image
Rahul A.
Back End Developer & Programmer
Information Services, 11-50 employees
Used the software for: 1-2 years
Overall Rating
5/5
Ease of Use
5/5
Features
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
January 18, 2019

“A lightweight relational database management system especially for offline mobile applications and d”

OverallWe 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.
ProsSQLite 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.
Cons1. 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.
Reviewer Source 
Source: Capterra
January 18, 2019
George S.
CEO
Computer Software, 1-10 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
August 15, 2019

“Great choice if you use it correctly”

ProsSQLite is a fantastic database for resource-constraint systems or for those cases where full-blown SQL client-server system is not required. SQLite has been probably implemented for any platform. It even exists for microcontrollers. When used properly, SQLite makes programmers life easy.
ConsThere is nothing that I dislike about SQLite.
Reviewer Source 
Source: Capterra
August 15, 2019
Carl H.
Software Developer
Computer Software, Self-employed
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
February 28, 2019

“Great for simple persistent storage”

ProsSQLite 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.
ConsOff 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 
Source: Capterra
February 28, 2019
Pablo S.
RPA Developer
Information Technology and Services, 5001-10,000 employees
Used the software for: 1-2 years
Overall Rating
3/5
Ease of Use
5/5
Features
4/5
Value for Money
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
September 30, 2019

“My Own Experience working with SQLite”

OverallMy overall experience using SQLite is good, but it is based on small projects, always working locally and with little information. If you are thinking of working on large-volume information projects, I recommend other applications related to somewhat better, more visual databases, and with more functions to generate code and store queries or procedures.
ProsThe best thing about SQLite is undoubtedly that you can work with it for free. In addition with SQLite we can perform any type of query that we would perform with another program.
ConsWhat I like least about SQLite is undoubtedly nothing visual. The way to work with SQLite is through the console, and this may seem silly, and when you are accustomed it may not matter, but for people who begin to familiarize themselves with database environments, it is really useful for tables, and which is done with them, be fully visible. When displaying results by console, unless you print them in an external table, such as an Excel workbook, it will be quite complicated to see and analyze large results (Tables over 10k rows for example)
Reviewer Source 
Source: Capterra
September 30, 2019
Luis Miguel R.
Software Developer
Computer Software, 10,001+ employees
Used the software for: 1-2 years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
August 30, 2019

“Great tool to have lightweight data bases.”

OverallI 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 
Source: Capterra
August 30, 2019
Avatar Image
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
4/5
Value for Money
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
June 12, 2019

“Exactly what the name says SQL lite”

OverallWhenever 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.
ProsSQLite 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.
ConsThere are some areas where it deviates from using SQL language, but it is usually easily fixed by a quick Google search.
Reviewer Source 
Source: Capterra
June 12, 2019
Avatar Image
Yngrid M.
Docente y Coordinadora del Dpto de Informática
Unspecified
Used the software for: 1-2 years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
3/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
July 8, 2018

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

OverallIt 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
Reviewer Source 
Source: Capterra
July 8, 2018
Verified Reviewer
Computer Software, 1-10 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
4/5
Features
3/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
April 20, 2019

“Open Source solution for local persistence”

ProsIt's lightweight, it complies most simple SQL language, it does not need a server process working and it's free. These make SQLite a good option to store information locally in your application without running any extra application. For example, you can use it in a wide set of scenarios: mobile apps, embedded apps, or even desktop apps where you do not need intensive data change. It is Open Source and widely used, what makes it a plus for the community support.
ConsIt is not a good option for heavy load work. The lock mechanism that SQLite uses means that multiprocess applications will have to look for potential concurrency issues. Also it does not have the high end benefits of RDBMS, you can find problems working with big files or intensive use of data.
Reviewer Source 
Source: Capterra
April 20, 2019
Verified Reviewer
Information Technology and Services, 11-50 employees
Used the software for: 1-2 years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
April 1, 2019

“A very efficient way to store certain kinds of data.”

OverallWe use it for storing certain data.
ProsYou get all the benefits of using sql statements without having to set up a sql server online.
ConsSQL 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 
Source: Capterra
April 1, 2019
Avatar Image
Ashok G.
Automation Test Lead
11-50 employees
Used the software for: 1-2 years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
4/5
Features
3/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
April 17, 2018

“To store small data perfect solution”

Pros1. It is free 2. Easy to set up and connect 3. Multiple person can use simultaneously which we cann't do in CSV
Cons1. Integration with some other tools is not so much easy 2. Loading time for existing tables is little high 3. No stored procedure can be written
Reviewer Source 
Source: Capterra
April 17, 2018
Avatar Image
Mohamed S.
Freelancer
Information Technology and Services, 201-500 employees
Used the software for: 6-12 months
Overall Rating
5/5
Ease of Use
5/5
Features
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
July 18, 2019

“Used it for a small python project, and It was great”

ProsIt's in the name, it's very light and easy to run, but what I like most is the interface, it's simple and doesn't need a learning curve.
ConsSome features aren't available, like some sql commands and also when a lot of people are updating the db, this may cause a data crash.
Reviewer Source 
Source: Capterra
July 18, 2019
ARIEL M.
President
1-10 employees
Used the software for: 6-12 months
Overall Rating
4/5
Ease of Use
5/5
Customer Service
3/5
Features
3/5
Value for Money
5/5
Likelihood to Recommend
6/10
Reviewer Source 
Source: Capterra
July 30, 2018

“Was easy to install and to install on customer machine”

OverallIs free, but same time is good enough for programming very fast.
ProsEasy to learn, no complicated database definitions. Can use only Varchar variable for everything.
ConsHard programming for multi-user. I have to create my own system to avoid database crash when more than one computer is assessing the database.
Reviewer Source 
Source: Capterra
July 30, 2018
Verified Reviewer
51-200 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Reviewer Source 
Source: Capterra
April 13, 2018

“You need a small database without problems? the answer is: SQLite”

Prossmall, easy, no complicated stored procedure. You choose how to use and STOP. SQLite is ok if need a database for your application . No problem with a lot of datas: I've managed SQLite database with Millions of records.
ConsUse only for storage information. No other features are available: No native stored procedure. So internal procedure are impossible.
Reviewer Source 
Source: Capterra
April 13, 2018
Ali O.
Analyst
Information Technology and Services, 11-50 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
May 8, 2019

“Small, Fast And Efficient RDBMS”

ProsSQLite 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.
Consif what you need is a client-server database, it's not for you.
Reviewer Source 
Source: Capterra
May 8, 2019
Avatar Image
John D. K.
Founder
Unspecified
Used the software for: 6-12 months
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
July 25, 2018

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

OverallEase of accessing data for Ad-Hoc reports.
ProsLinking SQLite to the internal database was quite simple; setting up authorized users was as well.
ConsSQLite could be finicky on my company's database, I would sometimes switch over to Sandbox to run quicker queries.
Reviewer Source 
Source: Capterra
July 25, 2018
Verified Reviewer
Financial Services, 10,001+ employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
2/5
Features
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
April 19, 2019

“Depends on how you store your data”

ProsIf you are storing variable data that resemble objects, use this instead of MySQL! There are also a lot of libraries built for accessing and manipulating SQLite databases now.
ConsIt takes up much more space and memory compared to conventional databases like MySQL
Reviewer Source 
Source: Capterra
April 19, 2019
Dennis N.
Software Engineer
Information Technology and Services, 51-200 employees
Used the software for: 6-12 months
Overall Rating
5/5
Ease of Use
4/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
April 18, 2019

“Lightweight and easy to use.”

OverallPerfect for small project and easy to setup.
ProsIt's really well design and easy to connect to database, and best of all it is free.
ConsIt's not really good for large databases it can be quite slow, but perfect for small projects.
Reviewer Source 
Source: Capterra
April 18, 2019
Danoosh D.
Metadata Specialist
Unspecified
Used the software for: 1-2 years
Overall Rating
4/5
Ease of Use
5/5
Features
3/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
May 17, 2018

“A suitable light weight for small applications (and learning)”

ProsI 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
ConsIf 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 
Source: Capterra
May 17, 2018
Julio S.
Developer
Computer Games, 11-50 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
4/5
Customer Service
5/5
Features
4/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
April 26, 2019

“Database on the go!”

ProsSQLite 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!
ConsBeing a smaller library, it misses some features from bigger database systems.
Reviewer Source 
Source: Capterra
April 26, 2019
Jimcarl S.
Data Analyst
Information Technology and Services, 1001-5000 employees
Used the software for: 6-12 months
Overall Rating
4/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
September 9, 2018

“Good choice for portable database”

ProsI like how SQLite offer T-SQL despite of being a portable database. I can create moderately complex queries and still runs fine.
ConsThere's nothing I really don't like with SQLite. It's free and does the job.
Reviewer Source 
Source: Capterra
September 9, 2018
Rita N.
Software Engineer
Computer Software, 501-1000 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
5/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
June 9, 2019

“Invaluable offline database ”

ProsSQLite 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.
ConsUnderstandably not suitable for large data content
Reviewer Source 
Source: Capterra
June 9, 2019
Verified Reviewer
Information Technology and Services, 5001-10,000 employees
Used the software for: Less than 6 months
Overall Rating
5/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
September 28, 2019

“Best relational database system for embedded applications.”

OverallBets choice to choose SQL for store data on embedded application instead of connecting Server and get data.
ProsSQLite 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.
ConsAs 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.
Reviewer Source 
Source: Capterra
September 28, 2019
Verified Reviewer
Hospitality, 11-50 employees
Used the software for: 1-2 years
Overall Rating
4/5
Ease of Use
4/5
Customer Service
3/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
December 4, 2018

“A must for BI”

OverallUsed SQLite for querying a relational database at work. Once you learn the basic syntax, it becomes fairly easy to use.
ProsOnce you figure out syntax, there is no better language for writing queries to a relational database. SQL is the measuring stick
ConsLike any language, there is a learning curve (albeit not as bad as most others)
Reviewer Source 
Source: Capterra
December 4, 2018
Avatar Image
Elcenir P.
Asistente Administrativo III
Unspecified
Used the software for: Less than 6 months
Overall Rating
4/5
Ease of Use
4/5
Customer Service
5/5
Features
4/5
Value for Money
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
June 18, 2018

“Lightweight, easy and powerful at the same time”

Overalllearn to consult views and functions in the tool
Prosis a lightweight and powerful database manager to store data from a web and mobile project, it is within relational databases, its installation is very simple, I use it to make simple querys of a project that I am currently carrying
Consone more difficulty of software is of knowledge of the SQL language, since there are very complicated queries that I must do and sometimes the tool remains frozen and I have had to restart my machine
Reviewer Source 
Source: Capterra
June 18, 2018
Avatar Image
Jesse T.
Student
Computer Software, Self-employed
Used the software for: Less than 6 months
Overall Rating
5/5
Ease of Use
4/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
March 20, 2019

“Easy to use Database”

OverallOverall I'd say my experience with using SQLite in school has been fantastic. It's easy to pick up and use, lots of features, easy to use software that allows you to connect and create databases as well.
ProsSQL is pretty easy to understand. The syntax is common words so you can figure out what the code is trying to accomplish very easily.
ConsLearning the language can be confusing sometimes if you don't know where to go.
Reviewer Source 
Source: Capterra
March 20, 2019
Avatar Image
Sahil S.
dot net developer
Information Technology and Services, 11-50 employees
Used the software for: Less than 6 months
Overall Rating
4/5
Ease of Use
5/5
Customer Service
3/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
7/10
Reviewer Source 
Source: Capterra
September 1, 2018

“Sqllite”

OverallI solve my problem in window application to sync the server data and local storage data by adding local storage entries SqlLite.
ProsExcellent creation to store relational data in local storage, that is helpful for mobile and desktop application so they do not need server to store the data.
ConsProduct look and feel needs to be change and it should be great if it has intelligence.
Reviewer Source 
Source: Capterra
September 1, 2018
Kyle J.
Web Developer
Education Management, 11-50 employees
Used the software for: Less than 6 months
Overall Rating
4/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
6/10
Reviewer Source 
Source: Capterra
May 4, 2018

“Small Scale Sql Engine”

OverallSide projects with a SQL database engine.
ProsSQLite 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.
ConsNot good for large scale or data warehousing. I would recommend only for small projects or personal use for side projects.
Reviewer Source 
Source: Capterra
May 4, 2018
Avatar Image
Alafia V.
Analista de programas
Unspecified
Used the software for: 6-12 months
Overall Rating
4/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
June 28, 2018

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

OverallPractices and test projects
ProsIt is a portable and lightweight database to handle small data quantities or parameters of an application without complicated configurations
ConsIf 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 
Source: Capterra
June 28, 2018
Nestor Z.
Integration Engineer
Unspecified
Used the software for: 6-12 months
Overall Rating
5/5
Ease of Use
5/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Reviewer Source 
Source: Capterra
June 27, 2018

“When the small is really big.”

ProsIt's fast, simple and fun. The learning curve is very comfortable. Although it is a small database it is capable of storage up to 2 terabytes of information.
ConsThe tables are not related. The relationships are logical (We have to program this logic). There are no DATE type columns. This hinders operations between DATES.
Reviewer Source 
Source: Capterra
June 27, 2018
Avatar Image
Marco R.
Coordinatore Area Business Intelligence
1001-5000 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
3/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
May 7, 2018

“Database small and effective”

OverallIf you need a small and robust DB it is the right choice
ProsGiven 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.
ConsFrom 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 
Source: Capterra
May 7, 2018
Verified Reviewer
Information Technology and Services, 51-200 employees
Used the software for: Less than 6 months
Overall Rating
4/5
Ease of Use
4/5
Customer Service
3/5
Features
3/5
Value for Money
2/5
Likelihood to Recommend
7/10
Reviewer Source 
Source: Capterra
January 29, 2019

“SQLite is a good embedded database choice”

ProsI like how SQLite offer similar capabilities with full-pledged MSSQL. It runs traditional TSQL and it stays small in file size. It's very convenient to use and have so 3rd party management tools available.
ConsWhen the database gets large, say around 2 gigs, loading times can be a bit slow.
Reviewer Source 
Source: Capterra
January 29, 2019
Avatar Image
Drew L.
IT Administrator
Transportation/Trucking/Railroad, 11-50 employees
Used the software for: 1-2 years
Overall Rating
2/5
Ease of Use
3/5
Customer Service
1/5
Features
2/5
Value for Money
3/5
Likelihood to Recommend
3/10
Reviewer Source 
Source: Capterra
August 9, 2018

“Very Basic SQL engine for iPad”

OverallThis is a budget choice for SQL on iOS if you're building some sort of mobile app that requires databasing. If you're looking for extensible support and lots of features, this ain't it. If you need basic databasing and are working to keep costs down, this may be a good choice, but I wouldn't recommend it outright.
ProsCompatible on multiple versions of iOS across my environment. Works well with app it was designed to work for. Pretty stable and predictable performance. Management GUI is excellet.
ConsIt lacks some very basic features most mobile SQL engines would have. Stuff like importing DB's from external apps is just non-existent.
Reviewer Source 
Source: Capterra
August 9, 2018
Chris M.
Software Support Consultant
Unspecified
Used the software for: Less than 6 months
Overall Rating
4/5
Ease of Use
3/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
6/10
Reviewer Source 
Source: Capterra
July 26, 2018

“Functions as an easy, obtainable SQL server.”

ProsInstallation of this program was rather easy, and initial set up was just as easy. Free, and allowed for easy database configuration.
ConsHad a few issues installing an updated version on the database and had to downgrade, but believe that was due to the computer being utilized.
Reviewer Source 
Source: Capterra
July 26, 2018
Verified Reviewer
Computer Networking, Self-employed
Used the software for: 6-12 months
Overall Rating
4/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
September 14, 2018

“Database for as storage”

OverallSQLite is perfect for a certain kind of usage. Not for massive access but amazing for compact traditional database.
ProsSQLite is fast and durable due to it's file-as-database approach. SQL Dump is very much compliant with most other databases.
ConsThe bottle-neck on concurrency makes SQLite unsable for server/client use.
Reviewer Source 
Source: Capterra
September 14, 2018
Paul N.
Program Developer
Information Technology and Services, 1-10 employees
Used the software for: 1-2 years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
March 9, 2019

“Awesome server-less database for simple projects”

ProsBasically I don't have to install a server to host my databases.
ConsSQLITE has no graphical interface to view the tables
Reviewer Source 
Source: Capterra
March 9, 2019
Avatar Image
Even S.
Software Engineer
Unspecified
Used the software for: 1-2 years
Overall Rating
5/5
Ease of Use
3/5
Customer Service
2/5
Features
4/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
April 13, 2018

“I have used sqlite for different mobile applications and has been a fairly good experience”

OverallStoring and accessing information for your mobile application, it is lightweight, fast and easy to use once it is installed
ProsThe fact that you can store information easily on your local device and access it through the SQL language. This helps my apps to stay usable even if the device is offline
ConsThe first few times it can be a bit difficult to configure. An external resource documentation is needed to install across different platforms.
Reviewer Source 
Source: Capterra
April 13, 2018
Verified Reviewer
11-50 employees
Used the software for: 6-12 months
Overall Rating
4/5
Ease of Use
3/5
Features
5/5
Reviewer Source 
Source: Capterra
April 4, 2018

“Good software, needs a bit of knowledge”

ProsFree, powerful and comprehensive bit of software which manages and helps to look after our SQL databases
ConsIt does take a little while to get used to the software and to get to know the features, there are more features than meets the eye.
Reviewer Source 
Source: Capterra
April 4, 2018
Avatar Image
LOKESH S.
Software Engineer
Computer Software, 501-1000 employees
Used the software for: I used a free trial
Overall Rating
5/5
Ease of Use
4/5
Features
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
January 23, 2019

“Nice software for file based Data management”

OverallWe used in android application.
ProsI like that it allows multiple application access the same database at the same time. Low memory consumption n light weight application. And it's free to use , no need to install,no need of assign access permission to users.
ConsAs it doesn't support stored procedures but it fine when you just need to save data in single file.
Reviewer Source 
Source: Capterra
January 23, 2019
Verified Reviewer
Renewables & Environment, 501-1000 employees
Used the software for: 6-12 months
Overall Rating
5/5
Ease of Use
5/5
Features
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
March 12, 2019

“a very decent IDE”

Overallvery happy
Prosit's easy to use and doesn't get too much space on your system!
ConsMaybe not a proper choice for very big projects! but great for practicing or small projects
Reviewer Source 
Source: Capterra
March 12, 2019
Bruno Nicholas S.
Software Engineer and Developer
Computer Software, Self-employed
Used the software for: 1-2 years
Overall Rating
4/5
Ease of Use
5/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
June 20, 2019

“Local Minified SQL Database”

Prosit is a compact and light solution available for with many programming languages, it givers you the power to perform operation while an application user is offline and sync updates when the application user gets online.
ConsThere is not way of viewing the data in a tabular format
Reviewer Source 
Source: Capterra
June 20, 2019
Ankit J.
Database Consultant
Investment Banking, 201-500 employees
Used the software for: 6-12 months
Overall Rating
4/5
Ease of Use
4/5
Features
3/5
Likelihood to Recommend
7/10
Reviewer Source 
Source: Capterra
April 5, 2019

“Native to many popular Languages!”

OverallSQLite is a reliable and lightweight application. All of the local data can be stored in SQLite.
Pros1. Very lightweight 2. Faster querying 3. Though it is native to many application and software, there are connector and libraries available for integration. 4. System Independent nature 5. Costing won't affect.
Cons1. It can handle only small transactions or traffic. Not for large scale production 2. It is advised to use SQLite for offline data storage in android and python.
Reviewer Source 
Source: Capterra
April 5, 2019
Avatar Image
Pardeep K.
Quality Assurance
Oil & Energy, 501-1000 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
4/5
Features
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
December 17, 2018

“SQLite”

ProsI found it useful for my project because it doesn't require a server to run.
ConsOnly thing I did not like is that the database size is restricted.
Reviewer Source 
Source: Capterra
December 17, 2018