Q: Syncing PostgresSQL DB and WP site
Hello,
We run number of WP multi-directories and we have been trying to sync CURD operations between an internal Postgres DB that my team uses and these sites through REST API.
So far it hasn't been easy to access all CPT fields especially those saved inside meta {}.
Would this tool allow me to do that out of the box?
What plan tier and extensions do I need?
This is very important project for us and my we are actively working on it.
Thank you
Leonardo_GatoGraphQL
Feb 27, 2025A: Yes, it should be possible. Notice that meta mutations are not in the plugin yet, but I'll add it within a couple of weeks (it's on the roadmap for Q1).
Tier 1 should be enough for that use case, but I'd recommend tier 3, so you can also store the queries on the DB if you need to (check "Persisted Queries"), and also execute the queries via code, directly within the PHP application (Check "Internal GraphQL Server").
DrmoyassinePLUSThanks for the quick reply. My usecase only involves one-way sync updates from DB (i.e., Supabase) to WP typically through APIs. It is not clear to me what persistent queries means or whether I do really need them.
Well, tier 1 should be enough then
DrmoyassinePLUSExcellent! Please let me know when this feature is released. I'll grab tier 2 for increased limits