Casey Peel
Casey Peel
I've rebased the branch to fix the merge conflict. I've updated the cronjob on TEST so that just before every UTC midnight the sandbox DB gets updated from the main...
These are great feedback Michael, thanks. I'll work through them tonight.
Latest commit addresses the good feedback from @jmdyck. The aforementioned validation script still shows no functional differences between the functions in `master` and those in this sandbox.
My intent is to get this merged in before June 8th and rolled out in the June 12th deployment.
I'm not sure what we can do about it besides remove the URLs at this point. I can't find any useful content on those two areas anymore 😦
We use `past_tallies` in a few primary ways 1. To get the sum of pages done over a specific time span eg: last week, last month * A sparse table...
Resolved with https://github.com/DistributedProofreaders/dproofreaders/pull/1199
Follow-up: this decreased the number of rows in the `past_tallies` table at pgpd.net: ``` Before: 598,611,362 rows Now: 4,320,420 rows ``` And after an `optimize`, the size of the tablespace...
We might be able to use the [full-text search feature](https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html) of MySQL. That's what the forums use for their search too. I don't know exactly how it handles punctuation.
In the failure case, the first request to update the page wins and the second request will get an error, correct?