631
What is a database transaction?
What are database transactions and how do SQL databases isolate one transaction from another?
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,337 posts.
632
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.
633
We made Postgres writes faster, but it broke replication
Exploring LSM tree implementation in PostgreSQL for better write performance.
634
635
636
637
638
How to learn data science
What's the best way to learn data science? This guide will show you how to learn data science and stay motivated.
639
Hazelcast 3.8.3
2017-10-07: IMap is not the only datatype supporting merge: ICache is mergable as well.
640
Getting Started on Geospatial Analysis with Python, GeoJSON and GeoPandas
Learn to perform the basics of geospatial analysis using Python along with the GeoJSON and GeoPandas libraries.
641
Why is Snowflake so Valuable?
An overview of some of the reasons Snowflake is trading at 150x its revenue.
642
SQL Server on Linux public preview
This post was authored by Tiffany Wissner, Senior Director of Data Platform Marketing Today, we are excited to announce the public preview of the next release of SQL Server on Linux and Windows, which brings the power of SQL Server to both Windows – and for the first time ever – Linux.
643
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.
644
645
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.
646
PlanetScale is now generally available
PlanetScale is now GA.
647
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.
648
649
64-bit bank balances ‘ought to be enough for anybody’?
“640K ought to be enough for anybody.” - Supposedly Bill Gates, circa 1981.
650
651
SQLite 3.8.0 Release with next-generation query planner
Beginning with this release, SQLite will not compile on Windows version prior to Windows Vista (circa 2007), due to a switch to using Slim Reader/Writer Locks (SRWLs) which are faster but which are not available on WindowsXP and earlier.
652
Transforming Postgres into a Fast OLAP Database
Introducing the search capabilities of ParadeDB.
653
Colossus for Rapid Storage
Colossus’s performance comes from its stateful protocol, which plays a pivotal role in the new Rapid Storage offering launched at Google Cloud Next '25.
654
655
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.
656
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.
657
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.
658
Discovering less-known Postgres v12 features
Get to know and learn how to use some less-known features of Version 12 of PostgreSQL. You'll surely discover something new for yourself.
659
Books: an immutable double-entry accounting database service
Tracking financial transactions at scale
660
Logstash joins Elasticsearch
Logstash is an open source data collection engine with real-time pipelining capabilities. Logstash can dynamically unify data from disparate sources and...