Who Uses This Software?

Large businesses.

Average Ratings

58 reviews
  • Overall 4.5 / 5
  • Ease of Use 4.5 / 5
  • Customer Service 3.5 / 5
  • Features 4 / 5
  • Value for Money 4.5 / 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

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.

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.

SQLite - compatability at it's best level

Reviewed on 03/04/2019
Chaya W.
Trainee Software Engineer
Computer Software, 51-200 Employees
Used the Software for: 1+ year
Reviewer Source 
3/5
Overall
3 / 5
Ease of Use
3 / 5
Features & Functionality
2 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

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

Pros: SQLite 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.

Cons: SQLite 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.

A good choice for storing small and local data

Reviewed on 19/06/2018
Nera joy C.
Software Programmer
Used the Software for: 2+ years
Reviewer Source 
4/5
Overall
4 / 5
Ease of Use
2 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money

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.

Read More Reviews