LibSQL

We aim to evolve it to suit many more use cases than SQLite was originally designed for, and plan to use third-party OSS code wherever it makes sense.

libSQL has many great features, including:

• Embedded replicas that allow you to have replicated database inside your app.
• libSQL server for remote SQLite access, similar to PostgreSQL or MySQL
• Supports Rust, JavaScript, Python, Go, and more.

For more information, check the Docker configuration guide here.

Connection

You will be instructed to bind a domain for connecting the libSQL instance.

It binds to the HTTP port of libSQL that is designed for external connection.

You can optionally enable the gRPC port (5001) in the "Networking" tab if you need the inter-node communication.

Authentication

You can specify SQLD_HTTP_AUTH variable optionally.

It specifies legacy HTTP basic authentication. The argument must be in format basic:$PARAM, where $PARAM is base64-encoded string $USERNAME:$PASSWORD.

For example, if you want to set username admin and password password, you can set SQLD_HTTP_AUTH to basic:YWRtaW46cGFzc3dvcmQ=.