Databases SQLite Ubuntu

How to install SQLite 3.18.0 on Ubuntu 17.04, Ubuntu 16.04, Linux Mint

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.

Install SQLite

SQLite 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.

Bug Fixes:

  • 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

About the author



A passionate Linux user for personal and professional reasons, always exploring what is new in the world of Linux and sharing with my readers.

Leave a Comment