Questions & Help>Questions

How to configure phoenix for sqlite

/phoenix
staymetal

staymetal

Can one guide me step by step in configuring phoenix with sqlite ?

P.S. im on elixir 1.6 and latest phoenix

Thanks a ton !!

15 comments
/phoenix
12624 15

First Post!

AstonJ

AstonJ

You might find this thread of interest:

And this post:

And I have to ask, why not just use Postgres?

1
Post #1

Most Liked

gon782

gon782

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.

5
Post #4
LostKobrakai

LostKobrakai

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

5
Post #13
sergio

sergio

Some of the replies in that thread are a trainwreck. :frowning:

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.

4
Post #2

Last Post!

kokolegorille

kokolegorille

An easy way to check the config would be to create a side project with --database sqlite3.

You would see DATABASE_URL is not used, but DATABASE_PATH

You would find this code…

  database_path =
    System.get_env("DATABASE_PATH") ||
      raise """
      environment variable DATABASE_PATH is missing.
      For example: /etc/kokolite/kokolite.db
      """

Which means You need to adapt your config/runtime.exs to sqlite3

No, it is really not the way to start a release… You need to set all the required env variables and use the release script.

Once You know how to start the release, You’ll need to write a service script for systemd, if You are on Linux.

It’s hard to deploy a release, but only the first time…

Then, You’ll learn that deploying nodes in a cluster is even much harder :slight_smile:

2
Post #15

Where Next? Top

View thread on forum (has 15 replies!)
phoenix
Home Questions & Help>Questions
32 11954 15
Last post
REPLY VIEW THREAD WITH 15 POSTS

Trending in Questions Top

katta
Questions & Help>Questions

Phoenix Ecto realistic benchmarks
I having some trouble figuring out if I have set myself too strict of standards for my production server. Currently I can handle 75% of r...
/phoenix#ecto#troubleshooting
2 1863 12
New
achenet
Questions & Help>Questions

No Tailwind binary for FreeBSD
Hello, I’m trying to build a basic Phoenix web-app, and I’d like to use Tailwind. However, when I launch mix phx.server, I get an error...
/phoenix#freebsd#tailwindcss#tailwind
11 1073 14
New
kpanic
Questions & Help>Questions

"Mentoring" match maker? maybe MVP
Hi everyone, I am toying with the idea of building a “match maker” for giving personal help to people that wants to start coding. I sta...
#helpers#programming
8 940 4
New
Cxx-mlr
Questions & Help>Questions

Using try/catch with update_in/3
I’m working on a small exercise involving update_in/3, and I came up with this solution: data = %{ name: "Periodic Table", category:...
#learning-elixir
9 273 12
New
ChrisAmelia
Questions & Help>Questions

Need help understanding order of function calls from Phoenix auth
I’ve got trouble wrapping my head around the order in which functions are called in this snippet (from Phoenix’s authentication): toke...
/phoenix#learning-elixir
0 76 2
New
dillonoconnor
Questions & Help>Questions

Hologram compiler and iex -S mix
Is there any way to avoid the Hologram compiler running when using iex? It seems like the front-end code could potentially be disregarded...
/hologram#iex
2 386 3
New
thiagogsr
Questions & Help>Questions

Oban Worker max_attempts doesn't compile with a constant
** (ArgumentError) expected :max_attempts to be a positive integer, got: {:@, [line: 10, column: 19], [{:max_attempts, [line: 10, column:...
/oban
0 66 1
New

Other Trending Topics Top

GenericJam
News>Announcing

Mob - Native BEAM / Elixir on Native Mobile
Edit: 2026 May 15 - This post is archived. Mob is alive!! Main docs: mob v0.7.11 — Documentation A bit of explanation for the slightly c...
/mob#library#beam#mobile#liveview#react-native#mobile-app#mobile-development
259 8396 111
New
mudasobwa
Chat & Discussions>Discussions

Cure - a new language compiled to BEAM
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
#static-types#type-checking#types#fsm
171 6315 70
New
garrison
News>Announcing

Hobbes - a low-level distributed database for the Elixir programming language
Hobbes is a low-level distributed database for the Elixir programming language. Hobbes provides a simple, safe, and scalable storage lay...
#library#database#distributed#hobbes
306 6242 88
New
budgie
Chat & Discussions>Discussions

I genuinely hate programming now
A little off-topic, but I feel like people here have a good head on their shoulders. I used to be quite good at making software. Was luc...
#ai#career#rant
460 3763 113
New
KristerV
Chat & Discussions>AI / LLMs

State of developing agents with Elixir (not coding agents)
Hey. Is there anyone here who creates agents in their apps? Not talking about using agents, but creating them. I’m finding it pretty diff...
#agent#ai#llm#dev-tools#ai-tools
31 3653 21
New
mcass19
News>Announcing

ExRatatui - Elixir bindings for the Rust ratatui terminal UI library
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
#library#rust#terminal#tui
60 3370 16
New
Back to top

Latest Phoenix Threads

Phoenix Forum ❯

Questions & Help>Questions

Questions Questions ❯

Latest on Elixir Forum

Elixir Forum ❯

Sponsor Spotlight

Potions

Deploy Phoenix to your own VPS with PaaS ease: push-to-deploy, zero downtime, auto SSL, managed Postgres. 14-day free trial at potions.io

Our Sponsors

Dashbit

Build Elixir applications with speed and confidence.

EEF

Supporting innovation across the BEAM ecosystem.

Coders51

We build reliable cloud platforms for business-critical systems.

AppSignal

Catch errors, track performance, monitor hosts and more.

Honeybadger

Error tracking, logs, uptime, and Just Enough APM. Built for developers.

Pragmatic Bookshelf

Practical resources that improve the lives of professional developers.

Defacto

Bringing learning, work and compliance together since 1987.

WyeWorks

**Building the future of software with AI, trust, and human connection.**

Software Mansion

The team behind Membrane, Popcorn, LiveDebugger. Available for hire.

Pragmatic Studio

Courses that'll move you from confusion to "Aha, now I get it!"

View all our sponsors ❯

Categories:

Sub Categories:

Forums

Popular Tags

Our Sponsors

Dashbit

Build Elixir applications with speed and confidence.

EEF

Supporting innovation across the BEAM ecosystem.

Coders51

We build reliable cloud platforms for business-critical systems.

AppSignal

Catch errors, track performance, monitor hosts and more.

Honeybadger

Error tracking, logs, uptime, and Just Enough APM. Built for developers.

Pragmatic Bookshelf

Practical resources that improve the lives of professional developers.

Defacto

Bringing learning, work and compliance together since 1987.

WyeWorks

**Building the future of software with AI, trust, and human connection.**

Software Mansion

The team behind Membrane, Popcorn, LiveDebugger. Available for hire.

Pragmatic Studio

Courses that'll move you from confusion to "Aha, now I get it!"

View all our sponsors ❯

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews