An Elixir wrapper around esqlite. The main aim here is to provide convenient usage of sqlite databases.
The simple way to use sqlitex is just to open a database and run a query
Sqlitex.with_db('test/fixtures/golfscores.sqlite3', fn(db) ->
Sqlitex.query(db, "SELECT * FROM players ORDER BY id LIMIT 1")
end)
# => [[id: 1, name: "Mikey", created_at: {{2012,10,14},{05,46,28}}, updated_at: {{2013,09,06},{22,29,36}}, type: nil]]
Sqlitex.with_db('test/fixtures/golfscores.sqlite3', fn(db) ->
Sqlitex.query(db, "SELECT * FROM players ORDER BY id LIMIT 1", into: %{})
end)
# => [%{id: 1, name: "Mikey", created_at: {{2012,10,14},{05,46,28}}, updated_at: {{2013,09,06},{22,29,36}}, type: nil}]If you want to keep the database open during the lifetime of your project you can use the Sqlitex.Server GenServer module.
Here's a sample from a phoenix projects main supervisor definition.
children = [
# Start the endpoint when the application starts
worker(Golf.Endpoint, []),
worker(Sqlitex.Server, ['golf.sqlite3', [name: Sqlitex.Server]])
]Now that the GenServer is running you can make queries via
Sqlitex.Server.query(Sqlitex.Server,
"SELECT g.id, g.course_id, g.played_at, c.name AS course
FROM games AS g
INNER JOIN courses AS c ON g.course_id = c.id
ORDER BY g.played_at DESC LIMIT 10")I am building this package as an attempt to learn more about Elixir and I'll be adding features only as I need them.
I would love to get any feedback I can on how other people might want to use SQlite with Elixir.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent