Distributed SQL

How a Distributed SQL Database Boosts Secondary Index Queries with Index Only Scan

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

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

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.

Read more

Distributed SQL Change Management Using Liquibase-YugabyteDB  Extension

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.

Read more

Announcing Spring Data YugabyteDB

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

Distributed SQL Tips and Tricks – August 18th, 2021

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

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

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

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.

2.

Read more

Customer Chat with Paul Gaffney of Kohl’s

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,

Read more

Distributed SQL Tips and Tricks – July 9th, 2021

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,

Read more

Multi-Region YugabyteDB Deployments on Kubernetes with Istio

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.

Read more

Explore Distributed SQL and YugabyteDB in Depth

Discover the future of data management.
Learn at Yugabyte University
Get Started Business
Browse Yugabyte Docs
Explore docs Business
PostgreSQL For Cloud Native World
Read for Free Business