b217a2da

By: Michael Lynch <git@mtlynch.io>

Store user IDs as strings

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

This also removes the integer conversion at the simpleauth session boundary so auth sessions persist the string user ID directly.

Suite timing

Time to Start Worker time Duration Time to finish
Config 0s 2s 2s 2s
Eval 2s 1m07s 1m07s 1m09s
Build 4s 7m07s 1m26s 1m31s
Test - - - -
Deploy - - - -
Suite 0s 8m17s 1m31s 1m31s

Timeline

0s10s20s30s40s50s1m1m10s1m20s1m30s