>>8
It's not like there was any meaningful discussion of it yeah, like we ever get meaningful discussion on /prog/ [Anonymous@/prog/ progscrape]$ sqlite3 prog.db "select thread,count(*) from posts where body like \"%SUSHIS_LOGIC%\" group by thread;"
1195467271|1
1199028995|1
1202804002|2
1205528716|2
1206857754|1
1210249472|1
1222512492|1
1222823124|1
1224104914|1
1224517946|1
1233260524|1
1234622548|2
1234677860|1
1236875737|1
1259840120|1
>>9
There's more to discussion than just posts that mention the filename.
sqlite> select thread, count(*) from posts where thread in (select distinct thread from posts where body like '%SUSHIS_LOGIC%') group by thread;
1195467271|36
1199028995|43
1202804002|36
1205528716|43
1206857754|30
1210249472|33
1222512492|25
1222823124|13
1224104914|45
1224517946|14
1233260524|43
1234622548|43
1234677860|8
1236875737|39
1259840120|75
1270892099|6
(I'm sure there's a more elegant way to write that query, but it's been ages since I've written any SQL.)
I sometimes wish /prog/scrape was written in perl; a perl programmer would get the obscene notion to tie into SQLite in such a way that I could make posts via INSERT.
Amazing write-up! This could aid plenty of people find out more about this particular issue. Are you keen to integrate video clips coupled with these? It would absolutely help out. Your conclusion was spot on and thanks to you; I probably won’t have to describe everything to my pals. I can simply direct them here!