18 years helping British businesses
choose better software
SQLite
What is SQLite?
Open source database engine used by applications due to its compact size, cross platform stability and serverless functionality.
Who Uses SQLite?
Large businesses.
Not sure about SQLite?
Compare with a popular alternative
SQLite
Other great alternatives to SQLite
Reviews of SQLite
SQLite: The best Database ever
Comments: It is an excellent database as compared to others. I do not see any database competing with SQLite
Pros:
SQLite operates with lightning speed. It is the compressed version the MYSQL. It is extremely efficient in website management and many other managerial tasks in any organization.
Cons:
It is very complex for beginners, but easy to understand.
The best database management
Comments: I've been using SQLite to store databases and manage them easily. It's a fast and light tool, which helped me in several different cases.
Pros:
It's light (doesn't require much resources), fast, it's stable, cross-platform. It's a free and open-source software which helps a lot with saving money and making sure it's secure.
Cons:
It's not recommended for big databases, only for small ones.
A useful, yet untidy tool
Comments: quick to deploy and simple to implement, although certain users may want to be aware of some UI and security concerns.
Pros:
Very simple to use and undoubtedly reduces the amount of physical memory used
Cons:
Some security issues and occasionally non-loading user interface parts make me doubt its reliability
Alternatives Considered:
Power in the simplicity
Comments: Works very well in simple scenarios! It might be a great choice for small applications that require low maintenance and easy setup
Pros:
It's very simple to use and lightweight. Typically does not require a separate server (it could run on the same server as a web application). It's quite handy that the database is contained in one file, which then can be backed up easily or transferred across machines. It's quite fast for certain uses.
Cons:
Compared to other RDBMSes, it's very simple - which means that it's lacking certain features when it comes to scalability - it performs well in simple scenarios, and in complex ones - it just won't (unless you are very lucky and it's e.g. a case when there is only a single connection).Moreover, it lacks certain security features like user management and access control.
Alternatives Considered:
An excellent database for mobile projects
Comments: I have used this database for the development of mobile application projects and for the prototyping of web pages, which makes it a very good database, easy and agile when manipulating data
Pros:
What I like most about this product or database is how easy it is to integrate with mobile projects in the creation of applications and its easy portability, as well as performance, agility and little space in its implementation that makes it unique when it comes to of mobile application projects
Cons:
That for very large projects it is not so robust handling so many transaction threads
