ecto_sqlite3
ecto_sqlite3 copied to clipboard
elixir-sqlite
An Ecto SQLite3 adapter.
When using Elixir 1.14.0 with OTP 25, we get a new set of warnings when running `mix test` Here are the warnings. ``` warning: Application.get_env/2 is discouraged in the module...
Hi, I already posted this issue in the [ecto repository](https://github.com/elixir-ecto), but @josevalim pointed me to this repository with the guess, that there might be additional quotes added around the index...
I am trying to use the [`values/2`](https://hexdocs.pm/ecto/3.11.1/Ecto.Query.API.html#values/2) macro to filter results by matching compound keys (`group_name, name`). ```elixir vals = Enum.map(rows, fn row -> %{group_name: row.group_name, name: row.name} end) Repo.all(...
I am trying to use a sqlite3 database with ecto. Everything seems to work without any problems on the dev environment, however when I am running tests, a lot of...
When using an in memory database, if the a process that performs a query crashes, then the database is destroyed. This could potentially be avoided by isolating the process that...
**Test environment:** ``` Erlang/OTP 25 [erts-13.1.2] Elixir 1.14.2 ecto 3.10.3 ecto_sql 3.10.1 ecto_sqlite3 0.10.3 ``` **Description:** Suppose it, as a completely straightforward use case, as the documentation of `no_assoc_constraint/3` expressed...
I'm looking at a project (live_beats modified to use SQLite3) with a query like this: ```elixir Ecto.Multi.new() |> Ecto.Multi.delete_all( :delete_expired_songs, from(s in Song, where: s.inserted_at < from_now(^(-count), ^to_string(interval)), where: s.server_ip...
Is there any way to specify that a table's primary key should be AUTOINCREMENT?
Hi everyone, SQLite3 does not currently support async tests in the sandbox. At first, it makes sense because it is single writer, but then I realized that we never commit...
It seem like sqlite supports all the necessary features in json to support ecto array types. It would be nice especially for atomic updates where new rows are pushed.
