Skip to main content
Version: Next

SQLite

SQLite is Self-contained, high-reliability, full-featured, SQL database engine, used for Relational Databases . 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.

gui

Prepare​

When referring to this document to use SQLite, please read and ensure the following points:

  • This application is installed by Websoft9 console.

  • Please check the application's usage license agreement to ensure compliance.

  • Configure the domain name or server security group opens external network ports for application access.

Getting started​

Initial setup​

  1. When completed installation of SQLite at Websoft9 Console, get the applicaiton's Overview and Access information from My Apps

  2. Enter the command mode of the SQLite container and run the sqlite3 command.

    [root@VM-0-11-centos ~]# sqlite3
    SQLite version 3.29.0 2019-07-10 17:32:03
    Enter ".help" for usage hints.
    Connected to a transient in-memory database.
    Use ".open FILENAME" to reopen on a persistent database.
    sqlite>

Configuration options​

  • CLI: sqlite3 --help

Administer​

  • Upgrade: Binary Replacement and sqlite3.conf Migration

Troubleshooting​