TrustRadius: an HG Insights company

SQLite Reviews & Insights

Score8 out of 10

47 Reviews and Ratings

Get a Demo

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

15 Reviews

Review On SQLite

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

We use SQLite to store local data as it has zero maintenance deployment. Since it is lightweight, embedded database , has high performance without a dedicated server. we are running relational database server (like PostgreSQL or MySQL) so SQLite add no unnecessary complexity.The business problems we are solving with SQLite as it can use as offline tool. It is really fast to setup as a software. High performance for single-user or embedded workloads since it easily compatible with windows or mac os.
scope of our use case includes storing intermediate data during ETL process. we use it for light analytics for operation dashboards.

Pros

  • It basically work well on offline mode , easily syncs to backend file when connectivity restored.
  • SQLite provides transactional safety, even on unreliable devices like mobile phones and Raspberry Pis.
  • It provides fast reads & reliable writes.
  • easy to setup on various operating system.

Cons

  • it misses advanced SQL features.
  • its not suitable for big-data or high-throughput workflows.
  • Schema integrations can be more hectic than in PostgreSQL or MySQL.

Likelihood to Recommend

I would rate SQLite an 8 out of 10, since its really good in some of the areas like Local/offline data base storage, low-concurrency workflows like Prototyping, scripting, automation etc. It has Zero-maintenance deployments which is suitable for general sql related functions. however its not suitable for project work where complex sql functions are needed. its not suitable for multiuse or Large-scale production databases.
MK
Manidipa Kundu
Data Analyst in Quality Assurance at Gfactors (11-50 employees)
Vetted Review
SQLite
3 years of experience
View profile

SQLite is a compact and fast embedded relational database

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

It is often a good fit to be used as integrated local database in mobile applications. The benefit is the good speed and that it's really small in size and does not depend on external libraries like Microsoft Visual C++ Runtime, which wouldn't exist on mobile platforms anyway. It is also widely supported by programming environments like Embarcadero Delphi and there exist some GUI tools for modifying the database structure or entering and reading data contained in the database.

Pros

  • Speed
  • Ease of use
  • Small footprint

Cons

  • It is not fully ACID compliant
  • The encryption offered is a paid offering and not cheap

Likelihood to Recommend

As a local database where type safety is properly handled by the developer. That's especially useful on mobile platforms.
VU
Verified User
Employee in Research & Development (10,001+ employees)
Vetted Review
SQLite
2 years of experience

I use free and Open Source SQLite Database for mobile Applikations

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

I use it as a database for my mobile Apps developed with C# Xamarin / Maui and for a couple of smaller WebApps developed with C# and ASP.Net Core.

Pros

  • Performance is very good
  • Data Security in case of Crashes during a transaction
  • Ease of use

Cons

  • Native encryption support
  • Better C# integration

Likelihood to Recommend

Database for Mobile Apps, Desktop Client Apps with offline functionality, Smaller Server Apps or Server Apps with one Database per User / Company.
MH
Markus Hopfenspirger
Freelancer - Senior Software Architekt in Manufacturing at MaHop.Net the Software Copmany (1-10 employees)
Vetted Review
SQLite
4 years of experience
View profile

Lite weight portable Database engine for Developers

Rating: 9 out of 10

Use Cases and Deployment Scope

We have been using SQLite for a long time now along with Python. it is excellent as it works as an independent Database thus allowing us to create easily scalable applications. WE use it in our machine learning application to store static data which needs regular retrievals of for Data cluster creation.

Pros

  • SQLite is easy top install and portable.
  • Table creation is easy with SQLite when using Python.

Cons

  • Not being Multi user it doesn't allow multiple user to create concurrent queries
  • no inbuilt Data viewer is available for SQLite

Likelihood to Recommend

I First Used SQLite with Python when I was a fresher and didn't know much about Databases. SQLite helped me create initial projects with ease and helped me understand RDBMS. Currently, we use SQLite to store DATA outputs which are in the form of JSONS produced by our Algorithm containing Hirerachical trees of the datasets from sample data which are later used by our application for processing.
VU
Verified User
Professional in Information Technology (11-50 employees)
Vetted Review
SQLite
1 year of experience

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

