Start Now

Category: PostgreSQL

My Time as a Yugabyte Software Engineering Intern

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,

Read more

Distributed SQL Tips and Tricks – Aug 17, 2020

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?

Read more

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

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,

Read more

Distributed SQL Tips and Tricks – July 17, 2020

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 (http://<yb-master-ip>:7000/tables).

Read more

Announcing YugabyteDB 2.2 – Distributed SQL Made Easy

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,

Read more

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

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,

Read more

INSERT INTO Yugabyte (We’re Hiring Developer Advocates)

INSERT INTO Yugabyte (We’re Hiring Developer Advocates)

It has been an exciting last few weeks here at Yugabyte! We closed our Series B funding round, Bill Cook (formerly of Pivotal and Greenplum) joined as our new CEO, we reaffirmed our commitment to open source, and achieved a bunch of cool community adoption milestones. We are hiring for several roles across engineering, customer success, and marketing. Particularly, with a new round of funding and exploding interest in Distributed SQL,

Read more

Distributed SQL Tips and Tricks – June 29, 2020

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

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

Polymorphism in SQL part one – anyelement and anyarray

Polymorphism in SQL part one – anyelement and anyarray

The term “polymorphism”, and its inflections, has various meanings in the context of programming languages in general. Roughly, it means “chameleon-like”. Of course, Wikipedia has something to say about it, here. PostgreSQL uses it with this meaning: “Parametric polymorphism: when one or more types are not specified by name but by… symbols that can represent any type”.

The term “variadic” has a universal meaning,

Read more

Learn More to Accelerate Your Retail Business

Ready to dive deeper into distributed SQL, YugabyteDB, and Yugabyte Cloud?
Learn at Yugabyte University
Learn More
Browse Yugabyte Docs
Read More
Join the Yugabyte Community
Join Now