I support this. I wrote a Sqlite plugin for KSUIDs, but at the end I never used them, since all I do can be handled by integer primary keys, which sqlite maps to the rowid automatically. Autoincrement is only required, if you want to prevent the reuse of ids in deleted rows.

For a database primary key, yeah. Just use serial.

...if you work specifically on web applications with a centralized database.

Some of us don't, so these types of universal proclamations are rather unhelpful.

another benefit of not using UUID:

for AI heavy apps/agent they are token expensive