Who Uses This Software?

Large businesses.

Average Ratings

65 reviews
  • Overall 4.5 / 5
  • Ease of Use 4.4 / 5
  • Customer Service 3.7 / 5
  • Features 4.1 / 5
  • Value for Money 4.4 / 5

Product Details

  • Starting Price US$0.00
  • Free Trial No
  • Deployment Installed - Mac
    Installed - Windows
  • Support Online

Vendor Details

  • SQLite
  • https://sqlite.org/

About SQLite

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

Spotlight_media_placeholder

SQLite Features

  • Access Controls/Permissions
  • Backup and Recovery
  • Data Migration
  • Data Replication
  • Database Conversion
  • Mobile Access
  • Multiple Programming Languages Supported
  • NOSQL
  • Performance Analysis
  • Relational
  • Virtualisation
  • Backup
  • Data Migration
  • Database Conversion
  • Monitoring
  • OLAP
  • Performance Analysis
  • Queries
  • Storage Optimisation

SQLite Most Helpful Reviews

A standard for testing

Reviewed on 14/09/2019
Gareth N.
Web Developer
Computer Software, 13-50 Employees
Used the Software for: 2+ years
Reviewer Source 
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
Customer Support
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

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

Perfect database tool for embedded software

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

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

No server required, used for standalone application and less configuration

Reviewed on 25/04/2019
Verified Reviewer
Software Engineer
Telecommunications, 13-50 Employees
Used the Software for: 1+ year
Reviewer Source 
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

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

Great Database For Smaller Loads

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

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.

Easy to become a problem

Reviewed on 08/11/2018
Anderson M.
Senior Software Engineering
Information Technology & Services, 201-500 Employees
Used the Software for: 6-12 months
Reviewer Source 
4/5
Overall
3 / 5
Ease of Use
2 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

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

Read More Reviews