search

dwyl / phoenix-liveview-todo-list-tutorial

✅ Beginners tutorial building a Realtime Todo List in Phoenix 1.6.10 + LiveView 0.17.10 ⚡️ Feedback very welcome!
https://liveview-todo.herokuapp.com/
69 stars 11 forks source link

change database from postgresql to sqlite #120

Closed UweKrause closed 1 year ago

UweKrause commented 1 year ago

Because sqlite does not need a running server it is better for the purpose of this tutorial.

I tested only with versions:

$ elixir --version 
Erlang/OTP 26 [erts-14.0.1] [source] [64-bit] [smp:4:4] [ds:4:4:10] [async-threads:1] [jit:ns]

Elixir 1.15.0 (compiled with Erlang/OTP 26)
$ mix --version
Erlang/OTP 26 [erts-14.0.1] [source] [64-bit] [smp:4:4] [ds:4:4:10] [async-threads:1] [jit:ns]

Mix 1.15.0 (compiled with Erlang/OTP 26)
nelsonic commented 1 year ago

mix format fails: https://github.com/dwyl/phoenix-liveview-todo-list-tutorial/actions/runs/5521106732/jobs/10071298156#step:7:136

image

please run:

mix format

on your localhost to see what the issue is.

Also, while using SQLite instead of Postgres is certainly is a nice-to-have, this change will also need to be made if deployed to Fly.io. e.g: https://fly.io/docs/elixir/advanced-guides/sqlite3/

nelsonic commented 1 year ago

@SimonLab considering that you've done most of the work on this repo, how do you feel about switching to SQLite as trial? 💭