Indexing for Not-Equal in YugabyteDB Indexing for Not-Equal in PostgreSQL Indexing for Not-Equal in... Tagged with mongodb, oracle, postgres, yugabytedb.

Franck Pachot

27.01.2025

ESR (Equality, Sort, Range) rule for YugabyteDB indexes - DEV Community

TL;DR: To make developers' lives easier, MongoDB has documented a simple rule for creating an... Tagged with yugabytedb, postgres, index, mongodb.

Franck Pachot

29.01.2025

set parameter if exists - DEV Community

When you code a SQL script that must run on PostgreSQL or YugabyteDB, you may want to set additional... Tagged with yugabytedb, postgres, distributed, database.

Franck Pachot

31.01.2025

⛔ ORDER BY in Subquery - DEV Community

Here is a quick post to show the danger of not understanding how SQL and ORDER BY works. In... Tagged with yugabytedb, distributed, postgres, sql.

home›Franck Pachot

Franck Pachot

Software

Indexing for NOT EQUAL (<>,!=) in YugabyteDB, PostgreSQL, Oracle Database, SQL Server, and MongoDB - DEV Community

ESR (Equality, Sort, Range) rule for YugabyteDB indexes - DEV Community

set parameter if exists - DEV Community

⛔ ORDER BY in Subquery - DEV Community

home
›
Franck Pachot