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:

  • Login to Websoft9 Console and find or install SQLite:

    • Go to My Apps listing applications
    • Go to App Store installing target application

  • 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. After completing the installation of SQLite in the Websoft9 Console, retrieve the application'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

Administration​

  • Upgrade: Binary Replacement and sqlite3.conf Migration

Troubleshooting​