Rating: 9 out of 10
Incentivized

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.
SK
Sumon K Chowdhury
Asst. Software Specialist in Information Technology at i-Tech Software Ltd. (11-50 employees)
Vetted Review
SQLite
1 year of experience
View profile

The best cross-platform embedded database is free

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

SQLite is my number one choice when I am looking for an embedded database for any cross platform solution. With SQLite, we have been able to create one database model and deploy it across all platforms, including mobile, desktop, and embedded systems. I have not found a better supported multi-platform solution than SQLite. For example, in a recent mobile app upgrade, we were able to roll out full text search across iOS, macOS, Windows, and Android, all from a prepopulated database generated once and deployed multiple times.

Pros

  • Compatibility across many platforms
  • Speed and low resource use
  • Full Text Search out of the box
  • Excellent user community and adoption across the industry

Cons

  • Scaling beyond embedded instances will require moving to another platform
  • Vendor supplied tools are not as comprehensive as other RDBMS solutions
  • The documentation lacks the professional polish of its competitors

Likelihood to Recommend

Nothing beats SQLite if you are wanting an easy to use embedded database solution that runs out of the box across a wide range of platforms. If your solution is not likely to scale into a N-tier or client-server architecture, you will find that SQLite serves you well for your application's lifetime.

Both Android and iOS provide comprehensive support for SQLite, and SQLite's own high level of compatibility between versions means that you only need to create a database once to deploy it across multiple platforms.
PC
Peter Chapman
Senior System Architect in Information Technology at Conglomo Limited (1-10 employees)
Vetted Review
SQLite
3 years of experience

SQLite: Instrumental in Performant ETL Pipeline

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

SQLite has been instrumental in our ETL pipeline. We utilize it heavily to ingest JSON and XML from multiple sources like Rest API, SFTP, and WebDAV repositories. It is performant for our needs and allows our development staff to work in a familiar language for them, reducing our technical debt and improving our response time. We manipulate our data on the client and package it for export or import to our primary RDBMS solution. The extra data transformation tools SQLite has available made it an easy choice to make use of.

Pros

  • Direct data transformation from JSON/CSV to table
  • Easy to format data exported to desired layout and file type
  • Direct ingestion from Rest API
  • Familiar language syntax for SQL Server developers

Cons

  • Lack of procedures makes for convoluted data manipulation via nested triggers
  • Linked Server with MySQL/SQL Server would be very much appreciated
  • Basic Table manipulation, not drop and recreate

Likelihood to Recommend

The portability and ease of use has us doing local development, and then shipping the database to production for implementation. This compact deliverable object is great. Until multiple developers need to access it at a time. It is a caveat, but we create a database per integration as it is easier to manage. Using a SQLite database to manage more than one integration or task is not something we would recommend.
BW
Bradley Wilson
Database Administrator in Information Technology at Colton Joint Unified School District (1001-5000 employees)
Vetted Review
SQLite
6 years of experience

Best Database for 2021- My SQLite

Rating: 8 out of 10
Incentivized

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.
MK
Mantosh Kumar
Consultant in Professional Services at Capgemini (10,001+ employees)
Vetted Review
SQLite
2 years of experience

SQLite: Fast and lightweight SQL for all your needs

Rating: 10 out of 10
Incentivized

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.
SP
Shivani Pandey
Project Engineer in Information Technology at Wipro Limited (10,001+ employees)
Vetted Review
SQLite
2 years of experience
View profile

The great little database that could

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

We use SQLite for file based data integration and ETL's. Only the IT Department uses SQLite due to its technical nature.

Pros

  • In memory database is extremely fast
  • Supports nearly all database capabilities
  • Lightweight footprint for using on many types of devices (mobile, PC, consumer devices)

Cons

  • Not multi-user due to its file locking design, but this supports its efficiency and speed strengths
  • Doesn't offer all join options typically available in standard databases
  • High repetitive single table writes can be problematic

Likelihood to Recommend

[SQLite is well suited for:]
  • Mobile app development (storing user application data on a smart device)
  • Supporting fast ETL's in scripting type programs or console applications
  • Usable on embedded and low power hardware such as Raspberry Pi's
[SQLite is not well suited for:]
  • Would not be good as a centralized database where many clients are trying to read/write at the same time
VU
Verified User
Professional in Information Technology (201-500 employees)
Vetted Review
SQLite
2 years of experience