The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

Building Serverless Applications Using Spring Boot, AWS Lambda, and YugabyteDB

Introduction to Serverless Applications

Serverless applications allow developers to run code without having to provision or manage any servers; developers can just concentrate on implementing the business logic of their applications.

As workloads move to the cloud, serverless applications are gaining tremendous popularity with developers. Serverless frameworks allow developers to program for the cloud to take advantage of elastic scaling for workloads and provide cost benefits of using pay-for-use features,

Read More

Using Terraform to Provision a YugabyteDB Cluster

This blog post is written by guest author Bhavin Gandhi, Software Engineer at InfraCloud Technologies, Inc. InfraCloud helps startups, SMBs, and enterprises scale by adopting cloud-native technologies.

HashiCorp’s Terraform is an infrastructure as code (IaC) tool as well as a framework. It is used for writing the infrastructure configuration in a declarative way using HashiCorp Configuration Language (HCL) or JSON.

Read More

How Justuno Leveraged YugabyteDB to Consolidate Multiple SQL & NoSQL Databases

Justuno provides a Conversion Rate Optimization (CRO) Platform that enables e-commerce sites to turn visitors into customers through personalized onsite messaging, intelligent cross-selling, and upselling. More than 188,000 (and counting) industry leading brands improve sales and the customer experience at the same time.

At the heart of the Justuno platform is visitor intelligence data, and there’s a lot of it.

Read More

Heroku Add-on for Yugabyte Cloud Now Available in Public Beta

Today, we are pleased to announce the public beta release of the Heroku Yugabyte Cloud add-on. With new accessibility to the Heroku marketplace, the process of deploying a fully-managed distributed SQL database in the cloud is now radically simple. For those of you who are new to distributed SQL, YugabyteDB is a Google Spanner-inspired, cloud native distributed SQL database that is 100% open source.

Read More

Getting Started with Hasura GraphQL Remote JOINs on Multi-Cloud Distributed SQL

Remote Joins in Hasura GraphQL extend the concept of joining data across tables, to being able to join data across tables and remote data sources. In this blog post we are going to demonstrate this capability by configuring the following set up.

  • A 3 node YugabyteDB cluster running on GKE with a Hasura GraphQL Engine attached
  • A 3 node YugabyteDB cluster running on AKS with a Hasura GraphQL Engine attached
  • A Remote Schema and Remote Relationship configured
  • The ability to issue GraphQL queries that join data from two different databases,

Read More

Deploying a Real-Time Location App with Hasura GraphQL Engine and Distributed SQL

Hasura is one of the leading vendors in the GraphQL ecosystem. They offer an open source engine that connects to your databases and microservices, and then auto-generates a production-ready GraphQL backend. GraphQL is a query language (more specifically a specification) for your API, and a server-side runtime for executing queries by using a type system you define for your data.

Read More

Run the REST Version of Spring PetClinic with Angular and Distributed SQL on GKE

Java developers know that Spring Data makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. When YugabyteDB is combined with Spring, Java developers are able to leverage their familiarity with PostgreSQL while gaining the added benefits of Distributed SQL. These “out-of-the-box” benefits include geo-data distribution, high performance, and horizontal scalability,

Read More

Distributed SQL Change Management with Liquibase and YugabyteDB on GKE

Liquibase is an open source and extensible change management project that supports a variety of databases including Snowflake, MySQL, and PostgreSQL via JDBC. Liquibase allows users to easily define changes in SQL, XML, JSON, and YAML. These changes are then managed in a version control system so the changes can be documented, ordered, and standardized. For more information on the features and benefits of Liquibase,

Read More

Getting Started with SQLPad and Distributed SQL on Google Kubernetes Engine

SQLPad is an MIT licensed web app written in React and Node.js for writing and running SQL queries and visualizing the results. SQLPad supports PostgreSQL, MySQL, SQL Server, Crate, Vertica, Presto, SAP HANA, Cassandra, Snowflake, Google BigQuery, SQLite, and many more via ODBC. Because YugabyteDB is PostgreSQL compatible, most third-party tools and apps will work “out of the box.” SQLPad is no exception here.

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