SQL database abstraction library written in C which can get included directly into another program. Each driver has been implemented using the client connector library provided by the corresponding database system.

• Single C and header file
• Cross-platform (POSIX, BSD, Windows)
• Simple API that handles most common database operations (driver-specific database/statement handles available if needed)
• Test cases with 100% code and branch coverage
• Doxygen with 100% documentation
• Free software (permissive - CC0)

Supports the following database engines:

• MariaDB/mySQL (requires libmariadbclient or libmysqlclient)
• PostgreSQL (requires libpq)
• SQLite (requires libsqlite3)

To include the library into your application, simply copy the src/sqldbal.h and src/sqldbal.c files into your project directory. Then include the sqldbal.h header into your C file, compile sqldbal.c, and include the resulting object file into the build system.

The following example code demonstrates how to use this library with the SQLite driver. This example opens a database file, creates a table, inserts a record, and then reads back the inserted records.

#include <assert.h> #include <stdint.h> #include <stdio.h> #include "sqldbal.h" #define DRIVER SQLDBAL_DRIVER_SQLITE #define LOCATION "example.db" #define PORT NULL #define USERNAME NULL #define PASSWORD NULL #define DATABASE NULL #define FLAGS (SQLDBAL_FLAG_DEBUG | \ SQLDBAL_FLAG_SQLITE_OPEN_CREATE | \ SQLDBAL_FLAG_SQLITE_OPEN_READWRITE) int main(void){ enum sqldbal_status_code rc; struct sqldbal_db *db; struct sqldbal_stmt *stmt; int64_t i64; const char *text; rc = sqldbal_open(DRIVER, LOCATION, PORT, USERNAME, PASSWORD, DATABASE, FLAGS, NULL, 0, &db); assert(rc == SQLDBAL_STATUS_OK); rc = sqldbal_exec(db, "CREATE TABLE IF NOT EXISTS test(id INTEGER, str TEXT)", NULL, NULL); assert(rc == SQLDBAL_STATUS_OK); rc = sqldbal_stmt_prepare(db, "INSERT INTO test(id, str) VALUES(?, ?)", -1, &stmt); assert(rc == SQLDBAL_STATUS_OK); rc = sqldbal_stmt_bind_int64(stmt, 0, 10); assert(rc == SQLDBAL_STATUS_OK); rc = sqldbal_stmt_bind_text(stmt, 1, "test string", -1); assert(rc == SQLDBAL_STATUS_OK); rc = sqldbal_stmt_execute(stmt); assert(rc == SQLDBAL_STATUS_OK); rc = sqldbal_stmt_close(stmt); assert(rc == SQLDBAL_STATUS_OK); rc = sqldbal_stmt_prepare(db, "SELECT id, str FROM test WHERE id = 10", -1, &stmt); assert(rc == SQLDBAL_STATUS_OK); rc = sqldbal_stmt_execute(stmt); assert(rc == SQLDBAL_STATUS_OK); while(sqldbal_stmt_fetch(stmt) == SQLDBAL_FETCH_ROW){ rc = sqldbal_stmt_column_int64(stmt, 0, &i64); assert(rc == SQLDBAL_STATUS_OK); rc = sqldbal_stmt_column_text(stmt, 1, &text, NULL); assert(rc == SQLDBAL_STATUS_OK); printf("%d / %s\n", (int)i64, text); } rc = sqldbal_stmt_close(stmt); assert(rc == SQLDBAL_STATUS_OK); rc = sqldbal_close(db); assert(rc == SQLDBAL_STATUS_OK); return 0; }

Place the code snippet above into a file named 'example.c' and change each #define to the appropriate values for your database. Then copy sqldbal.c and sqldbal.h into the same directory and run the following commands to compile with support for all databases.

cc -DSQLDBAL_MARIADB -DSQLDBAL_POSTGRESQL -DSQLDBAL_SQLITE sqldbal.c -c -o sqldbal.o

cc -DSQLDBAL_MARIADB -DSQLDBAL_POSTGRESQL -DSQLDBAL_SQLITE example.c -c -o example.o

cc example.o sqldbal.o -o sqldbal_test -lsqlite3 -lpq -lmariadbclient

Remove the corresponding -D and -l arguments for the database drivers that you do not need to use. The commands as above should create an executable called 'sqldbal_test'.

See the Technical Documentation generated from Doxygen.