PostgreSQL Library | Page 6 of 15

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

August 26, 2020

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,

…

My Time as a Yugabyte Software Engineering Intern

August 18, 2020

By Vivek Gopalan

Careers Databases Distributed SQL Open Source PostgreSQL

My Time as a Yugabyte Software Engineering Intern

February – A Unique Introduction

It was late February, and I had spent the past several weeks learning everything I could about the distributed database ecosystem. As an intern on the Investment Team at 8VC, I had gotten the chance to work on technical due diligence under Partner & CTO Bhaskar Ghosh, taking a multitude of pitches every week and constantly shifting contexts. One of those companies speaking with us was Yugabyte,

…

Distributed SQL Tips and Tricks – Aug 17, 2020

August 17, 2020

By Dorian Hoxha

Databases Distributed SQL How To PostgreSQL

Distributed SQL Tips and Tricks – Aug 17, 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 are secondary indexes stored internally in YugabyteDB?

…

July 24, 2020

By Jimmy Guerrero

Databases Distributed SQL How To PostgreSQL

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – July 24, 2020

Welcome to this week’s tips and tricks blog where we explore both beginner and advanced YugabyteDB topics for PostgreSQL and Oracle DBAs. First things first, for those of you who might be new to either distributed SQL or YugabyteDB.

What is Distributed SQL?

Distributed SQL databases are becoming popular with organizations interested in moving data infrastructure to the cloud or cloud native environments. This is often motivated by the desire to reduce TCO or move away from the horizontal scaling limitations of monolithic RDBMS like Oracle,

…

July 17, 2020

By Dorian Hoxha

Community News Databases Distributed SQL How To Open Source PostgreSQL

Distributed SQL Tips and Tricks – July 17, 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 to identify a colocated database from the rest

One way to identify a colocated table in YugabyteDB is to look at the yb-master UI page (https://<yb-master-ip>:7000/tables).

…

Announcing YugabyteDB 2.2 – Distributed SQL Made Easy

July 15, 2020

By Sid Choudhury

Community News Company News Databases Distributed SQL PostgreSQL YugabyteDB

Announcing YugabyteDB 2.2 – Distributed SQL Made Easy

We are excited to announce the general availability of YugabyteDB 2.2! The highlight of this release is that YugabyteDB now supports fully-transactional distributed backups thus making mission-critical distributed SQL deployments operationally simple, even for the most demanding enterprise environments. This release also includes critical new features such as online index builds, colocated tables, and deferred constraints. The end result is that YugabyteDB continues to make distributed SQL easy. For those of you who are new to distributed SQL,

…

July 10, 2020

By Jimmy Guerrero

Community News Distributed SQL GraphQL How To PostgreSQL

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

Welcome to this week’s tips and tricks blog where we explore topics related to combining GraphQL and YugabyteDB to develop scalable APIs and services. We’ll also review upcoming events, new documentation, and blogs that have been published since the last tips and tricks post.

This next section is for those of you who might be new to either GraphQL or distributed SQL.

What’s GraphQL?

GraphQL is a query language (more specifically a specification) for your API,

…

June 29, 2020

By Dorian Hoxha

Community News Databases Distributed SQL How To PostgreSQL

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,

…

PostgreSQL

February – A Unique Introduction

How are secondary indexes stored internally in YugabyteDB?

What is Distributed SQL?

How to identify a colocated database from the rest

What’s GraphQL?

Regular expression queries (or pattern matching queries)

Explore Distributed SQL and YugabyteDB in Depth