Space Tech
Space Tech
Space Tech
Query Planning
Autovacuum's ANALYZE threshold formula combines a fixed floor and a percentage of table size.
Uber
AI Psychosis
Haskell
Kubernetes
AI Psychosis
Meta
EVs and Transportation
Large Language Models
Clojure
Apple
C++
Browser Internals
Google
Homelab & Self-Hosting
AI Psychosis
Statistics and Probability
Reverse Engineering
Observability
C++
If you have ever run pg_ctl stop -m fast on a primary and watched it hang well past wal_sender_shutdown_timeout, you have met a bug that has been sitting in walsender.c for years. As of commit c0b24b3 on master (Fujii Masao, May 1, reported by Andres Freund via FreeBSD CI), it is fixed. PostgreSQ…
Information Theory
AI Coding Tools
EVs and Transportation
MySQL
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
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...
Exploit Development
Martin Kleppmann's Hermitage project categorizes the behavior of transaction isolation levels in major SQL databases, but many results haven't been updated in over a decade. And MariaDB has diverged significantly from MySQL since then.
OpenAI
Large Language Models
Prompt Engineering
AI Hardware
AI Psychosis
xAI
Parquet and columnar formats
Mathematics
Meta
AI Psychosis
AI Psychosis
Scientists analyzed thousands of self-reported dreams and discovered that our sleeping visions are influenced by personality traits and external events, such as the pandemic.
Hello! One of my long term projects on here is figuring out how to write frontend Javascript without using Node or any other server JS runtime. One issue I run into a lot in my frontend JS projects is that I don’t know how to write tests for them. I’ve tried to use Playwright in the past, but it felt slow and unwieldy to be starting these new browser processes all the time, and it involved some Node code to orchestrate the tests. The result is that I just don’t test my frontend code whi...
Homelab & Self-Hosting
AGI and AI Safety
Artificial Intelligence
AI Hardware
Search Engines
Microsoft
Apache Kafka
Network Security
Rust