How To Library | Page 8 of 17

Using the PostgreSQL Recursive CTE – Part Two

March 1, 2021

Databases Distributed SQL How To PostgreSQL

Using the PostgreSQL Recursive CTE – Part Two

Computing Bacon Numbers for actors listed in the IMDb

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;

…

Using the PostgreSQL Recursive CTE – Part One

March 1, 2021

By Bryn Llewellyn

Databases Distributed SQL How To PostgreSQL

Using the PostgreSQL Recursive CTE – Part One

Traversing an employee hierarchy

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;

…

Measuring the Performance Impact of TLS Encryption Using TPC-C

February 22, 2021

By Taylor Mull

Databases Distributed SQL How To Performance Benchmarks

Measuring the Performance Impact of TLS Encryption Using TPC-C

Organizations need to protect their data, especially the personal data entrusted to them from their users and customers. In order to do so, the data transferred by a database over the network needs to be secure. This is often accomplished using TLS encryption, an encryption protocol that secures communication across a network. When secured by TLS, a communication between a client and a server can enable the two parties to identify one another (preventing any impersonation),

…

How We Learned to Stop Guessing and Love Low P-Values

February 8, 2021

By Rob Sami

Databases Distributed SQL How To Performance Benchmarks

How We Learned to Stop Guessing and Love Low P-Values

“I don’t think it’s quite fair to condemn the whole program because of a single slip up, sir.” Famous last words from Kubrick’s 1964 classic Dr. Strangelove, as a forlorn general realizes his negligence is about to lead to nuclear apocalypse. This may feel relatable to any engineer who has immediately regretted pushing the big red “release” button only to later find themselves putting out fires late into the night.

…

February 4, 2021

By Eric Pratt

Databases Distributed SQL How To

Secondary Index Migration in YugabyteDB

Introduction

YugabyteDB has a great feature in strongly consistent secondary indexes. I have been asked a few times now about how to modify existing indexes. These can range from adding another column to the index or adding another column to the INCLUDE clause. The big question at the end of the day is: how to do this without having to take downtime on the indexes? In this blog post, using the Yugabyte CQL API we will look at how to switch a live running application from using one index to another without a performance hit during the transition,

…

Applying Legal Design Thinking to the Software Development Process

February 3, 2021

By Cyrus Wadia

Community News How To

Applying Legal Design Thinking to the Software Development Process

Legal compliance for technology startups can be overwhelming. GDPR, CCPA, HIPAA, SOX, PCI, NIST — with so many long acronyms covering so many different legal frameworks, it can be hard to keep track of what applies to what, and become easy to fall into the trap of thinking you’ll deal with it later. But that can result in big technical and legal debt down the road that inhibits a startup’s growth very quickly. There is a middle road — applying legal design thinking from the beginning allows companies to innovate while at the same time choosing a legal framework for their software that meets customer needs and ensures business success.

…

A Practical Multi-Cloud Distributed SQL Strategy for 2021

January 11, 2021

By Chirag Narang

Cloud Providers Distributed SQL How To

A Practical Multi-Cloud Distributed SQL Strategy for 2021

In order to meet the needs of the growing demand of businesses, many global enterprises are choosing cloud infrastructure from multiple providers like AWS, Azure, Google, or private data centers. According to a Gartner survey of public cloud users, 81% of respondents are already using multiple clouds. Leveraging multiple clouds to support data infrastructure provides these benefits:

Reduced operating and infrastructure costs by avoiding vendor lock-in.
Improved application resilience and redundancy with geographically distributed data centers.

…

Distributed SQL Summit Recap: Mastercard’s Cloud Native Journey to Distributed Databases

December 29, 2020

By Jimmy Guerrero

Databases Distributed SQL How To

Distributed SQL Summit Recap: Mastercard’s Cloud Native Journey to Distributed Databases

At the Distributed SQL Summit 2020, Ken Owens – Vice President, Cloud Native Engineering, Mastercard, presented the talk, “The Data Divide: An End User’s Cloud Native Journey to Distributed Databases.”

Because Ken has been working at the intersection of technology and financial services for more than 20 years, he brings a unique perspective to how cloud native and distributed systems can transform, what from the outside may appear to be a slow moving industry,

…

What’s New in YugabyteDB Docs – December 2020

December 14, 2020

By Michelle Brinich

Community News Databases Distributed SQL How To Open Source

What’s New in YugabyteDB Docs – December 2020

Welcome to this latest post on 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.

As a reminder, YugabyteDB provides two distributed SQL APIs:

Yugabyte Structured Query Language (YSQL) is a fully-relational, PostgreSQL-compatible API.
Yugabyte Cloud Query Language (YCQL) is a semi-relational API with document data modeling and has its roots in the Apache Cassandra Query Language (CQL).

…

December 10, 2020

By Bhavin Gandhi

Distributed SQL How To Kubernetes

Using Linkerd with YugabyteDB

This blog post is written by guest author Bhavin Gandhi, Software Engineer at InfraCloud Technologies, Inc., in collaboration with the teams at Buoyant, the creator of Linkerd, and Yugabyte.

As more organizations turn to microservices architectures for their applications, Kubernetes naturally emerges as a perfect complement to those applications. But for application developers, building on Kubernetes can introduce complex problems to solve at the application layer. This is where service meshes like Linkerd come to the rescue and provide essential features like reliability,

…

How To

Computing Bacon Numbers for actors listed in the IMDb

Traversing an employee hierarchy

Introduction

Explore Distributed SQL and YugabyteDB in Depth