1471
Introducing ArcticDB: A Database for Observability
Continuous profiling needed a columnar database, so we built it.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
1472
Simple declarative schema migration for SQLite
At my company we use a small SQLite database. We define the schema in a single file with SQL CREATE TABLE statements. If we add tables, columns, or indexes, our application will create them automatically the next time it starts up.
1473
1474
Why isn’t there a decent file format for tabular data?
Tabular data is everywhere. I support reading and writing tabular data in various formats in all 3 of my software application. It is an important part of my data transformation software. But all th…
1475
1476
Jepsen: Redpanda 21.10.1
Redpanda is a Kafka -compatible distributed streaming system based around append-only logs. Compared to Kafka, Redpanda aims to offer users lower latencies and reduced operational complexity. It uses the Raft consensus algorithm internally, rather than depending on a separate installation of Zookeeper . Redpanda…
1477
1478
I put my whole life into a single database
Back in 2019, I started collecting all kinds of metrics about my life. Every single day for the last 2.5 years I tracked over 100 different data types - ranging from fitness & nutrition to social life, computer usage and weather.
1479
Making Faster B-Trees with Go Generics
Go generics are a new way to improve performance in golang. Let’s see what effect generics had on Google’s B-tree implementation.
1480
Zq: An easier and faster alternative to jq
Take an in-depth look at the different computational models of zq and jq.
1481
Datalog in JavaScript
Let's build a query engine from scratch. In about 100 lines of Javascript, we'll support joins, indexes, and find our answer for Arnold!
1482
How Postgres chooses which index to use for a query
How the Postgres planner breaks down a query into scans and how this impacts indexing choices
1483
1484
Amazon releases 51-language dataset for language understanding
MASSIVE dataset and Massively Multilingual NLU (MMNLU-22) competition and workshop will help researchers scale natural-language-understanding technology to every language on Earth.
1485
How we upgraded our 4TB Postgres database
Last fall, we migrated our 4TB Postgres database from version 9.6 to version 13 with minimal downtime. Here is how we did it (gotchas included).
1486
The satellite imagery industry still has no idea what customers want
The satellite imagery industry still has no idea what customers actually want
1487
1488
Migrating from SQLite to PostgreSQL
Product updates, comparisons, and deep dives on database change management, access control, and compliance from the Bytebase engineering team.
1489
K-Nearest Neighbors
One Machine Learning algorithm that relies on the concepts of proximity and similarity is K-Nearest Neighbor (KNN). KNN is a supervised learning algorithm capable of performing both classification and regression tasks.
1490
1491
A basic introduction to NumPy's einsum
Haphazard investigations
1492
Meta quickly detects silent data corruptions at scale
Silent data corruptions (SDCs), data errors that go undetected by the larger system, are a widespread problem for large-scale infrastructure systems. Left undetected, these types of corruptions can…
1493
A database for 2022
we moved from etcd to SQLite for a simpler, more scalable database solution. Learn about Litestream, live replication, and lessons learned.
1494
1495
GraphQL is now available on Supabase
GraphQL support is now in general availability on the Supabase platform via our open source PostgreSQL extension, pg_graphql.
1496
1497
It’s fine, Rewind: Revert a migration without losing data
Learn how PlanetScale lets you revert changes to your database after a migration with no downtime and zero data loss.
1498
Statistical Analysis with Lisp-Stat
Version 1.0-beta
1499
Aggregating away the signal in your data
By aggregating our data in an effort to simplify it, we lose the signal and the context we need to make sense of what we’re seeing.
1500
MySQL now shows its thread names at OS level for better troubleshooting
Starting from v8.0.27, the MySQL daemon shows its thread names at the OS level too, for better troubleshooting. The MySQL 8.0.27 release notes say this: To assist monitoring and troubleshooting, the Performance Schema instrumentation is now used to export names of instrumented threads to the operating system. This…