Topics /

Databases & Data

The most popular blog posts about databases & data on Hacker News. 4,222 posts.

Any year
273

DuckDB 2.0.0 LTS “Cinnamon Teal”

The DuckDB team is happy to announce that today we're releasing DuckDB version 2.0.0 LTS, codenamed “Cinnamon Teal” (Spatula cyanoptera). This is our biggest feature release so far, and it ships a polished version of the Quack protocol, asynchronous I/O, a first-class VARIANT type, agent mode, triggers, an extensible…

275

Data Science: Reality Doesn't Meet Expectations

OLXTOTO adalah situs menyediakan link alternatif untuk login tanpa hambatan yang di rancang agar pemain bermain lebih stabil dan optimal apabila domain utama mengalamin kendala. Nike Hat Size 6 1/2 6 5/8 6 3/4 6 7/8 7 7 1/8 7 1/4 7 3/8 7 1/2 7 5/8 7 3/4 Head Size (CM) 52 53 54 55 56 57 58 59 60 61 62 Alpha Size - - XS…

281

Xor Filters: Faster and Smaller Than Bloom Filters

In software, you frequently need to check whether some objects is in a set. For example, you might have a list of forbidden Web addresses. As someone enters a new Web address, you may want to check whether it is part of your black list. Or maybe you have a large list of already used … Continue reading Xor Filters…

282

Using Metadata to Find Paul Revere

London, 1772. I have been asked by my superiors to give a brief demonstration of the surprising effectiveness of even the simplest techniques of the new-fangled Social Networke Analysis in the pursuit of those who would seek to undermine the liberty enjoyed by His Majesty’s subjects. This is in connection with the…

288

Mini NASes marry NVMe to Intel's efficient chip

I'm in the process of rebuilding my homelab from the ground up, moving from a 24U full-size 4-post rack to a mini rack. One of the most difficult devices to downsize (especially economically) is a NAS. But as my needs have changed, I'm bucking the trend of all datahoarders and I need less storage than the 120 TB (80…

297

My Favorite PostgreSQL Queries and Why They Matter

In today's data-driven world, data is valuable. Extracting insight, answering questions, and meaningful metrics from data by way of querying and data manipulation is an integral component of SQL in general. This blog presents a combination of 8 interesting, differing PostgreSQL queries or types of queries to explore…