one of the most tedious parts of Postgres is connection management
if you use a connection pooler (almost always the case), you usually need to choose between Transaction Mode, Statement Mode, or Session Mode
with @multigres you don't need to choose. coming soon to supabase
the @supabase repo just hit 100K stars on github
github stars are a vanity metric, but i love open source so it's something that matters to me
thank you to all the contributors, maintainers, and partners. we didn't do it alone - we're standing on the shoulders of elephants
We're running the State of Startups survey again.
Last year 2,110 people told us what they're building, how they're building it, and what's breaking.
This year we want to know how AI changed the answer to all three.
Get a free t-shirt for completing it: https://t.co/fua01RFEDJ
the @multigres operator is now open source
progress so far:
◆ Direct pod management
◆ Zero-downtime rolling upgrades
◆ pgBackRest PITR backups
◆ Observability with OTel tracing
link to repo in thread
We are releasing benchmarks for the @multigres Postgres Parser.
It is 2.5x faster than the cgo alternative.
Manan was able to build it in 8 weeks. A similar effort for the MySQL parser took over a year. No surprises, @claudeai was the difference
we just shipped an official @claudeai connector for @supabase
since this is topical, you can ask it "fix any security issues" and it will solve everything for you:
we are looking for someone to lead CLI development at @supabase
this is becoming one of the most critical interfaces for devs/agents
tag the best Go dev that you know and if we hire them I'll give you $1,000 of Supabase credits
They don't need CLI experience, they just need to have a good product sense. My pitch for Supabase:
◆ we're open source
◆ we don't do geo-adjusted pay
◆ we have an async work culture
◆ most engineers have 1 meeting per week
◆ we're full distributed across 50 countries
◆ we power the world's fasted growing companies
Application link ↓
https://t.co/flLV1GWtzZ
Using @supabase in TRAE goes beyond a simple integration. Here’s a practical guide on how we use it in real full-stack workflows:
• One-click backend provisioning
• Supabase Platform Kit integration
• Supabase MCP support
Read the blog to learn more: https://t.co/0k4dRy0LSq
@multigres will land on supabase early next year
features:
◆ Sharding
◆ Local NVMe disks
◆ Cross-zone failover
◆ Automated Backups
◆ Built-in Observability
◆ Change Data Capture
◆ Built-in Connection Pooler
◆ Built-in Database Protection
◆ Migrations across PG versions
we have added async streaming support for Postgres FDWs
You can use a FDW to query other databases directly from postgres.
For this release, we’ve started with the clickhouse fdw (used by some of our largest customers) and we’ll be rolling it out to other Wrappers incrementally
I’m almost certain this is the first implementation of streaming support for postgres FDW’s, which we manage to implement using the rust-based framework we’ve developed around Postgres’ native FDW feature
Most other FDWs use a “batched” approach which blocks Postgres during I/O, and the executor can’t proceed until each batch is fully received and processed.
With asynchronous streaming, Postgres can start returning results as soon as the first rows are available, reducing memory pressure and improving query responsiveness - even for massive analytical workloads.
Supabase just made Postgres FDW way smoother! 🚀
Async streaming = pull data from other DBs faster and more efficiently.
Big win for real-time apps & keeping things snappy.
Check it out 👉 https://t.co/R9A5G1hEhN
#Postgres#Supabase#dev
I'm super excited to announce that @supabase ETL is finally in private alpha!
Seeing this project go from prototype to production makes me very proud of the team ⚡💚
at @supabase we're building:
◆ a new storage engine for Postgres
◆ an open source sharding engine for Postgres
◆ an open source ETL engine for Postgres
◆ an FDW extension to query anything from Postgres
we hire talented people who just want to build. come us ↓
📆Save the date:
December 2nd, 19:00 @ImpactHubAthens
I'm hosting the first @supabase meetup in Athens, with the support of the local communities and my friends!
We'll be exploring Supabase, OSS tools, and... 🥁 AI!
I'll be announcing the first 2 speakers tomorrow!