Viewing profile — oliverrice

An idiomatic rust port of python's textual/rich library for beautiful terminal output

One peice of tooling I've wanted for Vitess is for it to make recommendations about sharding keys based on the statistics it collects + query patterns. Seems like it's in the perfe…

how are you thinking the differences between mysql and postgres will impact multigres vs vitess? The ones the jump to mind are - Postgres has transactional DDL vs auto-commit. Can …

OrioleDB maintains a very small set of Postgres patches that are targeted for upstream. The storage engine that mitigates the need for vacuuming [1] is implemented in a standard Po…

I don't want to hijack Datadogs+Quickwit's post comment section with unrelated promotional-looking info. Quick summary below but if you have any other questions pls tag olirice in …

(disclaimer: supabase employee) OrioleDB continues to be a fully open source and liberally licensed. We're working with the OrioleDB team to provide an initial distribution channel…

yeah, fair shout `columnar index` for hybrid analytical workloads and `multi-master` roadmap items haven't been put in an order on the schedule yet so maybe multi-master makes sens…

what's your use-case for multi-master that would not be supported by something like regional routed for read-replicas with high availability? i.e. do you have a specific need for l…

At Supabase we also recently switched to Nix for packaging our Postgres+extensions bundle https://github.com/supabase/postgres/blob/develop/flake.nix

In Studio you'd need to click on a query to get the recommendations but the most important queries to optimize are on several metrics like "Most time consuming", "Most frequent", "…

> I'm concerned about getting locked in Supabase is one of the most portable platforms out there. The whole stack is self-hostable and open source. All of the data are contained in…

What additional tooling do you think would be needed to turn this concept into a maintainable stack with good UX for mid-to-large sized applications?

hey, author here (although not of this feature) Exposing postgres functions through the GraphQL API has been one of our most frequent requests. I'm really looking forward to seeing…

hi, author here & happy to answer any questions Really looking forward to the next steps with vecs and would love to hear any thoughts about the `future ideas`. Mainly, what kind o…

PostGIS is a native extension mostly written in C. Since there is no C trusted language it would be hard to fit PostGIS into the TLE paradigm Its less of a problem for well known a…

yeah, exactly. pgxn also houses native extensions, some of which may be TLE compatible. database.dev is trusted language extension specific We've reached out to David, who runs pgx…

RDS does have the underlying native extension that is required to install user defined packages (pg_tle) from database.dev. It doesn't currently have support for the extension that…