Co-creator of pgrust: https://nitter.cf/t.co/AIOEC49svY - MIT 2020
San Francisco
Joined March 2013
- Tweets101
- Following247
- Followers388
- Likes103
Jason Seibel retweeted
At @primateriacom, we are building chemical simulators that reflects reality, so we can run experiments for new discoveries entirely on a computer.
Are coding agents good enough to help us get there? To find out, we used experimental results to test their work on reengineering existing simulators.
Introducing Wavefunction bench: primateria.com/blog/wavefunc…
Jason Seibel retweeted
We're launching The Upskilling Company: your AI-native L&D team for hire.
Everyone wants to do more with fewer people. But do you know what your team can actually do?
Backed by 10+ years of research and 10,000+ learners.
Assess skills. Train adaptively. Maintain courses with a click.
schole.ai – at San Francisco, CA
Jason Seibel retweeted
New post: how @JasonSeibel and I built Gravity, the query engine in last week's @pgrustdb 0.4 beta that's as much as 3x faster than ClickHouse on ClickBench.
Blog post: pgrust.com/blog/programming-…
Jason Seibel retweeted
Introducing Phonic-1, the most advanced speech-to-speech model for agentic tasks — from @phonic_co, the speech-to-speech model company.
We’ve had a breakout year and raised a $27.5M Series A led by @firstround with participation from @Lux_Capital, @felicis, and Definition.
Jason Seibel retweeted
On average, how do coding agents impact relative returns to long hours?
Please adjust for generic increases in productivity; if you think coding agents increase productivity by N for 40/hr weeks, this should be factored out because we want the ratio of relative productivity.
20%Decrease
18%No change
62%Increase
460 votes • Final results Jason Seibel retweeted
We should be more ambitious with the software we build:
danluu.com/ambitious/
![Since early this year, Michael Malis (of pgrust) has been showing me interesting things he's done and saying [W]e should be more ambitious1 with the software we build There is, understandably, a lot of skepticism about projects like pgrust because there are so many low-quality AI-generated projects out there. If I didn't know Malis and didn't look into it, I would just assume that pgrust was another vibe slopped project that's never going to work. But I know Malis well enough to trust his work without looking into it, and if you look into it a bit, you'll see that in testing pgrust, he's testing thoroughly enough that he's even uncovering real bugs in Postgres, such as this numerical bug that can cause valid SP-GiST operations to fail, this format cache bug that can cause incorrect results from JSONPath, this pgcrypto bug that can cause later operations to fail, multiple memory safety bugs in the dictionary loader, this money overflow bug, etc. This isn't to say that pgrust i...](https://pbs.twimg.com/media/HVbOGdKboAAAbtO.png?name=orig)
ALT Since early this year, Michael Malis (of pgrust) has been showing me interesting things he's done and saying [W]e should be more ambitious1 with the software we build There is, understandably, a lot of skepticism about projects like pgrust because there are so many low-quality AI-generated projects out there. If I didn't know Malis and didn't look into it, I would just assume that pgrust was another vibe slopped project that's never going to work. But I know Malis well enough to trust his work without looking into it, and if you look into it a bit, you'll see that in testing pgrust, he's testing thoroughly enough that he's even uncovering real bugs in Postgres, such as this numerical bug that can cause valid SP-GiST operations to fail, this format cache bug that can cause incorrect results from JSONPath, this pgcrypto bug that can cause later operations to fail, multiple memory safety bugs in the dictionary loader, this money overflow bug, etc. This isn't to say that pgrust i...
Jason Seibel retweeted
Introducing the free Government & Legal Index for ChatGPT & Claude.
Give your AI agents 30M+ US government pages, from federal statutes and court opinions to city codes and permits.
Research tax rules, permits & case law with the Firecrawl plugin.
firecrawl.dev/alexandria/gov…
great use of pgrust!
🚨Introducing a new database: PGX 🐘
Postgres for AI agents. In Rust. pgx.dev
One runtime. Thousands of Postgres databases.
⚡ Up to 100× less idle memory
⚡ 1,000 databases in just 659 MB RAM
⚡ Clone a 674 MB database in 85 ms
⚡ ~0.7 MB per idle database
RUST. OPEN SOURCE. FREE.
No containers per database.
No heavyweight instances.
No production baggage.
Real Postgres. Built to be disposable.
nitter.cf/alxshp/status/21100494…
Jason Seibel retweeted
I'm super excited to announce the release of Proa ⛵, a new Rust web framework!
It's the fastest component-based SSR engine we've benchmarked, with a new approach to interfaces via multi-target rendering
Jason Seibel retweeted
Two weeks ago, @PlanetScale launched TIN. They benchmarked it against us, and it was very fast. So we spent those two weeks making ParadeDB faster without their tradeoffs.
Today, we are faster than TIN.
paradedb.com/blog/opening-a-…
Jason Seibel retweeted
Today, we're killing the billable hour for patent work.
Fearn Legal (@fearnlegal ) is a modern patent firm built from the ground up on our own operating system, FearnOS.
What that means:
→ Flat fees, not hourly billing
→ Drafts in days, not months
→ Experienced patent attorneys reviewing every application
→ One platform for your entire portfolio, with permissions you control
If you're building something worth protecting, we'd love to help.
RT @af_gao: The days of waiting weeks for a patent are over.
Today we’re launching Fearn, a modern patent firm with flat fees, turnaround…
This quoted post is unavailable.
elephant smash
Introducing pgrust v0.3: the bug-smashing release.
We evaluated pgrust v0.2 and v0.3 against the same held-out corpus: 164,000 test cases from 50 open-source projects.
pgrust v0.2 diverged from Postgres on 1,454 cases. pgrust v0.3 diverged on 11.
pgrust is 300x faster than Postgres for analytical workloads, and we're a drop-in replacement.
Held-out corpus included: @djangoproject, SQLAlchemy, Hibernate, @rails, and more.
@pgrustdb is now much more Postgres-compatible and reliable than before. @JasonSeibel and I don't recommend running pgrust in production (yet), but we are successfully running it ourselves internally.
- @AntithesisHQ and @workersdotio for simulation testing
- Detail.dev by @danlovesproofs for LLM-assisted code analysis
- Multiple home-built differential fuzzers
- Kani for formal verification
Our goal is for pgrust to be truly 100% compatible with Postgres.
There are still bugs. You should still run Postgres for any data you can't afford to lose.
But we want people trying pgrust on real workloads in non-critical environments. If you need Clickhouse performance queries in Postgres, are frustrated by the many gotchas in Postgres, or just geek out about databases and Rust, feel free to send me a DM as we would love to chat.
Jason Seibel retweeted
At @pgrustdb, @JasonSeibel and I built a hash table that's 5x faster than Postgres's.
By partitioning the data into smaller hash tables that fit within the L2 CPU cache, we're able to achieve wildly better performance
Jason Seibel retweeted
We're able to make certain Postgres queries 20x faster through whole query jit compilation.
The Postgres query engine interprets the query plan, which adds a lot of overhead.
In pgrust, we compile your query directly to assembly, delivering big performance gains.
Jason Seibel retweeted
Our top priority for pgrust right now is testing. We've been testing it so much, we've found over 20 bugs in Postgres.
My favorite is that due floating point rounding, it's possible for a point to be neither to the left, nor right, nor even with the center point of a quadtree
