Topics /
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
In contrast to the imperative programming paradigm, declarative programming expresses the logic of a computation without explicitly specifying its control flow. That is, declarative programming focuses on the what , not the how . If you have tentatively researched declarative programming before, you have likely read…
This is a major milestone. After almost 2 years of development, version 2.0 of VisiData is finally released. It's got several major improvements, a bunch of new loaders, and tons of new features and quality of life improvements. And, most importantly, an API specification for plugins.
We’re pleased to announce the availability of RethinkDB 2.4.1. This update includes bug fixes, build improvements and the reintroduced update checker. For a complete list of changes in this update, you can refer to the release notes . Don’t forget that we replaced our download server, please read our latest blog post .
Wikimedia Enterprise announced its first customers: multinational technology company Google and nonprofit digital library Internet Archive. Wikimedia Enterprise was recently launched by the Wikimedia Foundation as an opt-in product.
Oh relational databases, that tired old relic of another age. Codd and friends were great in their time, but serious software engineers need to move on. People building Web Scale™ software You’ve probably heard a similar sentiment at some point. That relational databases were great, but they are dinosaurs that are…
I think simple ultra-high speed lossy (or near-lossless) image codecs, built from the new generation of fast LZ codecs, are going to become ...
Common Table Expressions in PostgreSQL are a powerful SQL construct. You can think of CTEs as a view that is materialized only while the query is running. Recursive CTEs allow themselves to be called until some condition is met. This post from the Citus Data team explores how recursive CTEs work in Postgres.
As a project evolves, does the new code just add on top of the old code? Or does it replace the old code slowly over time? In order to understand this, I built a little thing to analyze Git projects, with help from the formidable GitPython project.
libSQL “server mode” (sqld) enables access to SQLite-based databases using Postgres and HTTP network protocols.
The story behind how LinkedIn created Apache Kafka
Datasette (previously) is my open source tool for exploring and publishing structured data. There are a lot of ideas embedded in Datasette. I realized that I haven’t put many of …
In this exploratory analysis of 2 highly controlled crossover studies in 30 participants without diabetes, the same meals led to highly variable glucose responses, as measured with continuous glucose monitors.
Database load can be a silent performance killer. I’ve been optimizing the query performance of a web app I run designed to get people involved in open sourc...
How to get ACID transactions between almost any data stores, with the Epoxy protocol.
Materialize secures Series B funding to enhance its Operational Data Warehouse with real-time streaming capabilities for immediate data action.
Spoiler alert: the answer is maybe! Although, my inclusion of the word “actually” betrays my bias. Vector databases are having their day right now. Three different vector DB companies have raised money on valuations up to $700 million (paywall link). Surprisingly, their rise in popularity is not for their “original”…
Start building on Google Cloud with $300 in free credits and 20+ always free products.
Have you seen this legendary SQL iceberg meme? Let's talk about it while wearing our PostgreSQL hat!
Ryan Marcus, assistant professor at the University of Pennsylvania. Using machine learning to build the next generation of data systems.
So you know the Bayes rule. How does it relate to machine learning? It can be quite difficult to grasp how the puzzle pieces fit together - we know …
