SQLite Professional, Scientific, and Technical Services Reviews & Insights

Score9.6 out of 10

45 Reviews and Ratings

Community insights

TrustRadius Insights for SQLite are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Easy to Use: Many users have found SQLite to be easy to use, with a simple and intuitive syntax. Some reviewers have appreciated its simplicity in operation and integration, making it a convenient choice for developers.

High Compatibility with Android Applications: Several users have highlighted that SQLite is highly compatible with Android applications, making it easy to use in mobile development. This compatibility allows developers to seamlessly integrate SQLite into their Android projects without any major issues.

Frequent Updates and Active Maintenance: Reviewers have mentioned that SQLite is frequently updated, indicating that it is actively maintained and improved. This continuous improvement ensures that the database remains up-to-date with the latest features and enhancements, providing a reliable solution for developers.

Reviews

7 Reviews

Professional, Scientific, and Technical Services

"SQLite is a lightweight, efficient, and user-friendly database management system."

Rating: 9 out of 10

Incentivized

July 8, 2022

Use Cases and Deployment Scope

SQLite is an excellent tool because it's easy to use with many languages, especially C#. Because SQLite is quicker and easier to integrate, we use it for C++ applications. And yes, we also used it with web and mobile applications when we needed instant access to a small database. It's the most widely used database with many high-profile applications. We can use it to create long-term storage for our applications without installing anything. It is a transactional SQL database engine self-contained, serverless, and requires zero configuration. This software is fast, reliable, suitable for small and big projects, user-friendly, and easy to learn.

Pros

Easy-to-use.
An easy-to-use query.
Simple to understand syntax.
Simple in both operation and integration.
In Android applications, it is simple to use.
Frequently updated cross-platform database.

Cons

The transaction moves slowly.
Too many search windows are confusing.
Database size is limited to about 2GB, which is not good.

Likelihood to Recommend

SQLite is a lightweight and efficient database management system. With SQLite, performance increases as memory are added. It's reliable and well-tested before release. SQLite handles memory allocation and I/O errors gracefully. SQLite provides bug lists and code-change chronologies. All bugs are disclosed, and it's compatible with iOS, Android, MAC, and Windows. SQLite is open-source, allowing developers to tailor it to their specific needs.

Sumon K Chowdhury

Asst. Software Specialist in Information Technology at i-Tech Software Ltd. (Information Technology & Services, 11-50 employees)

Vetted Review

1 year of experience

View profile

Best Database for 2021- My SQLite

Rating: 8 out of 10

Incentivized

August 27, 2021

Use Cases and Deployment Scope

I am a regular user of the SQLite database in my several iOS projects. Even other teams also using SQLite in my organization. It is fast and I can say easy to install in existing and new projects. It supports many cross-platforms as well like iOS, Android, MAC, windows as well. SQLite is fully open source and developers can modify it according to their use. SQLite database can be used for small to large scale projects. It is available for a long time in the market so it has a very large community and easy to get any type of help from StackOverflow.

Pros

It supports many cross-platform like iOS, Android, MAC, Windows projects
It is open source, and all code are public, developers can easily modify.
Easy to integrate in existing or new projects

Cons

In many case SQLite wont support Relational database feature.
If a application which scale-out very fast, for that type of project we need to use carefully

Likelihood to Recommend

One SQLite database structure can be used by one or many other platforms like iOS, Android, even python as well. Many third-party ORM's and data layers are available in the market for SQLite, which make developer life easy. and it saves development time. It supports JSON and CSV files. SQLite can work with in-memory data or external files.

Mantosh Kumar

Consultant in Professional Services at Capgemini (Information Technology & Services, 10,001+ employees)

Vetted Review

2 years of experience

SQLite: Fast and lightweight SQL for all your needs

Rating: 10 out of 10

Incentivized

May 6, 2021

Use Cases and Deployment Scope

Our team is using SQLite for relational data storage for a web development project in dot.net. It is a lightweight database and very easy to manage using open-source tools.

Pros

Very easy to deploy and use.
Highly compatible with most of the popular programming languages.
Fast
Freeware
Lightweight database

Cons

Limitations in terms of data table size
No built in data encryption methods/ techniques
Not suitable for large applications

Likelihood to Recommend

SQLite is best suited for scenarios where the team requires a lightweight relational data storage solution for small to medium-sized applications. Also, the team needs to keep the cost of the project minimal.

Shivani Pandey

Project Engineer in Information Technology at Wipro Limited (Information Technology & Services, 10,001+ employees)

Vetted Review

2 years of experience

View profile

SQLite is the better Database for Mobile Applications

Rating: 9 out of 10

Incentivized

March 3, 2020

Use Cases and Deployment Scope

We use SQLite in our mobile projects by the Application development team.

SQLite solves our problem for storage in the APP database for offline data.

Pros

Xamarin.Forms Compatibility
Free
Easy Implementation

Cons

Limited for many rows
Documentation

Likelihood to Recommend

SQLite is perfect for applications that need to save data offline and then synchronize. It is not good if you have many lines in the local SQLite base.

Rogério Rodrigues

Team Lead in Information Technology at SternTI (Information Technology & Services, 201-500 employees)

Vetted Review

6 years of experience

View profile

SQLite - Reliable, Lightweight and Fast Database Management System

Rating: 8 out of 10

Incentivized

June 7, 2019

Use Cases and Deployment Scope

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.

Pros

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.

Cons

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.

Likelihood to Recommend

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.

Verified User

Team Lead in Information Technology (Information Technology and Services company, 10,001+ employees)

Vetted Review

3 years of experience

SQLite — First choice every time

Rating: 9 out of 10

Incentivized

July 29, 2016

Use Cases and Deployment Scope

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.

Pros

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.

Cons

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.

Likelihood to Recommend

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.

Aaron Bratcher

iOS Developer in Information Technology at AT&T (Market Research, 51-200 employees)

Vetted Review

3 years of experience

View profile

SQLite Great Start to your business!

Rating: 5 out of 10

Incentivized

January 20, 2016

Use Cases and Deployment Scope

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.

Pros

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

Cons

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

Likelihood to Recommend

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.

Marco Lostaunau

C# .NET Developer in Information Technology at Easy Expunctions (Legal Services, 11-50 employees)

Vetted Review

2 years of experience

View profile

Loading Reviews List....

SQLite - Reliable, Lightweight and Fast Database Management System

Rating: 8 out of 10

Incentivized

June 7, 2019

Use Cases and Deployment Scope

Pros

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.

Cons

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.

Likelihood to Recommend

Verified User

Team Lead in Information Technology (Information Technology and Services company, 10,001+ employees)

Vetted Review

3 years of experience