Welcome to the first 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 compati… Read More >
Using Stored Procedures in Distributed SQL Databases
These days, most monolithic SQL databases support stored procedures. This support first emerged in commercially available offerings in the late nineteen eighties. However, stored procedure support is … Read More >
The Benefit of Partial Indexes in Distributed SQL Databases
If 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 for this column—then the response time for inserts, updates,… Read More >
Relational Data Modeling with Foreign Keys in a Distributed SQL Database
Note added on October 31, 2019 A lot has happened since this post was published in July 2019. Back then, the current YugabyteDB version was 1.2.10. And now, it's 2.0.3. My original text included some… Read More >
Why I Moved from Oracle to YugaByte
I’m thrilled at the prospect of what lies ahead of me in my new job at YugaByte. I’ve just started in the role of Developer Advocate for YugaByte DB. This is an open source, cloud native, distribu… Read More >
