3 ms·
Supabase is an interesting middle ground here — it runs on managed Postgres but gives you access to a curated set of extensions (pg_cron, pgvector, unaccent, Po
by jpshastri 5mo ago
Supabase is an interesting middle ground here — it runs on managed Postgres but gives you access to a curated set of extensions (pg_cron, pgvector, unaccent, PostGIS etc.) without needing to build your own. We used unaccent + GIN indexes for fuzzy city search and it worked well. Still not the same as arbitrary custom extensions, but covers a lot of practical use cases that RDS won't touch.
- setr 5mo agoRDS also has a curated set of extensions? https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLRelea... Which includes literally all 4 extensions you’ve mentioned. Every managed service does this, specifically because they need to blacklist extensions that touch on the managed parts of it — eg filesystem
- tracker1 5mo agoIf I need to do fuzzy location searches, I've thought about just matching geohash locations... even if doing multiple sets and collating them... Note: this was in consideration for something like Scylla or Dynamo.