holy shit how did i miss this?! push notifications have been merged into mastodon master!
congrats @sorin !!!
to get an idea of why i'm making a thing about this
BEHOLD
https://github.com/tootsuite/mastodon/pull/3243
https://github.com/tootsuite/mastodon/commit/0c7c188c459117770ac1f74f70a9e65ed2be606f
the PR was opened May 22nd and merged 6 hours ago
the the work was done in 85 commits and happened almost EVERY DAY between when the PR was opened and now
fucking BRAVO 🎉
:tada: New Commit! :tada:
[update time] 7/14/2017, 5:15:32 AM(JST)
Web Push Notifications (#3243)
https://github.com/tootsuite/mastodon/commit/0c7c188c459117770ac1f74f70a9e65ed2be606f
SQL
MediaAttachment.where.not(remote_url: '').where('created_at < ?', 1.week.ago).where('NOT EXISTS (SELECT 1 FROM statuses AS reblogs WHERE reblogs.id = media_attachments.status_id AND reblogs.created_at >= ? LIMIT 1)', 1.week.ago).count
D, [2017-07-13T11:12:34.223311 #1214] DEBUG -- : (3345.8ms) 略
=> 61722
じさばどん