How To

Distributed SQL Tips and Tricks – June 29, 2020
June 29, 2020
By
Community NewsDatabasesDistributed SQLHow ToPostgreSQL

Distributed SQL Tips and Tricks – June 29, 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:

Regular expression queries (or pattern matching queries)

YugabyteDB inherits PostgreSQL upper layer,

…

Read more

Polymorphism in SQL part two – variadic functions
June 25, 2020
By
DatabasesDistributed SQLHow ToPostgreSQL

Polymorphism in SQL part two – variadic functions

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code. This is explained in the two part blog post “Distributed PostgreSQL on a Google Spanner Architecture”: (1) Storage Layer; and (2) Query Layer.

…

Read more

Real-Time Scalable GraphQL and JAMstack with Gatsby, Hasura, and YugabyteDB
June 17, 2020
By
DatabasesDistributed SQLGraphQLHow To

Real-Time Scalable GraphQL and JAMstack with Gatsby, Hasura, and YugabyteDB

JAMstack is a new way of building websites and apps. It’s not a technology but rather an architectural pattern that is growing in popularity. In JAMstack, the JAM acronym stands for JavaScript, API, and Markup, and the main idea behind the technology is that web applications don’t have to rely on the application server to be fully functional and robust.

There are four primary benefits of adopting a JAMstack architecture.

  • Higher performance driven by efficient use of static assets and Content Delivery Networks (CDNs).

…

Read more

Getting Started with Distributed SQL on Red Hat OpenShift with YugabyteDB Operator
June 4, 2020
By
Company NewsDatabasesDistributed SQLHow To

Getting Started with Distributed SQL on Red Hat OpenShift with YugabyteDB Operator

We are happy to announce that the YugabyteDB Operator is now certified and available as a Beta release on Red Hat OpenShift, a leading enterprise Kubernetes platform for deploying and managing cloud native applications. Achieving certification means that customers can deploy YugabyteDB on OpenShift with confidence because the YugabyteDB container image has been secured, validated, and is well-integrated to run on OpenShift. And the solution is backed by collaborative support between Red Hat and Yugabyte,

…

Read more

Highly Available Prometheus Metrics for Distributed SQL with Thanos on GKE
May 26, 2020
By
DatabasesDistributed SQLGoogle Cloud PlatformHow ToKubernetes

Highly Available Prometheus Metrics for Distributed SQL with Thanos on GKE

In the last few years, Prometheus has gained huge popularity as a tool for monitoring distributed systems. It has a simple yet powerful data model and query language, however, it can often pose a bit of a challenge when it comes to high availability as well as for historical metric data storage. Adding more Prometheus replicas can be used to improve availability, but otherwise, Prometheus does not offer continuous availability. For example, if one of the Prometheus replicas crashes,

…

Read more

Getting Started with YugabyteDB on Azure Kubernetes Service
May 11, 2020
By
How ToKubernetesMicrosoft AzureYugabyteDB

Getting Started with YugabyteDB on Azure Kubernetes Service

Microsoft’s Azure Kubernetes Service (AKS) offers a highly available, secure, and fully managed Kubernetes service for developers looking to host their applications on containers in the cloud. AKS features elastic provisioning, an integrated developer experience for rapid application development, enterprise security features, and the most available regions of any cloud provider.

YugabyteDB is a natural fit for AKS because it was designed to support cloud native environments since its initial design.

…

Read more

Distributed SQL Tips and Tricks – May 8, 2020
May 8, 2020
By
Community NewsDatabasesDistributed SQLHow ToOpen SourcePostgreSQL

Distributed SQL Tips and Tricks – May 8, 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 can I connect YugabyteDB with Apache Spark?

…

Read more

Spanning the Globe without Google Spanner
April 16, 2020
By
ContainersDatabasesDistributed SQLGoogle Cloud PlatformGoogle SpannerHow ToKubernetesPostgreSQL

Spanning the Globe without Google Spanner

Open Source Geo-Distributed Relational Database on Multi-Cluster Kubernetes

Google Spanner, conceived in 2007 for internal use in Google AdWords, has been rightly considered a marvel of modern software engineering. This is because it is the world’s first horizontally-scalable relational database that can be stretched not only across multiple nodes in a single data center but also across multiple geo-distributed data centers, without compromising ACID transactional guarantees. In 2012,

…

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