The Distributed SQL Blog

YSQL Development Intermediate Training Recap – April 22, 2021

YSQL Development Intermediate Training Recap – April 22, 2021

Yesterday we delivered our free “YSQL Development Intermediate” community training and certification class. If you weren’t able to make it, here’s what you missed…

Course Content

In this 90 min training aimed at beginner and intermediate SQL developers, we covered the following topics:

  • YugabyteDB review and setup
  • Constraints
  • UDFs, expressions, and operators
  • Indexes
  • Views
  • Triggers
  • Extensions

We worked through over 40 exercises that showed how developers can immediately leverage their PostgreSQL knowledge and apply it to YugabyteDB.

Read more

Distributed SQL Tips and Tricks – April 21, 2021

Distributed SQL Tips and Tricks – April 21, 2021

Welcome back to our bi-weekly tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation, and blogs that have been published recently. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stack Overflow. Let’s get into it:

Importing a Large Table Using Smaller Transactions

When first playing around with YugabyteDB many users import existing data from other databases,

Read more

Creating a Centralized Consent Database for 80M Citizens Across 100k+ Companies

Creating a Centralized Consent Database for 80M Citizens Across 100k+ Companies

At this year’s Distributed SQL Summit Asia 2021, Cetin Yalcin Gulec, Shivam Arora, and Cem Aladogan from Softtech presented the talk, “Creating a Centralized Commercial Consent Database for 80M Citizens Across 100k+ Companies.” In this post you can find a summary of the talk, some of the presentation highlights, as well as links to this talk and others from the event.

A Quick Introduction to Softtech

Cem kicked things off with a quick introduction to Softtech.

Read more

Distributed SQL Tips and Tricks – April 7, 2021

Distributed SQL Tips and Tricks – April 7, 2021

Welcome back to our bi-weekly tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation, and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channelForumGitHub, or Stack Overflow. Let’s dive right in:

How to create client certs and propagate those on the yb-nodes using the YSQL API

There was a behavior change for the YSQL API after YugabyteDB version 2.5.2 where client certs are no longer required to authenticate to a TLS enabled cluster.

Read more

An Adventure in Multi-Cloud with Kubernetes and Distributed Data

An Adventure in Multi-Cloud with Kubernetes and Distributed Data

At this year’s Distributed SQL Summit Asia 2021, Leon Kuperman from CAST AI presented the talk, “An Adventure in Multi-Cloud with Kubernetes and Distributed Data.”

Setting the Scene

CAST AI is an AI-driven cloud optimization platform for Kubernetes that helps companies cut their cloud bill and prevent downtime. In the presentation, Leon walks through how to deploy a highly available YugaybteDB cluster across three cloud providers (AWS,

Read more

What’s New in YugabyteDB Docs – March 2021

What’s New in YugabyteDB Docs – March 2021

Welcome to the latest edition of what’s new and improved in Yugabyte Docs. We’re always adding new and updating existing documentation to provide you with the most up-to-date information on YugabyteDB, Yugabyte Platform, and our database ecosystem.

YugabyteDB Core

We had previously launched the Explore section to help users get started with YugabyteDB. YugabyteDB is an open source distributed SQL database that uniquely combines enterprise-grade RDBMS capabilities with the horizontal scalability and resilience of cloud native architectures.

Read more

Fortune 500 Financial Services Company Chooses YugabyteDB to Support Microservices and Mainframe Migration Initiatives

Fortune 500 Financial Services Company Chooses YugabyteDB to Support Microservices and Mainframe Migration Initiatives

A large, global financial services company is pursuing digital transformation initiatives across the board, with its biggest priorities focused around application modernization. Their goals were to untether from the mainframe, consolidate its numerous database technologies, and migrate to a modern microservices-oriented, cloud native architecture. Learn how they did it and the benefits they achieved.

Read more

Getting Started with DBeaver EE and YugabyteDB Cloud Query Language (YCQL)

Getting Started with DBeaver EE and YugabyteDB Cloud Query Language (YCQL)

Developers and DBAs widely use SQL editors to design database schemas, write ad hoc queries, troubleshoot, and manage the security policies and database users. For these reasons, it is essential for us as builders of YugabyteDB to bring native integration with popular database tools like DBeaver.

If you are following the YugabyteDB project and our blog posts, you’ll know YugabyteDB currently supports two APIs – YSQL and YCQL (NoSQL) – for querying the database.

Read more

How my Wish to Contribute to Open Source Lead me To Join Yugabyte

How my Wish to Contribute to Open Source Lead me To Join Yugabyte

Databases are omnipresent

Back in 2016 I started at Nutanix, fresh after finishing my graduate studies. This was barely a couple of weeks after two of Nutanix’s employees, Karthik and Kannan, left to start Yugabyte with Mikhail Bautin. They were still the subject of a few watercooler chats at Nutanix, mainly because of their bold decision to enter the database market, one that is definitely not known for being easy.

It became apparent to me why databases are hard.

Read more

Explore Distributed SQL and YugabyteDB in Depth

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