example.c

#include "../../libsql.h"
#include <stdio.h>

int main() {
    libsql_setup((libsql_config_t){0});

    const char *encryption_key = "my_secret_key";

    libsql_database_t db = libsql_database_init((libsql_database_desc_t
    ){.path = "encrypted.db",
      .encryption_key = encryption_key,
      .cypher = LIBSQL_CYPHER_AES256});

    if (db.err) {
        fprintf(
            stderr,
            "Error initializing encrypted database: %s\n",
            libsql_error_message(db.err)
        );
        return 1;
    }

    libsql_connection_t conn = libsql_database_connect(db);
    if (conn.err) {
        fprintf(
            stderr,
            "Error connecting to encrypted database: %s\n",
            libsql_error_message(conn.err)
        );
        return 1;
    }

    const char *setup_sql = "CREATE TABLE IF NOT EXISTS secrets (id INTEGER "
                            "PRIMARY KEY AUTOINCREMENT, content TEXT);"
                            "INSERT INTO secrets (content) VALUES ('Top Secret "
                            "Info 1'), ('Classified Data 2');";

    libsql_batch_t batch = libsql_connection_batch(conn, setup_sql);
    if (batch.err) {
        fprintf(
            stderr,
            "Error executing setup batch: %s\n",
            libsql_error_message(batch.err)
        );
        return 1;
    }

    printf("Table created and data inserted into encrypted database.\n");

    libsql_statement_t query_stmt =
        libsql_connection_prepare(conn, "SELECT * FROM secrets");
    if (query_stmt.err) {
        fprintf(
            stderr,
            "Error preparing query: %s\n",
            libsql_error_message(query_stmt.err)
        );
        return 1;
    }

    libsql_rows_t rows = libsql_statement_query(query_stmt);
    if (rows.err) {
        fprintf(
            stderr,
            "Error executing query: %s\n",
            libsql_error_message(rows.err)
        );
        return 1;
    }

    printf("Secrets in the encrypted database:\n");
    libsql_row_t row;
    while (!(row = libsql_rows_next(rows)).err && !libsql_row_empty(row)) {
        libsql_result_value_t id = libsql_row_value(row, 0);
        libsql_result_value_t content = libsql_row_value(row, 1);

        if (id.err || content.err) {
            fprintf(stderr, "Error retrieving row values\n");
            continue;
        }

        printf(
            "%lld: %s\n",
            (long long)id.ok.value.integer,
            (char *)content.ok.value.text.ptr
        );

        libsql_row_deinit(row);
    }

    libsql_rows_deinit(rows);
    libsql_statement_deinit(query_stmt);
    libsql_connection_deinit(conn);
    libsql_database_deinit(db);

    printf("Database closed. The file 'encrypted.db' is now encrypted.\n");

    return 0;
}