TrustRadius
SQLite is an open-source database.https://media.trustradius.com/product-logos/AD/BQ/9H5FVLWHM31T.jpegSQLite - Reliable, Lightweight and Fast Database Management SystemSQLite is a perfect relational database management system if your database is not of Enterprise level in terms of size and security. I have been working on this for quite some time now and I also go back to this database whenever we are starting with a new project and the development phase is involved. It's lightweight, reliable and robust to meet any of the database needs that you may come across. The best thing is that it is a zero-configuration server-less database which means you do not require to dedicate any specific server or space in memory for this database. The ease and fastness of working on this is unparalleled.,The biggest one has to be that it is freeware and open source as well. It means for an entry level person who wants to learn relational database and even for a team in the early development stage where security and size of the data are not much, it is a perfect fit in those cases. It requires no extra configuration or space because it a server-less installation and also done in just a few mins. So, installing this is never a blocker. It is the actual lite version of SQL as the name suggests and it very powerful and capable of doing all the things which SQL can do, but lacks some of the security and advanced features. It prepares the data for us in a structured form in terms of Tables with a file size less than 1 Mb for the complete database entries. It saves us a lot of physical space. It is the most suitable DB for Android systems because mobile apps do not have a lot of space or resources for a separate DB, but this one integrates with the whole ecosystem very nicely and we are able to make the most out of it and that too with a file lesser than 1 Mb in size.,Although it is excellent at what it does, you should be really careful and plan accordingly if you know that your database is going to scale at a huge level because it is not suitable of databases which are of Enterprise level and demands top-notch security and protection. If your project involves multiple people working on the same database simultaneously, then that becomes a big problem, because it only allows single write at one time. You really need to be forward thinking in a manner to predict if this database will cater to all the needs of your project. The most common difficulty with this is the lack of some of the basic functionality which is present in the other premier databases like Joints, Stored Procedure calls, Security and permission grants. If you do require all those things then you are better off not using this software. Lastly, if you are using this in an Andriod App development cycle then also your options are limited because it does not integrate with PostgreSQL and MYSQL.,9,SQLite comes with phenomenal documentation and support online. Also, it has a very active online community and most likely you will find the solution to any problem there. SQLite is a serverless relational database management system. So we do not need to have any pre-configurations to support it and also it does not require any physical space or memory because the complete DB file size is under 1 MB only. There is no learning curve because the syntax is the same as that of SQL and installation is very fast and straightforward. So we can get to work as soon as the tool gets installed. The best of all is that it is Freeware and an Open source too.,MySQL and PostgreSQL,Amazon Aurora, Apache Derby, PostgreSQL, Oracle Database 12c,9With Great Power Comes Great ResponsibilitySQLite is used by the R&D department. SQLite is the database engine we have chosen to handle data from the measurement device we developed, which runs an embedded Linux.,Our products are using SQLite in embedded Linux and in Windows software. It is truly a stable cross-platform database. The fact that it is a zero-configuration database engine, it is particularly a nice advantage when you work in the embedded world. Being a single database file, it provides ease for those who need to quickly transfer data to someone else, or quickly browse data.,We experienced a problem due to a bug in the Linux library of SQLite. All devices we already sold to our customers were impacted. We could solve it by deploying the new library version which included the fix. But as always, a piece of software is always better if it's bugs free.,8,We could start immediately to work with SQLite. It's very easy. The document is well done and easy to find. Having such good database system, free of charge and for any purpose is good news.,ms access, MySQL and PostgreSQL,Visual Studio IDE, Eclipse, Microsoft Office 2016, Microsoft Office 365,Self-taught,SQLite is very easy to learn for those who have knowledge of SQL language. The documentation is well done and easy to find. There is a vast community of SQLite users, so you can find all extra information you may need in a lot of forums. SQLite doesn't require any configuration so you can immediately start your work with it.,10,No - there is no facility to customize the interface,No - we have not done any custom code,We integrated SQLite to an embedded Linux for the measurement devices we developed We integrated SQLite to C# Windows applications,10SQLite — First choice every timeSQLite provides a quick and easily accessible means to store data on the local mobile device. Because of it's broad inclusion in various devices, I can be sure of it's availability. When debugging applications, I can reliably get access to the contents of the file with a variety of available applications.,SQLite is readily available. It has been included with iOS for as long as there's been a way for 3rd party developers to write apps for it. SQLite is small. When you think about the original iPhone and how little RAM it had, it's inclusion of SQLite is a testament to how little SQLite requires to work properly. SQLite is fast. I've never had issues with the speed of data retrieval while using this product. When I think of local storage when creating an iOS app, the first thing I turn to is SQLite.,Better data recovery when the database becomes corrupt would be ideal. I've learned to minimize it by closing the database more frequently, but it can still happen. Lack of built-in data encryption. SQLite is a single-user DBMS. If a multi-user system is required, then an alternative is required.,9,SQLite's market penetration provided a means to bring our product to market quickly. Ease of use let us focus on the product development without needing to learn a large API. Free applications let us design our schema without fuss.,ValentinaSQLite Great Start to your business!It was being used for low scale data storage. It was easy to use and integrate to our application which made it the best choice.,SQLite is in the public domain and does not require a license making it perfect for smaller startups. A lot of documentation available which will make training developers new to SQLite transition easily,Public code makes it more accessible however it makes it more vulnerable to possible attacks Not as easy to scale into a larger application compared to Microsoft Sql Management Studio,5,Documentation makes it easy to train new developers into the stack Calls are efficient and quick if properly structured,microsoft sql server management studio,Visual Studio.NET, Microsoft SQL Server
Unspecified
SQLite
26 Ratings
Score 8.0 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

