YugabyteDB Tips
  • Home
  • About
  • Featured Videos

Author: Jim Knicely

YugabyteDB Tips > Articles by: Jim Knicely

Is the postgres User a Security Risk?

Jim KnicelyApril 19, 2026

If you’ve worked with PostgreSQL before, you probably expect to see a postgres user… and YugabyteDB includes one too. That’s because YSQL […]

Read More

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

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