The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

Distributed SQL Summit 2021: Rajkumar Sen on Fulfilling the Data Modernization Dream

It’s critical for enterprises to modernize and democratize their database to drive digital transformation. Being stuck with legacy infrastructure only causes massive problems downstream, such as an inability to scale due to high costs, fragility, and vendor lock-in. It also creates a burden to add more infrastructure to scale with a requirement to be always-on, lowering developer productivity.

Distributed SQL databases solve this problem for enterprises by providing lower TCO,

Read More

Tutorial: Building Applications with YugabyteDB and Spark

At Distributed SQL Summit 2021, we presented a workshop on how to build an application using the YugabyteDB Spark Connector and Yugabyte Cloud to deliver business outcomes for our customers.

The YugabyteDB Spark Connector brings together the best of breed technologies Apache Spark — an industry-leading, distributed computing engine — with YugabyteDB, a modern,

Read More

Why I Joined Yugabyte

Background

Coming from an open source database background, my focus over the last number of years has been working with, and supporting sales teams globally through field marketing and events. I’ve had the opportunity to work closely with the open source community through running Percona Live and participating in many other industry events.

What I love about the open source community is that it’s far more than just a place to build and contribute to software and projects.

Read More

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,

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.

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-Cruz-Profile-Pic

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.

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,

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.

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