The latest blog posts to take off on Hacker News. 2,337 posts.
Oh relational databases, that tired old relic of another age. Codd and friends were great in their time, but serious software engineers need to move on. People building Web Scale™ software You’ve probably heard a similar sentiment at some point. That relational databases were great, but they are dinosaurs that are…
Pipelines with Airflow ETL: Unveiling the Good, the Bad, and the Ugly sides of the process.
With an effort to make Notion faster and more reliable for years to come — we migrated Notion’s PostgreSQL monolith into a horizontally-partitioned database fleet.
Run PostgreSQL 14 on Kubernetes, and see how convenient it is to use distributed features like parallel remote Postgres queries!
Timescale Cloud provides a balance between a familiar developer platform and a flexible database for modern applications while retaining the ease.
[Kubegres](https://www.kubegres.io) is an open-source Kubernetes operator allowing to deploy a cluster of PostgreSql instances with data replication enabled out-of-the box. …
How a mysterious stall in database queries uncovered a performance limitation with PostgreSQL.
The PostgreSQL Global Development Group today announced the release of [PostgreSQL 14](https://www.postgresql.org/docs/14/release-14.html), the latest version of the world’s [most advanced …
Photo by Alex Wong on UnsplashWe all heard that story before: The big monolith which brings so much business value and faithfully serves our customers is starting to slow us down. The product vision is evolving towards reactive features, which means reacting in real time to multiple domain events in the right context…
Introducing Cloudflare’s S3-compatible Object Storage service, with zero egress bandwidth charges and automatic migration from S3-compatible services.
In 2019, to meet growth and availability challenges, we set a plan in motion to improve our tooling and ability to partition relational databases.
An "SQLite Archive" is a file container similar to a ZIP archive or Tarball but based on an SQLite database.
What percentile approximations are, how percentiles work in PostgreSQL, and calculating them efficiently on time-series data.
The PostgreSQL Core Team and the PostgreSQL Community Association of Canada (PGCAC) wish to provide clarification on the ownership and …
Consensys is a blockchain software company building the tools, infrastructure and research that power the new Era of Decentralized Finance, for a more secure and open economy
This article describes how PostgreSQL v14 reduces B-tree index bloat with "bottom-up index tuple deletion". A test case shows the difference.
Read blog posts about Spice.ai OSS from the team and community
Product quantization (PQ) is a popular method for dramatically compressing high-dimensional vectors to use 97% less memory, and for making nearest-neighbor search speeds 5.5x faster in our tests.
PostgreSQL subtransactions (nested transactions) may cause multiple performance and scalability issues: higher rates of XID growth and higher risks of transaction ID wraparound, performance degradation when more than PGPROC_MAX_CACHED_SUBXIDS (64) are used in a session, drastic performance slowdowns when…
DuckDB, a free and open-source analytical data management system, has a new highly efficient parallel sorting implementation that can sort much more data than fits in main memory.
In this article, I'm going to go over the basics building blocks of jq in enough depth that you will be able to understand how jq works.
Discover the latest news and app updates, stories, company insights, and plenty more about Discord, all in one place.
UC Berkeley Division of Computing, Data Science and Society2021118 points34 commentsDatabases & Data details
Twenty years ago, UC Berkeley Associate Statistics Professor Fernando Pérez started one of the foundational tools for analyzing large amounts of data in a transparent and collaborative way. We spoke with Pérez about why he started this project, what challenges he’s faced and what to expect from him and Project Jupyter…
SQLite strives to be flexible regarding the datatype of the content that it stores. For example, if a table column has a type of "INTEGER", then SQLite tries to convert anything inserted into that column into an integer. So an attempt to insert the string '123' results in an integer 123 being inserted. But if the…
Vector similarity search is a game-changer in the world of search. It allows us to efficiently search a huge range of media, from GIFs to articles — with incredible accuracy in sub-second timescales for billion+ size datasets.
A discussion of aggregation in PostgreSQL and how it integrates with the design of Timescale’s hyperfunctions.
Money is marvelously nuanced. Because different assets can be used as money, we need several categories and definitions to keep track of it. M1 describes the most liquid and widely...
