Supabase Wrappers: A Framework for Building Postgres Foreign Data Wrappers

Re:Supabase Wrappers: A Framework for Building Postgres Fore... by burmecia on Thursday December 15, 2022 @06:59PM (#34007609)

You can create a custom function doing all the delta logic and use pg_cron to schedule it to periodically materialize data using FDW.

[ Parent | on HN ]

Re:Supabase Wrappers: A Framework for Building Postgres Fore... by chrisjc on Friday December 16, 2022 @09:59AM (#34015225)

Yeah, this was the approach I was imagining before someone mentioned Materialized View (proper).

Once I heard those words mentioned, I began to imagine what sort of interaction with a foreign data source's operations log FDW might have.

Of course, and depending on the foreign data source, you could probably even expose an operations log to Postgres via a FDW by defining it as a foreign table... Effectively opening up the possibility of eventually consistent replication. Lots of data stores' operations logs are accessible data collections/tables anyways.

All of this is exciting stuff!

[ Parent | on HN ]