ecto_sqlite3
ecto_sqlite3 copied to clipboard
An Ecto SQLite3 adapter.
See https://github.com/elixir-ecto/ecto_sql/pull/423 * [x] TODO: Change `mix.exs` back to released versions.
I noticed that this adapter doesn't seem to support DDL transactions or a migration lock during ecto migrations. Does that support need to be implemented? I'm probably missing something, but...
I've got a table that looks like this: ```sql CREATE TABLE IF NOT EXISTS "things" ("id" INTEGER PRIMARY KEY, "thing_id" INTEGER NOT NULL, "user_id" INTEGER NOT NULL, "timestamp" TEXT_DATETIME NOT...
Currently, the function checks if the database file exists. This returns false for in-memory. Which in turn fails `Phoenix.Ecto.CheckRepoStatus` during development. I would like to see if we can make...
Sqlite does support ON CONFLICT DO upsert feature, eg: https://www.sqlite.org/lang_UPSERT.html As part of this I synced a couple of function definitions to match current upstream postgrex as part of this....
Hi there I have a few questions and possibly an interesting proposal. First of all, amazing work you;ve put in this adapter and the exqlite version! I'm in love with...
This will likely require support from `exqlite` for named paramters: https://www.sqlite.org/c3ref/bind_blob.html Exqlite will need to handle taking in a parameter name and finding the correct parameter index via `sqlite3_bind_parameter_index()` when...
@kevinlang I saw that you had a logo made. Let's add it to repos as the logo. Unless you want to explore other potential logos.
I think in the docs in the [Limitation][1] we should add a simple example of how a schemaless query would work for sqlite3. [1]: https://hexdocs.pm/ecto_sqlite3/Ecto.Adapters.SQLite3.html#module-schemaless-queries