tangled-core/cmd/dbtest/ at master · willow.sh/tangled-core · Tangled

willow.sh / tangled-core

0

Monorepo for Tangled

0

tangled-core / cmd / dbtest /

at master 1 file

Seongmin Lee appview/db: more flexible tables 5mo ago

appview/db: more flexible tables migrate tables: `stars`, `reactions`, `follows`, `public_keys` Two major changes: 1. Remove autoincrement id for these tables. AUTOINCREMENT primary key does not help much for these tables and only introduces slice performance overhead. Use default `rowid` with non-autoincrement integer instead. 2. Remove unique constraints other than `(did, rkey)` We cannot block users creating non-unique atproto records. Appview needs to handle those properly. For example, if user unstar a repo, appview should delete all existing star records pointing to that repo. To allow this, remove all constraints other than `(did, rkey)`. Minor changes done while migrating tables: - rename `thread_at` in `reactions` to `subject_at` to match with other tables - follow common column names like `did` and `created` - allow self-follow (similar reason to 2nd major change. we should block it from service layer instead) Signed-off-by: Seongmin Lee <git@boltless.me>

5 months ago