Topics /
The most popular blog posts about databases & data on Hacker News. 170 posts.
In this post, we show you how to export data from a DynamoDB table, convert it into a more efficient format with AWS Glue, and query the data with Athena. This approach gives you a way to pull insights from your data stored in DynamoDB.
The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 11 is now available for download. This …
Common Table Expressions in PostgreSQL are a powerful SQL construct. You can think of CTEs as a view that is materialized only while the query is running. Recursive CTEs allow themselves to be called until some condition is met. This post from the Citus Data team explores how recursive CTEs work in Postgres.
Why using cryptographic hashes doesn't make data anonymous.
Posted by Umar Syed and Sergei Vassilvitskii, Research Scientists, Google AI, NYC Google BigQuery allows interactive analysis of large datasets, ma...
CockroachDB 2.1 includes a brand-new, built-from-scratch, cost-based SQL optimizer. This post explains what a cost-based SQL optimizer is, and tells the story of how we decided we really, really needed one.
FoundationDB 6.0.15, our first major release since open sourcing FoundationDB in April, is now officially available!
2019-04-10: The long fork test used in this analysis contained a bug which caused it to (in many cases) fail to identify long fork anomalies—though we did find instances of long fork using other tests. We have re-checked Dgraph 1.0.13 with a corrected checker, and its long fork tests still pass.
Lesser-known but idiomatic pandas features for those already comfortable with Pandas' basic functionality and concepts.
We dig into the challenges of in-place etcd upgrades beneath autonomous Kubernetes clusters running in air-gapped environments.
Get an in-depth look at how two leading time-series databases stack up. We compare data models, query language, reliability, performance, and more.
By Jay Judkowitz, Sr. Product Manager Like all good IT organizations, you religiously measure the performance and availability of your ser...
Backblaze has 99,636 spinning hard drives. This review looks at the quarterly and lifetime statistics for the data drive models in operation in our data centers.
May 20, 2024: As of September 2022, DynamoDB now supports 100 items per transactions. March 13, 2020: Post updated to clarify how to use transactions with global tables and the increase in the maximum number of items per transaction from 10 to 25. Over the years, customers have used Amazon DynamoDB for lots of…
Today, we're releasing two of the biggest updates in Mode's history, designed not only to make Mode more powerful, but also to make that power accessible to everyone.
Performance tuning is not trivial, but you can go a long way with a few basic guidelines. In this blog, we will discuss how you analyze the workload of the database, and then review a list of important configuration parameters to improve the performance of PostgreSQL.
Radar 2.0 improves machine learning performance and reduces fraud by up to an additional 25%.
An Oracle to PostgreSQL migration in the AWS Cloud can be a complex multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. This blog series covers the environment and configuration setups for your source Oracle database, the AWS Database Migration…
Python allows for several different approaches to parallel processing. The main issue with parallelism is knowing its limitations. We either want to parallelise IO operations or …
An interview covering our experience running PostgreSQL on on-premises Kubernetes: challenges, open source and commercial tools, and alternatives for stateful apps.
Erica Greene describes the tool that she built to extract structured data from recipes.
Michael Dexter returns to update his blog post on the different file systems and details some key developments that are unfolding. He covers what's being added to these respective file systems: OpenZFS, Btrfs, and bcachefs. Michael Dexter has invested his volunteer time and career in Open Source hypervisors and file…
You likely know I like the ZFS filesystem a lot. ZFS stores the files in B-trees in a similar fashion as InnoDB stores data.
