SQLite 3.18.0 recently released, is free and its the most widely deployed database engine in the world. It can be described as an embedded SQL database engine, with an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. Before we proceed on how to install SQLite Ubuntu, lets take a look at its features.
- Transactions are atomic, consistent, isolated, as well as 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, as well as common table expressions
- Furthermore, complete database is stored in a single cross-platform disk file. Great for use as an application file format.
- Supports terabyte-sized databases as well as gigabyte-sized strings and blobs.
- Small code footprint: less than 500KiB fully configured or much less with optional features omitted.
- Simple, as well as 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.
- Cross-platform: Android, *BSD, iOS, Linux, Mac, Solaris, VxWorks, as well as Windows (Win32, WinCE, WinRT) are supported out of the box. Easy to port to other systems.
- Sources are in the public domain, hence can be used for any purpose.
- Comes with a standalone command-line interface (CLI) client that can be used to administer SQLite databases.
SQLite 3.18.0 Highlights
- Added the PRAGMA optimize command to improve long-term query performance
- Enhance PRAGMA integrity_check and PRAGMA quick_check so that they verify CHECK constraints.
- Added the json_patch() SQL function to the JSON1 extension.
- Enhance the LIKE optimization so that it works for arbitrary expressions on the left-hand side as long as the LIKE pattern on the right-hand side does not begin with a digit or minus sign.
- Enhance the query plans for joins to detect empty tables early as well as halt without doing unnecessary work.
- In addtion to various performance improvements.
- Indexed expressions with collating sequences handled correctly
- Fix a bug in the ‘start of …’ modifiers for the date and time functions
- Fix a potential segfault in complex recursive triggers, resulting from a bug in the OP_Once opcode introduced as part of a performance optimization in version 3.15.0
- In the RBU extension, add extra sync operations to avoid the possibility of corruption following a power failure.
- The sqlite3_trace_v2() output for nested SQL statements should always begin with a “–” comment marker.
How to install SQLite 3.17.0 on Ubuntu 16.04
sudo add-apt-repository ppa:jonathonf/backports sudo apt-get update && sudo apt-get install sqlite3
How to uninstall SQLite from Ubuntu
sudo apt-get remove sqlite3