Donkie / Spoolman

Keep track of your inventory of 3D-printer filament spools.
MIT License
1.02k stars 93 forks source link

Add postgres schema option #236

Open TPausL opened 11 months ago

TPausL commented 11 months ago

Is your feature request related to a problem? Please describe. It currently is not possible to select the schema in which the tables are created when using postgres database. I am using supabase as the database and as the tables are added to the default schema spoolmans tables are mixed with my own.

Describe the solution you'd like It would be great to have an env variable SPOOLMAN_DB_SCHEMA, so that you can select which schema to use.

Describe alternatives you've considered You could use another database within postgres for spoolman, but this isn't possible with supabase.

rufinus commented 11 months ago

as far as i understand supabase - you just need to have a own project. it doesnt make any sense to have a database with multiple schema's ... each application each own database.

adepssimius commented 3 months ago

It would also be nice to be able to standardize the schema name to match my existing schema name standard in Postgres.