sqlight
sqlight copied to clipboard
lpil
💡 Use SQLite from Gleam!
Has there been any thoughts about transaction support? Not only is it good for correctness, putting inserts in a transaction often improves performance too!
This makes use of explicit type binds in esqlite3 since `String` & `BitArray` use the same runtime representation. This avoids an ambiguity [here](https://github.com/mmzeeman/esqlite/blob/58454af87559981aed6fb1235fc3f63d618505db/src/esqlite3.erl#L360-L361).
Hello! From experience, inserting into SQLite databases has been a common hurdle for people new to Gleam (for the people that are using SQLite of course). What do you think...
In Esqlite we can do ```erlang %% All columns {ok, Stmt} = esqlite3:prepare(Db, "select * from test_table"), ?assertEqual([, ], esqlite3:column_decltypes(Stmt)), ``` and ```erlang {ok, Stmt} = esqlite3:prepare(C, "select 1 as...
Hello :) I added support for prepared query statements to improve overall performance when queries are reused. Since both libraries (Erlang and JavaScript) use prepared statements under the hood when...
Hello hello! I accidentally introduced a bug in my application where I was passing a connection to another erlang actor and it kept crashing. Took me a while to figure...
[Deno](https://docs.deno.com/examples/sqlite/) (and [node.js](https://nodejs.org/api/sqlite.html)) now have built in support for sqlite3 with the same module. The benefit of using this built in module is that real sqlite will be used whereas...
