YugabyteDB Tips
  • Home
  • About
  • Featured Videos

Author: Jim Knicely

YugabyteDB Tips > Articles by: Jim Knicely

Date Offset Views (Make Old Data Look New)

Jim KnicelyApril 17, 2026

🤔 The Question You’ve got a dataset… but all the dates are from the 1970s. You want to: â—Ź Keep the original […]

Read More

No Primary Key in YSQL? YugabyteDB Still Creates One

Jim KnicelyApril 15, 2026

At first glance, YugabyteDB behaves just like PostgreSQL. You can create a table without a primary key: CREATE TABLE no_pk(id INT); No […]

Read More

AI Search on YugabyteDB with Native pgvector Integration + GCP

Jim KnicelyApril 15, 2026

🌍 The Problem: Search is Still… Dumb Most application search still relies on: â—Ź LIKE ‘%term%’ â—Ź exact keyword matching â—Ź brittle […]

Read More

How to Do a Simple Index Consistency Check

Jim KnicelyApril 13, 2026

Indexes are supposed to accurately reflect what’s in the base table. Newer versions of YugabyteDB include yb_index_check() to validate this, but if […]

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