Blogs by: Jimmy Guerrero

September 30, 2020

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,

…

Getting Started with IntelliJ IDEA and Distributed SQL

September 29, 2020

By Jimmy Guerrero

Databases Distributed SQL How To PostgreSQL

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.

…

Use Retool to Quickly Build Distributed SQL and React Apps

September 24, 2020

By Jimmy Guerrero

Databases Distributed SQL How To PostgreSQL

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.

…

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – Sep 9, 2020

September 9, 2020

By Jimmy Guerrero

Database Migration Distributed SQL How To PostgreSQL

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – Sep 9, 2020

Welcome to this week’s tips and tricks blog where we explore both beginner and advanced YugabyteDB topics for PostgreSQL and Oracle DBAs.

Please note that most examples in the post make use of the Northwind sample database. Instructions on how to get it installed are here.

Ok, let’s dive in…

Is there a functional equivalent to Oracle’s NVL in PostgreSQL or YugabyteDB?

In a nutshell,

…

Webinar Recap: CRUD Operations with Hasura GraphQL and Distributed SQL

August 25, 2020

By Jimmy Guerrero

Databases Distributed SQL GraphQL How To PostgreSQL

Webinar Recap: CRUD Operations with Hasura GraphQL and Distributed SQL

For those of you who missed last week’s YugabyteDB Community Q&A session, which covered GraphQL fundamentals, here’s the playback:

If you are interested in further exploring the possibilities of Hasura GraphQL and Distributed SQL, check out these resources.

…

Getting Started with Hasura GraphQL Remote JOINs on Multi-Cloud Distributed SQL

August 24, 2020

By Jimmy Guerrero

Distributed SQL Google Cloud Platform GraphQL How To Kubernetes Microsoft Azure PostgreSQL

Getting Started with Hasura GraphQL Remote JOINs on Multi-Cloud Distributed SQL

Remote joins in Hasura GraphQL extend the concept of joining data across tables, to being able to join data across tables and remote data sources. In this blog post we are going to demonstrate this capability by configuring the following set up.

A 3 node YugabyteDB cluster running on GKE with a Hasura GraphQL Engine attached
A 3 node YugabyteDB cluster running on AKS with a Hasura GraphQL Engine attached
A Remote Schema and Remote Relationship configured
The ability to issue GraphQL queries that join data from two different databases,

…

Deploying a Real-Time Location App with Hasura GraphQL Engine and Distributed SQL

August 21, 2020

By Jimmy Guerrero

Databases Distributed SQL Google Cloud Platform GraphQL How To Kubernetes

Deploying a Real-Time Location App with Hasura GraphQL Engine and Distributed SQL

Hasura is one of the leading vendors in the GraphQL ecosystem. They offer an open source engine that connects to your databases and microservices, and then auto-generates a production-ready GraphQL backend. GraphQL is a query language (more specifically a specification) for your API, and a server-side runtime for executing queries by using a type system you define for your data. GraphQL is often used for microservices, mobile apps, and as an alternative to REST.

…

Run the REST Version of Spring PetClinic with Angular and Distributed SQL on GKE

August 20, 2020

By Jimmy Guerrero

Distributed SQL Google Cloud Platform Kubernetes Spring

Run the REST Version of Spring PetClinic with Angular and Distributed SQL on GKE

Java developers know that Spring Data makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. When YugabyteDB is combined with Spring, Java developers are able to leverage their familiarity with PostgreSQL while gaining the added benefits of distributed SQL. These “out-of-the-box” benefits include geo-data distribution, high performance, and horizontal scalability, which are impossible or difficult to achieve with monolithic SQL databases.

…

GraphQL & Distributed SQL Tips and Tricks – Aug 10, 2020

August 10, 2020

By Jimmy Guerrero

Databases Distributed SQL GraphQL How To

GraphQL & Distributed SQL Tips and Tricks – Aug 10, 2020

Welcome to this week’s tips and tricks blog where we explore both beginner and advanced topics on how to combine GraphQL and YugabyteDB to develop scalable APIs and services.

First things first, for those of you who might be new to either GraphQL or distributed SQL.

What’s GraphQL?

GraphQL is a query language for your API, and a server-side runtime for executing queries by using a type system you define for your data.

…

Version Control for Distributed SQL Databases with Flyway

August 5, 2020

By Jimmy Guerrero

Databases Distributed SQL How To

Version Control for Distributed SQL Databases with Flyway

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, however there are a variety of plugins that can be leveraged, including Maven, Gradle, Spring Boot, and more.

Supported databases include Oracle, SQL Server, DB2,

…

Blogs by: Jimmy Guerrero

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

Is there a functional equivalent to Oracle’s NVL in PostgreSQL or YugabyteDB?

What’s GraphQL?

Explore Distributed SQL and YugabyteDB in Depth