2821
Linux 7.0 Broke PostgreSQL: The Preemption Regression Explained
Linux 7.0 delivered roughly half the throughput of Linux 6.x on the same hardware and workload.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
2822
How to Analyze Every Reddit Submission and Comment, in Seconds, for Free
With Reddit data in BigQuery, quantifying all the hundreds of millions of Reddit submissions and comments is trivial.
2823
2824
A new database on police use of force and misconduct in California
UC Berkeley Journalism offers a two-year Master of Journalism (MJ) degree and a summer minor, preparing students for careers in journalism.
2825
2826
The SQL filter clause: selective aggregates
The FILTER clause extends aggregate functions (SUM, AVG, COUNT, etc.) with an additional WHERE clause. Databases not supporting FILTER can use CASE within the aggregate function instead.
2827
2828
Re: MemSQL the “world's fastest database”? (2012)
On 6/25/12 10:23 AM, Kevin Grittner wrote: > Craig James <cjames@emolecules.com> wrote: > >> It claims to be "the world's …
2829
2830
Datomic: Look at all the things I'm not doing
A post by August Lilleaas, published April 20, 2018.
2831
Introducing DataFrames in Spark for Large Scale Data Science
Introducing Apache Spark's DataFrame API for easier, efficient big data processing and data science applications.
2832
How to make fake data look meaningful
If you are trying to trick somebody with your data, never share the raw data; only share the conclusions. Bonus points if you can’t share the data because it is somehow priviledged or a trade secret. The last thing you want is to allow other people to evaluate your analysis and possibly challenge your conclusions.
2833
SQLite 2022 Recap
There have been many improvements to SQLite during 2022. Listed below or just a few of the bigger changes. See the change logs or the trunk timeline for a more complete list of enhancements and improvements.
2834
Analyzing the Patterns of Numbers in 10M Passwords (2015)
There are many patterns for numbers in passwords, which involve surprising yet intuitive logic.
2835
Losing a 5-year-long Illinois FOIA lawsuit for database schemas
Thomas Ptacek, a friend and expert witness in this lawsuit summed it up best in the court's hallway while walking within three feet of opposing counsel: "This is fucking stupid" .
2836
2837
2838
Prepared statements and their surprising performance implications
Or: How To Increase Your Elixir/Postgres Performance 20x With One Weird Trick
2839
A visual exploration of the spatial patterns in endings of German town names
A visual exploration of the spatial patterns in the endings of German town and village names.
2840
2841
Optimizing LLMs from a Dataset Perspective
Practical guide to improving LLM finetuning with better instruction datasets, covering data curation, prompt-output pairs, synthetic data, and experiment ideas.
2842
Non blocking and zero downtime ALTER statements in PostgreSQL with pg-osc
pg-osc is a CLI tool for making non-blocking, zero downtime schema changes in PostgreSQL
2843
Consistency Models
Jepsen analyzes the safety properties of distributed systems–most notably, identifying violations of consistency models. But what are consistency models? What phenomena do they allow? What kind of consistency does a given program really need?
2844
Postgres tips for the average and power user
A collection of power user tips for those working with Postgres
2845
2846
Amazon Launches Managed Cassandra Service
Managing databases at scale is never easy. One of the options to store, retrieve, and manage large amounts of structured data, including key-value and tabular formats, is Apache Cassandra. With Cassandra, you can use the expressive Cassandra Query Language (CQL) to build applications quickly. However, managing large…
2847
Null Values in SQL Queries
*If you’re the owner of this website and have questions, reach out to Bluehost. We’re happy to help.
2848
2849
Finding unique items: hash vs. sort
A while back, I was trying to speed up some code which finds unique items in a collection. For example, transforming "AABBADCAB" => "ABDC" . There are two ways to do this efficiently - one is based on sorting, the other based on hashing. So, which is faster? I couldn't find the answer, so I ran some experiments and…
2850
Why MongoDB Never Worked Out at Etsy
In 2010ish, we tried to roll out a feature ( Treasury ) using MongoDB. It was an interesting experience. I learned quite a bit in the process. I wrote about what I was thinking at the time here . But for the most part it was an abject failure and Ryan Young wound up porting the entire thing to the MySQL shards which…