151
PostgreSQL is the worlds’ best database
Experience zero data sprawl with EDB Postgres AI. Capable of handling 30B+ trades a day and managing 50 TB.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,222 posts.
152
153
154
155
PostgreSQL 16
September 14, 2023 - The PostgreSQL Global Development Group today announced the release of PostgreSQL 16, the latest version of …
156
I found a bug in SQLite
rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Recently I introduced a high-performance write-path into rqlite and, to my great surprise, it exposed a bug in SQLite. The SQLite team quickly addressed the issue but let's take a look at the…
157
Accidental database programming
Join me as we take a look at common application data patterns, and how they relate to the inner-workings of databases. In this post, we discuss data caching, indexing, optimistic mutations, and recursive cache invalidation. We will see how life might be easier if we could just use a frontend optimized database like…
158
The Anthropic Economic Index
Announcement of the new Anthropic Economic Index and description of the new data on AI use in occupations
159
Lepton image compression: saving 22% losslessly from images at 15MB/s
Dash knows your context, your team, and your work, so your team can stay organized, easily find and share knowledge, and keep projects secure, all from one place.
160
Estimating the chances of something that hasn’t happened yet
A handy rule of thumb for creating a confidence interval for the probability of an event you haven't seen happen yet.
161
Postgres LISTEN/NOTIFY does not scale
Learn why Postgres LISTEN/NOTIFY doesn't scale for high-throughput use cases and what architectural alternatives Recall.ai uses in production.
162
Inserting a billion rows in SQLite under a minute
This is a chronicle of my experiment where I set out to insert 1B rows in SQLite
163
Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O
Postgres 18 introduces Asynchronous I/O (AIO) that can dramatically improve read performance, especially in the cloud. Learn how these changes and the new io_method setting work and see why our benchmark results show that io_uring is the recommended setting for maximizing I/O performance in Postgres 18 over the…
164
S3 is files, but not a filesystem
"Deep" modules, mismatched interfaces - and why SAP is so painful
165
166
167
Why Use Postgres?
Five years ago I wrote a post that got some good attention on why you should use Postgres. Almost a year later I added a bunch of things I missed. Many of those items bear repeating, and I’ll recap a few of those in the latter half of this post. But in the last 4-5 years there’s been a lot of improvements and more…
168
How Figma's databases team lived to tell the scale
Our nine month journey to horizontally shard Figma’s Postgres stack, and the key to unlocking (nearly) infinite scalability.
169
SQLite as an Application File Format (2014)
An SQLite database file with a defined schema often makes an excellent application file format. Here are a dozen reasons why this is so:
170
Hosting SQLite Databases on GitHub Pages
I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to use a
171
PostgreSQL 13
The PostgreSQL Global Development Group today announced the release of [PostgreSQL 13](https://www.postgresql.org/docs/13/release-13.html), the latest version of the world’s [most advanced …
172
Executable Is a SQLite Database
I have been probably obsessed with two things in the last few years: Nix as a tool to explore innovative ideas that require the capability to rebuild the world and replacing ELF with SQLite as an executable format. You might have noticed that these two ideas are well suited to each other.
173
Kafka is Fast – I'll use Postgres
Why you should just use Postgres instead of Kafka for small-scale message queuing and pub-sub patterns. Benchmarks and practical tests included.
174
Apache Arrow 3.0
The Apache Arrow team is pleased to announce the 3.0.0 release. This covers over 3 months of development work and includes 666 resolved issues from 106 distinct contributors. See the Install Page to learn how to get the libraries for your platform. The release notes below are not exhaustive and only expose selected…
175
Deep-Fried Data
This is the text version of a talk I gave on September 27, 2016, at the Collections as Data event at the Library of Congress. [ video ] (21 mins)
176
177
How Postgres stores data on disk – this one's a page turner
A high-level overview of how PostgreSQL stores data on disk, covering segments, pages and more.
178
A Docker footgun led to a vandal deleting NewsBlur's MongoDB database
tl;dr: A vandal deleted NewsBlur’s MongoDB database during a migration. No data was stolen or lost.
179
PostgreSQL 9.6 Released
PostgreSQL 9.6, the latest version of the world's leading open source database, was released today by the PostgreSQL Global Development …
180
How I made $500k with machine learning and high frequency trading
How I made $500k from high frequency trading using machine learning to optimize a trading algorithm for Russell 2000 and DAX futures, trading independently without working for a quant firm.