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

12/02/2020

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
ONET IDC thành lập vào năm 2012, là công ty chuyên nghiệp tại Việt Nam trong lĩnh vực cung cấp dịch vụ Hosting, VPS, máy chủ vật lý, dịch vụ Firewall Anti DDoS, SSL… Với 10 năm xây dựng và phát triển, ứng dụng nhiều công nghệ hiện đại, ONET IDC đã giúp hàng ngàn khách hàng tin tưởng lựa chọn, mang lại sự ổn định tuyệt đối cho website của khách hàng để thúc đẩy việc kinh doanh đạt được hiệu quả và thành công.
Bài viết liên quan

Install and Use TensorFlow on Ubuntu

TensorFlow with CPU support This mechanism takes less time (usually 5 to 10 minutes) during installation. If your system...
12/02/2020

How to Permanently Install Ubuntu on Any External Drive Using VirtualBox

A portable disk with a full featured self-contained installation of Ubuntu can be useful in scenarios where you don’t...
29/12/2020

How to Install Life is Strange Episode 1 on Ubuntu

What’s so special about Life Is Strange? Life is Strange – Episode 1 was one of the most sought-after story-telling...
29/12/2020