An Ecto SQLite3 Adapter. Uses Exqlite as the driver to communicate with sqlite3.
See Limitations in Hexdocs.
defp deps do
{:ecto_sqlite3, "~> 0.5.2"}
end
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",
We have some benchmarks comparing it against the MySQL
and Postgres
adapters.
You can read more about those at bench/README.md.