🚀 Feature: Postgres Support

[shakks]

🔖 Feature description

Hi, i tried to look around to find any details regarding the plans to support Postgres, is there any plan to support it. If its already supported is there any documents. Thanks

🎤 Pitch

Our backend uses a Postgres DB.

👀 Have you spent some time to check if this issue has been raised before?

• [X] I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• [X] I have read the Code of Conduct

[lohanidamodar]

Hi @shakks, Postgres is not yet supported, however we do plan to support Postgres. You will be able to see the progress in our database library when the work starts.

[caevv]

The only thing holding me back from moving to appwrite. Hopefully, this is still in progress.

[amirping]

any news? that's the only missing + for appwrite

[eqoram]

I personally think that more people would go with Appwrite when the underlying database would be Postgres (same goes for the cloud)! Would be great to have this option in the future (:

[jmealo]

I don't understand why new projects are using MariaDB. The real-time worker could have really benefited from Logical Decoding. You could keep the cache populated without hitting the DB. It also makes it easier to scale out real time/read-only nodes. It made me kind of pick the rest of the project apart because I question the engineering decisions now. I see a lot of good, a lot of bad, but if ya'll had went with Postgres you'd probably have another contributor :)

[luke-stdev001]

@eldadfux sorry to bump this old issue, but has there been any movement to support postgres? We'd love to run AppWrite on top of our horizontally scaling postgres infrastructure as our expertise and tooling is all focused around Postgres. It looks like the Utopia database project supports Postgres, does this mean that AppWrite supports it now?

Happy to discuss in private if you can advise the best way to reach out to you to discuss.

[cahofmeyr]

I also saw that Utopia Database lists Postgres and therefore have the same question as @luke-stdev001

[marcbejar]

In the Utopia docs they say that they have already fully integrated a Postgres adapter into utopia library. As I understand, now it's time to wait until this library function is integrated into AppWrite... I hope they don't take too long, this is the main reason I'm still developing with Supabase. @cahofmeyr

[lostb1t]

+1 for this

[dishankjindal1]

Any update?

[nhdms]

Bump this update?

[rdr6000]

I am also waiting for an update on this.

[SaidBahaDev]

+1

[rickylabs]

Is there any news on this topic from @lohanidamodar?

I sincerely hope they will announce PostgreSQL support during the _init event next week!

These are long-awaited features that could shake up the competition (Supabase, Hasura, Nhost, etc.).

[KingPin]

Yeah, Postgres support is a blocker for my project also. Would love to hear some updates on this please.

[Splinteer]

I think it's now supported: https://github.com/utopia-php/database?tab=readme-ov-file#supported-databases

[KingPin]

I think it's now supported: https://github.com/utopia-php/database?tab=readme-ov-file#supported-databases

yeah, I saw on the utopia library page, wasn't sure if something is needed on appwrite side to support it, and devs haven't responded to anyone in a while.

[sawa-ko]

I need this too!

[platform-kit]

@lohanidamodar can you shed any light on this?

[jamroks]

I'm also in need of PostgreSql Support. But i just saw in your public roadmap , there is nothing plan for Potsgres :-(

[onlyamessenger]

@jamroks Looks like they work according to amount of upvotes. The MongoDB feature included in version 1.7 has 53 upvotes. While this Postgres feature only has 39. If we can get more people to upvote this I think we'll be in a good spot to have this included in version 1.8.

[evanheckert]

Disconcerting that project devs haven't commented on this to give any sense of the roadmap.

[rickylabs]

@eldadfux, could you enlighten us about this topic?

[CordialGit]

My Application is a SvelteKit Application, while I want to use a Postgres database for backend.

Now, Appwrite uses MariaDB.

I am of the opinion that Appwrite should have Postgres support, and give us the ability to select our Database at set up.

The reason for this is because-- suppose my Application grows in future, and I feel that I want to migrate my data from Appwrite, I want to be able to directly migrate all my database to my new Server's Postgres database, without downtime and without data loss.

+1

[rdlogout]

+1

[QThans]

+1

[renegadevi]

+1

[FaisalMohammadi]

+1

[AmiinYuusuf]

+1

[asynckebap]

+1

[polvallverdu]

+1

[stefanadelbert]

+1

[onrdmr]

+1

[Fractal-Tess]

+1