Start Now

The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

How a Distributed SQL Database Boosts Secondary Index Queries with Index Only Scan

A distributed SQL database reads from remote nodes, which increases the need for optimal data access. From my 20 years of experience as a database consultant, here is the most overlooked optimization technique for any database that supports it: performance-critical queries should find their columns from the index structure, without making extra hops to the table.

Many myths against SQL, such as “joins don’t scale” or “analytic queries need a separate column store”,

Read more

Distributed SQL Arrives at Turkey’s Largest E-Commerce Platform

At the Distributed SQL Summit 2021, Hüseyin Demir, Senior Database Platform Engineer at Trendyol, talked about the business and technology needs that drove the company to look for a new relational database management system (RDBMS). The talk covered the detailed performance and technology evaluation conducted by Trendyol, and explained why YugabyteDB—an open source distributed SQL database for cloud native applications—was the optimal choice to power its business.

Trendyol: Turkey’s e-commerce leader

Trendyol is Turkey’s largest e-commerce platform.

Read more

YugabyteDB Open Source Community Spotlight – October 2021

The Yugabyte community is always active and its members are constantly having interesting conversations and making valuable contributions. We spotlight members of the community to recognize their contributions to making the Yugabyte community a great place.

Warren Wilfred L. Cruz, Data Solutions Architect @ EXIST Software Labs, Inc.

Twitter: https://twitter.com/wawicruz and LinkedIn: https://www.linkedin.com/in/warrencruzpostgrex

If you’re on the Yugabyte community Slack,

Read more

Introducing Yugabyte Cloud – Effortless Distributed SQL

Yugabyte Cloud unlocks the power of “any” – allowing organizations to run any app at any scale, anywhere, accessible at any time and running in any cloud. In the keynote of the Distributed SQL Summit 2021, we announced the general availability of Yugabyte Cloud to make “any” feel effortless.

Yugabyte Cloud is a fully managed offering of YugabyteDB. It delivers the power of distributed SQL with the ease of use of a cloud database service.

Read more

Distributed SQL Change Management Using Liquibase-Yugabyte Extension

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, check out their documentation site.

Read more

Connecting a Spring Boot Application to Yugabyte Cloud and Deploying It to Kubernetes on minikube

Spring Boot is one of the most popular frameworks for building cloud native applications. It makes configuring an application easy and offers tons of starters to get you off the ground quickly. Each Spring Boot application is stand-alone and self-contained, which makes them easy to deploy in a distributed fashion – to containers or, even better, on Kubernetes.

Yugabyte Cloud is a perfect match for Spring Boot applications, especially ones made highly available with Kubernetes.

Read more

A SQL Stopwatch Utility for YugabyteDB or PostgreSQL as an Alternative for “\timing on”

This blog post shows you a few ways to use SQL to implement a timer for any multi-statement operation for use with ysqlsh with YugabyteDB (or psql with PostgreSQL). These tools are the overwhelmingly common choice for all sorts of ad hoc tasks as well as for critical tasks like running installation scripts. The native \timing on” feature times only individual SQL statements.

Read more

YugabyteDB Open Source Community Spotlight – September 2021

The Yugabyte community is always active and its members are constantly having interesting conversations and making valuable contributions. We spotlight members of the community to recognize their contributions to making the Yugabyte community a great place.

Martin Roos, Head of Technology @ Fortumo

LinkedIn: https://www.linkedin.com/in/martin-roos-16ab7532/

If you’re on the Yugabyte community Slack often, you’ve seen Martin Roos. He’s an active member of the community,

Read more

YugabyteDB on OKE (Oracle Cloud Kubernetes)

We have documented how to install YugabyteDB on the main cloud providers (https://docs.yugabyte.com/latest/deploy/public-clouds). And when I joined Yugabyte, many friends from the oracle community asked me about the Oracle Cloud (OCI).

In the Oracle Cloud there are 2 ways to run containers:

  • Do-It-Yourself with IaaS (Infrastructure as a Service)
    Obviously, you can provision some compute instances (and network and storage) running Docker and install Kubernetes (or other orchestration).

Read more

Connecting a Spring Boot Application to Yugabyte Cloud and Deploying It on Google Kubernetes Engine (GKE)

Spring Boot is one of the most popular frameworks for building cloud native applications. It makes configuring an application easy and offers tons of starters to get you off the ground quickly. Each Spring Boot application is stand-alone and self-contained, which makes them easy to deploy in a distributed fashion – to containers or, even better, on Kubernetes.

Yugabyte Cloud is a perfect match for Spring Boot applications, especially ones made highly available with Kubernetes.

Read more

Get started in any cloud, container or data center