Here is an intriguing SQL puzzle we came across in the context of a real-world use case. This post shows the power of advanced RDBMS features such as partial indexes and expression indexes.
Let us assume we have a table in PostgreSQL named users, where each row in the table represents a user. The table is defined as follows.
CREATE TABLE users (
id SERIAL PRIMARY KEY,
email VARCHAR DEFAULT NULL,
name VARCHAR
);
…
JAMstack is a new way of building websites and apps. It’s not a technology but rather an architectural pattern that is growing in popularity. In JAMstack, the JAM acronym stands for JavaScript, API, and Markup, and the main idea behind the technology is that web applications don’t have to rely on the application server to be fully functional and robust.
There are four primary benefits of adopting a JAMstack architecture.
…
While it is still early days, it is exciting to see the YugabyteDB community hit some cool milestones! We wanted to share them with you, plus update you some additional community related news.
First things first. Recent events that resulted in the death of George Floyd at the hands of police have been traumatic and painful for many of us, nationally and globally. It’s clear there is an overwhelming need for racial justice,
…
It is my pleasure to announce that Yugabyte has raised $30 million in an oversubscribed Series B funding round led by 8VC, with participation from Wipro Ventures and existing investors, Lightspeed and Dell Technologies Capital. Bhaskar Ghosh from 8VC joins our board of directors along with Scott Yara, formerly of Greenplum and Pivotal Software. We are truly excited to partner with Bhaskar Ghosh and the dynamic team at 8VC,
…
We are happy to announce that the YugabyteDB Operator is now certified and available as a Beta release on Red Hat OpenShift, a leading enterprise Kubernetes platform for deploying and managing cloud native applications. Achieving certification means that customers can deploy YugabyteDB on OpenShift with confidence because the YugabyteDB container image has been secured, validated, and is well-integrated to run on OpenShift. And the solution is backed by collaborative support between Red Hat and Yugabyte,
…
In the last few years, Prometheus has gained huge popularity as a tool for monitoring distributed systems. It has a simple yet powerful data model and query language, however, it can often pose a bit of a challenge when it comes to high availability as well as for historical metric data storage. Adding more Prometheus replicas can be used to improve availability, but otherwise, Prometheus does not offer continuous availability. For example, if one of the Prometheus replicas crashes,
…
I am incredibly proud and honored to be taking on a new role as CEO of Yugabyte. When I started talking with Yugabyte’s founders, Karthik, Kannan and Mikhail, about joining the Yugabyte executive team, I was hooked. I immediately felt a strong alignment between my experiences and goals, and the opportunities ahead at Yugabyte. A lot goes into finding the right role at the right time, but three things in particular really stood out and inspired me to join Yugabyte.
…
I’m excited to welcome Bill Cook to the team as the new CEO of Yugabyte! Bill is an extraordinary leader with an exemplary record of building and scaling enterprise infrastructure companies. Bill joins us from Pivotal Software where, as co-founder and President, he was part of the leadership team that helped solidify the company as the gold standard in cloud native software development and led Pivotal through its IPO and subsequent merger with VMware in 2019.
…
Today, we are releasing a new 451 Research report: Distributed SQL, An Enabler for Globally Consistent Transactional Workloads. The report, which we commissioned, explores how database systems, sitting at the heart of the enterprise, play a key role in digital transformation initiatives.
At Yugabyte, we partner with our customers daily to help accelerate their digital initiatives, and we get a front-row seat as their business-critical applications scale to billions and billions of operations per day,
…
In YugabyteDB v2.1, we released a new feature in beta: colocated tables. And we were excited to announce the general availability of colocated tables, along with many other exciting new features, in YugabyteDB 2.2. In this post, we’ll explain what colocated tables are in a distributed SQL database, why you would need them, and how to get started.