SQLite Reviews

SQLite
26 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.0 out of 101
Show Filters 
Hide Filters 
Filter 26 vetted SQLite reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-4 of 4)

  Vendors can't alter or remove reviews. Here's why.
No photo available
June 29, 2019

Review: "SQLite - Reliable, Lightweight and Fast Database Management System"

Score 9 out of 10
Vetted Review
Verified User
Review Source
SQLite is a perfect relational database management system if your database is not of Enterprise level in terms of size and security. I have been working on this for quite some time now and I also go back to this database whenever we are starting with a new project and the development phase is involved. It's lightweight, reliable and robust to meet any of the database needs that you may come across. The best thing is that it is a zero-configuration server-less database which means you do not require to dedicate any specific server or space in memory for this database. The ease and fastness of working on this is unparalleled.
  • The biggest one has to be that it is freeware and open source as well. It means for an entry level person who wants to learn relational database and even for a team in the early development stage where security and size of the data are not much, it is a perfect fit in those cases.
  • It requires no extra configuration or space because it a server-less installation and also done in just a few mins. So, installing this is never a blocker. It is the actual lite version of SQL as the name suggests and it very powerful and capable of doing all the things which SQL can do, but lacks some of the security and advanced features.
  • It prepares the data for us in a structured form in terms of Tables with a file size less than 1 Mb for the complete database entries. It saves us a lot of physical space.
  • It is the most suitable DB for Android systems because mobile apps do not have a lot of space or resources for a separate DB, but this one integrates with the whole ecosystem very nicely and we are able to make the most out of it and that too with a file lesser than 1 Mb in size.
  • Although it is excellent at what it does, you should be really careful and plan accordingly if you know that your database is going to scale at a huge level because it is not suitable of databases which are of Enterprise level and demands top-notch security and protection.
  • If your project involves multiple people working on the same database simultaneously, then that becomes a big problem, because it only allows single write at one time. You really need to be forward thinking in a manner to predict if this database will cater to all the needs of your project.
  • The most common difficulty with this is the lack of some of the basic functionality which is present in the other premier databases like Joints, Stored Procedure calls, Security and permission grants. If you do require all those things then you are better off not using this software.
  • Lastly, if you are using this in an Andriod App development cycle then also your options are limited because it does not integrate with PostgreSQL and MySQL.
