Markcomm Pitch

Overview

SQLite is the most widely deployed database in the world. It is popular because of its compact size, cross platform stability and serverless functionality. stores its entire database as a single cross-platform file on a host machine, and implements a self-contained, server less, zero configuration database engine.

Screenshot

SQLite

Features

  • Backup and Recovery
  • Multiple Programming Languages Supported
  • Queries
  • Data Manipulation
  • Query Language
  • Scalability
  • Storage
  • ANSI-C
  • Command-line interface (CLI)
  • Full-featured SQL
  • Zero-configuration
  • Single cross-platform disk file
  • Tunable consistency
  • Programmability for HTAP
  • Administration and management
  • Continuous high-speed ingest
  • Support for embedding
  • Administration and management

Specifications

  • Deployment: Installed - Mac, Installed - Windows

SQLite Users

Available Support

  • Online

Language Support

  • English

Company Details

  • Company Name: SQLite

  • Headquarter: United States

  • Full Address:

Reviews

If the application is not an ERP sort of then Sqlite is the best choice, it’s easy to integrate and fast if the data is small. Best choice for beginners as well.

Read Full Review Here

SQLite is not a multi-user platform where the users can handle concurrent writes. There for SQLite is not good for intensive applications with rapid data logging. If the system has concurrent transactions where lot of users keep accessing the same set of data simultaneously then SQLite is not a good choice for the project. SQLite data bases are restricted to maximum of 2GB in most of the cases.

Read Full Review Here

The most game changing aspect of SQLite is that it is serverless and self containing making it lightweight and portable. This makes it great for mobile applications and simplifies app architecture. We use SQLite to develop full apps but also only to explore some data sets using certain commands that I can only get in SQLite. It is close to SQL Server so it allows our RnD teams and developers to quickly test out some functionality before implementing in SQL Server.

Read Full Review Here

For mobile development(Android or iOS), this database works wonders considering it is so light weight and requires very less space. Database can be exported in the form of a single file which makes data sharing very easy. Data query operations are very fast. I have never faced any kind of downtime using this database which makes it highly available and reliable.

Read Full Review Here

SQLite is for a very specific use case and there are no distribution properties or guarantees. Designed to be very simple so not a lot of tuning for SQLite. If you want high availability and concurrency, you may want to look at a different solution.

Read Full Review Here