The latest blog posts to take off on Hacker News. 4,224 posts.
Now that MySQL 8 and PostgreSQL 10 are out, it's a good time to revisit how the two major open source relational databases compete against each other. Before these versions, the general perception has been that while Postgres is superior in feature sets and its pedigree, MySQL is more battle
PostgreSQL trigger performance. Should we use tiggers at all? Find out how triggers perform in performance tests.
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.
pgDash is an in-depth monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
Datasette 0.22 is out with the most significant new feature I’ve added since the initial release: faceted browse. Datasette lets you deploy an instant web UI and JSON API for …
We’ve all been there! You need to make a quick, seemingly simple fix to an important production database. You compose the query, give it a once-over, and let it run. Seconds later you realize that you forgot the WHERE clause, dropped the wrong table, or made another serious mistake, and interrupt the query, but the […]
Thoughts on FOSS and fintech, layered by Mahmoud Hashemi
Cloud Memorystore is fully compatible with open source Redis, letting you migrate your applications to Google Cloud with zero code changes.
In two weeks since open sourcing FoundationDB , we’ve had an outpouring of interest.
Erica Greene describes the tool that she built to extract structured data from recipes.
Concurrency Control is a mechanism that maintains atomicity and isolation, which are two properties of the ACID, when multiple transactions run concurrently in a database.
As of March 31, 2018 we had 100,110 spinning hard drives. This review looks at the quarterly and lifetime statistics for the data drive models (Seagate, HGST, WDC, and Toshiba) in operation in our data centers.
Taking a look at MyRocks performance through some benchmark testing.
Why using cryptographic hashes doesn't make data anonymous.
Flattening a single very hot vertical Redis node into a horizontal Redis Cluster at Stripe.
Google Cloud provides managed database services for your favorite open source data stores as well as Google proprietary technologies. Today we’re announcing updates to both.
MySQL is the last major SQL database that has evolved beyond SQL-92 by introducing window functions (OVER) and common table expressions (WITH [RECURSIVE])
"There are only two hard problems in Computer Science: cache invalidation and naming things."
A post by August Lilleaas, published April 20, 2018.
IoT applications generate torrents of data. Learn how - and why - to use TimescaleDB to scale PostgreSQL by 20x and harness its power for IoT.
Funding open source software development is a complicated subject. I’m excited to announce that I’ve founded Ursa Labs ( https://ursalabs.org ), an independent development lab with the mission of innovation in data science tooling.
FoundationDB is a distributed datastore, designed from the ground up to be deployed on clusters of commodity hardware. These clusters scale well as you add machines, automatically heal from hardware failures, and have a simple API. The key-value store supports fully global, cross-row ACID transactions. That’s the…
Radar 2.0 improves machine learning performance and reduces fraud by up to an additional 25%.
Among open-source relational databases, PostgreSQL is one of the most popular—and the most sought-after by Google Cloud Platform (GCP) users. Today, we’re thrilled to announce that PostgreSQL is now generally available and fully supported for all customers on our Cloud SQL fully-managed database service.
