@ben_lubar's MongoDB !!SCIENCE!! thread
-
Some people asked me to figure out which posts the top likers in /t/1000 were missing.
db.objects.aggregate([ {$match: {_key: 'tid:11847:posts'}}, {$sort: {score: 1}}, {$group: {_id: null, posts: {$push: '$value'}}}, {$project: {posts: {$concatArrays: [['11847'], '$posts']}}}, {$project: {pid: '$posts', posts: '$posts'}}, {$unwind: '$pid'}, {$project: {posts: '$posts', pid: '$pid', likeKey: {$concat: ['pid:', '$pid', ':upvote']}}}, {$lookup: {from: 'objects', localField: 'likeKey', foreignField: '_key', as: 'likes'}}, {$unwind: '$likes'}, {$project: {posts: '$posts', pid: '$pid', uid: '$likes.members'}}, {$unwind: '$uid'}, {$group: {_id: '$uid', posts: {$first: '$posts'}, liked: {$push: '$pid'}}}, {$project: {uid: {$concat: ['user:', '$_id']}, missed: {$setDifference: ['$posts', '$liked']}}}, {$project: {uid: '$uid', missed: '$missed', numMissed: {$size: '$missed'}}}, {$sort: {numMissed: 1}}, {$match: {numMissed: {$lt: 1000}}}, {$lookup: {from: 'objects', localField: 'uid', foreignField: '_key', as: 'user'}}, {$unwind: '$user'} ], {allowDiskUse: true}).map(function(u) { return '<details><summary>@' + u.user.userslug + ' is missing ' + u.numMissed + ' likes!</summary>\n\n' + u.missed.map(function(pid) { return '- https://what.thedailywtf.com/post/' + pid; }).join('\n') + '\n\n</details>'; }).join('\n\n');
@anotherusername is missing 31 likes!
- https://what.thedailywtf.com/post/1002454
- https://what.thedailywtf.com/post/1002472
- https://what.thedailywtf.com/post/1002509
- https://what.thedailywtf.com/post/1002515
- https://what.thedailywtf.com/post/1002527
- https://what.thedailywtf.com/post/1002529
- https://what.thedailywtf.com/post/1002533
- https://what.thedailywtf.com/post/1002539
- https://what.thedailywtf.com/post/1107986
- https://what.thedailywtf.com/post/1110816
- https://what.thedailywtf.com/post/1113703
- https://what.thedailywtf.com/post/1120560
- https://what.thedailywtf.com/post/1121416
- https://what.thedailywtf.com/post/1121486
- https://what.thedailywtf.com/post/1122027
- https://what.thedailywtf.com/post/1124272
- https://what.thedailywtf.com/post/1124332
- https://what.thedailywtf.com/post/1125708
- https://what.thedailywtf.com/post/1125710
- https://what.thedailywtf.com/post/1125899
- https://what.thedailywtf.com/post/1125926
- https://what.thedailywtf.com/post/1125930
- https://what.thedailywtf.com/post/1125934
- https://what.thedailywtf.com/post/1125960
- https://what.thedailywtf.com/post/1125962
- https://what.thedailywtf.com/post/1126029
- https://what.thedailywtf.com/post/1126068
- https://what.thedailywtf.com/post/1126718
- https://what.thedailywtf.com/post/1126728
- https://what.thedailywtf.com/post/1126731
- https://what.thedailywtf.com/post/1126732
@vault_dweller is missing 33 likes!
- https://what.thedailywtf.com/post/388077
- https://what.thedailywtf.com/post/388145
- https://what.thedailywtf.com/post/411262
- https://what.thedailywtf.com/post/411332
- https://what.thedailywtf.com/post/412773
- https://what.thedailywtf.com/post/412794
- https://what.thedailywtf.com/post/438717
- https://what.thedailywtf.com/post/481849
- https://what.thedailywtf.com/post/481870
- https://what.thedailywtf.com/post/484231
- https://what.thedailywtf.com/post/484245
- https://what.thedailywtf.com/post/511068
- https://what.thedailywtf.com/post/534019
- https://what.thedailywtf.com/post/534055
- https://what.thedailywtf.com/post/557881
- https://what.thedailywtf.com/post/571478
- https://what.thedailywtf.com/post/573984
- https://what.thedailywtf.com/post/579137
- https://what.thedailywtf.com/post/580004
- https://what.thedailywtf.com/post/614441
- https://what.thedailywtf.com/post/618888
- https://what.thedailywtf.com/post/629196
- https://what.thedailywtf.com/post/629199
- https://what.thedailywtf.com/post/637864
- https://what.thedailywtf.com/post/657576
- https://what.thedailywtf.com/post/1125340
- https://what.thedailywtf.com/post/1125357
- https://what.thedailywtf.com/post/1125366
- https://what.thedailywtf.com/post/1125371
- https://what.thedailywtf.com/post/1125723
- https://what.thedailywtf.com/post/1126618
- https://what.thedailywtf.com/post/1126904
- https://what.thedailywtf.com/post/1126920
-
@ben_lubar I only tested the first two, but they're both his own posts, which of course he cannot vote on.
-
@boomzilla said in @ben_lubar's MongoDB !!SCIENCE!! thread:
@ben_lubar I only tested the first two, but they're both his own posts, which of course he cannot vote on.
Well, damn.
-
(do I win a prize for first MLP science meme?)
-
@izzion said in @ben_lubar's MongoDB !!SCIENCE!! thread:
(do I win a prize for first MLP science meme?)
-
@boomzilla tested all 31, they're all selfposts.
var pids = ` https://what.thedailywtf.com/post/1002454 https://what.thedailywtf.com/post/1002472 https://what.thedailywtf.com/post/1002509 https://what.thedailywtf.com/post/1002515 https://what.thedailywtf.com/post/1002527 https://what.thedailywtf.com/post/1002529 https://what.thedailywtf.com/post/1002533 https://what.thedailywtf.com/post/1002539 https://what.thedailywtf.com/post/1107986 https://what.thedailywtf.com/post/1110816 https://what.thedailywtf.com/post/1113703 https://what.thedailywtf.com/post/1120560 https://what.thedailywtf.com/post/1121416 https://what.thedailywtf.com/post/1121486 https://what.thedailywtf.com/post/1122027 https://what.thedailywtf.com/post/1124272 https://what.thedailywtf.com/post/1124332 https://what.thedailywtf.com/post/1125708 https://what.thedailywtf.com/post/1125710 https://what.thedailywtf.com/post/1125899 https://what.thedailywtf.com/post/1125926 https://what.thedailywtf.com/post/1125930 https://what.thedailywtf.com/post/1125934 https://what.thedailywtf.com/post/1125960 https://what.thedailywtf.com/post/1125962 https://what.thedailywtf.com/post/1126029 https://what.thedailywtf.com/post/1126068 https://what.thedailywtf.com/post/1126718 https://what.thedailywtf.com/post/1126728 https://what.thedailywtf.com/post/1126731 https://what.thedailywtf.com/post/1126732 `.trim().replace(/\s+/g, "\n").split('https://what.thedailywtf.com/post/').join('').split('\n'); pids.forEach(pid => { var req = new XMLHttpRequest; req.addEventListener('load', () => { var url = JSON.parse(req.responseText); if (typeof url == "string") { req = new XMLHttpRequest; req.addEventListener('load', () => { req = JSON.parse(req.responseText); req.posts.filter(p => p.pid == pid).forEach(p => console.log(p.selfPost, p.uid)); }); req.open('GET', '/api' + url); req.send(); } else console.log(url); }); req.open('GET', '/api/post/' + pid); req.send(); });
-
@anotherusername I'm at work right now, but I'll tweak the query and post new results when I'm done.
-
db.objects.aggregate([ {$match: {_key: 'tid:11847:posts'}}, {$sort: {score: 1}}, {$group: {_id: null, posts: {$push: '$value'}}}, {$project: {posts: {$concatArrays: [['11847'], '$posts']}}}, {$project: {pid: '$posts', posts: '$posts'}}, {$unwind: '$pid'}, {$project: {posts: '$posts', pid: '$pid', likeKey: {$concat: ['pid:', '$pid', ':upvote']}}}, {$lookup: {from: 'objects', localField: 'likeKey', foreignField: '_key', as: 'likes'}}, {$unwind: '$likes'}, {$project: {posts: '$posts', pid: '$pid', uid: '$likes.members'}}, {$unwind: '$uid'}, {$group: {_id: '$uid', posts: {$first: '$posts'}, liked: {$push: '$pid'}}}, {$project: {uid: {$concat: ['user:', '$_id']}, unliked: {$setDifference: ['$posts', '$liked']}, madeKey: {$concat: ['uid:', '$_id', ':posts']}}}, {$lookup: {from: 'objects', localField: 'madeKey', foreignField: '_key', as: 'made'}}, {$project: {uid: '$uid', missed: {$setDifference: ['$unliked', {$map: {input: '$made', as: 'pid', in: '$$pid.value'}}]}}}, {$project: {uid: '$uid', missed: '$missed', numMissed: {$size: '$missed'}}}, {$sort: {numMissed: 1}}, {$match: {numMissed: {$lt: 500}}}, {$lookup: {from: 'objects', localField: 'uid', foreignField: '_key', as: 'user'}}, {$unwind: '$user'} ], {allowDiskUse: true}).map(function(u) { return '<details><summary>@' + u.user.userslug + ' is missing ' + u.numMissed + ' likes!</summary>\n\n' + u.missed.map(function(pid) { return '- https://what.thedailywtf.com/post/' + pid; }).join('\n') + '\n\n</details>'; }).join('\n\n');
@anotherusername is missing 0 likes!
@raceprouk is missing 8 likes!
- https://what.thedailywtf.com/post/599816
- https://what.thedailywtf.com/post/1127188
- https://what.thedailywtf.com/post/1127215
- https://what.thedailywtf.com/post/1127217
- https://what.thedailywtf.com/post/1127220
- https://what.thedailywtf.com/post/1127221
- https://what.thedailywtf.com/post/1127222
- https://what.thedailywtf.com/post/1127223
@vault_dweller is missing 50 likes!
- https://what.thedailywtf.com/post/1126904
- https://what.thedailywtf.com/post/1126920
- https://what.thedailywtf.com/post/1126956
- https://what.thedailywtf.com/post/1126957
- https://what.thedailywtf.com/post/1126958
- https://what.thedailywtf.com/post/1126959
- https://what.thedailywtf.com/post/1126963
- https://what.thedailywtf.com/post/1126969
- https://what.thedailywtf.com/post/1126982
- https://what.thedailywtf.com/post/1126991
- https://what.thedailywtf.com/post/1127033
- https://what.thedailywtf.com/post/1127039
- https://what.thedailywtf.com/post/1127068
- https://what.thedailywtf.com/post/1127080
- https://what.thedailywtf.com/post/1127096
- https://what.thedailywtf.com/post/1127109
- https://what.thedailywtf.com/post/1127112
- https://what.thedailywtf.com/post/1127115
- https://what.thedailywtf.com/post/1127117
- https://what.thedailywtf.com/post/1127120
- https://what.thedailywtf.com/post/1127121
- https://what.thedailywtf.com/post/1127122
- https://what.thedailywtf.com/post/1127125
- https://what.thedailywtf.com/post/1127126
- https://what.thedailywtf.com/post/1127128
- https://what.thedailywtf.com/post/1127130
- https://what.thedailywtf.com/post/1127132
- https://what.thedailywtf.com/post/1127134
- https://what.thedailywtf.com/post/1127138
- https://what.thedailywtf.com/post/1127139
- https://what.thedailywtf.com/post/1127141
- https://what.thedailywtf.com/post/1127142
- https://what.thedailywtf.com/post/1127147
- https://what.thedailywtf.com/post/1127151
- https://what.thedailywtf.com/post/1127153
- https://what.thedailywtf.com/post/1127156
- https://what.thedailywtf.com/post/1127158
- https://what.thedailywtf.com/post/1127165
- https://what.thedailywtf.com/post/1127166
- https://what.thedailywtf.com/post/1127169
- https://what.thedailywtf.com/post/1127170
- https://what.thedailywtf.com/post/1127172
- https://what.thedailywtf.com/post/1127173
- https://what.thedailywtf.com/post/1127188
- https://what.thedailywtf.com/post/1127215
- https://what.thedailywtf.com/post/1127217
- https://what.thedailywtf.com/post/1127220
- https://what.thedailywtf.com/post/1127221
- https://what.thedailywtf.com/post/1127222
- https://what.thedailywtf.com/post/1127223
@obeselymorbid is missing 103 likes!
- https://what.thedailywtf.com/post/273977
- https://what.thedailywtf.com/post/274398
- https://what.thedailywtf.com/post/274855
- https://what.thedailywtf.com/post/279154
- https://what.thedailywtf.com/post/279786
- https://what.thedailywtf.com/post/282003
- https://what.thedailywtf.com/post/284788
- https://what.thedailywtf.com/post/285812
- https://what.thedailywtf.com/post/289842
- https://what.thedailywtf.com/post/289848
- https://what.thedailywtf.com/post/289849
- https://what.thedailywtf.com/post/289851
- https://what.thedailywtf.com/post/291227
- https://what.thedailywtf.com/post/295805
- https://what.thedailywtf.com/post/297755
- https://what.thedailywtf.com/post/298892
- https://what.thedailywtf.com/post/331578
- https://what.thedailywtf.com/post/368131
- https://what.thedailywtf.com/post/370555
- https://what.thedailywtf.com/post/374312
- https://what.thedailywtf.com/post/419586
- https://what.thedailywtf.com/post/433834
- https://what.thedailywtf.com/post/433924
- https://what.thedailywtf.com/post/556342
- https://what.thedailywtf.com/post/565352
- https://what.thedailywtf.com/post/572008
- https://what.thedailywtf.com/post/591341
- https://what.thedailywtf.com/post/593007
- https://what.thedailywtf.com/post/596690
- https://what.thedailywtf.com/post/596691
- https://what.thedailywtf.com/post/597896
- https://what.thedailywtf.com/post/598588
- https://what.thedailywtf.com/post/599308
- https://what.thedailywtf.com/post/599310
- https://what.thedailywtf.com/post/599844
- https://what.thedailywtf.com/post/601432
- https://what.thedailywtf.com/post/603318
- https://what.thedailywtf.com/post/603378
- https://what.thedailywtf.com/post/610337
- https://what.thedailywtf.com/post/610371
- https://what.thedailywtf.com/post/626540
- https://what.thedailywtf.com/post/627124
- https://what.thedailywtf.com/post/637647
- https://what.thedailywtf.com/post/640500
- https://what.thedailywtf.com/post/643168
- https://what.thedailywtf.com/post/661458
- https://what.thedailywtf.com/post/661501
- https://what.thedailywtf.com/post/661502
- https://what.thedailywtf.com/post/661504
- https://what.thedailywtf.com/post/661505
- https://what.thedailywtf.com/post/661506
- https://what.thedailywtf.com/post/661507
- https://what.thedailywtf.com/post/661515
- https://what.thedailywtf.com/post/661516
- https://what.thedailywtf.com/post/661518
- https://what.thedailywtf.com/post/661519
- https://what.thedailywtf.com/post/661521
- https://what.thedailywtf.com/post/661522
- https://what.thedailywtf.com/post/661523
- https://what.thedailywtf.com/post/661524
- https://what.thedailywtf.com/post/661525
- https://what.thedailywtf.com/post/661526
- https://what.thedailywtf.com/post/661528
- https://what.thedailywtf.com/post/661529
- https://what.thedailywtf.com/post/661532
- https://what.thedailywtf.com/post/661533
- https://what.thedailywtf.com/post/661534
- https://what.thedailywtf.com/post/661535
- https://what.thedailywtf.com/post/661536
- https://what.thedailywtf.com/post/661537
- https://what.thedailywtf.com/post/661538
- https://what.thedailywtf.com/post/661539
- https://what.thedailywtf.com/post/661540
- https://what.thedailywtf.com/post/661541
- https://what.thedailywtf.com/post/661542
- https://what.thedailywtf.com/post/661543
- https://what.thedailywtf.com/post/661544
- https://what.thedailywtf.com/post/661545
- https://what.thedailywtf.com/post/661546
- https://what.thedailywtf.com/post/661547
- https://what.thedailywtf.com/post/661548
- https://what.thedailywtf.com/post/661549
- https://what.thedailywtf.com/post/661550
- https://what.thedailywtf.com/post/661551
- https://what.thedailywtf.com/post/661552
- https://what.thedailywtf.com/post/661553
- https://what.thedailywtf.com/post/661554
- https://what.thedailywtf.com/post/661555
- https://what.thedailywtf.com/post/661556
- https://what.thedailywtf.com/post/661557
- https://what.thedailywtf.com/post/661558
- https://what.thedailywtf.com/post/661560
- https://what.thedailywtf.com/post/661561
- https://what.thedailywtf.com/post/661562
- https://what.thedailywtf.com/post/661563
- https://what.thedailywtf.com/post/661577
- https://what.thedailywtf.com/post/661581
- https://what.thedailywtf.com/post/661588
- https://what.thedailywtf.com/post/661589
- https://what.thedailywtf.com/post/661590
- https://what.thedailywtf.com/post/661591
- https://what.thedailywtf.com/post/1125287
- https://what.thedailywtf.com/post/1127223
-
@ben_lubar said in @ben_lubar's MongoDB !!SCIENCE!! thread:
@anotherusername is missing 0 likes!
Wow. That's just... kind of insane.
-
@ben_lubar said in @ben_lubar's MongoDB !!SCIENCE!! thread:
@raceprouk is missing 8 likes!
No I'm not, and I never was
>.>
<.<
>.>
<.<
^.^
-
@ben_lubar said in @ben_lubar's MongoDB !!SCIENCE!! thread:
db.objects.aggregate([ {$match: {_key: 'tid:11847:posts'}}, {$sort: {score: 1}}, {$group: {_id: null, posts: {$push: '$value'}}}, {$project: {posts: {$concatArrays: [['11847'], '$posts']}}}, {$project: {pid: '$posts', posts: '$posts'}}, {$unwind: '$pid'}, {$project: {posts: '$posts', pid: '$pid', likeKey: {$concat: ['pid:', '$pid', ':upvote']}}}, {$lookup: {from: 'objects', localField: 'likeKey', foreignField: '_key', as: 'likes'}}, {$unwind: '$likes'}, {$project: {posts: '$posts', pid: '$pid', uid: '$likes.members'}}, {$unwind: '$uid'}, {$group: {_id: '$uid', posts: {$first: '$posts'}, liked: {$push: '$pid'}}}, {$project: {uid: {$concat: ['user:', '$_id']}, unliked: {$setDifference: ['$posts', '$liked']}, madeKey: {$concat: ['uid:', '$_id', ':posts']}}}, {$lookup: {from: 'objects', localField: 'madeKey', foreignField: '_key', as: 'made'}}, {$project: {uid: '$uid', missed: {$setDifference: ['$unliked', {$map: {input: '$made', as: 'pid', in: '$$pid.value'}}]}}}, {$project: {uid: '$uid', missed: '$missed', numMissed: {$size: '$missed'}}}, {$sort: {numMissed: 1}}, {$match: {numMissed: {$lt: 500}}}, {$lookup: {from: 'objects', localField: 'uid', foreignField: '_key', as: 'user'}}, {$unwind: '$user'} ], {allowDiskUse: true}).map(function(u) { return '<details><summary>@' + u.user.userslug + ' is missing ' + u.numMissed + ' likes!</summary>\n\n' + u.missed.map(function(pid) { return '- https://what.thedailywtf.com/post/' + pid; }).join('\n') + '\n\n</details>'; }).join('\n\n');
@anotherusername is missing 0 likes!
@raceprouk is missing 8 likes!
- https://what.thedailywtf.com/post/599816
- https://what.thedailywtf.com/post/1127188
- https://what.thedailywtf.com/post/1127215
- https://what.thedailywtf.com/post/1127217
- https://what.thedailywtf.com/post/1127220
- https://what.thedailywtf.com/post/1127221
- https://what.thedailywtf.com/post/1127222
- https://what.thedailywtf.com/post/1127223
@vault_dweller is missing 50 likes!
- https://what.thedailywtf.com/post/1126904
- https://what.thedailywtf.com/post/1126920
- https://what.thedailywtf.com/post/1126956
- https://what.thedailywtf.com/post/1126957
- https://what.thedailywtf.com/post/1126958
- https://what.thedailywtf.com/post/1126959
- https://what.thedailywtf.com/post/1126963
- https://what.thedailywtf.com/post/1126969
- https://what.thedailywtf.com/post/1126982
- https://what.thedailywtf.com/post/1126991
- https://what.thedailywtf.com/post/1127033
- https://what.thedailywtf.com/post/1127039
- https://what.thedailywtf.com/post/1127068
- https://what.thedailywtf.com/post/1127080
- https://what.thedailywtf.com/post/1127096
- https://what.thedailywtf.com/post/1127109
- https://what.thedailywtf.com/post/1127112
- https://what.thedailywtf.com/post/1127115
- https://what.thedailywtf.com/post/1127117
- https://what.thedailywtf.com/post/1127120
- https://what.thedailywtf.com/post/1127121
- https://what.thedailywtf.com/post/1127122
- https://what.thedailywtf.com/post/1127125
- https://what.thedailywtf.com/post/1127126
- https://what.thedailywtf.com/post/1127128
- https://what.thedailywtf.com/post/1127130
- https://what.thedailywtf.com/post/1127132
- https://what.thedailywtf.com/post/1127134
- https://what.thedailywtf.com/post/1127138
- https://what.thedailywtf.com/post/1127139
- https://what.thedailywtf.com/post/1127141
- https://what.thedailywtf.com/post/1127142
- https://what.thedailywtf.com/post/1127147
- https://what.thedailywtf.com/post/1127151
- https://what.thedailywtf.com/post/1127153
- https://what.thedailywtf.com/post/1127156
- https://what.thedailywtf.com/post/1127158
- https://what.thedailywtf.com/post/1127165
- https://what.thedailywtf.com/post/1127166
- https://what.thedailywtf.com/post/1127169
- https://what.thedailywtf.com/post/1127170
- https://what.thedailywtf.com/post/1127172
- https://what.thedailywtf.com/post/1127173
- https://what.thedailywtf.com/post/1127188
- https://what.thedailywtf.com/post/1127215
- https://what.thedailywtf.com/post/1127217
- https://what.thedailywtf.com/post/1127220
- https://what.thedailywtf.com/post/1127221
- https://what.thedailywtf.com/post/1127222
- https://what.thedailywtf.com/post/1127223
@obeselymorbid is missing 103 likes!
- https://what.thedailywtf.com/post/273977
- https://what.thedailywtf.com/post/274398
- https://what.thedailywtf.com/post/274855
- https://what.thedailywtf.com/post/279154
- https://what.thedailywtf.com/post/279786
- https://what.thedailywtf.com/post/282003
- https://what.thedailywtf.com/post/284788
- https://what.thedailywtf.com/post/285812
- https://what.thedailywtf.com/post/289842
- https://what.thedailywtf.com/post/289848
- https://what.thedailywtf.com/post/289849
- https://what.thedailywtf.com/post/289851
- https://what.thedailywtf.com/post/291227
- https://what.thedailywtf.com/post/295805
- https://what.thedailywtf.com/post/297755
- https://what.thedailywtf.com/post/298892
- https://what.thedailywtf.com/post/331578
- https://what.thedailywtf.com/post/368131
- https://what.thedailywtf.com/post/370555
- https://what.thedailywtf.com/post/374312
- https://what.thedailywtf.com/post/419586
- https://what.thedailywtf.com/post/433834
- https://what.thedailywtf.com/post/433924
- https://what.thedailywtf.com/post/556342
- https://what.thedailywtf.com/post/565352
- https://what.thedailywtf.com/post/572008
- https://what.thedailywtf.com/post/591341
- https://what.thedailywtf.com/post/593007
- https://what.thedailywtf.com/post/596690
- https://what.thedailywtf.com/post/596691
- https://what.thedailywtf.com/post/597896
- https://what.thedailywtf.com/post/598588
- https://what.thedailywtf.com/post/599308
- https://what.thedailywtf.com/post/599310
- https://what.thedailywtf.com/post/599844
- https://what.thedailywtf.com/post/601432
- https://what.thedailywtf.com/post/603318
- https://what.thedailywtf.com/post/603378
- https://what.thedailywtf.com/post/610337
- https://what.thedailywtf.com/post/610371
- https://what.thedailywtf.com/post/626540
- https://what.thedailywtf.com/post/627124
- https://what.thedailywtf.com/post/637647
- https://what.thedailywtf.com/post/640500
- https://what.thedailywtf.com/post/643168
- https://what.thedailywtf.com/post/661458
- https://what.thedailywtf.com/post/661501
- https://what.thedailywtf.com/post/661502
- https://what.thedailywtf.com/post/661504
- https://what.thedailywtf.com/post/661505
- https://what.thedailywtf.com/post/661506
- https://what.thedailywtf.com/post/661507
- https://what.thedailywtf.com/post/661515
- https://what.thedailywtf.com/post/661516
- https://what.thedailywtf.com/post/661518
- https://what.thedailywtf.com/post/661519
- https://what.thedailywtf.com/post/661521
- https://what.thedailywtf.com/post/661522
- https://what.thedailywtf.com/post/661523
- https://what.thedailywtf.com/post/661524
- https://what.thedailywtf.com/post/661525
- https://what.thedailywtf.com/post/661526
- https://what.thedailywtf.com/post/661528
- https://what.thedailywtf.com/post/661529
- https://what.thedailywtf.com/post/661532
- https://what.thedailywtf.com/post/661533
- https://what.thedailywtf.com/post/661534
- https://what.thedailywtf.com/post/661535
- https://what.thedailywtf.com/post/661536
- https://what.thedailywtf.com/post/661537
- https://what.thedailywtf.com/post/661538
- https://what.thedailywtf.com/post/661539
- https://what.thedailywtf.com/post/661540
- https://what.thedailywtf.com/post/661541
- https://what.thedailywtf.com/post/661542
- https://what.thedailywtf.com/post/661543
- https://what.thedailywtf.com/post/661544
- https://what.thedailywtf.com/post/661545
- https://what.thedailywtf.com/post/661546
- https://what.thedailywtf.com/post/661547
- https://what.thedailywtf.com/post/661548
- https://what.thedailywtf.com/post/661549
- https://what.thedailywtf.com/post/661550
- https://what.thedailywtf.com/post/661551
- https://what.thedailywtf.com/post/661552
- https://what.thedailywtf.com/post/661553
- https://what.thedailywtf.com/post/661554
- https://what.thedailywtf.com/post/661555
- https://what.thedailywtf.com/post/661556
- https://what.thedailywtf.com/post/661557
- https://what.thedailywtf.com/post/661558
- https://what.thedailywtf.com/post/661560
- https://what.thedailywtf.com/post/661561
- https://what.thedailywtf.com/post/661562
- https://what.thedailywtf.com/post/661563
- https://what.thedailywtf.com/post/661577
- https://what.thedailywtf.com/post/661581
- https://what.thedailywtf.com/post/661588
- https://what.thedailywtf.com/post/661589
- https://what.thedailywtf.com/post/661590
- https://what.thedailywtf.com/post/661591
- https://what.thedailywtf.com/post/1125287
- https://what.thedailywtf.com/post/1127223
there have got to be more than 4 people who have liked that thread.......
-
@accalia said in @ben_lubar's MongoDB !!SCIENCE!! thread:
@ben_lubar said in @ben_lubar's MongoDB !!SCIENCE!! thread:
db.objects.aggregate([ {$match: {_key: 'tid:11847:posts'}}, {$sort: {score: 1}}, {$group: {_id: null, posts: {$push: '$value'}}}, {$project: {posts: {$concatArrays: [['11847'], '$posts']}}}, {$project: {pid: '$posts', posts: '$posts'}}, {$unwind: '$pid'}, {$project: {posts: '$posts', pid: '$pid', likeKey: {$concat: ['pid:', '$pid', ':upvote']}}}, {$lookup: {from: 'objects', localField: 'likeKey', foreignField: '_key', as: 'likes'}}, {$unwind: '$likes'}, {$project: {posts: '$posts', pid: '$pid', uid: '$likes.members'}}, {$unwind: '$uid'}, {$group: {_id: '$uid', posts: {$first: '$posts'}, liked: {$push: '$pid'}}}, {$project: {uid: {$concat: ['user:', '$_id']}, unliked: {$setDifference: ['$posts', '$liked']}, madeKey: {$concat: ['uid:', '$_id', ':posts']}}}, {$lookup: {from: 'objects', localField: 'madeKey', foreignField: '_key', as: 'made'}}, {$project: {uid: '$uid', missed: {$setDifference: ['$unliked', {$map: {input: '$made', as: 'pid', in: '$$pid.value'}}]}}}, {$project: {uid: '$uid', missed: '$missed', numMissed: {$size: '$missed'}}}, {$sort: {numMissed: 1}}, {$match: {numMissed: {$lt: 500}}}, {$lookup: {from: 'objects', localField: 'uid', foreignField: '_key', as: 'user'}}, {$unwind: '$user'} ], {allowDiskUse: true}).map(function(u) { return '<details><summary>@' + u.user.userslug + ' is missing ' + u.numMissed + ' likes!</summary>\n\n' + u.missed.map(function(pid) { return '- https://what.thedailywtf.com/post/' + pid; }).join('\n') + '\n\n</details>'; }).join('\n\n');
@anotherusername is missing 0 likes!
@raceprouk is missing 8 likes!
- https://what.thedailywtf.com/post/599816
- https://what.thedailywtf.com/post/1127188
- https://what.thedailywtf.com/post/1127215
- https://what.thedailywtf.com/post/1127217
- https://what.thedailywtf.com/post/1127220
- https://what.thedailywtf.com/post/1127221
- https://what.thedailywtf.com/post/1127222
- https://what.thedailywtf.com/post/1127223
@vault_dweller is missing 50 likes!
- https://what.thedailywtf.com/post/1126904
- https://what.thedailywtf.com/post/1126920
- https://what.thedailywtf.com/post/1126956
- https://what.thedailywtf.com/post/1126957
- https://what.thedailywtf.com/post/1126958
- https://what.thedailywtf.com/post/1126959
- https://what.thedailywtf.com/post/1126963
- https://what.thedailywtf.com/post/1126969
- https://what.thedailywtf.com/post/1126982
- https://what.thedailywtf.com/post/1126991
- https://what.thedailywtf.com/post/1127033
- https://what.thedailywtf.com/post/1127039
- https://what.thedailywtf.com/post/1127068
- https://what.thedailywtf.com/post/1127080
- https://what.thedailywtf.com/post/1127096
- https://what.thedailywtf.com/post/1127109
- https://what.thedailywtf.com/post/1127112
- https://what.thedailywtf.com/post/1127115
- https://what.thedailywtf.com/post/1127117
- https://what.thedailywtf.com/post/1127120
- https://what.thedailywtf.com/post/1127121
- https://what.thedailywtf.com/post/1127122
- https://what.thedailywtf.com/post/1127125
- https://what.thedailywtf.com/post/1127126
- https://what.thedailywtf.com/post/1127128
- https://what.thedailywtf.com/post/1127130
- https://what.thedailywtf.com/post/1127132
- https://what.thedailywtf.com/post/1127134
- https://what.thedailywtf.com/post/1127138
- https://what.thedailywtf.com/post/1127139
- https://what.thedailywtf.com/post/1127141
- https://what.thedailywtf.com/post/1127142
- https://what.thedailywtf.com/post/1127147
- https://what.thedailywtf.com/post/1127151
- https://what.thedailywtf.com/post/1127153
- https://what.thedailywtf.com/post/1127156
- https://what.thedailywtf.com/post/1127158
- https://what.thedailywtf.com/post/1127165
- https://what.thedailywtf.com/post/1127166
- https://what.thedailywtf.com/post/1127169
- https://what.thedailywtf.com/post/1127170
- https://what.thedailywtf.com/post/1127172
- https://what.thedailywtf.com/post/1127173
- https://what.thedailywtf.com/post/1127188
- https://what.thedailywtf.com/post/1127215
- https://what.thedailywtf.com/post/1127217
- https://what.thedailywtf.com/post/1127220
- https://what.thedailywtf.com/post/1127221
- https://what.thedailywtf.com/post/1127222
- https://what.thedailywtf.com/post/1127223
@obeselymorbid is missing 103 likes!
- https://what.thedailywtf.com/post/273977
- https://what.thedailywtf.com/post/274398
- https://what.thedailywtf.com/post/274855
- https://what.thedailywtf.com/post/279154
- https://what.thedailywtf.com/post/279786
- https://what.thedailywtf.com/post/282003
- https://what.thedailywtf.com/post/284788
- https://what.thedailywtf.com/post/285812
- https://what.thedailywtf.com/post/289842
- https://what.thedailywtf.com/post/289848
- https://what.thedailywtf.com/post/289849
- https://what.thedailywtf.com/post/289851
- https://what.thedailywtf.com/post/291227
- https://what.thedailywtf.com/post/295805
- https://what.thedailywtf.com/post/297755
- https://what.thedailywtf.com/post/298892
- https://what.thedailywtf.com/post/331578
- https://what.thedailywtf.com/post/368131
- https://what.thedailywtf.com/post/370555
- https://what.thedailywtf.com/post/374312
- https://what.thedailywtf.com/post/419586
- https://what.thedailywtf.com/post/433834
- https://what.thedailywtf.com/post/433924
- https://what.thedailywtf.com/post/556342
- https://what.thedailywtf.com/post/565352
- https://what.thedailywtf.com/post/572008
- https://what.thedailywtf.com/post/591341
- https://what.thedailywtf.com/post/593007
- https://what.thedailywtf.com/post/596690
- https://what.thedailywtf.com/post/596691
- https://what.thedailywtf.com/post/597896
- https://what.thedailywtf.com/post/598588
- https://what.thedailywtf.com/post/599308
- https://what.thedailywtf.com/post/599310
- https://what.thedailywtf.com/post/599844
- https://what.thedailywtf.com/post/601432
- https://what.thedailywtf.com/post/603318
- https://what.thedailywtf.com/post/603378
- https://what.thedailywtf.com/post/610337
- https://what.thedailywtf.com/post/610371
- https://what.thedailywtf.com/post/626540
- https://what.thedailywtf.com/post/627124
- https://what.thedailywtf.com/post/637647
- https://what.thedailywtf.com/post/640500
- https://what.thedailywtf.com/post/643168
- https://what.thedailywtf.com/post/661458
- https://what.thedailywtf.com/post/661501
- https://what.thedailywtf.com/post/661502
- https://what.thedailywtf.com/post/661504
- https://what.thedailywtf.com/post/661505
- https://what.thedailywtf.com/post/661506
- https://what.thedailywtf.com/post/661507
- https://what.thedailywtf.com/post/661515
- https://what.thedailywtf.com/post/661516
- https://what.thedailywtf.com/post/661518
- https://what.thedailywtf.com/post/661519
- https://what.thedailywtf.com/post/661521
- https://what.thedailywtf.com/post/661522
- https://what.thedailywtf.com/post/661523
- https://what.thedailywtf.com/post/661524
- https://what.thedailywtf.com/post/661525
- https://what.thedailywtf.com/post/661526
- https://what.thedailywtf.com/post/661528
- https://what.thedailywtf.com/post/661529
- https://what.thedailywtf.com/post/661532
- https://what.thedailywtf.com/post/661533
- https://what.thedailywtf.com/post/661534
- https://what.thedailywtf.com/post/661535
- https://what.thedailywtf.com/post/661536
- https://what.thedailywtf.com/post/661537
- https://what.thedailywtf.com/post/661538
- https://what.thedailywtf.com/post/661539
- https://what.thedailywtf.com/post/661540
- https://what.thedailywtf.com/post/661541
- https://what.thedailywtf.com/post/661542
- https://what.thedailywtf.com/post/661543
- https://what.thedailywtf.com/post/661544
- https://what.thedailywtf.com/post/661545
- https://what.thedailywtf.com/post/661546
- https://what.thedailywtf.com/post/661547
- https://what.thedailywtf.com/post/661548
- https://what.thedailywtf.com/post/661549
- https://what.thedailywtf.com/post/661550
- https://what.thedailywtf.com/post/661551
- https://what.thedailywtf.com/post/661552
- https://what.thedailywtf.com/post/661553
- https://what.thedailywtf.com/post/661554
- https://what.thedailywtf.com/post/661555
- https://what.thedailywtf.com/post/661556
- https://what.thedailywtf.com/post/661557
- https://what.thedailywtf.com/post/661558
- https://what.thedailywtf.com/post/661560
- https://what.thedailywtf.com/post/661561
- https://what.thedailywtf.com/post/661562
- https://what.thedailywtf.com/post/661563
- https://what.thedailywtf.com/post/661577
- https://what.thedailywtf.com/post/661581
- https://what.thedailywtf.com/post/661588
- https://what.thedailywtf.com/post/661589
- https://what.thedailywtf.com/post/661590
- https://what.thedailywtf.com/post/661591
- https://what.thedailywtf.com/post/1125287
- https://what.thedailywtf.com/post/1127223
there have got to be more than 4 people who have liked that thread.......
The next person was missing over 500 and the person after that was missing over 800 and NodeBB didn't want my post to be that long.
-
-
@ben_lubar Did your query include bot accounts?
-
@RaceProUK said in @ben_lubar's MongoDB !!SCIENCE!! thread:
@ben_lubar Did your query include bot accounts?
The query is right above the results. There's nothing in it that looks at what groups a user is in.
-
@ben_lubar That means all my bot accounts are at least 500 posts behind!
I really need to get them running again…
-
@RaceProUK said in @ben_lubar's MongoDB !!SCIENCE!! thread:
I really need to get them running again…
Or not ... they are already soooo behind ... they are screwed!
-
@ben_lubar Wait, does that mean I'm missing likes?
I shouldn't be miss… Oh, right, I went and skipped bot posts in protest. A bunch of us started skipping the bots when they began cluttering up the thread. :P
-
@ben_lubar said in @ben_lubar's MongoDB !!SCIENCE!! thread:
The next person was missing over 500 and the person after that was missing over 800 and NodeBB didn't want my post to be that long.
Damn. That means I'm missing a lot. And here I thought I was update-to-date (well, just missing the current crop...)
-
@dcon said in @ben_lubar's MongoDB !!SCIENCE!! thread:
@ben_lubar said in @ben_lubar's MongoDB !!SCIENCE!! thread:
The next person was missing over 500 and the person after that was missing over 800 and NodeBB didn't want my post to be that long.
Damn. That means I'm missing a lot. And here I thought I was update-to-date (well, just missing the current crop...)
Ah - looks like the original import must've killed me off... Back to the top!
edit: Oh hell. Found the cutoff point. It's going to take a while catching up with the first 50000. Yes, 50,000.
-
Someday, when I have enough free time, I'll go to that thread and annoy everyone with notifications
-
@TimeBandit I just hope my script is online when you do, so that it can automatically ignore them all. :P
...actually, I haven't posted that many times in it, so you wouldn't annoy me anyway. Carry on!
-
docker service create --constraint 'node.role == worker' --name 'wtdwtf-science-communityserver' --network wtdwtf-science --mount 'type=bind,source=/mnt/sda1/backup,destination=/var/backup,ro' -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=AnInsecure!Passw0rd' microsoft/mssql-server-linux docker service create --constraint 'node.role == worker' --name 'wtdwtf-science-discourse' --network wtdwtf-science --mount 'type=bind,source=/mnt/sda1/backup,destination=/var/backup,ro' postgres docker service create --constraint 'node.role == worker' --name 'wtdwtf-science-nodebb' --network wtdwtf-science --mount 'type=bind,source=/mnt/sda1/backup,destination=/var/backup,ro' mongo docker exec wtdwtf-science-communityserver.1.`docker service ps wtdwtf-science-communityserver -q` /opt/mssql-tools/bin/sqlcmd -H localhost -U SA -P 'AnInsecure!Passw0rd' -Q 'USE master RESTORE DATABASE [TheDailyWtf] FROM DISK=N''/var/backup/communityserver.bak'' WITH FILE = 1, MOVE N''CommunityServer'' TO N''/var/opt/mssql/data/CommunityServer.mdf'', MOVE N''CommunityServer_log'' TO N''/var/opt/mssql/data/CommunityServer_log.ldf'', NOUNLOAD, REPLACE, STATS = 1' docker exec wtdwtf-science-discourse.1.`docker service ps wtdwtf-science-discourse -q` psql -U postgres -f /var/backup/discourse.sql docker exec wtdwtf-science-nodebb.1.`docker service ps wtdwtf-science-nodebb -q` mongorestore --drop /var/backup/nodebb/
-
postgres=# with imported as ( select rc.id original_id, ic.category_id imported_id from imported_categories ic inner join raw_categories rc on ic.imported_forum_id = rc.forum_id and ic.imported_category_id = rc.raw_id ) select original_id, imported_id, fo.name original_forum_name, oc.name original_category_name, fi.name imported_forum_name, ic.name imported_category_name from imported inner join raw_categories oc on original_id = oc.id inner join raw_categories ic on imported_id = ic.id inner join forums fo on fo.id = oc.forum_id inner join forums fi on fi.id = ic.forum_id; original_id | imported_id | original_forum_name | original_category_name | imported_forum_name | imported_category_name -------------+-------------+---------------------+----------------------------------+---------------------+------------------------ 24 | 1 | Community Server | General Discussion | Discourse | General Discussion 33 | 2 | Community Server | Moderator's Forum | Discourse | Rubbish 26 | 3 | Community Server | The I-Hate-Oracle Club | Discourse | The I-Hate-Oracle Club 30 | 4 | Community Server | Coding Related Help & Questions | NodeBB | Coding Help 5 | 4 | Discourse | Coding Help | NodeBB | Coding Help 30 | 5 | Community Server | Coding Related Help & Questions | Discourse | Coding Help 24 | 6 | Community Server | General Discussion | NodeBB | General 9 | 6 | Discourse | General | NodeBB | General 28 | 7 | Community Server | "Side Bar" WTF | NodeBB | Side Bar WTF 24 | 9 | Community Server | General Discussion | Discourse | General 33 | 10 | Community Server | Moderator's Forum | NodeBB | Rubbish 2 | 10 | Discourse | Rubbish | NodeBB | Rubbish 45 | 11 | Community Server | Funny Stuff | Discourse | Funny stuff 1 | 57 | Discourse | General Discussion | NodeBB | General Discussion 32 | 67 | Community Server | Coder Challenge | NodeBB | Coder Challenge 45 | 68 | Community Server | Funny Stuff | NodeBB | Funny stuff 11 | 68 | Discourse | Funny stuff | NodeBB | Funny stuff 26 | 71 | Community Server | The I-Hate-Oracle Club | NodeBB | The I-Hate-Oracle Club 3 | 71 | Discourse | The I-Hate-Oracle Club | NodeBB | The I-Hate-Oracle Club (19 rows)
(The two IDs on the left are completely meaningless in any context outside of the science database.)
-
By the way, compare the code to get a list of categories from Community Server with the code for Discourse and the code for NodeBB.
-
postgres=# select forums.name, raw_categories.name from raw_categories left outer join imported_categories on raw_id = imported_category_id and forum_id = imported_forum_id inner join forums on forums.id = forum_id where forum_id <> 3 and imported_category_id is null; name | name ------------------+---------------------------- Community Server | Administrators Community Server | The Daily WTF Community Server | OMGWTF Contest (Read Only) Community Server | Reporting Forums Community Server | Deleted Posts Community Server | CodeSOD Editors Community Server | OMG News & Updates Community Server | Contest Discussion Community Server | Entry Comments Community Server | Questions closed elsewhere Community Server | OMGWTF2 Contest Discussion (11 rows)
-
@ben_lubar So, if you're playing around with database backups, did this mean it's possible to have something like @shadowmod again?
-
@NedFodder said in @ben_lubar's MongoDB !!SCIENCE!! thread:
@ben_lubar So, if you're playing around with database backups, did this mean it's possible to have something like @shadowmod again?
Yep!
-
-
@ben_lubar that syntax highlighting is... special...
-
@anotherusername said in @ben_lubar's MongoDB !!SCIENCE!! thread:
that syntax highlighting is... special...
LOLRUBY
-
@ben_lubar said in @ben_lubar's MongoDB !!SCIENCE!! thread:
Some people asked me to figure out which posts the top likers in /t/1000 were missing.
Update, since I'm playing around with a backup inbetween waiting for trains to come online (I've deliberately removed the @'s)
vault_dweller is missing 40 likes!
- https://what.thedailywtf.com/post/388077
- https://what.thedailywtf.com/post/388145
- https://what.thedailywtf.com/post/411262
- https://what.thedailywtf.com/post/411332
- https://what.thedailywtf.com/post/412773
- https://what.thedailywtf.com/post/412794
- https://what.thedailywtf.com/post/438717
- https://what.thedailywtf.com/post/481849
- https://what.thedailywtf.com/post/481870
- https://what.thedailywtf.com/post/484231
- https://what.thedailywtf.com/post/484245
- https://what.thedailywtf.com/post/511068
- https://what.thedailywtf.com/post/534019
- https://what.thedailywtf.com/post/534055
- https://what.thedailywtf.com/post/557881
- https://what.thedailywtf.com/post/571478
- https://what.thedailywtf.com/post/573984
- https://what.thedailywtf.com/post/579137
- https://what.thedailywtf.com/post/580004
- https://what.thedailywtf.com/post/614441
- https://what.thedailywtf.com/post/618888
- https://what.thedailywtf.com/post/629196
- https://what.thedailywtf.com/post/629199
- https://what.thedailywtf.com/post/637864
- https://what.thedailywtf.com/post/657576
- https://what.thedailywtf.com/post/1125340
- https://what.thedailywtf.com/post/1125357
- https://what.thedailywtf.com/post/1125366
- https://what.thedailywtf.com/post/1125371
- https://what.thedailywtf.com/post/1125723
- https://what.thedailywtf.com/post/1126618
- https://what.thedailywtf.com/post/1136086
- https://what.thedailywtf.com/post/1136464
- https://what.thedailywtf.com/post/1137533
- https://what.thedailywtf.com/post/1190728
- https://what.thedailywtf.com/post/1197853
- https://what.thedailywtf.com/post/1201129
- https://what.thedailywtf.com/post/1201132
- https://what.thedailywtf.com/post/1201135
- https://what.thedailywtf.com/post/1201533
anotherusername is missing 88 likes!
- https://what.thedailywtf.com/post/1002454
- https://what.thedailywtf.com/post/1002472
- https://what.thedailywtf.com/post/1002509
- https://what.thedailywtf.com/post/1002515
- https://what.thedailywtf.com/post/1002527
- https://what.thedailywtf.com/post/1002529
- https://what.thedailywtf.com/post/1002533
- https://what.thedailywtf.com/post/1002539
- https://what.thedailywtf.com/post/1107986
- https://what.thedailywtf.com/post/1110816
- https://what.thedailywtf.com/post/1113703
- https://what.thedailywtf.com/post/1120560
- https://what.thedailywtf.com/post/1121416
- https://what.thedailywtf.com/post/1121486
- https://what.thedailywtf.com/post/1122027
- https://what.thedailywtf.com/post/1124272
- https://what.thedailywtf.com/post/1124332
- https://what.thedailywtf.com/post/1125708
- https://what.thedailywtf.com/post/1125710
- https://what.thedailywtf.com/post/1125899
- https://what.thedailywtf.com/post/1125926
- https://what.thedailywtf.com/post/1125930
- https://what.thedailywtf.com/post/1125934
- https://what.thedailywtf.com/post/1125960
- https://what.thedailywtf.com/post/1125962
- https://what.thedailywtf.com/post/1126029
- https://what.thedailywtf.com/post/1126068
- https://what.thedailywtf.com/post/1126718
- https://what.thedailywtf.com/post/1126728
- https://what.thedailywtf.com/post/1126731
- https://what.thedailywtf.com/post/1126732
- https://what.thedailywtf.com/post/1126959
- https://what.thedailywtf.com/post/1127188
- https://what.thedailywtf.com/post/1127344
- https://what.thedailywtf.com/post/1127349
- https://what.thedailywtf.com/post/1128126
- https://what.thedailywtf.com/post/1128129
- https://what.thedailywtf.com/post/1128184
- https://what.thedailywtf.com/post/1128214
- https://what.thedailywtf.com/post/1128787
- https://what.thedailywtf.com/post/1128803
- https://what.thedailywtf.com/post/1128805
- https://what.thedailywtf.com/post/1128835
- https://what.thedailywtf.com/post/1129019
- https://what.thedailywtf.com/post/1129027
- https://what.thedailywtf.com/post/1129077
- https://what.thedailywtf.com/post/1129078
- https://what.thedailywtf.com/post/1129087
- https://what.thedailywtf.com/post/1129104
- https://what.thedailywtf.com/post/1129118
- https://what.thedailywtf.com/post/1129120
- https://what.thedailywtf.com/post/1129128
- https://what.thedailywtf.com/post/1129141
- https://what.thedailywtf.com/post/1129154
- https://what.thedailywtf.com/post/1129157
- https://what.thedailywtf.com/post/1129166
- https://what.thedailywtf.com/post/1129178
- https://what.thedailywtf.com/post/1129937
- https://what.thedailywtf.com/post/1132217
- https://what.thedailywtf.com/post/1132249
- https://what.thedailywtf.com/post/1132438
- https://what.thedailywtf.com/post/1135444
- https://what.thedailywtf.com/post/1136073
- https://what.thedailywtf.com/post/1136075
- https://what.thedailywtf.com/post/1136082
- https://what.thedailywtf.com/post/1136264
- https://what.thedailywtf.com/post/1136266
- https://what.thedailywtf.com/post/1136275
- https://what.thedailywtf.com/post/1136296
- https://what.thedailywtf.com/post/1136305
- https://what.thedailywtf.com/post/1137512
- https://what.thedailywtf.com/post/1137516
- https://what.thedailywtf.com/post/1137523
- https://what.thedailywtf.com/post/1137528
- https://what.thedailywtf.com/post/1148099
- https://what.thedailywtf.com/post/1158851
- https://what.thedailywtf.com/post/1158855
- https://what.thedailywtf.com/post/1168201
- https://what.thedailywtf.com/post/1168210
- https://what.thedailywtf.com/post/1168212
- https://what.thedailywtf.com/post/1170877
- https://what.thedailywtf.com/post/1178926
- https://what.thedailywtf.com/post/1178927
- https://what.thedailywtf.com/post/1179201
- https://what.thedailywtf.com/post/1190848
- https://what.thedailywtf.com/post/1190854
- https://what.thedailywtf.com/post/1192514
- https://what.thedailywtf.com/post/1192517
After that, listing only those below 10,000 missing(!)
- dcon missing 256
- netbot missing 801
- raceprouk missing 2310
- obeselymorbid missing 3629
- discoursebot missing 3940
- codinghorrorbot missing 4137
- vinduv missing 4668
- boomzilla missing 4877
- offbyone missing 4935
- sockbot missing 5600
- mott555 missing 5809
- zoidberg missing 5995
- bender missing 6557
- johnnyfive missing 6559
- darkmatter missing 6574
- accalia missing 6807
- eor missing 8677
- hardwaregeek missing 8709
- abarker missing 8989
- chaostheeternal missing 9760
-
@pjh said in @ben_lubar's MongoDB !!SCIENCE!! thread:
Update
Ignore that post - just found the amended query...
-
@pjh How many am I missing? I know there are large chunks because it's all manual and there were months at a time that I didn't read it
-
@pjh said in @ben_lubar's MongoDB !!SCIENCE!! thread:
raceprouk missing 2310
@pjh said in @ben_lubar's MongoDB !!SCIENCE!! thread:
netbot missing 801
Is that post counts? If so, can you send me the figures for all my alts? They're listed on my profile.
-
@pjh said in @ben_lubar's MongoDB !!SCIENCE!! thread:
offbyone missing 4935
So is it 4934 or 4936? WE MUST KNOW!
-
Those missing 100,000 or less. Which judging from the ones at the end, is everyone who's posted.
- anotherusername missing 0 - vault_dweller missing 5 - raceprouk missing 8 - dcon missing 64 - obeselymorbid missing 102 - darkmatter missing 541 - netbot missing 793 - boomzilla missing 853 - abarker missing 1134 - discoursebot missing 3817 - codinghorrorbot missing 4009 - mott555 missing 4267 - offbyone missing 4403 - accalia missing 4505 - vinduv missing 4534 - hardwaregeek missing 4826 - sockbot missing 5503 - zoidberg missing 5919 - bender missing 6557 - johnnyfive missing 6558 - chaostheeternal missing 7829 - eor missing 8660 - placeholder missing 13792 - luhmann missing 15421 - mathbot missing 17180 - reverendryan missing 19436 - aliceif missing 23703 - rpbot missing 27304 - onyx missing 29898 - spencer missing 35182 - nedfodder missing 35716 - maciejasjmj missing 36019 - izzion missing 41957 - ben_lubar missing 44517 - the_dragon missing 45046 - faoileag missing 47630 - mrstumpy missing 50468 - jarry missing 51312 - arantor missing 52159 - slackerd missing 55457 - gog missing 57598 - sockpuppet missing 57664 - m_adams missing 57695 - doctorjones missing 59093 - buddy missing 59143 - chudbert missing 59542 - loopback0 missing 59709 - cheong missing 61053 - oojimaflib missing 62789 - jaloopa missing 62959 - redwizard missing 62980 - zecc missing 63209 - likebot missing 63234 - todo missing 63579 - riking missing 63646 - tufty missing 63687 - pwolff missing 64079 - tsaukpaetra missing 64231 - null_loop missing 64275 - drakesmith missing 64455 - tcotcdck missing 64674 - systern missing 64689 - djls45 missing 65004 - flabdablet missing 65046 - polygeekery missing 65328 - error missing 65364 - pjh missing 65458 - royal_poet missing 65493 - svieira missing 65629 - asdf missing 65778 - choonster missing 65868 - cartman82 missing 65906 - dhromed missing 65956 - cursorkeys missing 65956 - jbert missing 65982 - discourse missing 66025 - dkf missing 66092 - magus missing 66139 - oesor missing 66163 - nagesh missing 66174 - sockadept missing 66182 - presidentsdaughter missing 66225 - jazzyjosh missing 66284 - nightware missing 66312 - piko missing 66322 - menugarit missing 66340 - rc4 missing 66353 - frsfnrrg missing 66375 - monarch missing 66395 - algorythmics missing 66406 - keith missing 66421 - dogsb missing 66434 - ender missing 66442 - bb36e missing 66452 - masonwheeler missing 66465 - chubertdev missing 66468 - createdtodislikethis missing 66484 - mikael_svahnberg missing 66505 - delfinom missing 66509 - wukl missing 66516 - zpedro missing 66527 - bort missing 66532 - apapadimoulis missing 66555 - antiquarian missing 66568 - mottbott missing 66577 - captain missing 66580 - peedub missing 66584 - cleverbot missing 66588 - mrl missing 66596 - dreikin missing 66598 - xaade missing 66607 - lorne-kates missing 66609 - hotmailcom missing 66610 - pronbot missing 66610 - minkovsky missing 66613 - swayde missing 66620 - groaner missing 66621 - matches missing 66621 - barteks2x missing 66629 - wood missing 66630 - chouchuuchochouchou missing 66631 - trithne missing 66646 - summonbot missing 66648 - lushr missing 66650 - carrievs missing 66650 - cvi missing 66659 - subscript_error missing 66661 - snuffles missing 66662 - ingenieurlogiciel missing 66663 - frank missing 66666 - jerome_viveiros missing 66670 - shadowmod missing 66676 - arthurdent421 missing 66678 - youcancallmeal missing 66680 - dse missing 66682 - davezych missing 66683 - sam missing 66683 - webinsane missing 66684 - random_garbage missing 66684 - testdisgobot missing 66685 - loose missing 66687 - the_quiet_one missing 66687 - frostcat missing 66692 - erufael missing 66695 - flwf missing 66695 - xaos missing 66696 - yellowonline missing 66696 - yamibot missing 66697 - vaelynphi missing 66697 - zacrath missing 66697 - anonymous234 missing 66698 - fbmac missing 66699 - adrian7 missing 66700 - superjer missing 66700 - voldemort missing 66700 - eldelshell missing 66701 - ntauthority missing 66701 - coynethedup missing 66701 - cpradio missing 66702 - scramblebot missing 66704 - yamikuronue missing 66704 - minimaul missing 66705 - miketheliar missing 66705 - meglio missing 66705 - jaming missing 66706 - gąska missing 66707 - pleegbot missing 66707 - revmaxx missing 66707 - loremipsum missing 66707 - sloosecannon missing 66708 - feibrix missing 66708 - codlnghorror missing 66708 - pythonbot missing 66709 - e4tmyl33t missing 66709 - end missing 66710 - boner missing 66711 - file_not_found missing 66711 - killacoder missing 66711 - scholrlea missing 66711 - nazar missing 66712 - weng missing 66712 - martijntje missing 66712 - ofcource missing 66712 - dstopia missing 66713 - powerlord missing 66713 - scudsucker missing 66713 - necromancer missing 66713 - your_name missing 66714 - masaaki_hosoi missing 66714 - fox missing 66714 - monkeyarms missing 66714 - twelvebaud missing 66714 - eviltrout missing 66714 - aperson missing 66714 - jamesn missing 66714 - mott556 missing 66715 - lolwhat missing 66715 - scboffspring missing 66716 - r10pez10 missing 66716 - mrguyorama missing 66716 - tar missing 66716 - rtapeloadingerror missing 66716 - lee_ars missing 66716 - antipattern missing 66716 - mike_james missing 66717 - lightsoff missing 66717 - spanky587 missing 66717 - lathun missing 66717 - perverted_vixen missing 66717 - statsbot missing 66717 - hungrier missing 66717 - codeclown missing 66717 - nzcode missing 66717 - tarunik missing 66717 - belgariontheking missing 66718 - bugmenot missing 66718 - nocha missing 66718 - blek missing 66718 - index missing 66718 - toon missing 66718 - mark_bowytz missing 66718 - locallunatic missing 66718 - xi_ missing 66718 - jello missing 66719 - tl1tester missing 66719 - john_a missing 66719 - cabrito missing 66719 - maidul missing 66719 - belgium missing 66719 - japonicus missing 66719 - epicenter missing 66719 - seraph missing 66719 - dcross missing 66719 - rhywden missing 66719 - salamander missing 66719 - remy missing 66719 - wtf missing 66719 - tatsu missing 66719 - marinus missing 66719 - andreas missing 66719 - rfoxmich missing 66719 - myself missing 66719 - tiyawatis207 missing 66719 - pleegwat missing 66719 - tdwtftest missing 66719
-
@pjh said in @ben_lubar's MongoDB !!SCIENCE!! thread:
raceprouk missing 2310
@pjh said in @ben_lubar's MongoDB !!SCIENCE!! thread:
raceprouk missing 8
Which is it? Am I missing 8, or 2310?
-
-
@raceprouk said in @ben_lubar's MongoDB !!SCIENCE!! thread:
Which is it? Am I missing 8, or 2310?
@anotherusername said in @ben_lubar's MongoDB !!SCIENCE!! thread:
@boomzilla tested all 31, they're all selfposts.
@ben_lubar said in @ben_lubar's MongoDB !!SCIENCE!! thread:
@anotherusername I'm at work right now, but I'll tweak the query and post new results when I'm done.
Depends on what you're counting. The second includes your own posts, the first doesn't.
-
@pjh said in @ben_lubar's MongoDB !!SCIENCE!! thread:
anotherusername missing 0
Teach us, oh great one!
(CC @anotherusername )
-
@zecc he cheats
-
@pjh Is there a way to get likes into the DB without triggering a bajillionty twelve thousand and a billion notifications?
-
@raceprouk no idea. I'm only running the queries Ben had above - I've no clue how to start constructing my own yet.
-
@pjh Then I'll hold off getting my alts caught up for now. At least I can get the 8 my main account is missing.
-
@raceprouk Please rate-limit your auto liking (that goes for everyone). I'm seeing lots of cooties today, and I bet it's the likes thread (or ben fucking around with postgres)
-
@nedfodder I've already slowed it down by a factor of 10. I think the issue isn't so much how fast I'm going, but where I was at the time (19967 posts into the thread, there seems to be a batch that kills the forum).
Edit: The staff have been alerted.
-
@raceprouk said in @ben_lubar's MongoDB !!SCIENCE!! thread:
there seems to be a batch that kills the forum
Oh, I forgot about that. I thought that was fixed...
-
@nedfodder said in @ben_lubar's MongoDB !!SCIENCE!! thread:
@raceprouk said in @ben_lubar's MongoDB !!SCIENCE!! thread:
there seems to be a batch that kills the forum
Oh, I forgot about that. I thought that was fixed...
Some were, but I think I found a new one.
I skipped 10,000 posts, so I should be well past the issue area now.
-
It's cleaned up now, you can thank @boomzilla