31
Full text search over Postgres: Elasticsearch vs. alternatives
A comprehensive comparison between Elasticsearch and PostgreSQL for search workloads.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 185 posts.
32
Postgres Incremental Backup
We walk through the incremental backup feature committed to the Postgres 17 development branch by Robert Haas. We show an example on our local machine.
33
Electric (Postgres sync engine) beta release
The Electric sync engine is now in BETA. If you haven't checked out Electric recently, it's a great time to take another look.
34
Contextual Retrieval
Contextual retrieval improves how AI systems access and use information, reducing retrieval failures in large knowledge bases.
35
36
Amazon's exabyte-scale migration from Apache Spark to Ray on EC2
Large-scale, distributed compute framework migrations are not for the faint of heart. There are backwards-compatibility constraints to maintain, performance expectations to meet, scalability limits to overcome, and the omnipresent risk of introducing breaking changes to production. This all becomes especially…
37
Amazon S3 will no longer charge for several HTTP error codes
Discover more about what's new at AWS with Amazon S3 will no longer charge for several HTTP error codes
38
My thoughts on Python in Excel
An in-depth review of Microsoft's new Python in Excel functionality
39
Sieve is simpler than LRU
SIEVE is Simpler than LRU: an Efficient Turn-Key Eviction Algorithm for Web Caches
40
Movable tree CRDTs and Loro's implementation
This article introduces the implementation difficulties and challenges of Movable Tree CRDTs when collaboration, and how Loro implements it and sorts child nodes. The algorithm has high performance and can be used in production.
41
Prisma Postgres – Runs on bare metal and unikernels
At Prisma, we believe that deploying a database should be as simple as adding a new page in Notion. Today, we are excited to share the first milestone towards this vision: Prisma Postgres® gives developers an always-on database with pay-as-you-go pricing, thanks to our unique architecture design.
42
GraphRAG is now on GitHub
GraphRAG, a graph-based approach to retrieval-augmented generation (RAG) that significantly improves question-answering over private or previously unseen datasets, is now available on GitHub. Learn more:
43
The drive stats of Backblaze storage pods
Dive into Backblaze's analysis of storage server performance, exploring Drive Stats, Storage Pods, and insights on drive failure rates since 2009.
44
An overview of distributed Postgres architectures
Marco just joined Crunchy Data and he reflects on his career in distributed systems in this post. He provides an overview of several options for approaching distributed Postgres workloads and the pros and cons of each approach.
45
Using SQLite as storage for web server static content
Why OpenRun uses a SQLite database instead of the local file system for static files.
46
How to get the most out of Postgres memory settings
Engineering deep-dives, product updates, and company news from Tembo — the platform for running coding agents across your stack.
47
Why does everyone run ancient Postgres versions?
Many companies are running old Postgres versions and missing out on many improvements. The reasons: Postgres works and upgrades suck.
48
What's new in the Postgres 16 query planner
Postgres 16 introduces quite a few improvements to the query planner and makes many SQL queries run faster than they did on previous versions of PostgreSQL. This post is a deep dive into 10 of the improvements, including code blocks and comparisons of query plan output between Postgres 15 & Postgres 16.
49
All-in-one embedding model for interleaved text, images, and screenshots
TL;DR — We are excited to announce voyage-multimodal-3, a new state-of-the-art for multimodal embeddings and a big step forward towards seamless RAG and semantic search for documents rich with both…
50
Perf Is Not Enough
Are database benchmarks still relevant ? Let's understand why it's a poor way to choose a database. | Reading time: 17 min read
51
52
53
54
55
Better RAG Results with Reciprocal Rank Fusion and Hybrid Search
Optimize your support with Assembled's Hybrid Search. Learn how we enhance RAG results using Reciprocal Rank Fusion for accurate, relevant answers.
56
Backblaze Drive Stats for Q1 2024
Analyze Backblaze's Q1 2024 hard drive stats, including annualized failure rates, average ages of failure, and insights on over 279,000 drives.
57
Transforming Postgres into a Fast OLAP Database
Introducing the search capabilities of ParadeDB.
58
Building and scaling Notion's data lake
How Notion build and grew our data lake to keep up with rapid growth
59
I want flexible queries, not RAG
There is a lot of excitement around retrieval augmented generation or “RAG.” Roughly the idea is: some of the deficiencies in current generative AI or large language models (LLMs) can b…
60
Upgrading Uber's MySQL Fleet
Learn all about our journey of successfully upgrading our MySQL fleet at Uber from v5.7 to v8.0, enhancing performance and reliability.