YugabyteDB Tips
  • Home
  • About
  • Featured Videos

Category: Data Types

YugabyteDB Tips > Data Types

Handling NaN in NUMERIC Columns (Postgres vs YugabyteDB)

Jim KnicelyMarch 17, 2026

đź’ˇ TL;DR PostgreSQL allows NaN in NUMERIC. YugabyteDB currently does not. The best solution is to model “NaN” explicitly in your schema, […]

Read More

Making yb-admin list_snapshots Output Valid JSON

Jim KnicelyNovember 23, 2025

🧑‍💼 Customer Story A customer recently automated their backup validation pipeline and wanted to parse snapshot metadata using: yb-admin list_snapshots show_details JSON […]

Read More

Storing 128-bit Integers in YugabyteDB (YSQL)

Jim KnicelyNovember 6, 2025

đź’ˇ Intro YSQL (like PostgreSQL) gives us INT (32-bit) and BIGINT (64-bit), but there’s no native 128-bit integer. So what happens when […]

Read More

Going Beyond 4713 BC: Storing Ancient Dates in YugabyteDB

Jim KnicelySeptember 8, 2025

When most people think about databases, they think about storing business transactions, customer activity, or financial records that span days, years, or […]

Read More

Posts navigation

Older posts
Newer 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