631
Subtly Bad Things Linux May Be Doing To PostgreSQL
In addition to talking about PostgreSQL at LSF/MM and Collab , I also learned a few things about the Linux kernel that I had not known befor...
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
632
Temporal quality degradation in AI models
A recent study from MIT, Harvard, The University of Monterrey, and other top institutions showed an experiment where 91% of their ML models degrade over time . This study is one of the first of its kind, where researchers focus on studying machine learning models' behavior after deployment and how their performance…
633
Backblaze Hard Drive Stats for 2016
We take a deep dive on hard drive performance stats from 73,653 hard drives. What are the most reliable hard drives by size, manufacturer, and model?
634
635
Xkcd-Style Plots in Matplotlib (2012)
Update: the matplotlib pull request has been merged! See This post for a description of the XKCD functionality now built-in to matplotlib!
636
Neon Serverless Postgres is generally available
Neon is now Generally Available. We’ve shipped major improvements to Neon internals that, combined with our operating experience scaling up to 700,000+ databases over the past year, give us the confidence that Neon is ready to support your business-critical workloads. If you’re building or scaling an application, you…
637
Modern CSV version 2
And I think you’ll love it. I focused on several areas: Improved UI and user experience Faster performance Useful features Updated documentation For Mac users, Native Apple Silicon (ARM – M1, M2) compatibility If that’s all you need to know, you can buy a license here. Or if you already have a version 1 license, you…
638
I could've accessed 17T Microsoft records
How one unchecked login token put 17 trillion rows in a Microsoft internal analytics service within reach.
639
New information extracted from Snowden PDFs through metadata version analysis
We discovered that entire sections describing domestic U.S. intelligence facilities were deliberately removed from two published documents, while equivalent foreign facilities remained visible. The evidence exists in an unexpected place - the PDF metadata of documents published by The Intercept in 2016, and by The…
640
641
NumPy 2.0
NumPy 2.0.0 is the first major release since 2006. It is the result of 11 months of development since the last feature release and is the work of 212 contributors spread over 1078 pull requests. It contains a large number of exciting new features as well as changes to both the Python and C APIs.
642
Architecture Notes: Datasette
Simon is the creator of Datasette and co-creator of Django web framework. Formerly he was a JSK journalism fellow at Stanford, and prior to that an Engineering Director at Eventbrite.
643
Learn SQL Once, Use It for 30 Years
The Only Programming Language Built on Mathematics, Not Fashion
644
Databases in 2021: A Year in Review
Andy Pavlo - Carnegie Mellon University,
645
Scaling our spreadsheet engine from thousands to billions of cells
Causal has joined Lucanet to deliver Extended Planning and Analysis (xP&A) as part of the Lucanet CFO Solution Platform. Make smarter planning decisions with unified real-time insights across financial and operational planning.
646
Tips for a Healthier Postgres Database
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
647
The Marketing Behind MongoDB
Countless NoSQL databases competed to be the database of choice. MongoDB's marketing strategy helped it become the winner.
648
21 GB/s CSV Parsing Using SIMD on AMD 9950X
Sep 0.10.0 was released April 22nd, 2025 with optimizations for AVX-512 capable CPUs like the AMD 9950X (Zen 5) and updated benchmarks including the 9950X. Sep now achieves a staggering 21 GB/s on the 9950X for the low-level CSV parsing. 🚀 Before 0.10.0, Sep achieved ~18 GB/s on 9950X.
649
Bunny Database
Deploy globally, query over HTTP, and scale reads with low latency. Bunny Database lets you build fast without paying the serverless tax.
650
651
Fine, I'll run a regression analysis but it won't make you happy
State partisanship and COVID vaccination rates are strongly predictive of COVID death rates even once you account for age.
652
Introduction to Zipline: A Trading Library for Python
This blogpost introduces zipline package in python with its benefits, how to install it, and using it code the moving crossover strategy for financial trade
653
654
Message DB: Event Store and Message Store for PostgreSQL
The Eventide Project team is excited to announce Message DB: A fully-featured event store and message store implemented in PostgreSQL for pub/sub, event sourcing, and evented microservices applicat...
655
Speeding up sort performance in Postgres 15
Deep dive into the sort performance improvements in PostgreSQL 15, along with charts to visualize what types of queries will be faster. Includes speedups in single column sorts, reduced memory consumption with generation memory context, specialized sort routines for common datatypes, & use of k-way merge.
656
FoundationDB Record Layer
Today, we are excited to announce the open source release of the FoundationDB Record Layer!
657
658
3.4M Solar Panels
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
659
A/B test of banner ads vs. traffic
9 months of daily A/B-testing of Google AdSense banner ads on Gwern.net indicates banner ads decrease total traffic substantially, possibly due to spillover effects in reader engagement and resharing.
660
SQL patterns I use to catch transaction fraud
The actual queries I run when I'm hunting fraud in transaction data. Velocity, impossible distances, suspicious amounts, merchant clusters, off-hours buys, and window functions.