Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
Showdown: MySQL 8 vs. PostgreSQL 10
Now that MySQL 8 and PostgreSQL 10 are out, it's a good time to revisit how the two major open source relational databases compete against each other. Before these versions, the general perception has been that while Postgres is superior in feature sets and its pedigree, MySQL is more battle
U.S. universities, rich in data, struggle to capture its value, study finds
A UCLA–MIT Press paper highlights a lack of data infrastructure and data strategy in U.S. higher education.
WebAssembly is eating the database?
User-Defined Functions: powered by WebAssembly
One way to fix your rubbish password database
Suppose for a moment that you are running a web site that has a poorly implemented password database that stores password hashes using some...
The CAP theorem. The Bad, the Bad, & the Ugly
The CAP theorem is too simplistic and too widely misunderstood to be of much use for characterizing systems.
Notes on Analytics and Tracking in Onavo Protect for iOS
Recent media coverage of Onavo Protect encouraged me to investigate the code for the iOS version of their app. I wanted to determine what…
20x faster than pgvector: HNSW index in Postgres with pg_embedding
We’re excited to announce the release of our pg_embedding extension for Postgres and LangChain! The new pg_embedding extension brings 20x the speed for 99% accuracy to graph-based approximate nearest neighbor search to your Postgres databases. While the pgvector extension with IVFFlat indexing has been a popular…
RethinkDB 1.9: Indexing and query runtime performance
This release includes massive enhancements that improve performance of many queries by orders of magnitude. See the full list of enhancements , or watch Joe Doliner ( @jdoliner ), an engineer at RethinkDB, talk about the 1.9 release in this two-minute video:
Statistical Analysis with Lisp-Stat
Version 1.0-beta
Reed-Solomon error recovery in RAID-6
A post describing a simple example how you can create your own manual error recovery solution based on what is used in RAID-6, in Python.
InfluxDB now supports Prometheus remote reads and writes natively
We were inspired after Paul Dix, Co-Founder and CTO of InfluxData spoke at PromCon and received interest in more integration between Prometheus and InfluxDB. We are excited to introduce InfluxDB Prometheus Interoperability - InfluxDB 1.4, which now sup...
32k context length text embedding models
TL;DR – We are excited to announce voyage-3 and voyage-3-lite embedding models, advancing the frontier of retrieval quality, latency, and cost. voyage-3 outperforms OpenAI v3 large by 7.55% on aver…
Pocket Watch: Verifying Exabytes of Data
Dash knows your context, your team, and your work, so your team can stay organized, easily find and share knowledge, and keep projects secure, all from one place.
Machine Learning for Hackers Table of Contents
ZIA is a place for me to “think out loud,” about my current and future research. As the author, my goals are to share my ideas, highlight new research, and possibly develop new tools along the way.
Who Contributed to PostgreSQL Development in 2020 and 2021?
I have done a few previous blog posts on who has contributed to PostgreSQL , but I did not do one last year. A couple people mentioned to me...
Quantifying the Clickbait and Linkbait in BuzzFeed Article Titles
You probably do not know that the 3 most interesting things I found will blow your mind.
Common Problems in Financial Services Reconciliation
Common problems in financial recon, for fintechs, particularly those building deposit products and managing their own ledger.
Everything I've seen on optimizing Postgres on ZFS
Looking to run Postgres on ZFS? I've gathered some of the information and sage advice out there to give you a head start on figuring out how to do it safely and efficiently.