317eb2c3

Author: Michael Lynch <git@mtlynch.io>

Committer: Michael Lynch <mtlynch@noreply.codeberg.org>

Store user IDs as UUIDv4 values (#134)

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.

Reviewed-on: https://codeberg.org/mtlynch/little-moments/pulls/134

Suite timing

Time to Start Worker time Duration Time to finish Idle
Config 0s 2s 2s 2s 0s
Eval 2s 45s 45s 48s 0s
Build 4s 1m12s 24s 29s 0s
Suite 0s 2m00s 48s 48s 0s

Timeline

0s10s20s30s40s