The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

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

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

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

Martin Roos, Head of Technology @ Fortumo

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

If you’re on the Yugabyte community Slack often,

Read More

Announcing Spring Data YugabyteDB

YugabyteDB is the database of choice for building stateful cloud native apps that require resilience and scale. YugabyteDB offers Spring developers an easy way to deploy a transactional, resilient and geo-distributed database in their application stack from the outset, while also providing flexibility and  scalability as requirements change. The Spring community has always been a major influence on what we build at Yugabyte.

Read More

Announcing YugabyteDB 2.9: Pushing the Boundaries of Relational Databases

This morning we announced the latest release of the YugabyteDB open source database, YugabyteDB 2.9! This release introduces new capabilities that push the boundaries of relational databases further than ever before. Yugabyte pioneered distributed SQL databases that combine advanced RDBMS capabilities with the resilience, scale, and geo-distribution that cloud native applications demand. Over the years, we have continued to innovate with capabilities such as distributed transactional backups,

Read More

Distributed SQL Tips and Tricks – August 18th, 2021

Welcome back to our bi-weekly tips and tricks blog where I have the pleasure of recapping some distributed SQL questions from around the Internet. I had a month long hiatus this summer, so we are making it up by adding an extra entry into this week’s edition. As always, this blog series would not be possible without all of the behind the scenes work done by Yugabeings such as Dorian Hoxha and Frits Hoogland.

Read More

Announcing DSS ’21: Third Annual Distributed SQL Summit

We are delighted to announce that registration is now open for the third annual Distributed SQL Summit! DSS 2021 will happen on September 21-23, bringing together the YugabyteDB open source user community, customers, partners and industry thought leaders to explore opportunities and experiences of embracing modern cloud native data architectures. We are planning sessions and workshops that will dive into use cases,

Read More