Repository files navigation

Elixir API for interacting with SQLite databases.This library allows you to use the accelent sqlite engine fromerlang. The library is implemented as a nif library, which allows forthe fastest access to a sqlite database. This can be risky, as a bugin the nif library or the sqlite database can crash the entire ErlangVM. If you do not want to take this risk, it is always possible toaccess the sqlite nif from a separate erlang node.

Special care has been taken not to block the scheduler of the callingprocess. This is done by handling all commands from erlang within alightweight thread. The erlang scheduler will get control back whenthe command has been added to the command-queue of the thread.

{:ok,db}=Sqlite.open(":memory:")Sqlite.exec("create virtual table test_table using fts3(content text);",db):ok=Sqlite.exec("create table test_table(one varchar(10), two int);",db):ok=Sqlite.exec(["insert into test_table values(","\"hello1\"",",","10);"],db){:ok,1}=Sqlite.changes(db)

Since this project was originally an Erlang package, I chose to maintain theoriginal module name (as an alias) and it's tests to try to maintainbackwards compatibility. By default these tests get ran by default.

# All the tests without the bench marks.mixtest

There is also a benchmark suite located in thebench directory.It does not get ran with the test suite since it can take quite a while.

# run all the tests and the benchmarks.mixtest --include bench

This project is originally a fork ofesqliteWhich was originally an Erlang implementation. The underlying NIF code (inc_src),and the test file inerl_test both retain the original Apache v2 license.