The Distributed SQL Blog

How Justuno Leveraged YugabyteDB to Consolidate Multiple SQL and NoSQL Databases

September 23, 2020

Apache Cassandra CockroachDB Customers Google Cloud Platform

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,

…

What’s New and Improved in YugabyteDB Docs – September 2020

September 22, 2020

By Steve Bang

Community News Databases Distributed SQL How To PostgreSQL

What’s New and Improved in YugabyteDB Docs – September 2020

Welcome to this month’s edition of what’s new and improved in YugabyteDB Docs. We’re continually adding to and updating the documentation to give you the information you need to make the most out of YugabyteDB. This post covers recent content added, and changes made, to the YugabyteDB documentation since the last posting.

YSQL

What is YSQL? Yugabyte Structured Query Language (YSQL) is a fully-relational,

…

Heroku Add-on for Yugabyte Cloud Now Available in Public Beta

September 17, 2020

By Chirag Narang

Cloud Providers Databases Distributed SQL GraphQL

Heroku Add-on for Yugabyte Cloud Now Available in Public Beta

Today, we are pleased to announce the public beta release of the Heroku Yugabyte Cloud add-on. With new accessibility to the Heroku marketplace, the process of deploying a fully-managed distributed SQL database in the cloud is now radically simple. For those of you who are new to distributed SQL, YugabyteDB is a Google Spanner-inspired, cloud native distributed SQL database that is 100% open source. It puts a premium on high performance, data resilience,

…

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,

…

Distributed SQL Summit Schedule Now Live!

September 2, 2020

By Karthik Ranganathan

Community News Company News Databases Distributed SQL Open Source

Distributed SQL Summit Schedule Now Live!

In two weeks, thought leaders, database builders, and application developers are coming together for a free online conference to push the boundaries of cloud native RDBMS forward. Distributed SQL (Virtual) Summit, now in its second year, is taking place September 15-17.

We’re excited to announce that the 2020 Distributed SQL Summit schedule is now live!

Speakers include:

VMware – Joe Beda, Principal Engineer
Trifacta/UC Berkeley –

…

Recap: YugabyteDB at KubeCon + CloudNativeCon Europe 2020

August 31, 2020

By Michelle Brinich

Community News Databases Distributed SQL

Recap: YugabyteDB at KubeCon + CloudNativeCon Europe 2020

What a great KubeCon + CloudNativeCon Europe 2020 earlier this month! We were happy to participate, sponsor, and help #KeepCloudNativeConnected.

Thank you to everyone who stopped by the YugabyteDB booth, and a big thanks to all who redeemed your virtual swag of $5 to charity. Together, your swag redemptions ended up in more than $3,000 being donated across these three charities:

Project HOPE is on the ground,

…

Row Counts of Tables in a SQL Schema & Database – PostgreSQL and YugabyteDB

August 27, 2020

By Karthik Ranganathan

Databases Distributed SQL How To PostgreSQL

Row Counts of Tables in a SQL Schema & Database – PostgreSQL and YugabyteDB

Getting total row counts of data in tables across various dimensions (per-table, per-schema, and in a given database) is a useful technique to have in one’s tool belt of SQL tricks. While there are a number of use cases for this, my scenario was to get the per-table row counts of all tables in PostgreSQL and YugabyteDB as a first sanity check after migrating an application with the pre-existing data from PostgreSQL to YugabyteDB.

…

Using Envoy Proxy’s PostgreSQL & TCP Filters to Collect Yugabyte SQL Statistics

August 26, 2020

By Sid Choudhury

Databases Distributed SQL Docker Ecosystem Integrations How To Kubernetes PostgreSQL

Using Envoy Proxy’s PostgreSQL & TCP Filters to Collect Yugabyte SQL Statistics

Layer 7 proxies like NGINX and HAProxy have been popular since the mid-2000s. The term “proxy” refers to their role as an intermediary for the traffic between an application client and an application server. The “layer 7” classification comes from the fact that these proxies take routing decisions based on URLs, IPs, TCP/UDP ports, cookies, or any information present in messages sent over a layer 7 (aka application layer) networking protocol like HTTP and gRPC.

…

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,

…

The Distributed SQL Blog

Learn More to Accelerate Your Retail Business