1291
Building a BFT JSON CRDT
CRDTs are a family of data structures that are designed to be replicated across multiple computers without needing to worry about conflicts when people write data to the same place.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
1292
Semantic Search with SQLite
txtai is an all-in-one open-source AI framework for semantic search, LLM orchestration and language model workflows
1293
The 12-bit rainbow palette
A palette of twelve colours chosen with consideration for how we perceive luminance, chroma, and hue
1294
SQLite Release 3.40.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
1295
1296
Bottomless, consumption-based storage for PostgreSQL built on Amazon S3
Data management decisions don’t have to be costly. Introducing Tiered Storage, a low-cost infinite storage tier for your historical data needs.
1297
How PlanetScale Boost serves SQL queries faster
PlanetScale offers the world’s fastest and most scalable cloud hosting for Vitess, Neki, and Postgres.
1298
PlanetScale Boost
PlanetScale offers the world’s fastest and most scalable cloud hosting for Vitess, Neki, and Postgres.
1299
We upgraded an old, 3PB large, Elasticsearch cluster without downtime
Back in 2018, now five years ago, we published a blog post describing our 400+ node Elasticsearch cluster. In that post we brought up an important topic: So far, we have elected to not upgrade the cluster. We would like to, but so far there have been more urgent tasks. How we actually perform the upgrade is undecided…
1300
Building a semantic search engine in Rust
If you're interested in building a semantic search engine in Rust, this article will show you how! We'll cover building a basic engine using sentence transformers and a kd-tree.
1301
It's not Ruby that's slow, it's your database
Many people keep repeating that Ruby is slow. It is. But that doesn't matter, because your database is so much slower that it is the bottleneck. So, an alternative title would be "Ruby is slow, but that doesn't matter for you."
1302
1303
Postgres Insider Terminology
If you've ever wondered - What is a tuple? What is a Postgres page? What's the difference between a record and a row? What is a relation? What's an array? What is TOAST? This post is for you! These are terms you hear all the time in the Postgres world. This post breaks down what these terms mean and how they are used.
1304
The case for JPEG XL
The recent decision by Chrome developers to no longer support JPEG XL has sent a ripple through the developer community and is a bit premature given the relative newness of the image format.
1305
Phlare: open-source database for continuous profiling at scale
Grafana Labs is helping enable continuous profiling at cloud native scale for the open source community and enterprises, giving developers a better understanding of resource usage of their code.
1306
One Million Database Connections
Learn how to use PlanetScale to safely include your database in your serverless functions without hitting connection limits in MySQL.
1307
Backblaze Drive Stats for Q3 2022
Q3 2022 Drive Stats: Read the latest insights and check out the data.
1308
1309
1310
SQLite in the browser with WASM/JS
WebAssembly , a.k.a. WASM, is a standard defining a low-level programming language suitable (A) as a target for cross-compilation from many other languages and (B) for running via a virtual machine in a browser. Designed with scriptability via JavaScript in mind, it provides a way to compile C code (among others) to…
1311
Push-based outbox pattern with Postgres logical replication
There are only a few patterns that I’m comfortable saying: “You should use it always if you want to build mature system”. One of them is the Outbox Pattern. Why? Because…
1312
Multiranges in Postgres
Multiranges are a new feature in PostgreSQL 14. Here's a brief introduction on how to use them - learn the basics & important new uses.
1313
IOx: InfluxData’s New Storage Engine
Today I’m excited to announce that we deployed our next-generation storage engine that’s built on InfluxDB IOx in our InfluxDB Cloud platform. #influxdb
1314
The evolution of the data engineer role
The Evolution of The Data Engineer: A Look at The Past, Present & Future
1315
Maintaining sufficient free space with ZFS
TLDR: ZFS free-space reporting is a lagging indicator. Background I use Proxmox VM server backed by a ZFS array of hard drives for various personal infrastructure. I also have security cameras that upload motion-triggered videos to my server (via FTP!). Problem Description I would like to use 90% of my available space…
1316
Quirks, Caveats, and Gotchas in SQLite
The SQL language is a "standard". Even so, no two SQL database engines work exactly alike. Every SQL implementation has its own peculiarities and oddities, and SQLite is no exception to this rule.
1317
1318
Postgres 15 Merge Command with Examples
We’re excited about the MERGE command in PostgreSQL 15. We have some ideas about using it for data loading with an example use case for remote sensors.
1319
Simple, Fast, and Scalable Reverse Image Search
How we built our first iteration of content matching at Canva.
1320
Postgres Full Text Search vs. the Rest
Comparing one of the most popular Postgres features against alternatives