{"action":"created","issue":{"url":"https://api.github.com/repos/phoenixframework/phoenix/issues/3218","repository_url":"https://api.github.com/repos/phoenixframework/phoenix","labels_url":"https://api.github.com/repos/phoenixframework/phoenix/issues/3218/labels{/name}","comments_url":"https://api.github.com/repos/phoenixframework/phoenix/issues/3218/comments","events_url":"https://api.github.com/repos/phoenixframework/phoenix/issues/3218/events","html_url":"https://github.com/phoenixframework/phoenix/issues/3218","id":393739863,"node_id":"MDU6SXNzdWUzOTM3Mzk4NjM=","number":3218,"title":"Drop SQLite from the list of supported databases","user":{"login":"mitakas","id":210645,"node_id":"MDQ6VXNlcjIxMDY0NQ==","avatar_url":"https://avatars1.githubusercontent.com/u/210645?v=4","gravatar_id":"","url":"https://api.github.com/users/mitakas","html_url":"https://github.com/mitakas","followers_url":"https://api.github.com/users/mitakas/followers","following_url":"https://api.github.com/users/mitakas/following{/other_user}","gists_url":"https://api.github.com/users/mitakas/gists{/gist_id}","starred_url":"https://api.github.com/users/mitakas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mitakas/subscriptions","organizations_url":"https://api.github.com/users/mitakas/orgs","repos_url":"https://api.github.com/users/mitakas/repos","events_url":"https://api.github.com/users/mitakas/events{/privacy}","received_events_url":"https://api.github.com/users/mitakas/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-12-23T10:40:45Z","updated_at":"2018-12-24T14:17:47Z","closed_at":null,"author_association":"NONE","body":"Drop SQLite (and MongoDB) from the list of supported databases in `guides/ecto.md`.\r\n\r\n### Environment\r\n\r\n* Elixir version (elixir -v): 1.7.4\r\n* Phoenix version (mix deps): 1.4.0\r\n* NodeJS version (node -v): v6.15.1\r\n* NPM version (npm -v): 3.10.10\r\n* Operating system: Ubuntu 16.04.5 LTS\r\n\r\n### Expected behavior\r\nBeing able to use SQLite with Phoenix 1.4.\r\n\r\n### Actual behavior\r\nSupport for SQLite (and MongoDB) was removed in 2016 (see issue #1843 and commit 60351e6). Ecto 3 (see #3100 and commit 5e84b20) is the default database wrapper and the adapter for SQLite isn't compatible with Ecto 3 (see the [Ecto documentation](https://github.com/elixir-ecto/ecto/blame/v3.0.3/README.md#L77) and elixir-sqlite/sqlite_ecto2#224) yet."},"comment":{"url":"https://api.github.com/repos/phoenixframework/phoenix/issues/comments/449739353","html_url":"https://github.com/phoenixframework/phoenix/issues/3218#issuecomment-449739353","issue_url":"https://api.github.com/repos/phoenixframework/phoenix/issues/3218","id":449739353,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0OTczOTM1Mw==","user":{"login":"mpranjic","id":2545452,"node_id":"MDQ6VXNlcjI1NDU0NTI=","avatar_url":"https://avatars2.githubusercontent.com/u/2545452?v=4","gravatar_id":"","url":"https://api.github.com/users/mpranjic","html_url":"https://github.com/mpranjic","followers_url":"https://api.github.com/users/mpranjic/followers","following_url":"https://api.github.com/users/mpranjic/following{/other_user}","gists_url":"https://api.github.com/users/mpranjic/gists{/gist_id}","starred_url":"https://api.github.com/users/mpranjic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mpranjic/subscriptions","organizations_url":"https://api.github.com/users/mpranjic/orgs","repos_url":"https://api.github.com/users/mpranjic/repos","events_url":"https://api.github.com/users/mpranjic/events{/privacy}","received_events_url":"https://api.github.com/users/mpranjic/received_events","type":"User","site_admin":false},"created_at":"2018-12-24T14:17:47Z","updated_at":"2018-12-24T14:17:47Z","author_association":"NONE","body":"Phoenix 1.4 should work with Ecto 2, and `elixir-sqlite/sqlite_ecto2` should work with Ecto 2.\r\nHaven't personally tried, but nothing implies not being able to use it.\r\nPerhaps a note to `guides/ecto.md` about version requirements, but in my opinion Ecto documentation is clear about that, and because `guides/ecto.md` doesn't point to any specific libraries, you should check out `Ecto` anyway.\r\n\r\nPhoenix is not bound to Ecto 3 in any way, except through mix tasks that generate ecto-related code.\r\nSQLite [is not supported](https://hexdocs.pm/phoenix/Mix.Tasks.Phx.New.html#module-options) generator adapter, so you have to manually add libraries to `mix.exs` in which case you simply use Ecto 2."}}
{"actor":{"display_login":"mpranjic"}}