61
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 212 posts.
62
63
The part of Postgres we hate the most: Multi-version concurrency control
Andy Pavlo - Carnegie Mellon University,
64
Storing OpenAI embeddings in Postgres with pgvector
An example of how to build an AI-powered search engine using OpenAI's embeddings and PostgreSQL.
65
FerretDB: open-source MongoDB alternative
After many months of development, FerretDB is now production-ready. We are excited to announce the general availability of FerretDB v1.0.
66
Faster neural networks straight from JPEG (2018)
Uber AI Labs introduces a method for making neural networks that process images faster and more accurately by leveraging JPEG representations.
67
SQLite 3.42.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 .
68
69
Loro: Reimagine state management with CRDTs
Loro, our high-performance CRDTs library, is now open source. In this article, we share our vision for the local-first software development paradigm, why we're excited about it, and the current status of Loro.
70
BigQuery prices increasing by more than 100% for many users
New BigQuery pricing editions and autoscaling let you choose the right price-performance for your workloads, and pay for only what you use.
71
64-bit bank balances ‘ought to be enough for anybody’?
“640K ought to be enough for anybody.” - Supposedly Bill Gates, circa 1981.
72
Unexpected downsides of UUID keys in PostgreSQL
Understand how using UUIDs as primary keys can affect PostgreSQL performance, and how to tweak your index to avoid UUID performance pitfalls.
73
Don't use DISTINCT as a "join-fixer"
Using DISTINCT to fix duplicate rows from a SQL join is a common antipattern. It generates all the duplicates first, then sorts them away - hurting performance. Learn how to rewrite these queries using EXISTS for cleaner, faster SQL Server results.
74
An automatic indexing system for Postgres
The pganalyze Indexing Engine simulates hundreds of possible combinations to recommend missing Postgres indexes using its 'What if?' analysis.
75
Build a search engine, not a vector DB
Don’t confuse embeddings with memory. To build effective RAG, start with a search engine, not just a vector database.
76
PageRank algorithm for graph databases
What is PageRank algorithm? How can it be used in various graph database use cases? How to use it in Memgraph? If these questions are keeping you up at night, here is a blog post that will finally put your mind at ease.
77
We put a distributed database in the browser and made a game of it
TigerBeetle is a distributed financial transactions database, designed for mission critical safety. How do you test something so critical? Well, we could tell you (and we will), but why not show you?
78
Databases are the endgame for data-oriented design
For the first SpacetimeDB blog post, I’d like to clear up some confusion that I’ve seen arise in discussions about SpacetimeDB and address some general misperceptions about databases. My sense is tha…
79
LiteFS Cloud: Distributed SQLite with Managed Backups
Documentation and guides from the team at Fly.io.
80
RedPajama v2 Open Dataset with 30T Tokens for Training LLMs
RedPajama-Data-v2 is a 30 trillion token open dataset from 84 CommonCrawl dumps across five languages, with over 40 precomputed quality annotations.
81
82
When did Postgres become cool?
Craig takes a look at the history of Postgres. From the origins of the project through some of the key production features that make Postgres what it is today.
83
Excel will allow certain auto data conversions to be turned off
Based on your feedback, we've improved the Automatic Data Conversion settings, and made them also available in Excel for Mac.
84
Open and portable Postgres-as-a-service. Also available on Hetzner
With Ubicloud PostgreSQL, we are releasing an open and managed PostgreSQL, and cutting your cloud database spend by 3x.
85
Choosing a Postgres primary key
Turns out the question of which identifier to use as a Primary Key is complicated -- we're going to dive into some of the complexity and inherent trade-offs, and figure things out
86
87
How does it know I want CSV? – An HTTP trick
Forgotten parts of RFC2616
88
89
Pg_jsonschema – JSON Schema Support for Postgres
Today we're releasing pg_jsonschema, a Postgres extension for JSON validation.
90
ClickHouse Keeper: A ZooKeeper alternative written in C++
Read about why we built a resource-efficient alternative for Zookeeper from scratch in C++, what our next big step with it is, and how you can join the Keeper community.