Topic

til

A collection of 2 posts

TIL UUIDv4 vs UUIDv7

I've always run with UUID v4 because it's the default for the Ecto.UUID library in Elixir. However a coworker recommended UUID v7. Having never really looked into UUID other than to implement as a primary key the distinction was news to me. Effectively; * UUID v4

TIL INSERT INTO with SELECT constraints

In the past month I've had to write a lot of SQL to migrate a system and split existing "locations" into tenants ie. migrating data from a public schema to a tenant's schema is gets messy due to foreign key constraints. Order of operations