News for hackers. Stuff that matters.

A comment on Supabase Wrappers: A Framework for Building Postgres Foreign Data Wrappers.

Re:Supabase Wrappers: A Framework for Building Postgres Fore... by spankalee on Thursday December 15, 2022 @05:54PM (#34006965)
How well do foreign data wrappers work with Postgres's query planner? Does't the planner need to estimate the cardinality of results from each table? Are the Supabase wrappers providing this info from the wrappers even though it might be hard to get from the data source?

Also, is the Firebase connector for Realtime Database or Firestore?

[ Parent | on HN ]
Re:Supabase Wrappers: A Framework for Building Postgres Fore... by burmecia on Thursday December 15, 2022 @06:27PM (#34007301)
| How well do foreign data wrappers work with Postgres's query planner?

You can provide table size estimation to Postgres's query planner in wrappers using `get_rel_size()` function, here is doc:

https://docs.rs/supabase-wrappers/latest/supabase_wrappers/i...

| Also, is the Firebase connector for Realtime Database or Firestore?

It is for Firestore, Realtime Database is not supported yet.

[ Parent | on HN ]