cef662d1

By: Michael Lynch <git@mtlynch.io>

Let SQLite assign media IDs

CreateMediaItem now relies on SQLite's INTEGER PRIMARY KEY allocation instead of computing MAX(id) + 1 in application code. Lower the media ID minimum to 1 so SQLite's first generated row ID is valid, and update TinyBeans import tests to start from the shared minimum.

Suite timing

Time to Start Worker time Duration Time to finish Idle
Config 1s 6s 6s 8s 1s
Eval 6s 55s 55s 1m01s 0s
Build 11s 7m30s 1m39s 1m50s 0s
Suite 1s 8m32s 1m49s 1m50s 1s

Timeline

0s10s20s30s40s50s1m1m10s1m20s1m30s1m40s1m50s