kiwicopple
Joined 9 years ago
Joined 9 years ago
> I’d bet you’re likely to see this from a Postgres-specific provider first, like Supabase.
we deprecated this feature in our ETL tool[0]. The functionality is still in there but we can't support some of the production features we'd need for data/schema guarantees
Iceberg is still nascent - only supporting single-table transactions (at least when we tried). A lot of important CDC/transactional semantics were "a work in progress" upstream. We shifted our focus to ducklake, which stores the catalog in Postgres
confirming that we're still working hard on this. aiming to be production-ready this year. benchmarks and compatibility testing are on track
The main highlight here is that we have released Multigres v0.1:
https://supabase.com/blog/multigres-v0-1-alpha
This is open source and self-hostable. It’s not production ready yet. That will take a few more months
You can find instructions for running the operator in EKS here
https://github.com/multigres/multigres/blob/43db3a4873922eee...
(supabase ceo) I'm curious what gives you this impression? it's true that a lot of platforms build on top of Supabase, but our focus is still just building the best Postgres platform we can (OrioleDB, Multigres, etc)
admittedly we've also had to shift a lot of our tooling to things like Claude/Codex, but that's more reflective of how people are building now
a useful example from last week where TLA+ found a bug in pg_rewind:
https://github.com/orioledb/orioledb/releases/tag/beta15
We expect it to be production ready this year
> RLS policies are executed per row
not necessarily. the planner integrates the policy expression into the query plan. stable/immutable expressions and indexable predicates aren't naively re-evaluated per row
> If SET LOCAL is omitted, current_setting() returns an empty string or throws an error depending on how your policy is written
if you're using tools like PostgREST, they set the GUC automatically per request
> RLS policies themselves are stored in pg_policies inside your database, not in your source code
Policies are plain DDL and are tracked by every serious migration tool. Off the top of my head, these tools track Policies: Sqitch, Flyway, Alembic, Atlas, Prisma migrate, dbmate
> Most migration tools do not include SQL functions
same as above
(we maintain OrioleDB) Mostly because the TAM API isn't mature enough yet. Hopefully we can upstream more patches so that it's possible
> undo-based MVCC storage engine project stall?
From what I could gather, it ran out of steam simply because of the difficulty of the task. There is a lot of work involved to get the requisite patches into core and the community are (correctly) cautious
copple [at] supabase [dot] io