Start Now

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

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

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

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. Many of our customers rely on the immensely popular Spring Boot framework to build microservices. 

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, YSQL tablespaces,

Read more

Schema Versioning in YugabyteDB Using Flyway

Introduction

As developers, many of us are aware of source versioning which helps us easily track and manage changes to the source code of our applications. Schema versioning is to databases what source versioning is to the applications. It helps track and manage the changes to the databases that our applications rely on.

In this blog post, we will talk about using Flyway – one of the most popular tools that simplify schema versioning for databases –

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, technologies, and best practices for adopting distributed SQL databases for any app at any scale across any cloud.

Read more

Announcing YugabyteDB 2.6

Yugabyte is on a mission to build the default database for cloud native applications and simplify operational data infrastructure. Our latest release, YugabyteDB 2.6, is a big step forward towards that goal. YugabyteDB 2.6 includes significant enhancements to the open source database and our self-managed DBaaS offering, Yugabyte Platform. These enhancements, including point in time recovery (PITR), default encryption in transit, availability of Yugabyte Platform on Microsoft Azure, Red Hat OpenShift, and VMware Tanzu, and Yugabyte Platform high availability,

Read more

Get started in any cloud, container or data center