How To

September 20, 2021

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.

…

Connecting a Spring Boot Application to YugabyteDB Managed and Deploying It to Kubernetes on minikube

September 17, 2021

By Suda Srinivasan

How To Kubernetes Spring YugabyteDB Managed

Connecting a Spring Boot Application to YugabyteDB Managed and Deploying It to Kubernetes on minikube

Spring Boot is one of the most popular frameworks for building cloud native applications. It makes configuring an application easy and offers tons of starters to get you off the ground quickly. Each Spring Boot application is stand-alone and self-contained, which makes them easy to deploy in a distributed fashion – to containers or, even better, on Kubernetes.

YugabyteDB Managed (formerly Yugabyte Cloud) is Yugabyte’s DB-as-a-service and is a perfect match for Spring Boot applications,

…

YugabyteDB on OKE (Oracle Cloud Kubernetes)

September 3, 2021

By Franck Pachot

How To Kubernetes

YugabyteDB on OKE (Oracle Cloud Kubernetes)

We have documented how to install YugabyteDB on the main cloud providers (https://docs.yugabyte.com/latest/deploy/public-clouds). And when I joined Yugabyte, many friends from the oracle community asked me about the Oracle Cloud (OCI).

In the Oracle Cloud there are 2 ways to run containers:

Do-It-Yourself with IaaS (Infrastructure as a Service)
Obviously, you can provision some compute instances (and network and storage) running Docker and install Kubernetes (or other orchestration).

…

Connecting a Spring Boot Application to YugabyteDB Managed and Deploying It on Google Kubernetes Engine (GKE)

September 2, 2021

By Suda Srinivasan

Amazon Web Services How To Kubernetes YugabyteDB Managed

Connecting a Spring Boot Application to YugabyteDB Managed and Deploying It on Google Kubernetes Engine (GKE)

Spring Boot is a popular framework for building cloud native applications. It makes configuring an application easy and helps you off the ground quickly. Each Spring Boot application is stand-alone and self-contained, which makes all of them easy to deploy in a distributed fashion – to containers or on Kubernetes.

YugabyteDB Managed (formerly Yugabyte Cloud) is our database-as-service offering. It is a perfect match for Spring Boot applications, especially ones made highly available with Kubernetes.

…

Connecting a Spring Boot Application to YugabyteDB Managed and Deploying It on Amazon Elastic Kubernetes Service (EKS)

August 27, 2021

By Suda Srinivasan

Amazon Web Services How To Kubernetes YugabyteDB Managed

Connecting a Spring Boot Application to YugabyteDB Managed and Deploying It on Amazon Elastic Kubernetes Service (EKS)

Spring Boot is an extremely popular framework for building cloud native applications. It makes configuring an application easy and offers lots of starters to get you off the ground quickly. Each Spring Boot application is stand-alone and self-contained, which makes them easy to deploy in a distributed fashion – to containers or, even better, on Kubernetes.

YugabyteDB Managed (formerly Yugabyte Cloud) is a perfect match for Spring Boot applications,

…

Schema Versioning in YugabyteDB Using Flyway

August 25, 2021

By Amogh Shetkar

Databases How To YugabyteDB Anywhere

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, we will talk about using Flyway – one of the most popular tools that simplify schema versioning for databases –

…

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.

…

August 13, 2021

By Sanyam Singhal

How To

Using Sequelize with YugabyteDB

Sequelize is a promise-based Node.js ORM tool that allows us to interact with databases using javascript instead of SQL. In simple terms, Object Relational Mapping is a process for accessing a relational database using object-oriented languages like javascript. For more information on the features in Sequelize, you can check out their documentation site.

Sequelize Node.js package already has support for databases like Postgres, MySQL, MariaDB, SQLite, and Microsoft SQL Server.

…

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.

…

Getting Started with the Kafka Connect for YugabyteDB (beta)

July 21, 2021

By Suranjan Kumar

How To Kafka

Getting Started with the Kafka Connect for YugabyteDB (beta)

Kafka Connect is a popular tool for scaling and reliably streaming data between Apache Kafka and other data systems. It ships with a JDBC Sink which is used to insert data from Kafka to a database. Although the default JDBC Sink is good for many popular RDBMS it isn’t optimized for distributed SQL databases that provide linear scalability and high availability like YugabyteDB.

In our earlier blog introducing YugabyteDB 2.7,

…

How To

Introduction

Setting up a database connection

Explore Distributed SQL and YugabyteDB in Depth