3811
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,226 posts.
3812
ClickHouse vs PostgreSQL UPDATE performance comparison
See how ClickHouse’s update speed stacks up against PostgreSQL on the same data and hardware.
3813
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.
3814
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.
3815
3816
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.
3817
Postgres SELECT DISTINCT Does Not Scale
Postgres SELECT DISTINCT performs surprisingly poorly. We explain why and how we mitigated it.
3818
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
3819
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...
3820
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…
3821
3822
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…
3823
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.
3824
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…
3825
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...
3826
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.
3827
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 …
3828
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...
3829
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 …
3830
Oops, You Wrote a Database
Those who fail to study databases are doomed to write them
3831
Event Sourcing (2005)
Capture all changes to an application state as a sequence of events.
3832
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…
3833
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…
3834
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
3835
3836
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…
3837
3838
3839
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.
3840