The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

GraphQL & Distributed SQL Tips and Tricks – July 10, 2020

Welcome to this week’s tips and tricks blog where we explore topics related to combining GraphQL and YugabyteDB to develop scalable APIs and services. We’ll also review upcoming events, new documentation, and blogs that have been published since the last tips and tricks post.

This next section is for those of you who might be new to either GraphQL or distributed SQL.

Read More

Polymorphism in SQL part two – variadic functions

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code. This is explained in the two part blog post “Distributed PostgreSQL on a Google Spanner Architecture”: (1) Storage Layer;

Read More

Real-Time Scalable GraphQL and JAMstack with Gatsby, Hasura, and YugabyteDB

JAMstack is a new way of building websites and apps. It’s not a technology but rather an architectural pattern that is growing in popularity. In JAMstack, the JAM acronym stands for JavaScript, API, and Markup, and the main idea behind the technology is that web applications don’t have to rely on the application server to be fully functional and robust.

Read More

Getting Started with Distributed SQL on Red Hat OpenShift with YugabyteDB Operator

We are happy to announce that the YugabyteDB Operator is now certified and available as a Beta release on Red Hat OpenShift, a leading enterprise Kubernetes platform for deploying and managing cloud native applications. Achieving certification means that customers can deploy YugabyteDB on OpenShift with confidence because the YugabyteDB container image has been secured, validated, and is well-integrated to run on OpenShift.

Read More

Highly Available Prometheus Metrics for Distributed SQL with Thanos on GKE

In the last few years, Prometheus has gained huge popularity as a tool for monitoring distributed systems. It has a simple yet powerful data model and query language, however, it can often pose a bit of a challenge when it comes to high availability as well as for historical metric data storage. Adding more Prometheus replicas can be used to improve availability,

Read More

Part 1: Deploying a Distributed SQL Backend for Apache Airflow on Google Cloud

Apache Airflow is a popular platform for programmatically authoring, scheduling, and monitoring workflows. Airflow has been deployed by companies like Adobe, Airbnb, Etsy, Instacart, and Square. The advantage of defining workflows as code is that they become more maintainable, versionable, testable, and collaborative. Airflow is used to author these workflows as directed acyclic graphs (DAGs) of tasks.

Read More

Oracle vs PostgreSQL: First Glance – Testing YugabyteDB’s Compatibility

Roland Takacs wrote an interesting blog post titled Oracle vs PostgreSQL: First Glance earlier this month. The genesis for his blog post was that he was in the middle of migrating his current Oracle tech stack to Python, parquet files, and PostgreSQL. As such, Roland thought it might be a good exercise to document the various Oracle features he was accustomed to and figure out what the equivalent functionality was in PostgreSQL.

Read More

Getting Started with Distributed SQL on Azure Kubernetes Service

Microsoft’s Azure Kubernetes Service (AKS) offers a highly available, secure, and fully managed Kubernetes service for developers looking to host their applications on containers in the cloud. AKS features elastic provisioning, an integrated developer experience for rapid application development, enterprise security features, and the most available regions of any cloud provider.

Getting Started with Distributed SQL on Azure Kubernetes Service how to tutorial

YugabyteDB is a natural fit for AKS because it was designed to support cloud native environments since its initial design.

Read More