# How do I setup Phoenix with SQLite?

**URL:** <https://forum.elixirforum.com/t/how-do-i-setup-phoenix-with-sqlite/35993>\
**Category:** Questions\
**Tags:** ecto, phoenix, sqlite\
**Created:** [December 5, 2020, 1:10am UTC](https://forum.elixirforum.com/t/how-do-i-setup-phoenix-with-sqlite/35993 "2020-12-05T01:10:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![broccolidev](https://forum.elixirforum.com/letter_avatar_proxy/v4/letter/b/d6d6ee/32.png) [@broccolidev](https://forum.elixirforum.com/u/broccolidev)\
**Post date:** [December 5, 2020, 1:10am UTC](https://forum.elixirforum.com/t/how-do-i-setup-phoenix-with-sqlite/35993/1 "2020-12-05T01:10:01Z")

</div>

The only guide I’ve found suggested adding “{:sqlite\_ecto, “~\> 1.0.0”}” to my mix.exs, but when running “mix deps.get” I receive the following error:

```elixir

`Failed to use "ecto" (version 3.5.5) because` ` ecto_sql (version 3.5.3) requires ~> 3.5.0` ` phoenix_ecto (version 4.2.1) requires ~> 3.0` ` sqlite_ecto (versions 1.0.0 to 1.0.2) requires ~> 1.0` ` mix.lock specifies 3.5.5` `** (Mix) Hex dependency resolution failed, change the version requirements of your dependencies or unlock them (by using mix deps.update or mix deps.unlock). If you are unable to resolve the conflicts you can try overriding with {:dependency, "~> 1.0", override: true}`

```

---

<div class="post-metadata">

**Author:** ![John-Goff](https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/john-goff/32/19768_2.png) [@John-Goff](https://forum.elixirforum.com/u/John-Goff)\
**Post date:** [December 5, 2020, 2:29pm UTC](https://forum.elixirforum.com/t/how-do-i-setup-phoenix-with-sqlite/35993/3 "2020-12-05T14:29:29Z")

</div>

Just did a cursory glance on Github, looks as though that adapter has not been updated for the past 5 years and does not support ecto 3.

---

<div class="post-metadata">

**Author:** ![ityonemo](https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/ityonemo/32/11341_2.png) [@ityonemo](https://forum.elixirforum.com/u/ityonemo)\
**Post date:** [December 6, 2020, 9:00pm UTC](https://forum.elixirforum.com/t/how-do-i-setup-phoenix-with-sqlite/35993/4 "2020-12-06T21:00:01Z")

</div>

Yeah there have been several attempts to bring sqlite\_ecto to ecto3 (including an abortive attempt by myself)… I wonder if there’s a way to contribute to a community fund to get that done. I’d pitch in. Any suggestions?
