Database (SQLite)

Opening a Database

int db = db_open("my_database.db");

Executing Queries

You can execute SQL queries using db_query. This function returns an array of results for SELECT queries.

// Create table
db_query(db, "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT);");

// Insert data
db_query(db, "INSERT INTO users (name) VALUES ('Tulpar');");

// Select data
array results = db_query(db, "SELECT * FROM users;");
print(results);

Closing the Database

db_close(db);