1591
DuckDB 1.1.0 Released
The DuckDB team is happy to announce that today we're releasing DuckDB version 1.1.0, codenamed “Eatoni”.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
1592
Introduction to Datalog
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…
1593
Visidata 2.0
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.
1594
RethinkDB 2.4.1
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 .
1595
Wikimedia Enterprise announces Google and Internet Archive as first customers
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.
1596
Relational databases aren’t dinosaurs, they’re sharks
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…
1597
Near-lossless image formats using ultra-fast LZ codecs
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 ...
1598
Recursive Common Table Expressions in Postgres
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.
1599
1600
1601
Analysis of longevity of code across many popular projects
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.
1602
Text Mining South Park
pop culture + data science
1603
SQLite-based databases on the Postgres protocol? Yes we can
libSQL “server mode” (sqld) enables access to SQLite-based databases using Postgres and HTTP network protocols.
1604
1605
Why was Apache Kafka created?
The story behind how LinkedIn created Apache Kafka
1606
SQL as an API language
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 …
1607
Continuous glucose monitors reveal variable glucose responses to the same meals
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.
1608
How I Reduced My DB Server Load by 80%
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...
1609
1610
How to get transactions between almost any data stores
How to get ACID transactions between almost any data stores, with the Epoxy protocol.
1611
1612
Materialize Raises a $32M Series B
Materialize secures Series B funding to enhance its Operational Data Warehouse with real-time streaming capabilities for immediate data action.
1613
Do you need a vector database?
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”…
1614
1615
1616
1617
New PostgreSQL Interface for Cloud Spanner
Start building on Google Cloud with $300 in free credits and 20+ always free products.
1618
Explaining the Postgres iceberg
Have you seen this legendary SQL iceberg meme? Let's talk about it while wearing our PostgreSQL hat!
1619
1620
The often-overlooked random forest kernel
Ryan Marcus, assistant professor at the University of Pennsylvania. Using machine learning to build the next generation of data systems.