jonahharris
Show HN: uplpgsql – PL/pgSQL compiled to native code
https://github.com/nextgres/uplpgsql
uplpgsql compiles PL/pgSQL to native code. It took over twenty years to get here, but here it is.On July 19, 2005, I demoed my optimizing PL/SQL compiler to Andy Astor, Denis Lussier, and Jim Mlodgenski at EnterpriseDB; PL/SQL packages, procedures, and functions ran on Postgres at native speed, not interpreted. While they didn't acquire it, they brought me on as a founding engineer focused on...
Why YC Rejects Experienced Founders (and Why They're Probably Right)
After reflecting on my own experience, and talking with others, I think YC is mostly right.
Early-stage startups reward speed, not caution. Experience often slows founders down at the exact moment when reckless momentum matters most.
Here’s my breakdown of where/why older founders struggle and how to approach it more clearly.
Show HN: New Postgres Connection Pooling Extension Breaks 100k Barrier
If you’ve ever dealt with scaling PostgreSQL, you know the traditional process-per-connection model just doesn’t cut it when you're handling massive numbers of connections, particularly short-lived ones. When I led architecture at The Meet Group, which had one of the largest deployments of Postgres in the world, we optimized everything: connection pools in the app tier, as a man-in-the-middle,...
The Future of MySQL is Postgres [pdf]
Today, at Postgres Conference 2024, we introduced a PostgreSQL extension we are developing, which enables MySQL applications to run on PostgreSQL without any code changes by supporting the MySQL wire protocol, SQL syntax, and procedural language. It addresses MySQL's large database performance issues by leveraging PostgreSQL's features, such as enhanced partitioning, analytical queries, parallel query, advanced indexing, and materialized views. The extension also gives MySQL developers access to the comprehensive PostgreSQL extension ecosystem, including columnar storage, vector database functionality, and in-database machine learning, providing additional functionality. I mean, Oracle just released a preview of JavaScript procedural language support in MySQL in 2024, whereas our extension inherits Postgres' PLs, giving MySQL developers access to in-database Python, Rust, JavaScript, et al.
Not only that, but our solution consolidates database management, eliminating the need to run both MySQL and PostgreSQL systems, which is common among 75% of businesses using PostgreSQL. This approach improves productivity and simplifies operations.
Our Alpha will be released in July, Beta in September, and we expect to be GA by EOY. Questions welcomed.