3811
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. 4,224 posts.
3812
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.
3813
A polynomial autoencoder beats PCA on transformer embeddings
A closed-form autoencoder: PCA encoder + quadratic Ridge decoder. On FiQA it gives 4× compression of mxbai-embed-large-v1 at -0.88 p.p. NDCG@10, +1.34 p.p. over PCA. No SGD, no neural networks.
3814
3815
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.
3816
Postgres SELECT DISTINCT Does Not Scale
Postgres SELECT DISTINCT performs surprisingly poorly. We explain why and how we mitigated it.
3817
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
3818
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...
3819
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…
3820
3821
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…
3822
Understanding Variance, Co-Variance, and Correlation
An explanation of Variance, Covariance and Correlation in rigorous yet clear terms providing a more general and intuitive look at these essential concepts.
3823
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…
3824
Surviving without a superuser in Postgres 16
As I've written about before , a PostgreSQL superuser always has the ability to take over the operating system account in which PostgreSQL i...
3825
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.
3826
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 …
3827
Don't test with SQLite when you use Postgres in Production
Yesterday, I was looking for some help trying to have a clean way to roll back database transactions at the end of a test in a Python TestC...
3828
First Contact with SQLite
I've been playing around with SQLite the last couple of days. I thought I knew a little about SQLite, but I didn't, and am getting my remedial education through an accelerated gauntlet. Some of what …
3829
Oops, You Wrote a Database
Those who fail to study databases are doomed to write them
3830
Event Sourcing (2005)
Capture all changes to an application state as a sequence of events.
3831
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…
3832
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…
3833
A synthetic control causal analysis of Musk's tweet on Tesla stock price
a terse analysis of tesla stock prices and how one of elon’s tweets moves them
3834
3835
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…
3836
3837
3838
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.
3839
3840
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.