Reviews
Now Reading
SQLite
0
Review

SQLite

Overview
Synopsis

SQLite is a the most widely deployed database in the world with very many applications which includes very many high-profile projects. It implements a self-contained, server less, zero configuration and transactional SQL database engine.

Category

RDBMS Free

Features

• Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
•Zero-configuration - no setup or administration needed.
•Full-featured SQL implementation with advanced capabilities like partial indexes, indexes on expressions, JSON, and common table expressions. (Omitted features)
•A complete database is stored in a single cross-platform disk file. Great for use as an application file format.

License

Proprietary

Price

Free

Pricing

Subscription

Free Trial

Available

Users Size

Small (<50 employees), Medium (50 to 1000 employees), Enterprise (>1001 employees)

Website
Company

SQLite

What is best ?

•Supports terabyte-sized databases and gigabyte-sized strings and blobs. (See limits.html.)
•Small code footprint: less than 500KiB fully configured or much less with optional features omitted.
•Simple, easy to use API.
•Written in ANSI-C. TCL bindings included. Bindings for dozens of other languages available separately.
•Well-commented source code with 100% branch test coverage.
•Available as a single ANSI-C source-code file that is easy to compile and hence is easy to add into a larger project.
•Self-contained: no external dependencies.

What are the benefits ?

• Simple to install.
• It can run on any modern PC or smartphone as no additional programs are required for it to run.
• It’s portable and very simple to share databases, all that needs to be done is to just copy one file.
• It’s not owned by any company, so the code is free for all to change and use.
• It’s shared freely.

Rating
Our Rating
User Rating
Ease of use
7.6
Features & Functionality
7.6
Advanced Features
7.6
Integration
7.6
Customer Support
7.6
Performance
7.6
Implementation
Renew & Recommend
Bottom Line

SQLite is a the most widely deployed database in the world with very many applications which includes very many high-profile projects and it implements a self-contained, server less, zero configuration and transactional SQL database engine.

7.6
Our Rating
User Rating
You have rated this

SQLite is a the most widely deployed database in the world with very many applications which includes very many high-profile projects. It implements a self-contained, server less, zero configuration and transactional SQL database engine. It’s free to use for any purpose, commercial or private. SQLite is embedded into the end program. It’s not a client-server database engine. SQLite stores its entire database as a single cross-platform file on a host machine. It’s an SQL database engine that is embedded. It doesn’t have a separate server process. It reads and writes to ordinary disk files directly. A complete SQL database with multiple tables, indices, triggers and views, is contained in a single disk file. A database between 32-bit and 64-bit systems can be freely copied as the database file format is cross platform. SQLite is a compact library. With SQLite, the more memory you give it the faster it runs. SQLite is very reliable and its very carefully tested before its released. SQLite is perfect when it comes to responding gracefully to memory allocation failures and disk I/O errors. SQLite provides bugs lists and minute-by-minute chronologies of code changes. It’s open and honest about all bugs. Its source code is available for free to anybody who wants it although professional support is also available. It’s ideal for making good products that are fast, reliable, and simple to use.

SQLite
RDBMS Free: Top Twenty
PAT Index™
 
1
Sequel Pro
 
2
Db2 Express-C
 
3
Oracle Database XE
 
4
SQL Server Express
 
5
MySQL
 
6
SQLite
 
7
CUBRID
 
8
Firebird
 
9
PostgreSQL
 
10
MariaDB
Heat Index
 
 
 
 
 
The Latest
 
Read More
6
Editor's Picks
 
 
 
 
Go To RDBMS Free
Filter reviews
User Ratings





User Company size



User role





User industry





Ease of use
Features & Functionality
Advanced Features
Integration
Customer Support
Performance
Implementation
Renew & Recommend

What's your reaction?
Love It
0%
Very Good
0%
INTERESTED
0%
COOL
0%
NOT BAD
0%
WHAT !
0%
HATE IT
0%