YugabyteDB Tips
  • Home
  • About
  • Featured Videos

Category: SQL Functions

YugabyteDB Tips > SQL Functions

Generate UUIDv7 in YSQL with Better Write Efficiency

Jim KnicelyMarch 29, 2026

UUIDv7 has become a popular choice for modern applications because it combines global uniqueness with time-based ordering. That makes it appealing for […]

Read More

Why ORDER BY Can Sort a Value Differently Than What You See

Jim KnicelyMarch 19, 2026

Sometimes a query result looks wrong at first glance… until you realize YugabyteDB is doing exactly what the type system told it […]

Read More

Decode a UUID and Identify Its Version

Jim KnicelyDecember 18, 2025

UUIDs look random… but they aren’t. Every UUID encodes its version directly in the bits, and you can extract it easily in […]

Read More

Create a No-Gap Sequence in YSQL

Jim KnicelyFebruary 10, 2025

Sequences are specialized database objects in YSQL that generate unique numeric identifiers. While they are often used to create auto-incrementing primary keys […]

Read More

Posts navigation

Older posts

NOTICE

This site is not affiliated, endorsed or associated with YugabyteDB. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.

Find Us

Address
Here!

Hours
24×7

Recommended YugabyteDB Links

  • Home
  • Key Concepts
  • Docs
  • Blog
  • Forum
  • Content Library
  • Support



YugabyteDB Tips

Copyright 2025 - Knicely/Li