As I have mentioned before, SQLite is suited best in development phases where the data table is not huge and the data security is also not the primary concern. Secondly, if you are working on an Android App development in that case also this is the best database by far which meets all your requirements without taking any space or memory.

It is not suited for applications where the Database is in Gigabytes or Terabytes. It is also not suited where you need to perform complex operations like Joins and Stored procedure calls and implying top security is the requirement of the project.
Read this authenticated review
No photo available
April 11, 2018

SQLite Review: "With Great Power Comes Great Responsibility"

Score 8 out of 10
Vetted Review
Verified User
Review Source
SQLite is used by the R&D department.
SQLite is the database engine we have chosen to handle data from the measurement device we developed, which runs an embedded Linux.
  • Our products are using SQLite in embedded Linux and in Windows software.
  • It is truly a stable cross-platform database.
  • The fact that it is a zero-configuration database engine, it is particularly a nice advantage when you work in the embedded world.
  • Being a single database file, it provides ease for those who need to quickly transfer data to someone else, or quickly browse data.
  • We experienced a problem due to a bug in the Linux library of SQLite.
  • All devices we already sold to our customers were impacted.
  • We could solve it by deploying the new library version which included the fix.
  • But as always, a piece of software is always better if it's bugs free.
I recommend the use of SQLite for embedded systems.
If you need to store a large amount of data, store blobs, use triggers, handle multiple accesses at the same time, and need to optimize indexes, then I would recommend using another database system.
SQLite should also be considered if the installation/configuration of a heavier database system is a problem.
Read this authenticated review
Aaron Bratcher profile photo
August 08, 2016

User Review: "SQLite — First choice every time"

Score 9 out of 10
Vetted Review
Verified User
Review Source
SQLite provides a quick and easily accessible means to store data on the local mobile device. Because of it's broad inclusion in various devices, I can be sure of it's availability. When debugging applications, I can reliably get access to the contents of the file with a variety of available applications.
  • SQLite is readily available. It has been included with iOS for as long as there's been a way for 3rd party developers to write apps for it.
  • SQLite is small. When you think about the original iPhone and how little RAM it had, it's inclusion of SQLite is a testament to how little SQLite requires to work properly.
  • SQLite is fast. I've never had issues with the speed of data retrieval while using this product. When I think of local storage when creating an iOS app, the first thing I turn to is SQLite.
  • Better data recovery when the database becomes corrupt would be ideal. I've learned to minimize it by closing the database more frequently, but it can still happen.
  • Lack of built-in data encryption.
  • SQLite is a single-user DBMS. If a multi-user system is required, then an alternative is required.
Most situations for local data storage can be easily handled by SQLite. If data encryption is needed, there are special builds available. Moving beyond the mobile space, SQLite is not designed for extremely large quantities of data or multi-user . Special consideration should be made of how much data is expected over the life of the product use. It is also not designed for simultaneous multi-user access.
Read Aaron Bratcher's full review
Marco Lostaunau profile photo
January 20, 2016

User Review: "SQLite Great Start to your business!"

Score 5 out of 10
Vetted Review
Verified User
Review Source
It was being used for low scale data storage. It was easy to use and integrate to our application which made it the best choice.
  • SQLite is in the public domain and does not require a license making it perfect for smaller startups.
  • A lot of documentation available which will make training developers new to SQLite transition easily
  • Public code makes it more accessible however it makes it more vulnerable to possible attacks
  • Not as easy to scale into a larger application compared to Microsoft Sql Management Studio
It's more suited for a start up on a budget since it presents a very good solution for data storage, maintenance and allows database engineers to structure the tables more efficiently and with scalability in mind.

I would say it's less appropriate for bigger companies and firms with a more lax budget. I currently use Microsoft SQL Server management studio and the main reason why we use it is because of its security.
Read Marco Lostaunau's full review

About SQLite

SQLite is an open-source database.
Categories:  Open-Source Database

SQLite Integrations

SQLite Technical Details

Operating Systems: Unspecified
Mobile Application:No