SQLite Server on Ubuntu Server 20.04

SQLite is a lightweight, command-line and cross-platform database management system RDBMS. SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world.

SQLite features:

• Transactional - Consistent, atomic, isolated and durable (ACID), allowing safe access from multiple processes or threads.
  
  
• Full-featured SQL implementation - Advanced capabilities like partial indexes, indexes on expressions, JSON, common table expressions, and window functions.
  
  
• Zero-configuration - Easy to use with no setup or administration needed.
  
  
• Storage in a single cross-platform disk file - Used as an application file format that supports terabyte-sized databases and gigabyte-sized strings and blobs.
  
  
• Written in ANSI-C and very fast - Appears faster than direct filesystem I/O.
  
  
• Cross-platformed DBMS - Android, BSD, iOS, Linux, Mac, Solaris, VxWorks, and Windows (Win32, WinCE, WinRT) with easily portable to other systems.
  
  
• Large number of API's: - (Visual Basic, C#), PHP, Java, Objective C, Python and a lot of other programming language.
  
  
• Command-line interface (CLI) client that can be used to administer SQLite databases.
  
  
• Small Runtime Footprint - Less than a megabyte of a code