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
Config 0s 2s 2s 2s
Eval 2s 45s 45s 48s
Build 4s 1m12s 24s 29s
Test - - - -
Deploy - - - -
Suite 0s 2m00s 48s 48s

Timeline

0s10s20s30s40s