31
Many small queries are efficient in SQLite
200 SQL statements per webpage is excessive for client/server database engines like MySQL, PostgreSQL, or SQL Server.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 314 posts.
32
The database servers powering Let's Encrypt
Let’s Encrypt helps to protect a huge portion of the Web by providing TLS certificates to more than 235 million websites. A database is at the heart of how Let’s Encrypt manages certificate issuance. If this database isn’t performing well enough, it can cause API errors and timeouts for our subscribers. Database…
33
Migrating Facebook to MySQL 8.0
MySQL, an open source database developed by Oracle, powers some of Facebook’s most important workloads. We actively develop new features in MySQL to support our evolving requirements. These feature…
34
Simple Anomaly Detection Using Plain SQL
Identify Problems Before They Become Disasters
35
Against SQL
But SQL is the only widely-used implementation of the relational model, and it is:
36
What's New in SQLite 3.35
Math functions, column removal and RETURNING clause.
37
38
Which jobs most often pair together among married couples
Find out which jobs most often pair together among married couples.
39
Lessons learned from sharding Postgres at Notion
With an effort to make Notion faster and more reliable for years to come — we migrated Notion’s PostgreSQL monolith into a horizontally-partitioned database fleet.
40
Postgres is a great pub/sub and job server (2019)
If you need a publish/subscribe or job server at any point in your project, try using Postgres. It'll give you lots of data integrity and performance guarantees, and it doesn't require you or your team learning any new technology.
41
An early look at Postgres 14: Performance and monitoring Improvements
We take a look at whats new in Postgres 14, with idle and active connection scaling, memory monitoring, query IDs and more
42
43
Things I hate about PostgreSQL (2020)
Over the last few years, the software development community’s love affair with the popular open-source relational database has reached a…
44
45
Pg_GraphQL: A GraphQL Extension for PostgreSQL
GraphQL support is in development for PostgreSQL + Supabase.
46
Excel Never Dies
The Spreadsheet That Launched A Million Companies
47
Prisma – ORM for Node.js and TypeScript
Learn about the motivation for Prisma ORM and how it compares to other Node.js and TypeScript database tools like ORMs and SQL query builders. Applies to Prisma ORM v6.
48
Best practices for writing SQL queries
SQL best practices: a brief guide to writing better SQL queries.
49
An Introduction to JQ
In this article, I'm going to go over the basics building blocks of jq in enough depth that you will be able to understand how jq works.
50
Speeding up SQL queries by orders of magnitude using UNION
SQL's UNION operation isn't usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.
51
Kafka without ZooKeeper
Major milestone release Apache Kafka 4.0 removes ZooKeeper entirely, provides early access to Queues for Kafka, and enables faster rebalances, in addition to many other new KIPs.
52
Postgres scaling advice
Planning to scale PostgreSQL? Learn when a single node is enough, how to prepare for sharding, and which scaling steps to consider first.
53
I wrote one of the fastest DataFrame libraries
At the time of writing this, the coronavirus has been in our country for a year, which means I have been sitting at home for a very long time. At the start of the pandemic, I had a few pet projects in Rust under my belt and I noticed that the “are we DataFrame yet” , wasn’t anywhere near my satisfaction. So I wondered…
54
ClickHouse as an alternative to Elasticsearch for log storage and analysis
In 2018, I've written an article about Clickhouse, this piece of content is still pretty popular across the internet, and even was translated a few times. More than two years have passed since, and the pace of Clickhouse development is not slowing down: 800 merged PRs just during last month!
55
56
Building a full-text search engine in 150 lines of Python code
Full-text search is everywhere. From finding a book on Scribd, a movie on Netflix, toilet paper on Amazon, or anything else on the web through Google (like [how to do your job as a software engineer](https://localghost.dev/2019/09/everything-i-googled-in-a-week-as-a-professional-software-engineer/)), you've searched…
57
An unexpected find that freed 20GB of unused index space in PostgreSQL
How to free space without dropping indexes or deleting data
58
Is watching the 1984 Ghostbusters movie killing people?
Is watching the 1984 Ghostbusters movie killing people? English adults under 60 who have watched the 1984 Ghostbusters movie are dying at twice the rate of people who have watched the 2021 Ghostbusters move the same age.And have been for six months. The chart may seem unbelievable or impossible but it is correct…
59
Find anything fast with Google's vector search technology
Recently, Google Cloud partner Groovenauts, Inc. published a live demo of MatchIt Fast . As the demo shows, you can find images and text similar to a selected sample from a collection of millions in a matter of milliseconds:
60
An Unlikely Database Migration
From JSON Files to etcd: A Tailscale Database Migration Story