2491
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
2492
Why the KeePass format should be based on SQLite
Mohammed Ketab
2493
Using Countdown Clock Data to Understand the New York City Subway
Ranking the lines by reliability, the anatomy of a delay, and a case for the $19 billion subway plan
2494
2495
2496
Spaces: Scalable Object Storage on DigitalOcean
Helping millions of developers easily build, test, manage, and scale applications of any size - faster than ever before.
2497
Docker for data scientists: Introduction and use cases
Data scientists looking to learn Docker can get a brief intro and a look at how to improve your workflow
2498
2499
2500
Managed CockroachDB: Geo-Distributed Database as a Service
We’re pleased to announce the availability of Managed CockroachDB, the fully hosted and fully managed service run by Cockroach Labs that makes deploying, scaling, and managing effortless.
2501
We Analyzed 100M Headlines
Write better headlines with tactics from our analysis of 100 million headlines. Discover the best headline trigrams for Facebook, Twitter & more.
2502
2503
Wikipedia Adopts MariaDB
This past Wednesday marked a milestone in the evolution of Wikimedia’s Database infrastructure: the completion of the migration of the English and German Wikipedias, as well as Wikidata, to M…
2504
RegreSQL: Regression Testing for PostgreSQL Queries
Stop deploying broken SQL queries. RegreSQL provides regression testing for PostgreSQL queries with performance baselines and automated warnings.
2505
Mapping hospital accessibility with OpenStreetMap
Using OpenStreetMap data to craft a self-hosted interactive map of hospital accessibility in Virginia.
2506
Backblaze's Hard Drive Stats for Q1 2018
As of March 31, 2018 we had 100,110 spinning hard drives. This review looks at the quarterly and lifetime statistics for the data drive models (Seagate, HGST, WDC, and Toshiba) in operation in our data centers.
2507
Implementing a Principal Component Analysis In Python (2014)
Implementing Principal Component Analysis from scratch in Python: scatter matrices, eigenvectors, variance explained, and comparison with scikit-learn PCA.
2508
Forecasting in Python with Prophet
A guided walkthrough of how to use the Prophet python library to solve a common forecasting problem.
2509
Extracting city blocks from OpenStreetMap data
Extracting blocks within a city as GeoJSON polygons from OpenStreetMap data
2510
Visualizing SQL Plan Execution Time with FlameGraphs
Update: I wrote a follow-up article about adding Loop Counters and Row Counts to SQL Plan FlameGraphs. I also show some old examples of “Bookshelf Graph” visualizations there. Check it out after reading this post first. Introduction Brendan Gregg invented and popularized a way to profile & visualize program response…
2511
Lessons from Bug Hunters Who've Found 400 Bugs in Popular DBMSs
TiDB is the distributed SQL database built for AI agents. Vectors, transactions, and analytics in one engine with ACID guarantees and elastic scale.
2512
Making database systems usable
C. J. Date's Sigmod 1983 keynote, "Database Usability", was prescient. Usability is the most important thing to the customers. They care les...
2513
SELECT wat FROM sql
Thanks to Nikhil Benesch, Justin Jaffray and several decades of "wouldn't it be nice if..." for contributions.
2514
SQLite in Go, with and Without Cgo
Most people use the mattn/go-sqlite3 package to interact with SQLite in Go. This package uses cgo and bundles the SQLite C amalgamation files with the Go source.
2515
2516
Why PostgreSQL High Availability Matters and How to Achieve It
Achieving PostgreSQL high availability is vital for application uptime. Explore popular HA deployment options to make an informed choice that fits your needs.
2517
Amazon S3’s 15th Birthday: 5,475 Days and 100T Objects
I wrote the blog post that announced Amazon Simple Storage Service (Amazon S3) fifteen years ago today. In that post, I made it clear that the service was accessed via APIs and that it was targeted at developers, outlined a few key features, and shared pricing information. Developers found that post, started to write…
2518
2519
RAG to Riches
Today I will be regaling you with tales of marvelous cherry-picked new developments in AI, from Sam Altman's recent Uno Reverse incident to bear spraying job-hungry engineers.
2520
Apache Druid vs. Time-Series Databases
Although Druid draws ideas from a number of TSDB concepts, it is designed for a wider range of analytic use cases than those for which a TSDB is usually employed.