chainquery
chainquery copied to clipboard
Add support for lbcd & more
This PR adds support for lbcd so that lbrycrd can be forgotten. Additionally this PR:
- [x] improves sync times
- [x] fixes claimtrie sync job (that could not run at all if syncing for the first time)
- [x] adds more jobs that can be run manually
- [x] fixes a lot of random bugs
- [x] drops unused or redundant columns
- [x] updates sqlboiler to latest supported version
- [x] requires mysql8 for new data type (such as JSON)
- [x] updates old dependencies
Todo list:
- [x] add support for deterministic channel keys (https://github.com/lbryio/lbry-sdk/pull/3450)
- [ ] improve vout processing
- [x] improve claim processing
- more
This is a work in progress still, but it works!
warning: it's not recommended to run this against a production instance because the migrations included in this PR will take over 24 hours to run and can fail if not enough disk space is available (up to the same size of the biggest table on disk)
additionally, a few fields were missing or were incorrect due to bugs in the code and the migration doesn't aim at correcting those gaps. A full resync is ideal if running this one.
this runs in production so we should merge it