sqlite3

sqlite3 for all relevant haxe targets

basic usage

var db = new Database("somedb.db");
db.open().then(result -> {
    return db.exec("CREATE TABLE Persons (PersonID int, LastName varchar(50), FirstName varchar(50));");
}).then(result -> {
    return db.exec("INSERT INTO Persons (PersonID, LastName, FirstName) VALUES (1, 'Ian', 'Harrigan');");
}).then(result -> {
    return db.all("SELECT * FROM Persons;");
}).then(result -> {
    for (person in result.data) {
        trace(person.FirstName, person.LastName);
    }
    return db.get("SELECT * FROM Persons WHERE PersonID = ?", [1]); // use prepared statement
}).then(result -> {
    trace(result.data.FirstName, result.data.LastName);
}, (error:SqliteError) -> {
    // error
});

dependencies

• nodejs - sqlite3 (npm install sqlite3)
• hxcpp - libsqlite3 (better than haxe's internal sqlite)
• sys - haxe's internal sqlite