91
Why we spent the last month eliminating PostgreSQL subtransactions
How a mysterious stall in database queries uncovered a performance limitation with PostgreSQL.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 176 posts.
92
Common data model mistakes made by startups
Data modeling is hard. Here are some missteps to avoid when you're developing your models.
93
Postgres audit tables saved us from taking down production
Learn how audit tables helped us avoid a serious incident, and how you can create audit tables in your own Postgres databases.
94
How to make any immutable data structure distributed
Spark-style distributed datasets can be modeled with a few lines of code, using Unison's distributed computing library. This article teaches you how.
95
Building a recommendation engine inside Postgres with Python and Pandas (2020)
Learn how you can leverage Python and Pandas from directly inside PostgreSQL to build your own recommendation engine.
96
What time-weighted averages are and why you should care
Learn how time-weighted averages are calculated and why they’re so powerful for data analysis. Read the full article on the Tiger Data blog.
97
98
We need new data books, so we published one
A site around enabling companies and knowledge workers to be informed and enabled with the data they need for their work.
99
Amazon S3 Object Lambda
March 15, 2023 – You can now use S3 Object Lambda with Amazon CloudFront to tailor content for end users. August 13, 2024 – Added a note clarifying that, when following the walkthrough, you should not mark the Specify Lambda function version option that was added after this post was published. When you store data in…
100
Open-Source Babelfish for Postgres
Babelfish for PostgreSQL is an Apache-2.0 and PostgreSQL open source project that adds a Microsoft SQL Server-compatible end-point to PostgreSQL to enable your PostgreSQL database to understand the SQL Server wire protocol and commonly used SQL Server commands.
101
Realtime Postgres Row Level Security
Realtime database changes are now broadcast to authenticated users, respecting the same PostgreSQL policies that you use for Row Level Security.
102
PostgreSQL 14 on Kubernetes
Run PostgreSQL 14 on Kubernetes, and see how convenient it is to use distributed features like parallel remote Postgres queries!
103
NumPy 1.20
This NumPy release is the largest so made to date, some 684 PRs contributed by 184 people have been merged. See the list of highlights below for more details. The Python versions supported for this release are 3.7-3.9, support for Python 3.6 has been dropped. Highlights are
104
Nvidia Scientists Take Top Spots in 2021 Brain Tumor Segmentation Challenge
NVIDIA data scientists took three of the top spots in a brain tumor segmentation challenge validation phase at the prestigious MICCAI 2021.
105
SQLite Archive Files (2018)
An "SQLite Archive" is a file container similar to a ZIP archive or Tarball but based on an SQLite database.
106
Scaling Kafka at Honeycomb
See how Honeycomb reduced Kafka cost by a total of 87% per megabyte/sec of throughput w/ AWS’s new Amazon EC2 lm4gn instance family and Confluent Tiered Storage.
107
OpenZFS – dRAID, Finally
Learn about dRAID in OpenZFS 2.1. Explore its data protection capabilities, distributed hot spares, faster resilvering, and enhanced performance in this article.
108
109
Spice.ai – Open-source, time series AI for developers
Read blog posts about Spice.ai OSS from the team and community
110
Build an Elixir Redis Server that’s faster than HTTP
Build a redis server in Elixir
111
Demystifying OpenZFS 2.0
Explore the changes and reasons behind OpenZFS 2.0. This article clarifies the transition from feature flags and its impact on FreeBSD 13.
112
113
Cloudera taken private for $5.3B, acquires Datacoral and Cazena
Cloudera Blog is your source for expert guidance on the latest data and AI trends, technology innovation, best practices, success stories, and more.
114
Tips for Shipping Data Products Fast
Shipping a new data-centric product is hard, and under tight time constraints it's even harder. Here are 4 tips that are proven to help you ship new products fast.
115
Have the Tables Turned on NoSQL?
NoSQL was the next big thing in system architecture in 2011, but overall interest in it has plateaued recently. What is NoSQL, what does it have to do with modern development, and is it worth implementing in your project?
116
117
Amazon S3’s 15th Birthday: 5,475 Days and 100T Objects
I wrote the blog post that announced Amazon Simple Storage Service (Amazon S3) fifteen years ago today. In that post, I made it clear that the service was accessed via APIs and that it was targeted at developers, outlined a few key features, and shared pricing information. Developers found that post, started to write…
118
Databricks is an RDBMS
Databricks combines the best of data lakes and data warehouses.
119
120
ETL Pipelines with Airflow: The Good, the Bad and the Ugly
Pipelines with Airflow ETL: Unveiling the Good, the Bad, and the Ugly sides of the process.