bs-sqlite
Bindings to the better-sqlite3 module for interaction with Sqlite databases.
Usage
Basic Select
let db = Sqlite.Connection.make ~path:"test.db" ~memory:Js.true_ () let _ = Sqlite.Connection.prepare db "SELECT 1 + 1 AS result" |> Sqlite.Statement.get [||] |> Js.log )
Use un-named parameters
let db = Sqlite.Connection.make ~path:"test.db" ~memory:Js.true_ () let _ = Sqlite.Connection.prepare db "SELECT ? + ? AS result" |> Sqlite.Statement.get [|1; 1|] |> Js.log )
Use named parameters
Using :x format
let db = Sqlite.Connection.make ~path:"test.db" ~memory:Js.true_ () let _ = Sqlite.Connection.prepare db "SELECT :x + :y AS result" |> Sqlite.Statement.get_named [%bs.obj { x = 1; y = 2 }] |> Js.log )
Using $x format
let db = Sqlite.Connection.make ~path:"test.db" ~memory:Js.true_ () let _ = Sqlite.Connection.prepare db "SELECT $x + $y AS result" |> Sqlite.Statement.get_named [%bs.obj { x = 1; y = 2 }] |> Js.log )
Using @x format
let db = Sqlite.Connection.make ~path:"test.db" ~memory:Js.true_ () let _ = Sqlite.Connection.prepare db "SELECT @x + @y AS result" |> Sqlite.Statement.get_named [%bs.obj { x = 1; y = 2 }] |> Js.log )
How do I install it?
Inside of a BuckleScript project:
yarn install --save bs-sqlite
Then add bs-sqlite
to your bs-dependencies
in bsconfig.json
: