2131
ClickHouse vs PostgreSQL UPDATE performance comparison
See how ClickHouse’s update speed stacks up against PostgreSQL on the same data and hardware.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,338 posts.
2132
Redis as the primary data store
Le tecnologie in tempo reale stanno trasformando il digitale. Permettono interazioni immediate e autentiche🎯 Scopri come migliorano l'esperienza utente e favoriscono il coinvolgimento.
2133
Using GPT-3 for plain language incident root cause from logs
Skylar Advisor combines real-time observability data, rich operational context, and customer-owned knowledge to deliver explainable AI guidance for IT operations.
2134
Postgres SELECT DISTINCT Does Not Scale
Postgres SELECT DISTINCT performs surprisingly poorly. We explain why and how we mitigated it.
2135
Announcing Yugabyte DB 2.0 GA: High-Performance Distributed SQL
YugabyteDB 2.0 released. Read to learn about production-ready YSQL, performance benchmarks, Jepsen results, and Beta feature previews
2136
VideoPrism: A foundational visual encoder for video understanding
Posted by Long Zhao, Senior Research Scientist, and Ting Liu, Senior Staff Software Engineer, Google Research An astounding number of videos are av...
2137
Jepsen: YugaByte DB 1.3.1
2019-09-05: YugaByte’s blog post states YugaByte DB “passes Jepsen tests”. We feel obligated to state that YugaByte DB’s Jepsen test suite does not pass, though it may in the future. Race conditions in YugaByte DB’s schema system can cause correctness errors. For example, inserting rows into a freshly-created table…
2138
2139
Finding memory leaks in Postgres C code
I spent the last week looking for a memory leak in Postgres’s WAL Sender process. I spent a few days getting more acquainted with Valgrind and gcc/clang sanitizers, but ultimately got nowhere useful with them. Finally, I stumbled on the memleak program from the bcc tools collection which led me right to the source…
2140
The world of PostgreSQL wire compatibility
A wire protocol is the format for interactions between a database server and its clients. It encompasses authentication, sending queries, receiving responses, and so on. It is a description of the exact bytes sent and received by servers and clients. It does NOT encompass the actual query language itself, let alone…
2141
Real-time event aggregation at scale using Postgres with Citus
Citus is commonly used to scale out event data pipelines on top of PostgreSQL. Its ability to transparently shard data and parallelise queries over many machines makes it possible to have real-time responsiveness even with terabytes of data.
2142
Critical fix for a potential data corruption issue in PostgreSQL 9.3 and 9.4
The PostgreSQL Global Development Group has released an update with multiple functionality and security fixes to all supported versions of …
2143
Algorithmic rent-pricing litigation expands under new state and local laws
A new wave of litigation focused on violations of municipal regulations is emerging against multifamily housing landlords, many of whom are facing antitrust litigation targeting their use of certain revenue management products. The new regulations may potentially provide a simpler path to liability and the possibility…
2144
MySQL at Uber
At Uber, our MySQL® fleet is the backbone of our data infrastructure, supporting a vast array of operations critical to our platform. Uber operates an extensive MySQL fleet, consisting of over 2,300 independent clusters. Building a control plane to manage this fleet at such a massive scale, while ensuring zero…
2145
2146
DuckDB 0.7.0
The DuckDB team is happy to announce the latest DuckDB version (0.7.0) has been released. This release of DuckDB is named “Labradorius” after the Labrador Duck (Camptorhynchus labradorius) that was native to North America. To install the new version, please visit the installation guide. The full release notes can be…
2147
2148
Replacing EBS and Rethinking Postgres Storage from First Principles
Fluid Storage reimagines block storage like EBS with zero-copy forks, true elasticity, and sync replication. Built for the age of agents.
2149
2150
Apache Hudi vs. Delta Lake vs. Apache Iceberg Lakehouse Feature Comparison
A thorough comparison of the Apache Hudi™, Delta Lake, and Apache Iceberg™ data lakehouse projects across features, community, and performance benchmarks. This includes a focus on common use cases such as change data capture (CDC) and data ingestion.
2151
HTTP vs. WebSockets: Which one is the fastest for Postgres queries at the edge?
Faster is always better, especially when executing SQL queries. We recently introduced SQL-over-HTTP to our driver, which previously only supported WebSockets. Why did we do that? And which approach is faster? Our journey developing the WebSockets serverless driver We first developed the Neon driver to help developers…
2152
Why IndexedDB is slow and what to use instead
Struggling with IndexedDB performance? Discover hidden bottlenecks, advanced tuning techniques, and next-gen storage like the File System Access API.
2153
Progress in performance and scalability with CockroachDB
CockroachDB 2.1 is 50x more scalable than Amazon Aurora at less than 2% of the price per tpmC. Read on to see performance benchmarks of CockroachDB 2.1, including the latest TPC-C results.
2154
Searching 20 GB/sec: Systems Engineering Before Algorithms (2014)
SentinelOne unifies AI-powered endpoint, cloud, identity, and data protection—enhanced by our Security Data Lake for seamless and efficient cybersecurity.
2155
SVG Images from Postgres
We are excited to announce a new set of functions to generate svgs from Postgres and PostGIS! This gives you really easy maps, images, or charts directly from your database. Once you start reading through these samples, you'll want to start playing with images from your database.
2156
2157
Amazon DynamoDB On Demand
January 31, 2025: Post updated to clarify the reduced on-demand pricing and workloads recommendations. Just a few years ago, creating a database that could support your business at any scale while providing consistent low latency was a daunting task. That changed for me in 2012 while reading Werner Vogels’ blog post…
2158
Apache Iceberg now supports geospatial data types natively
Apache Iceberg and Parquet now support native geospatial types, connecting Wherobots, PostGIS, Sedona, Databricks, and Snowflake to one table format.
2159
Discovering the Computer Science Behind Postgres Indexes
Optimize continuous delivery with these Jenkins best practices, including pipeline as code, parallel stages, scripted pipeline syntax, and more.
2160
Implementing join planning in our open source Golang SQL query engine
Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.