summaryrefslogtreecommitdiff
path: root/migrations/20241002003606_global_sequence.sql
Commit message (Collapse)AuthorAge
* Start fresh with database migrations.Owen Jacobson2024-10-04
| | | | | | The migration path from the original project inception to now was complicated and buggy, and stranded _both_ Kit and I with broken databases due to oversights and incomplete migrations. We've agreed to start fresh, once. If this is mistakenly started with an original-schema-flavour DB, startup will be aborted.
* Track event sequences globally, not per channel.Owen Jacobson2024-10-01
Per-channel event sequences were a cute idea, but it made reasoning about event resumption much, much harder (case in point: recovering the order of events in a partially-ordered collection is quadratic, since it's basically graph sort). The minor overhead of a global sequence number is likely tolerable, and this simplifies both the API and the internals.