InfoQ Homepage Relational Databases Content on InfoQ

Articles

RSS Feed

Newer Older

Architecture & Design

Relational Data at the Edge: How Cloudflare Operates Distributed PostgreSQL Clusters

Explore Cloudflare's distributed PostgreSQL clusters and learn how a cross-region architecture ensures resilience. Discover how data storage and access at the edge deliver massive performance gains by reducing location-sensitive latency and why architecting for degraded states is much harder than for failure states.

Vignesh Ravichandran Justin Kwan
on Mar 21, 2024
Cloud

The Hidden Cost of Using Managed Databases

The rising popularity of managed relational databases brings hidden costs, and informed decisions are crucial for optimal use. This article shows the importance of monitoring service expenses, revising default settings, and understanding operational constraints, considering limitations like reduced flexibility and observability.

Vignesh Ravichandran
on Mar 06, 2024
Culture & Methods

Debugging outside Your Comfort Zone: Diving beneath a Trusted Abstraction

This article takes a deep dive through a complex outage in the main database cluster of a payments company. We’ll focus on the aftermath of the incident - the process of understanding what went wrong, recreating the outage in a test cluster, and coming up with a way to stop it from happening again, and dive deep into the internals of Postgres, and learn about how it stores data on disk.

Chris Sinjakli
on Jun 07, 2023
AI, ML & Data Engineering

How to Migrate an Oracle Database to MySQL Using AWS Database Migration Service

Data migration efforts are typically taken up for database consolidation, cost considerations, or migrating on-prem databases to a cloud platform. In this article, author Deepak Vohra discusses the details of migrating a local database to MySQL database on the cloud, using AWS Database Migration Service.

Deepak Vohra
on Sep 07, 2022
Architecture & Design

Creating a Secure Distributed Database Cluster Leveraging Your Existing Database Management System

The emergence of Big Data and data lakes doesn't necessarily mean the disappearance of the trusted relational database. The two can coexist, relational databases just need to adjust. For the transition we propose Database Plus, a new technology & concept applicable to any database, that answers these challenges and eliminates switching costs and vendor lock-in.

Trista Pan
on Aug 17, 2022
AI, ML & Data Engineering

API Friction Complicates Hunting for Cloud Vulnerabilities. SQL Makes it Simple

APIs can tell you everything about your cloud infrastructure, but they're hard to use and work in different ways. What if you could write simple SQL queries that call APIs for you and put results into a database? Steampipe, an open-source project that maps APIs to Postgres foreign tables, makes that dream come true. It's hard enough to reason over data. Acquiring it should be easy, and now it is.

Jon Udell
on Jul 06, 2022
Cloud

Developing a Cloud-Native Application on Microsoft Azure Using Open Source Technologies

Cloud native is a development approach that improves building, maintainability, scalability, and deployment of applications. My intention with this article is to explain, in a pragmatic way, how to build, deploy, run, and monitor a simple cloud-native application on Microsoft Azure using open-source technologies.

Andrea Grillo
on Jun 22, 2022
Java

Two Must-Have Tools for Jakarta EE Developers

The wildfly-jar-maven-plugin and the brand new wildfly-datasources-preview-galleon-pack from the WildFly project are worthy of your attention. These tools add on-the-fly generation of an Uber JAR including configuration for containerization and datasources, and make it a pleasure to write applications for Jakarta EE and WildFly.

Dennis Gesker
on Apr 01, 2022
Cloud

Evolution of Azure Synapse: Apache Spark 3.0, GPU Acceleration, Delta Lake, Dataverse Support

At Microsoft Build 2021, Azure Synapse has announced significant improvements for its Apache Spark pool, its performance, and data querying and integration capabilities. This article outlines the improvements and provides the context.

Lena Hall
on May 29, 2021
Cloud

State at the Edge: an Interview with Peter Bourgon

Building upon topics in his talk at QCon London, Peter Bourgon answers questions about edge computing, distributed data, and the complexity of synchronization.

Peter Bourgon Richard Seroter
on Jun 12, 2020
Culture & Methods

Q&A on the Book Real-World Bug Hunting

The book Real-World Bug Hunting by Peter Yaworski is a field guide to finding software vulnerabilities. It explains what ethical hacking is, explores common vulnerability types, explains how to find them, and provides suggestions for reporting bugs while getting paid for doing so.

Ben Linders Peter Yaworski
on Oct 14, 2019
AI, ML & Data Engineering

Postgres Handles More Than You Think

Thinking about scaling beyond Postgres with a data store like Redis or Elasticsearch? Think again before adopting a complex infrastructure. Postgres can scale for heavy loads and offers powerful features which are not obvious at first sight. For example, it's possible to enable in-memory caching, text search, specialized indexing, and key-value storage. Article

Jason Skowronski
on Sep 27, 2019