Remy's odin-sqlite bindings

Simple, incomplete, working Sqlite3 bindings for Odin.

So the original library is over 2 years old and doesn't work? I'm fixing it for my own project. However, if you find this and want to use odin-sqlite I would recommend using this fixed version as I did not manage to get the original working without modifying the source code.

This library requires a static lib to the build using the sqlite3 Source Code. I recommend downloading the "sqlite-autoconfg" version that concludes "configure" scripts and makefiles.

New helpers

I realized my old helper code was not on par with what other languages deliver, i.e. go / rust So i made some adjustments:

simple cache system map[string]^sql.Stmt that holds prepared statements for reusing
use bind system from sqlite itself instead of using core:fmt
SELECT helper to allow structs to be filled automatically ~ when column names match the struct field name
use or_return on sql.ResultCode since a lot can fail
bind helper to insert args: ..any into increasing sql.bind_*(stmt, arg_index, arg)

package main

import "core:fmt"
import "src" // <--- my helpers live in my src, up to you

run :: proc() -> (err: src.Result_Code) {
	using src
	db_execute_simple(`DROP TABLE IF EXISTS people`) or_return

	db_execute_simple(`CREATE TABLE IF NOT EXISTS people(
		id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
		number INTEGER DEFAULT 0,
		big_number DECIMAL DEFAULT 0,
		name VARCHAR(30)
	)`) or_return

	db_insert("people (number, name, big_number)", 4, "test", 1.24) or_return

	// above turns into
	// stmt := db_cache_prepare(`INSERT INTO people (number, name, big_number) 
	// 		VALUES (?1, ?2, ?3)
	// 	`) or_return
	// db_bind(stmt, 4, "test", 1.23) or_return
	// db_bind_run(stmt) or_return

	db_execute("UPDATE people SET number = ?1", 3) or_return

	People :: struct {
		id: i32,
		number: i32,
		big_number: f64,
		name: string,
	}

	p1: People
	db_select("FROM people WHERE id = ?1", p1, 1) or_return
	fmt.println(p1)
	
	return
}

main :: proc() {
	using src

	db_check(db_init("testing.db"))
	defer db_check(db_destroy())

	db_cache_cap(64)
	defer db_cache_destroy()

	err := run()
	fmt.println(err)
}

prints

People{id = 1, number = 3, big_number = 1.240, name = test}
OK

db_select & db_inser are obviously very opinionated, main call is db_execute :: proc(cmd: string, args: ..any) which does cmd preparing and bind argument insertion for you

still need to test multiple row result usage out

hrszpuk/odin-sqlite

Remy's odin-sqlite bindings

New helpers