lostkobrakai / ecto_sqlite3

An Ecto SQLite3 adapter.

Ecto SQLite3 Adapter

An Ecto SQLite3 Adapter. Uses Exqlite as the driver to communicate with sqlite3.

Caveats and limitations

See Limitations in Hexdocs.

Installation

defp deps do
  {:ecto_sqlite3, "~> 0.5.6"}
end

Usage

Define your repo similar to this.

defmodule MyApp.Repo do
  use Ecto.Repo, otp_app: :my_app, adapter: Ecto.Adapters.SQLite3
end

Configure your repository similar to the following. If you want to know more about the possible options to pass the repository, checkout the documentation for Ecto.Adapters.SQLite. It will have more information on what is configurable.

config :my_app,
  ecto_repos: [MyApp.Repo]

config :my_app, MyApp.Repo,
  database: "path/to/my/database.db",

Benchmarks

We have some benchmarks comparing it against the MySQL and Postgres adapters.

You can read more about those at bench/README.md.

Running Tests

Running unit tests

mix test

Runing integration tests

EXQLITE_INTEGRATION=true mix test