SQL Guide

Complete SQL guide for C/C++.

CREATE TABLE

dbx_execute_sql(db, "CREATE TABLE users (id INTEGER, name TEXT)");

INSERT

dbx_execute_sql(db, "INSERT INTO users VALUES (1, 'Alice')");

SELECT

char* result = dbx_execute_sql(db, "SELECT * FROM users");
printf("%s\n", result);
dbx_free_string(result);

UPDATE

dbx_execute_sql(db, "UPDATE users SET name = 'Bob' WHERE id = 1");

DELETE

dbx_execute_sql(db, "DELETE FROM users WHERE id = 1");

Transactions

DbxTransaction* tx = dbx_begin_transaction(db);
dbx_execute_sql(db, "INSERT INTO users VALUES (1, 'Alice')");
dbx_commit(tx);

Next Steps

• KV Operations - Key-Value operations
• C API - C function reference