Distributed SQL

October 14, 2021

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”,

…

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

October 8, 2021

By Dillon Pinto

Distributed SQL

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.

…

Distributed SQL Change Management Using Liquibase-YugabyteDB Extension

September 20, 2021

By Sfurti Sarah

Distributed SQL How To

Distributed SQL Change Management Using Liquibase-YugabyteDB 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.

…

September 1, 2021

By Suda Srinivasan

Community News Company News Databases Distributed SQL

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.

…

Distributed SQL Tips and Tricks – August 18th, 2021

August 18, 2021

By Marko Rajcevic

Databases Distributed SQL How To

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.

…

Announcing DSS ’21: Third Annual Distributed SQL Summit

August 17, 2021

By Bron Campbell

Community News Company News Distributed SQL

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.

…

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

July 23, 2021

By Franck Pachot

Distributed SQL How To PostgreSQL

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

YugabyteDB is PostgreSQL compatible. It uses the same protocol and SQL layer as PostgreSQL. This makes YugabyteDB compatible with a majority of database tools, because PostgreSQL is the most popular open source database on the planet. Here is an example with Arctype, a user-friendly collaborative SQL client to query and visualize data.

Setting up a database connection

1. I went to https://arctype.com/ and downloaded the client for Windows.

…

Customer Chat with Paul Gaffney of Kohl’s

July 14, 2021

By Suda Srinivasan

Customers Distributed SQL YugabyteDB

Customer Chat with Paul Gaffney of Kohl’s

A few weeks ago, Yugabyte CEO Bill Cook and I had the pleasure of speaking with Paul Gaffney, the CTO and Chief Supply Chain Officer of Kohl’s during a virtual fireside chat as part of our Catalysts of Change series. Paul is a visionary tech leader with an extensive track record of driving technology change and innovation at companies like Dick’s Sporting Goods, The Home Depot, and AAA of Northern California,

…

Distributed SQL Tips and Tricks – July 9th, 2021

July 9, 2021

By Marko Rajcevic

Databases Distributed SQL How To

Distributed SQL Tips and Tricks – July 9th, 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. This blog series would not be possible without all of the behind the scenes and community work done by YugabyteDB members such as Dorian Hoxha and Frits Hoogland. All of us here at Yugabyte also have to thank our incredible user community for their work with the technology,

…

Multi-Region YugabyteDB Deployments on Kubernetes with Istio

July 2, 2021

By Bhavin Gandhi

Databases Distributed SQL Kubernetes

Multi-Region YugabyteDB Deployments on Kubernetes with Istio

This blog post is written by guest author Bhavin Gandhi, Software Engineer at InfraCloud Technologies, Inc., in collaboration with teams at Yugabyte. InfraCloud helps startups, SMBs, and enterprises scale by adopting cloud native technologies.

As organizations deploy applications across multiple cloud regions to better meet user demand and comply with regulations such as GDPR, there is a need to distribute data across geographic regions.

…

Distributed SQL

Trendyol: Turkey’s e-commerce leader

Setting up a database connection

Explore Distributed SQL and YugabyteDB in Depth