Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
Protecting reserved roles with PostgreSQL Hooks
Using Postgres Hooks to protect functionality in your Postgres database.
Faster DISTINCT queries on PostgreSQL
Learn common performance pitfalls and discover techniques to optimize your DISTINCT PostgreSQL queries. Read the full article on the Tiger Data blog.
The many flavors of hashing
About the many types of hash functions, their use-cases, dos and don'ts, with suggestions for currently accepted algorithms.
Amundsen – Lyft’s data discovery and metadata engine
In order to increase productivity of data scientists and research scientists at Lyft, we developed a data discovery application built on…
Writing a storage engine for Postgres: An in-memory table access method (2023)
Writing a storage engine for Postgres: an in-memory Table Access Method
Using machine learning to estimate lost demand in a fulfillment chain
How Instacart uses Machine Learning to spot lost demand in its fulfillment chain
ZooKeeper: Wait-free coordination for Internet-scale systems
Zookeeper is an Apache project for providing coordination services to distributed systems. ZooKeeper aims to provide a simple kernel (a fil...
Our Hybrid lda2vec Algorithm
The goal of lda2vec is to make volumes of text useful to humans (not machines!) while still keeping the model simple to modify. It learns the powerful word r...
Study reveals scale of data-sharing from Android mobile phones
These vendor-customised Android variants transmit substantial amounts of information to the OS developer and to third parties such as Google, Microsoft, LinkedIn, and Facebook that have pre-installed system apps.
Scaling Datastores at Slack with Vitess
From the very beginning of Slack, MySQL was used as the storage engine for all our data. Slack operated MySQL servers in an active-active configuration. This is the story of how we changed our data storage architecture from the active-active clusters over to Vitess — a horizontal scaling system for MySQL. Vitess is…
Peppering (Password Storage)
Website with the collection of all the cheat sheets of the project.
Call me maybe: MongoDB (2013)
Previously in Jepsen , we discussed Redis . In this post, we’ll see MongoDB drop a phenomenal amount of data. See also: followup analyses of 2.6.7 and 3.4.0-rc3 .
Cdb: a fast, reliable, simple package for creating, reading constant databases
Packages that need to read cdb files should incorporate the necessary portions of the cdb library rather than relying on an external cdb library.