Bryn LlewellyninThe Distributed SQL BlogUsing PostgreSQL Aggregate Functions in YugabyteDB to Analyze COVID-19 Data — The Distributed SQL…YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google…Dec 1, 2020Dec 1, 2020
Bryn LlewellyninThe Distributed SQL BlogPolymorphism in SQL part two — variadic functionsYugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google…Jun 25, 2020Jun 25, 2020
Bryn LlewellyninThe Distributed SQL BlogPolymorphism in SQL part one — anyelement and anyarrayThe term “polymorphism”, and its inflections, has various meanings in the context of programming languages in general. Roughly, it means…Jun 24, 2020Jun 24, 2020
Bryn LlewellyninThe Distributed SQL BlogDocument Data Modeling in YugabyteDB with the JSON Data TypesYugabyteDB has two JSON data types, and jsonb, to let you store documents in a column in a YSQL table and to do content-based queries with…Mar 26, 2020Mar 26, 2020
Bryn LlewellyninThe Distributed SQL BlogNatural versus Surrogate Primary Keys in a Distributed SQL Database — The Distributed SQL BlogThere’s a subtle, but critical, difference between the two notions business-unique key and primary key in a relational database. For…Feb 18, 2020Feb 18, 2020
Bryn LlewellyninThe Distributed SQL BlogFour Compelling Use Cases for PostgreSQL Table FunctionsWelcome to part three of a three-part series of posts on PostgreSQL’s table functions. These functions can be easily leveraged in a…Dec 16, 2019Dec 16, 2019
Bryn LlewellyninThe Distributed SQL BlogImplementing PostgreSQL User-Defined Table Functions in YugabyteDBWelcome to part two of a three-part series of posts on PostgreSQL’s table functions. These functions can be easily leveraged in a…Dec 16, 2019Dec 16, 2019
Bryn LlewellyninThe Distributed SQL BlogAn Introduction to PostgreSQL Table Functions in YugabyteDBWelcome to the first of a three-part series of posts on PostgreSQL’s table functions. These functions can be easily leveraged in a…Dec 16, 2019Dec 16, 2019
Bryn LlewellyninThe Distributed SQL BlogUsing Stored Procedures in Distributed SQL DatabasesThese days, most monolithic SQL databases support stored procedures. This support first emerged in commercially available offerings in the…Dec 2, 2019Dec 2, 2019
Bryn LlewellyninThe Distributed SQL BlogThe Benefit of Partial Indexes in Distributed SQL DatabasesIf a partial index is used, instead of a regular one, on a nullable column-where only a small fraction of the rows have not null values…Oct 29, 2019Oct 29, 2019