This is the only Postgres schema you need, change my mind

2 philmcp 4 6/28/2025, 1:19:04 PM
CREATE TABLE x (

id uuid DEFAULT uuid_generate_v4() PRIMARY KEY,

data jsonb,

inserted timestamp with time zone DEFAULT now(),

updated timestamp with time zone

);

Comments (4)

roscas · 2h ago
Care to example some usage cases? And why uuid over auto-increment sequenced number?
bravesoul2 · 2h ago
Depends. Having a real schema can help with performance and correctness guarantees.
mooreds · 2h ago
Use mongoDB without using mongoDB.
philmcp · 2h ago
10x better than mongo