Jason M Barnes

Delete/Update All with Joins

1

See the note at the bottom of the [tests](https://github.com/jazzyb/sqlite_ecto/blob/master/test/sqlite_ecto_test.exs#L530): ``` # NOTE: The assertions commented out below represent how joins *could* be # handled in SQLite to produce the same...

Sqlite.Ecto does not support arbitrary prefixes by default. In order to do so, it would need to support the `ATTACH DATABASE` command -- probably as a config option. Need to...

See discussion at: https://news.ycombinator.com/item?id=10103695 When this is fully integrated into SQLite: - [ ] Issue a PR to update esqlite to the latest version that supports JSON - [ ]...

The `PRAGMA foreign_keys = ON;` method of ensuring foreign key constraints puts limits on what we are able to do with SQLite `ALTER TABLE`. See [this commit note](https://github.com/jazzyb/sqlite_ecto/commit/3e99c2d5f77417d412a92c14d13b76b31df8aed6) for details.

There is no syntax provision for implementing full outer joins in SQLite, but the link below discusses a way of implementing the same functionality using unions: http://sqlite.awardspace.info/syntax/sqlitepg06.htm See if this...