How To

August 25, 2021

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 Xignite Delivers Financial Data at Scale

July 16, 2021

By Dillon Pinto

Customers Databases How To

How Xignite Delivers Financial Data at Scale

At Distributed SQL Summit Asia, Qin Yu – VP, Engineering, Xignite – presented a talk on how Xignite uses YugabyteDB to power its technology infrastructure to meet the current and future data needs of its financial services and fintech customers.

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,

…

Auto-Balancing Data in YugabyteDB, a Distributed SQL Database

June 29, 2021

By Sanket Kedia

Databases Distributed SQL How To

Auto-Balancing Data in YugabyteDB, a Distributed SQL Database

YugabyteDB is a distributed, fault tolerant and highly available database with extremely low latencies for reads and writes. Data in YugabyteDB is sharded, replicated and balanced across multiple nodes that can potentially be in different availability zones, regions or even clouds for that matter. In this blog post, we look at how data balancing happens in YugabyteDB and some of the key features of YugabyteDB’s “Cluster Balancer.”

The cluster balancer runs once every second.

…

Deploy a Real-Time Polling App with Hasura Cloud and YugabyteDB Managed

June 23, 2021

By Nikhil Chandrappa

Distributed SQL GraphQL How To YugabyteDB Aeon

Deploy a Real-Time Polling App with Hasura Cloud and YugabyteDB Managed

Hasura is a leading vendor in the GraphQL ecosystem, offering a powerful alternative to REST for building microservices and mobile applications. Hasura’s open source GraphQL Engine connects to your database and instantly auto-generates a production-ready GraphQL API backend. YugabyteDB, the open source distributed SQL database, is a perfect complement to GraphQL giving you horizontal scalability, fault tolerance, and global data distribution in a single system. YugabyteDB eliminates many of the scaling and resilience limitations of a traditional monolithic RDBMS.

…

Reads in YugabyteDB – Tuning Consistency, Latency and Fault Tolerance

June 17, 2021

By Aravind Nallan

Databases Distributed SQL How To

Reads in YugabyteDB – Tuning Consistency, Latency and Fault Tolerance

Introduction

YugabyteDB is built primarily to be a CP database per the CAP theorem. It supports two interfaces – YSQL for SQL workloads and YCQL for Cassandra-like workloads. In this blog, we will primarily talk about the YCQL interface. When an application interacts with the database using the YCQL interface, the writes are always consistent and reads are consistent by default. When this level of consistency is not required, YugabyteDB supports two other types of reads:

…

How To

Introduction

Setting up a database connection

Introduction

Explore Distributed SQL and YugabyteDB in Depth