Databases Archives - Page 2 of 29 - The Distributed SQL Blog

Community News Company News Databases Distributed SQL Open Source

October 15, 2021

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.

…

Databases Distributed SQL

October 14, 2021

by Franck Pachot

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,

…

Community News Databases

October 1, 2021

by Marko Rajcevic

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,

…

Databases How It Works

September 15, 2021

by Bryn Llewellyn

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.

…

Community News Databases

September 8, 2021

by Gavin Johnson

YugabyteDB Open Source Community Spotlight – September 2021

Martin Roos, Head of Technology @ Fortumo

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

If you’re on the Yugabyte community Slack often,

…

Community News Company News Databases Distributed SQL

September 1, 2021

by Suda Srinivasan

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.

…

Community News Company News Databases Distributed SQL Release Announcements

August 26, 2021

by Yogesh Mahajan

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,

…

Databases How To

August 25, 2021

by Amogh Shetkar

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,

…

Databases Distributed SQL How To

August 18, 2021

by Marko Rajcevic

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.

…

Community News Company News Databases Distributed SQL

August 17, 2021

by Bronwyn Campbell

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,

…