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 Brackets Code Editor 1.11 on Ubuntu

How to Install Brackets Code Editor 1.11 on Ubuntu The Brackets Code Editor is a lightweight and versatile code editor that...
12/02/2020

How to install Syncthing – Continuous File Synchronization on Ubuntu

Syncthing is a continuous file synchronization open source software, that synchronizes files between two or more computers...
28/12/2020

Find Package Name of Installed Ubuntu Package

The user can install and uninstall any software in Ubuntu by using Ubuntu Software Center or command line. Many commands...
28/12/2020
Bài Viết

Bài Viết Mới Cập Nhật

mua Proxy riêng ở đâu, và nó đem lại lợi ích gì cho người sử dụng
22/11/2022

Hướng dẫn sử dụng Proxy Helper Fakeip khi thuê proxy
21/11/2022

PROXY NUÔI TÀI KHOẢN FACEBOOK – KINH NGHIỆM FAKE IP – THUÊ PROXY GIÁ RẺ
14/11/2022

Mua Proxy Nuôi Zalo Giá Rẻ Tại Onet.com.vn
14/11/2022

BẢNG GIÁ MUA PROXY VIỆT NAM và PROXY US Onet.com.vn
14/11/2022