The Distributed SQL Blog

Distributed SQL Tips and Tricks – Oct 16, 2020

Distributed SQL Tips and Tricks – Oct 16, 2020

Welcome to this week’s 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 channel, Forum, GitHub, or Stackoverflow. Ok, let’s dive right in:

How to use joins in UPDATE statements

Sometimes,

Read more

The Distributed Database Behind Twitter

The Distributed Database Behind Twitter

Twitter is one of the world’s favorite places for people and brands to connect online. Powering a global service that helps people share everything from breaking news and entertainment to sports, politics, and everyday interests takes infrastructure that can adapt and evolve over time.

In his talk at the 2020 Distributed SQL Summit, Mehrdad Nurolahzade, engineer on the real-time infrastructure team at Twitter, walks us through the distributed database behind Twitter,

Read more

Presentation Recap: Kubernetes as a Universal Control Plane – Joe Beda, VMware

Presentation Recap: Kubernetes as a Universal Control Plane – Joe Beda, VMware

We were delighted to have Joe Beda, one of the original creators of Kubernetes, and Principal Engineer at VMware, give the opening keynote at this year’s 2020 Distributed SQL Summit. If you weren’t able to attend, here’s the summary and playback of his keynote presentation.

Kubernetes as a Universal Control Plane

Oftentimes systems start out with efficiency in mind (as Joe states, “to try and get as much out of your computers as you possibly could“),

Read more

Yugabyte Adopts a New Versioning System

Yugabyte Adopts a New Versioning System

Many users in the YugabyteDB community simply love the velocity with which new and exciting features are introduced through frequent releases. However, as more and more business-critical applications start depending on YugabyteDB as the system of record database, there is an increasing need for enterprises to operate existing versions in production longer and avoid adopting fast-moving releases which can go through radical design changes. It’s clear we have different groups of users, each with important needs: those who need to go into production now with the generally available features,

Read more

INSERT INTO Yugabyte (We’re Hiring, October 2020 Edition)

INSERT INTO Yugabyte (We’re Hiring, October 2020 Edition)

Recent Highlights and Happenings

It’s time for another monthly hiring blog post from the Yugabyte team! Although 2020 remains difficult in many ways both nationally and globally, it’s our hope that sharing this information and our currently open positions may be some good news to some of you at a time when it’s needed most.

Since our last post, we have had some very exciting events and announcements, including these highlights …

Read more

Version Control for Distributed SQL with Flyway’s Maven Plugin

Version Control for Distributed SQL with Flyway’s Maven Plugin

Flyway is an open source database version control and migration tool that stresses simplicity and convention over configuration. Changes to the database can be written in SQL (and in some database-specific dialects like PL/SQL and T-SQL) or Java. You interact with Flyway using a command-line client, howeer there are a variety of plugins that can be leveraged, including Maven, Gradle, Spring Boot, and more.

Supported databases include Oracle, SQL Server,

Read more

Getting Started with IntelliJ IDEA and Distributed SQL

Getting Started with IntelliJ IDEA and Distributed SQL

IntelliJ IDEA is a popular integrated development environment (IDE) written in Java for developing software. It is developed by JetBrains and is available as an ache 2 licensed community edition and in a proprietary commercial edition. IntelliJ supports a variety of datasources within their IDE. Because YugabyteDB is PostgreSQL compatible, most third-party tools and apps will work “out of the box.” IntelliJ is no exception here.

In this blog post we’ll walk you though the following steps:

  • Install a 3 node YugabyteDB cluster on Google Kubernetes Platform
  • Install the Northwind sample database
  • Configure IntelliJ to work with YugabyteDB
  • Test out some basic IntelliJ database features with YugabyteD

Step 1: Install YugabyteDB on a GKE Cluster using Helm 3

In this section we are going to install YugabyteDB on the cluster.

Read more

Use Retool to Quickly Build Distributed SQL and React Apps

Use Retool to Quickly Build Distributed SQL and React Apps

Retool is a next generation WSIWYG SaaS-based tool that enables you to quickly build React applications for internal consumption from your existing data sources using a variety of pre-built “building blocks.” Developers can choose from over 58 drag and drop components and combine them with custom JavaScript to create applications that can be securely deployed on-premise or hosted environments like Heroku. Retool supports over 30 native integrations including PostgreSQL, GraphQL, AWS S3, and Cassandra.

Read more

How Justuno Leveraged YugabyteDB to Consolidate Multiple SQL and NoSQL Databases

How Justuno Leveraged YugabyteDB to Consolidate Multiple SQL and NoSQL Databases

Justuno provides a Conversion Rate Optimization (CRO) Platform that enables e-commerce sites to turn visitors into customers through personalized onsite messaging, intelligent cross-selling, and upselling. More than 188,000 (and counting) industry leading brands improve sales and the customer experience at the same time.

At the heart of the Justuno platform is visitor intelligence data, and there’s a lot of it. Justuno tracks between 30 and 50 data points per visitor–such as time on site,

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