601
A friendly guide to colours in data visualisation
A collection of tools that help you deal with color gradients & color palettes, to design better data visualizations.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
602
Labor market impacts of AI: A new measure and early evidence
We introduce "observed exposure," combining LLM capability with real Claude usage data, and share early evidence on employment effects.
603
604
SQLite Release 3.25.0 adds support for window functions
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 .
605
SQLite Release 3.37.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 .
606
Modes, Medians and Means: A Unifying Perspective
Introduction / Warning Link to heading Any traditional introductory statistics course will teach students the definitions of modes, medians and means. But, because introductory courses can’t assume that students have much mathematical maturity, the close relationship between these three summary statistics can’t be…
607
Strict Tables – Column type constraints in SQLite - Draft
SQLite strives to be flexible regarding the datatype of the content that it stores. For example, if a table column has a type of "INTEGER", then SQLite tries to convert anything inserted into that column into an integer. So an attempt to insert the string '123' results in an integer 123 being inserted. But if the…
608
pg_timeseries: Open-source time-series extension for PostgreSQL
Engineering deep-dives, product updates, and company news from Tembo — the platform for running coding agents across your stack.
609
Common statistical tests are linear models
By Jonas Kristoffer Lindeløv ( blog , profile ). Last updated: 28 June, 2019 (See changelog ). Check out the Python version and the Twitter summary .
610
Write a time-series database engine from scratch
It covers how to make a time-series database engine from scratch
611
I don't need your query language
Seriously, I don't. I'd prefer SQL.
612
Every GPU That Mattered
49 graphics cards. 30 years. From Quake to Cyberpunk.
613
Important PostgreSQL 14 update to avoid silent corruption of indexes
Join thousands of people who own a premium domain. Affordable financing available.
614
Vertically Scaling PostgreSQL
pgDash is an in-depth monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
615
616
Globally Distributed Postgres
Documentation and guides from the team at Fly.io.
617
Ten years of ClickHouse in open source
ClickHouse was released in open source on Jun 15 2016, ten years ago. Since then, it became the most popular open source analytical database with more than 2000 contributors.
618
50 years later, is two-phase locking the best we can do?
Two phase locking (2PL) was the first of the general-purpose Concurrency Controls to be invented which provided Serializability. In fact, 2P...
619
Uncloaking a Slumlord Conspiracy with Social Network Analysis
An economic justice organization uses InFlow SNA software to reveal a slumlord conspiracy
620
Migrating Uber's ledger data from DynamoDB to LedgerStore
This week, we'll dive into how we migrated Uber’s business-critical ledger data to LedgerStore. We'll detail how we moved more than a trillion entries (making up a few petabytes of data) transparently and without causing disruption, and we'll discuss what we learned during the migration.
621
Google's new pipe syntax in SQL
A new paper from Google Research describing custom syntax for analytical SQL queries that has been rolling out inside Google since February, reaching 1,600 "seven-day-active users" by August 2024. A …
622
Pgroll: zero-downtime, reversible schema migrations for Postgres
We are excited to ship the first version of pgroll, a command line tool that offers safe and reversible schema migrations for PostgreSQL
623
Use perfect hashing, instead of binary search, for keyword lookup
We've been speculating for a long time that hash-based keyword lookup ought to be faster than binary search, but up to now we hadn't found a suitable tool for generating the hash function. Joerg Sonnenberger provided the inspiration, and sample code, to show us that rolling our own generator wasn't a ridiculous idea…
624
Don't bother parsing: Just use images for RAG
If search is the game, looks matter
625
Psql command line tutorial and cheat sheet
The least you need to know about Postgres
626
Introduction to PostgreSQL Indexes
Who’s this for Basics How data is stored in disk How indexes speedup access to data Costs associated with indexes Disk Space Write operations Query planner Memory usage Types of Indexes Btree Hash BRIN GIN GiST & SP-GiST Conclusion Who’s this for This text is for developers that have an intuitive knowledge of what…
627
The Next 50 Years of Databases (2015)
Andy attempts to revive his blog by predicting what databases will look like in the year 2065.
628
Time for a WTF MySQL Moment
Documenting the reasons why I tend to prefer Postgres - even when it's my friends getting bitten.
629
The end of a myth: Distributed transactions can scale
This paper appeared in VLDB'17. The paper presents NAM-DB, a scalable distributed database system that uses RDMA (mostly 1-way RDMA) and a ...
630
Some SQL Tricks of an Application DBA
Non-trivial tips for database development