While I agree that Postgres works fine and is a good enough solution for most people to start with, SQLite is much simpler than all of the “real” databases. It works on a library level, requires no setup (meaning it doesn’t require any privileges on the box you’re working on) whatsoever and has bindings in every language out there. You get trivial database copying out of the box and all in all it’s a much better fit for small projects.

Phoenix can generate that with mix phx.new --database sqlite3. No need to manually do that.

Some of the replies in that thread are a trainwreck.

This guy comes in with a clear question and some people just go “use postgresql”. Thankfully Chris came in and replied with some actual information.

@staymetal check out this link: Twenty Eight Twelve - Creating a Phoenix Framework Application with SQLite

Seems like a simple adapter switch.