0821595a

By: Michael Lynch <git@mtlynch.io>

Store user IDs as UUIDv4 values

Change Little Moments user IDs from numeric uint32 values to generated UUIDv4 identifiers. Store users.id and all user foreign keys as TEXT in the initial SQLite schema because no existing database migration path is needed.

Validate user IDs when parsing strings, enforce the UUIDv4 shape in SQLite, and map Tinybeans numeric user IDs to generated Little Moments UUIDs during import.

Suite timing

Time to Start Worker time Duration Time to finish
Config 0s 2s 2s 2s
Eval 2s 57s 57s 59s
Build 4s 5m54s 1m10s 1m14s
Test - - - -
Deploy - - - -
Suite 0s 6m53s 1m14s 1m14s

Timeline

0s10s20s30s40s50s1m1m10s