Postgres First

@ryanflorence @_chenglou 🔥🫡

My dear front-end developers (and anyone who’s interested in the future of interfaces): I have crawled through depths of hell to bring you, for the foreseeable years, one of the more important foundational pieces of UI engineering (if not in implementation then certainly at least in concept): Fast, accurate and comprehensive userland text measurement algorithm in pure TypeScript, usable for laying out entire web pages without CSS, bypassing DOM measurements and reflow

Introducing the new dev-browser cli. The fastest way for an agent to use a browser is to let it write code. Just `npm i -g dev-browser` and tell your agent to "use dev-browser"

Georgia Tech built a free tool that animates every data structure and algorithm in real time csvistool.com this is what DSA study looks like when it actually makes sense

@stalmico @glcst DuckDB is awesome, and a great complement to Postgres.. they don’t compete

@glcst what makes it different from duckdb?

What if we could run Postgres as a single file, and take advantage of the best SQLite has to offer? Today I am announcing pg-micro, a crazy experiment I've been undertaking to make this happen. pg-micro is different than other approaches because it is fully local, and expected to be fast: there is no concurrency limitation and no statement translation. Here's how it works: we use the actual postgres parser to parse the statement, but compile that to the Turso AST. The Turso AST is then compiled do bytecode, and from there everything executes natively, as it'd do in SQLite. This makes it a perfect target to run in any environment. There is traditionally a mismatch between Postgres and SQLite in terms of functionality. But @tursodatabase has been hard at work to close this gap: things like MVCC and a rich, strict type system are present in Turso. There are PRs for things like lateral joins, etc. This means that the gap can be closed until it theoretically reaches zero. What you could do with it? Just imagine for example a primitive like Durable Objects by @Cloudflare, but with a postgres interface? Or imagine you could use the same pattern of local databases for agents that SQLite gives you, totally ephemeral and free, but with a Postgres interface? Or even that you could execute remote postgres in platforms like @vercel but with the unmatched density of the Turso Cloud? Expect lots not to work at this point. But as usual, this is done in the full spirit of OSS, so PRs welcome! To get started: npx pg-micro

Your agent can think. But it can't remember. Until now. dev.to/ghostbuild/you… @ghostdotbuild

io_uring easily beats AIO and gets faster with every kernel — until both suddenly get 30% slower. Join a database developer’s unexpected journey into the Linux kernel and IOMMU. medium.com/ydbtech/how-io…

@TheMonologist Broderick 43 years ahead of tricking AI by intentionally causing token timeouts. Visionary.

"Start with a definition of success, not code." This is the new model of software development. In a way, it's the modern test driven development.

📐Design Systems and DESIGN.md Consistency using Design Systems and DESIGN.md: ✨ Every new design automatically starts with a cohesive design system which GREATLY improves consistency (we heard you!) ✨ Edit the system, and all associated screens can be easily updated ✨ You can extract a design system from any URL ✨ Use DESIGN.md to export your design rules or import your design rules from other products (just ask your agent to create you a DESIGN.md file from your code or other context) ✨ You can start a new design by choosing from popular design systems ✨ Read more about DESIGN.md in the docs (link in thread)

Stop scrolling and watch this 55 min talk from Steve Jobs in 1983 where he tells you exactly how the next 4 decades will unfold

@ncq_syh @lukOlejnik this is the worse AI-slop I have seen about Manhattan.. Waymo does not operate in NYC yet

@lukOlejnik Seems like self-driving car making a mess.

Amazon is holding a mandatory meeting about AI breaking its systems. The official framing is "part of normal business." The briefing note describes a trend of incidents with "high blast radius" caused by "Gen-AI assisted changes" for which "best practices and safeguards are not yet fully established." Translation to human language: we gave AI to engineers and things keep breaking? The response for now? Junior and mid-level engineers can no longer push AI-assisted code without a senior signing off. AWS spent 13 hours recovering after its own AI coding tool, asked to make some changes, decided instead to delete and recreate the environment (the software equivalent of fixing a leaky tap by knocking down the wall). Amazon called that an "extremely limited event" (the affected tool served customers in mainland China).

Robert Haas (@robertmhaas): pg_plan_advice: Plan Stability and User Planner Control for PostgreSQL? postgr.es/p/7uj

I've lead a COBOL to Java migration project, and we did use software to translate most of the COBOL. The automatic translation step only took a few hours. The rest of the project took ~3 years. Even a perfect translation doesn't account for the subtle intricacies of moving platforms and paradigms, and testing if it all works. If we had used current-day AI instead, it would have taken us much longer because we would never be able to trust that all the translations were done in the same, deterministic way, requiring manual review and fixes. It probably would have never finished.

@sudomateo Up up and away!!!

Feels great to finally be able to share this! oxide.computer/blog/our-200m-…

Relational vs. Document! ⚖️ Franck Pachot from @MongoDB compares **PostgreSQL JSONB and MongoDB** for document workloads. Which database wins? #PostgreSQL #JSONB #MongoDB

Some interesting insights on who contributes to @PostgreSQL gathered by @eatonphil

Akhil Reddy Banappagari: Null and Empty String in Oracle vs SQL Server vs PostgreSQL postgr.es/p/7rc

@denismagda nice find ☝️

Postgres continues to evolve in the gen AI area. I’ve just come across two new extensions. VectorChord (vchord) is an extension designed for cost-effective and disk-efficient vector similarity search. Their promise is that you can store 400,000 vectors for just $1, enabling significant savings: 6x more vectors compared to Pinecone's optimized storage and 26x more than pgvector. pgpu is another extension that can use NVIDIA GPUs with CUDA to accelerate certain operations in the database and/or to offload them from the CPU to the GPU. Right now, the primary use case is accelerating the build time of vchord’s index type with the help of GPUs. The diagram shows how pgpu calculates centroids of the vchord index with the help of GPUs: 1. read data from the database 2. compute centroids on the GPU 3. write centroids to a Postgres table 4. create a vchord index passing the pre-computed centroids table

PostgreSQL doesn't protect itself by default on forgotten transactions, idle sessions, runaway queries they all pile up silently until your database feels "stuck." If you're migrating to #PostgreSQL, these 5 timeout parameters are critical to configure: datacloudgaze.com/post/postgresq…

damien clochard (@daamien): PostgreSQL Anonymizer, available in all good shops postgr.es/p/7qY