PostgreSQL Internal or External

[hektyc]

Does m3u-editor use an external PostgreSQL or internal container built into m3u-editor?

[sparkison]

There is an internal instance that is booted up when you add the ENABLE_POSTGRES=true environment variable. However, if you'd like to use your own instance, you can do that as well!

Just fill out the DB variables and don't add ENABLE_POSTGRES=true or change it to ENABLE_POSTGRES=false to prevent the internal instance from running.

If you just set these variables:

- DB_CONNECTION=pgsql
- DB_HOST=localhost
- DB_PORT=${PG_PORT:-5432}
- DB_DATABASE=${PG_DATABASE}
- DB_USERNAME=${PG_USER}
- DB_PASSWORD=${PG_PASSWORD}

you can connect to whichever PG instance you have running 😉

[hektyc]

Great thank you. I have set it up to using ENABLE_POSTGRES=true but noticed the logs referenced connection to SQLite which led to my question. Is that normal if I enable PostgreSQL?

[sparkison]

No problem! It is normal for the SQLite connection, we are still using that for job batches (you'll still see a `database/jobs.sqlite` SQLite file in the config). It will probably be pulled into PostgreSQL as well, but this works well for now 😉

…

On Thu, May 15, 2025 at 7:06 AM hektyc ***@***.***> wrote: Great thank you. I have set it up to using ENABLE_POSTGRES=true but noticed the logs referenced connection to SQLite which led to my question. Is that normal if I enable PostgreSQL? — Reply to this email directly, view it on GitHub <#167 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABBSH2AY7BG56WR7EDOTQRD26SGOPAVCNFSM6AAAAAB5EQVWIGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTGMJVHA3DCMY> . You are receiving this because you commented.