e131f17c

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 44s 44s 47s
Build 4s 1m39s 24s 28s
Test - - - -
Deploy - - - -
Suite 0s 2m26s 47s 47s

Timeline

0s10s20s30s40s