PostgreSQL
Radim Marek: TOAST: Where PostgreSQL hides big values
In earlier posts in this series we established that every heap tuple lives inside a strict 8KB page. Everything else is built on top of that hard limit: MVCC, HOT updates, and indexes that point at (page, line_pointer). And yet this still works: CREATE TABLE docs (id int PRIMARY KEY, body jsonb); INSERT INTO docs VALUES (1, (SELECT jsonb_agg(g) FROM generate_series(1, 100000) g)); That body value is somewhere north of half a megabyte. The heap page is still 8KB. Both statements are true at th...
Mastering Dyalog APL
Show HN: Git-based front-end interface for Hugo
Exploit Development
Debian SE Linux and PinTheft
Defense Tech
No captain, my captain – a crewless warship
X / Twitter
Google Discover's headline rewrites strike again
Query Planning
Andrei Lepikhov: On Polymorphic Associations in Postgres
OUTER JOIN is a typical plague of ORM-based PostgreSQL configurations: the planner is still relatively poor at optimising it. At the same time, ORM frameworks — and 1C as a prominent example — often generate outer joins from standard templates, which opens the door to targeted optimisations. In this article, I dig into one such template — polymorphic reference resolution: what the pattern is, where it comes from (Rails, Django, Hibernate, Salesforce — not just 1C), how widespread it i...
Swap tables, flash-friendly swap, swap_ops, and more
fht-compositor: A dynamic tiling Wayland compositor
All Lean Books and Where to Find Them
OpenAI
Greg Brockman: Inside the 72 Hours That Almost Killed OpenAI
Silk: Open-source cooperative fiber scheduler
Limerick
A Network Allow-List Won't Stop Exfiltration
Computational Biology
Expanding the human proteome with microproteins and peptideins – Nature
Vim and Neovim
Key, in sight [Creative uses of keyboard shortcuts and macros]
C++
The C++ Standard Library Has Been Walking Itself Back for Fifteen Years
Prompt Engineering
Local LLMs perform better when you teach them to ask before they answer
C++
Converting an Integer to a Decimal String in Under Two Nanoseconds
Minimal cross-platform direct I/O abstraction for Rust.
Just published my first Rust crate: odirect It’s a small cross-platform library for opening files with direct/unbuffered I/O. Linux → O_DIRECT macOS → F_NOCACHE Windows → FILE_FLAG_NO_BUFFERING https://crates.io/crates/odirect https://github.com/ankushT369/odirect submitted by /u/ankush2324235 [link] [comments]
C++
Neoclassical C++: segmented iterators revisited
Amazon
Amazon Web Services – Four Years and Out
Buildcraft Is a Compiler Problem
Mathematics
Alexander Grothendieck Revolutionized 20th-Century Mathematics
Open Source
'Fuck you, Bambu': How one private message could change the face of 3D printing
MySQL
Migrating Etsy’s database sharding to Vitess
Etsy has maintained a sharded MySQL architecture since around 2010. This database cluster contains most of Etsy’s online data and is made up of ~1,000 tables distributed across ~1,000 shards. Over the last 16 years, it has grown significantly: combined, these tables have over 425 TB of data and receive roughly 1.7 million requests per second. Etsy engineers access our MySQL data through a proprietary object-relational mapping (ORM). The ORM has a corresponding model for each MySQL table. W...
Artificial Intelligence
Making Ads Count: Using MMoE and Auxiliary Tasks to Better Connect Buyers & Sellers
When buyers search on Etsy, they need to quickly and easily find the perfect item. At the same time, sellers need to be confident their unique products are being seen by the right customers. Our Ads Search ranking model, which is built on a multitask learning foundation, is the critical link in this connection. Recently, we identified an opportunity to drive more meaningful buyer engagement by enhancing our model’s ability to predict purchase intent. We achieved this via a dual-pronged impr...
API proposed by Chrome: Declarative partial updates
C
The day my ping took countermeasures
AI didn't kill your junior pipeline. You did
Microsoft
Microsoft open-sources "the earliest DOS source code discovered to date"
NeuralNote
Web Application Security
The Security of Ephemeral Pages
wake up! 16b
Serverless
The AWS Service Quotas That Will Take Down Your Production at 3 Am
Show HN: Anyone interested in a tool helps to explore C++ ASTs
My I3-Emacs Integration
AI Psychosis
Judson's Last Ride
Bun.Image
CVE and Exploit Development
Dirty Frag, Copy Fail, Fragnesia: A Worrisome Linux Security Trend
AI Psychosis
Anthropic blames dystopian sci-fi for training AI models to act "evil"
xAI
Polsia raised $30M; source map: fake ARR, dead users, god-mode over your company
Don't Roll Your Own
We reduced a real Node.js production Docker image from 1.2GB to 78MB
Markdown Is Not LaTeX
remind(1) -- calendar and alarm program
Aube – Node.js package manager in Rust
Operating Systems
“Long-Term Support” doesn’t mean what you think
Chip Design and Semiconductors
A self-powered computer in actual credit-card size (~1mm thick)
Software Engineering
Software Engineering at the Tipping Point
Pardon MIE?
Networking Protocols
A new suite of modern tools for editing and publishing IETF RFCs
F#
dotNET (OK, C#) gets union types
The Architecture of BerkeleyDB
AI Hardware
Data Centers Now Consume 6% of US Electricity–and the Backlash Has Begun
Reflections on Building Forum Software
CC-Wiki: Turn Claude Code sessions into a shareable knowledge base wiki
Vim and Neovim
It's time to talk about my writerdeck
Storage Systems
We made our filesystem 47× faster by deleting it
Awesome Neuroscience
Authentication
JWT is a scam and your app doesn't need it
Privacy
Ordinary WiFi can now identify people with near perfect accuracy
Performance Engineering
Evaluating Spec CPU2026
Artificial Intelligence
AI Engineering from Scratch
Apple
Surface laptop ships with 8GB RAM for $1299 despite pushing 16GB for Copilot PCs
Reverse engineering circuitry in a Spacelab computer from 1980
Defense Tech
Italy Cancels Boeing Pegasus Order, Shifting to Airbus A330 MRTT
HP QuickWeb, Singular and Pointless
Package Management
New Attack "Megaladon" Compromises 5.5K+ GitHub Repos
Privacy
These special phone and app features can help protect you from spyware
Blockchain
AlphaProof Nexus solves 9 Erdős problems and proves 44 sequence conjectures
MySQL
PHP's Oddities
Lisp in Vim (2019)
C++
C Constructs That Still Don’t Work in C++ — and a Few That Changed
Userspace cache library
So I am writing a cross platform library in rust where I want to have a cache in userspace and it will directly read data from disk bypassing the OS page cache. Can you guys tell me what cache data structure should I use because in case of LRU cache we use linked list but the problem is each node's memory is separated so a lot of page fault. I want to know what cache modern databases use. submitted by /u/ankush2324235 [link] [comments]
Containers
Improving my self-hosted actions runner setup
z386: An Open-Source 80386 Built Around Original Microcode
The FBI Wants 'Near Real-Time' Access to US License Plate Readers
Startups and Venture