PgSQL extensions

[mrdanielm]

Add support for PgSQL extensions in the default Postgres, whilst you can use a docker hub image you lose the nice UI that comes with the built in database. Would be good if all the common plugins (Postgis for example) are preinstalled, similar to what Render/Heroku etc does.

[ksaitor]

having a pre-installed pgvector and postgis would be amazing!

[HitoshiroKyoka]

I can put the extensions I want to use in a Docker Image and publish it myself, but it is a hassle. It would be more convenient if it were pre-installed.

[hwhea]

+1 to this :)

[kcc989]

+1 here

[spaceworkplatform]

Please add postgis and pgvector, its basically blocking us right now, because the only way to use them with alpine image is build them and then we lose the built-in usage of coolify controls over db.

[andrasbacsai]

I made a small improvement in the next version.
You can choose predefined images when creating a new Postgresql database.

During live-stream, we (chat and me) decided to include these 4. What do you think?

[mrdanielm]

That looks great, exactly what I was thinking. Supabase alone would cover most of the extensions required thank you!

[wgicio]

Great feature!

[ksaitor]

will there be no PostGIS + PGVector at the same time?
ideally, ofc, would be great for people to be able to install any extension

[Nedi11]

+1 to install any extension

[peaklabs-dev]

Some nice details: https://x.com/ksaitor/status/1844685693471351076

[ksaitor]

any updates here? or is it recommended to use Supabase Postgres with extensions? Any pros/cons of that?

[wottpal]

any updates here? is it maybe possible to install extensions in the "initialization scripts" section?

[ksaitor]

Solved this issue by using Supabase Postgres image. Comes with all plugins one might need. Works.

[lucasfcunha]

+1, there should be an option to add the extensions you want as a pre-install script of the image or something similar.