2491
You probably don't need query builders
In a previous [0] post I’ve discussed why I ditched sea-query and why sql is almostalways the best way to not re-learn something new from the beginning...
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
2492
2493
Why the KeePass format should be based on SQLite
Mohammed Ketab
2494
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
2495
2496
2497
Spaces: Scalable Object Storage on DigitalOcean
Helping millions of developers easily build, test, manage, and scale applications of any size - faster than ever before.
2498
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
2499
2500
2501
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.
2502
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.
2503
2504
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…
2505
RegreSQL: Regression Testing for PostgreSQL Queries
Stop deploying broken SQL queries. RegreSQL provides regression testing for PostgreSQL queries with performance baselines and automated warnings.
2506
Mapping hospital accessibility with OpenStreetMap
Using OpenStreetMap data to craft a self-hosted interactive map of hospital accessibility in Virginia.
2507
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.
2508
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.
2509
Forecasting in Python with Prophet
A guided walkthrough of how to use the Prophet python library to solve a common forecasting problem.
2510
Extracting city blocks from OpenStreetMap data
Extracting blocks within a city as GeoJSON polygons from OpenStreetMap data
2511
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…
2512
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.
2513
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...
2514
SELECT wat FROM sql
Thanks to Nikhil Benesch, Justin Jaffray and several decades of "wouldn't it be nice if..." for contributions.
2515
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.
2516
2517
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.
2518
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…
2519
2520
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.