1
Common color mistakes and how to avoid them
Choosing good colors for your charts is hard. This article tries to make it easier.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 153 posts.
2
Jepsen: PostgreSQL 12.3
PostgreSQL is a major open-source relational database with a 23-year history and a broad range of features. While Jepsen’s work has traditionally focused on distributed systems, our tooling is readily applicable to traditional, single-node databases. In this report, we present the results of applying Jepsen’s…
3
4
Backblaze B2 Cloud Storage Now Has S3 Compatible APIs
With B2 Cloud Storage S3 Compatible APIs, we’re making the choice for something different a no-brainer.
5
Jepsen: MongoDB 4.2.6
2020-05-26: MongoDB identified a bug in the transaction retry mechanism which they believe was responsible for the anomalies observed in this report; a patch is scheduled for 4.2.8.
6
PostgreSQL is the worlds’ best database
Experience zero data sprawl with EDB Postgres AI. Capable of handling 30B+ trades a day and managing 50 TB.
7
SQLite as an Application File Format (2014)
An SQLite database file with a defined schema often makes an excellent application file format. Here are a dozen reasons why this is so:
8
PostgreSQL 13
The PostgreSQL Global Development Group today announced the release of [PostgreSQL 13](https://www.postgresql.org/docs/13/release-13.html), the latest version of the world’s [most advanced …
9
Pandas 1.0
These are the changes in pandas 1.0.0. See Release notes for a full changelog including other versions of pandas.
10
SQLite Is Serverless
Most SQL database engines are implemented as a separate server process. Programs that want to access the database communicate with the server using some kind of interprocess communication (typically TCP/IP) to send requests to the server and to receive back results. SQLite does not work this way. With SQLite, the…
11
Multi-node TimescaleDB is now free
Fully managed PostgreSQL from the creators of TimescaleDB. 99.9% uptime SLA, 10,000+ IOPS, columnar compression up to 95%, and built-in search. Try it free.
12
Discovering Millions of Datasets on the Web
Dataset Search launches publicly with an index of 25 million datasets, helping scientists, journalists, students, data geeks to find data.
13
Emerging Architectures for Modern Data Infrastructure
To help data teams stay on top of the changes happening in the industry, this article reviews an updated set of data infrastructure architectures.
14
A popular self-driving car dataset is missing labels for hundreds of pedestrians
SUMMARY A hand-check of the 15,000 images in the widely used Udacity Dataset 2 found problems in 4,986 of them (33%), including thousands of unlabeled vehicles, hundreds of unlabeled pedestrians, dozens of unlabeled cyclists, and 217 completely unannotated images that contained real objects. Phantom annotations…
15
16
SQLite now allows multiple recursive SELECT statements in a single recursive CTE
Is there any command to see the history of a file beyond renames, similar to git log --follow <file> ?
17
18
SQLite 3.32
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 .
19
Things we learned running Postgres 13
Learn about smaller indexes with B-Tree Deduplication, Extended Statistics Improvements, Parallel VACUUM, improved WAL Usage Stats in Postgres 13, and more.
20
How to Corrupt a SQLite Database File
An SQLite database is highly resistant to corruption. If an application crash, or an operating-system crash, or even a power failure occurs in the middle of a transaction, the partially written transaction should be automatically rolled back the next time the database file is accessed. The recovery process is fully…
21
Apache Arrow 1.0
The Apache Arrow team is pleased to announce the 1.0.0 release. This covers over 3 months of development work and includes 810 resolved issues from 100 distinct contributors. See the Install Page to learn how to get the libraries for your platform. Despite a "1.0.0" version, this is the 18th major release of Apache…
22
Dolt is Git for data
Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.
23
Hard Drive Stats for 2019
In 2019 we monitored the performance of 122,507 hard drives. In this article we look at the failure rates by make and model.
24
25
Kafka Removing Zookeeper Dependency
Say goodbye to Kafka ZooKeeper dependency! KIP-500 introduces a new way of storing data in Kafka itself, rather than in external systems such as ZooKeeper.
26
Kafka Is Not a Database
Get insights on Materialize's latest updates & trends in streaming databases & data products.
27
Oracle vs. PostgreSQL – A Comment
I know, this list is not for this, but I just couldn't resist. Please forgive me.
28
Three bugs in the Go MySQL driver
Check out what we learned from shipping our busiest Go service in production—we found 3 bugs in the Go MySQL driver.
29
Clang-11.0.0 Miscompiled SQLite
It appears that the clang-11.0.0 compiler mis-compiles sqlite3.c version 3.32.1. I have checked in a change to SQLite that appears to work around the problem. But there might be other bugs. Therefore, use clang-11.0.0 with caution and test your applications carefully!
30
TimescaleDB vs. Amazon Timestream
Our TimescaleDB vs Amazon Timestream results surprised us, but after intensive testing, we found Timestream slow, expensive, and missing key capabilities.