D
Jul 17, 2026DocumentDB on YugabyteDB
The DocumentDB extension, providing MongoDB compatibility for PostgreSQL, is available in preview in...
Jul 17, 20267 min read0 reactions1 comments
Back to articles 
Jan 26, 2025
Jan 22, 2025
Jan 17, 2025
Jan 14, 2025
Jan 12, 2025
Jan 8, 2025
Tag archive
#yugabytedb
U
Feb 5, 2025UUIDv7 in YugabyteDB
When creating a user-defined function for inserts, such as one that generates a default value, you...
Feb 5, 20252 min read3 reactions0 comments
⛔
Jan 30, 2025⛔ ORDER BY in Subquery
Here is a quick post to show the danger of not understanding how SQL and ORDER BY works. In...
Jan 30, 20257 min read3 reactions2 comments
s
Jan 29, 2025set parameter if exists
When you code a SQL script that must run on PostgreSQL or YugabyteDB, you may want to set additional...
Jan 29, 20251 min read0 reactions0 comments
ESR (Equality, Sort, Range) rule applied to YugabyteDB and PostgreSQL indexes
TL;DR: To make developers' lives easier, MongoDB has documented a simple rule for creating an...
Jan 26, 202511 min read8 reactions1 comments
I
Jan 24, 2025Indexing for NOT EQUAL (<>,!=) in YugabyteDB, PostgreSQL, Oracle Database, SQL Server, and MongoDB
Indexing for Not-Equal in YugabyteDB Indexing for Not-Equal in PostgreSQL Indexing for Not-Equal in...
Jan 24, 202513 min read4 reactions0 comments
PostgreSQL 15 Compatibility in YugabyteDB 2.25: Top 15 Features!
The latest YugabyteDB preview release supports PostgreSQL 15. This represents a significant upgrade...
Jan 22, 20258 min read0 reactions0 comments
W
Jan 16, 2025What does NULL mean in an OUTER JOIN? ("unknown" vs. "not exists")
In a previous post, I briefly mentioned that I consider a NULL in SQL databases as an existing but...
Jan 16, 20254 min read2 reactions0 comments
Aggregates with NULL: count(), min(), max(), sum()
In the previous blog, I explained that a NULL in a column indicates an unknown value rather than a...
Jan 17, 20253 min read0 reactions0 comments
PostgreSQL plan_cache_mode
Here is a small test case to demonstrate plan_cache_mode, a PostgreSQL 12 feature available in...
Jan 14, 20256 min read2 reactions0 comments
Unique Index on NULL Values in SQL & NoSQL
NoSQL behavior: MongoDB SQL behavior: PostgreSQL and YugabyteDB A mix of both: Oracle Database You...
Jan 12, 202514 min read15 reactions0 comments
Large IntentsDB MemTable with Many Small SST Files
An SQL transaction comprises many sequential reads and writes that affect different objects. These...
Jan 8, 20255 min read5 reactions0 comments