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-sqliteThen add bs-sqlite to your bs-dependencies in bsconfig.json: