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. … Read More >
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 o… Read More >
Using PostgreSQL Aggregate Functions in YugabyteDB to Analyze COVID-19 Data
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 docume… Read More >
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 s… Read More >
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… Read More >
Follow-up: Postgres Conference Webinar – Introduction to YugabyteDB
I delivered the webinar “YugabyteDB: a distributed PostgreSQL database” last week. It was hosted by Postgres Conference in a series that they’d arranged so that the speakers who’d been selecte… Read More >
Document Data Modeling in YugabyteDB with the JSON Data Types
YugabyteDB has two JSON data types, json and jsonb, to let you store documents in a column in a YSQL table and to do content-based queries with index support. YSQL is PostgreSQL compatible and it ther… Read More >
Natural versus Surrogate Primary Keys in a Distributed SQL Database
There’s a subtle, but critical, difference between the two notions business-unique key and primary key in a relational database. For example, in a “users” table, the “user_id” could be … Read More >
Four Compelling Use Cases for PostgreSQL Table Functions
Welcome to part three of a three-part series of posts on PostgreSQL's table functions. These functions can be easily leveraged in a distributed SQL database like YugabyteDB, which is PostgreSQL compat… Read More >
Implementing PostgreSQL User-Defined Table Functions in YugabyteDB
Welcome to part two of a three-part series of posts on PostgreSQL's table functions. These functions can be easily leveraged in a distributed SQL database like YugabyteDB, which is PostgreSQL compatib… Read More >
