TrustRadius: an HG Insights company

SQLite

Score9.6 out of 10

45 Reviews and Ratings

What is SQLite?

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is one of the most widely deployed databases in the world.

I use free and Open Source SQLite Database for mobile Applikations

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

Most Important Features

  • Simple to use
  • Good Performance
  • Reliable

Return on Investment

  • Faster App Development

Alternatives Considered

Microsoft SQL Server, Oracle Database, MongoDB and MySQL

Other Software Used

Microsoft Visual Studio, Microsoft Visual Studio Code

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

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.

Most Important Features

  • Lightweight database.
  • Optimizing syntax is easy.
  • Faster than other databases.
  • Data retrieval occurs quickly.
  • Installation and setup are easy.

Return on Investment

  • Cross-platforms like iOS, Android, MAC, and Windows are all supported.
  • Extremely user-friendly, both in terms of using it and writing queries to run on it.
  • JSON and CSV files are supported. SQLite can use in-memory and external files.
  • SQLite market has a plethora of third-party ORM and data layers that make life easier for developers and save time.

Alternatives Considered

Microsoft SQL Server

Other Software Used

InfluxDB, Microsoft Access, Cisco Jabber

SQLite: Instrumental in Performant ETL Pipeline

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

Most Important Features

  • Direct JSON/CSV integration
  • Portability. We can develop on multiple platforms, then ship and get the same consistent behavior
  • Performant. Some of our integrations are in processed in real time from our internal application to an external source. If SQLite were not performant, we would explore an alternative solution.

Return on Investment

  • We have had to invest more time in our staff to learn and make use of SQLite properly
  • We have incurred more technical debt as we have introduced additional technology and complexity to our systems.
  • We are able to respond more rapidly to our end users needs.

Alternatives Considered

MySQL, PostgreSQL and Microsoft SQL Server

Other Software Used

Microsoft SQL Server, Google Cloud SQL, Azure SQL Database

The best cross-platform embedded database is free

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

Most Important Features

  • Excellent compatiblity
  • Wide range of supported platforms
  • Excellent feature set
  • Impressive speed and fault tolerance

Return on Investment

  • No licensing fees has a net increase on ROI
  • The active community has kept support costs low, further increasing ROI
  • The wide range of supported platforms and high level of compatibility has increased ROI by reducing time spent porting the database model to any platform specific solutions.

Other Software Used

Microsoft SQL Server, MariaDB Platform, MySQL

Best Database for 2021- My SQLite

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

Most Important Features

  • It is free and open source
  • Easy in implement so it save time
  • Document are available for its Query
  • It have large community’s

Return on Investment

  • Same SQLite structure we are using for both iOS and Android. So it save lot's of time to design Database Schema.
  • It support for JSON data
  • We can do manipulation into external file as well. (eg CSV files)

Alternatives Considered

Realm and VistaDB

Other Software Used

Realm, VistaDB, FirebirdSQL