🚀 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?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• 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.

[goulvenb]

For those wanting news, I believe this PR is linked to this feature.

[ammarfaris]

For those wanting news, I believe this PR is linked to this feature.

wow niceeeee

[felixrydberg]

I wonder if you will be able to use Neon 🤔

[neolizee]

+1

[xingchen-zh]

+1

[ryonsoft]

Any news on postgres support guys?

[onlyamessenger]

I think we should give up on this gents. I commented the question on one of their YouTube videos recently and they just deleted it.

[mrbyrk]

@onlyamessenger They are planning it for 1.8 release.

[onlyamessenger]

@mrbyrk Thanks for the update. Where did you see the items for the 1.8 release?

[xunjianxiang]

+1

[abnegate]

Interested to know, what are people's expectations for Postgres support? As Appwrite provides an abstraction layer, the common interactions with the database would remain the same - it would just be Postgres under the hood.

Are you looking for:

• Postgres specific features
• Raw SQL access
• Direct database connection

[rhengles]

@abnegate In my opinion it's more about robustness, reliability and performance instead of using some exclusive feature.

Also could be good for scalability, but that may require more code and configuration than simply connecting to Postgres.

[DH-555]

@rhengles Scalability isn't an advantage for Postgres support at all.
MariaDB is already very performant and scalable. A proof is Appwrite cloud, that is handling thousands of projects and billions of monthly database operations.

[onlyamessenger]

@abnegate Postgres is just so feature-rich. If there is ever a need for lower-level access, Postgres offers more options.

[appurist]

@abnegate I'm looking for more direct input of large amounts of data (many records). I have about 8 hours of importing to do, every month, if one at a time. It's more like 15 minutes if I could directly import data.

+1 for Postgres support, or AppWrite support for multiple-record import in a single function execution.