×
Login Register an account
Top Submissions Explore Upgoat Search Random Subverse Random Post Colorize! Site Rules
41

searchvoat archive dump

submitted by v0atmage to TellTalk 1.8 yearsMay 30, 2022 22:42:07 ago (+42/-1)     (TellTalk)

Full disclosure: I have not looked at this data too thoroughly but I think I managed to get it all. It's apparently compressed sql data so to fully leverage it you need to run the sql statements in a mariadb session and then run adhoc queries.

Alternatively you could use something like zgrep.

I am lazily getting around to hosting my own lemmy server so I might try to migrate the data into that database at some point.

https://anonfiles.com/XaX6Adlfy5/svf.sql_gz
https://anonfiles.com/n1YaA0l3y9/images_tgz
https://anonfiles.com/x4Z7A5lfy7/user.sql_gz
https://anonfiles.com/5bZ8A9lbyf/userBadge.sql_gz
https://anonfiles.com/9eZ3Afl4yd/subverse.sql_gz
https://anonfiles.com/J7Z8Ael3y2/www_tgz
https://anonfiles.com/P2Z5A3l3ya/subverseModerator.sql_gz
https://anonfiles.com/R3ZfAfl1y2/submissionAttribute.sql_gz
https://anonfiles.com/z3a3B3l5y0/top50.sql_gz
https://anonfiles.com/J6a5B9l7yb/subverseSubscribers.sql_gz
https://anonfiles.com/D8baB3l5y6/submission.sql_gz
https://anonfiles.com/L2t2B0l1ye/comment.sql_gz


21 comments block


[ - ] beece 6 points 1.8 yearsMay 31, 2022 07:29:45 ago (+6/-0)

Thanks @V0atmage! It would be embarrassing for any of us to have to ask the Mossad for their copy:-)

[ - ] TankTinker 4 points 1.8 yearsMay 31, 2022 01:13:38 ago (+4/-0)

https://i.postimg.cc/Y92yPX7k/sql-Top-50.png

So what are you supposed to do to access the Search Voat files, 'coz this stuff means nothing to me.

[ - ] Boardallday3 2 points 1.8 yearsMay 31, 2022 01:32:24 ago (+2/-0)

Dude, just follow this procedure it's not complicated: https://m.youtube.com/watch?v=67gYEK4FtzA

[ - ] MartinTimothy 2 points 1.8 yearsMay 31, 2022 05:19:11 ago (+2/-0)

The video was incomprehensible ..

[ - ] knightwarrior41 4 points 1.8 yearsMay 31, 2022 01:06:43 ago (+4/-0)

there's a reason he's doing this i believe. the current political and social climate in the western world are hostile for the free exchange of ideas

[ - ] Boardallday3 4 points 1.8 yearsMay 31, 2022 01:42:05 ago (+4/-0)

Ya think? I've spent hundreds of dollars on storage backing up documentaries and videos and books. The internet is more fallible than the power grid.

Like 150 dollars

[ - ] WorldsEndFriend 4 points 1.8 yearsMay 31, 2022 02:11:13 ago (+4/-0)

Do you know of a documentary about Germans after WWII and the nightmare they went through, how do many of them were raped, murdered and gunned down? One section talked about a family that endured hardships to get to a boat of rescued civilians only to have a submarine sink it. I've been trying to find it to add to my own collection.

[ - ] GloryBeckons 3 points 1.8 yearsMay 31, 2022 02:15:35 ago (+3/-0)

I think I recall that being featured in Greatest Story Never Told, but you may be thinking of another one.

[ - ] Boardallday3 2 points 1.8 yearsMay 31, 2022 05:02:10 ago (+2/-0)

Probably that but the full version of Europa the last battle gets into that history.

[ - ] NationalSocialism 3 points 1.8 yearsMay 31, 2022 03:50:43 ago (+3/-0)

Germans after WWII and the nightmare they went through

The biggest tragedy of WWII and it’s basically hidden from the public. We have to hear endless fictional stories about the holocaust of jews and other degenerates.

to get to a boat of rescued civilians only to have a submarine sink it.

If you find it, please make a post about this.

[ - ] Zinnsee 4 points 1.8 yearsMay 31, 2022 04:51:31 ago (+4/-0)

The ships name was Wilhelm Gustloff

[ - ] NationalSocialism 2 points 1.8 yearsMay 31, 2022 04:55:18 ago (+2/-0)

Thanks, much appreciated!

[ - ] myshadoww 2 points 1.8 yearsMay 31, 2022 07:29:58 ago (+2/-0)*

[ - ] WorldsEndFriend 0 points 1.8 yearsJun 1, 2022 14:57:35 ago (+0/-0)

That's the one, Hellstorm. Man, what a difficult documentary to watch... The Germans just didn't want to be a part of the Federal Reserve and have their own country, but the jews really made sure it was destroyed, their people all but wiped out and for Germany to exist only "for israel". It's heart breaking to see such a beautiful country fall so much.

[ - ] deleted 2 points 1.8 yearsMay 31, 2022 09:31:52 ago (+2/-0)*

deleted

[ - ] DonaldJTrump 2 points 1.8 yearsMay 31, 2022 08:53:59 ago (+2/-0)

Mage, come join us in the #skunkworks channel. I want to hear about your Lemmy instance. We've also got some other projects that aren't entirely standing still you might enjoy.

[ - ] v0atmage [op] 1 point 1.8 yearsMay 31, 2022 10:00:45 ago (+1/-0)

will do!

[ - ] v0atmage [op] 0 points 1.8 yearsJun 5, 2022 18:30:21 ago (+0/-0)

I couldn't log in for some reason. rejected my passwords I believe.

[ - ] deleted 2 points 1.8 yearsMay 30, 2022 23:22:33 ago (+2/-0)

deleted

[ - ] deleted 1 point 1.8 yearsMay 31, 2022 11:32:56 ago (+1/-0)

deleted

[ - ] RomanSalute 1 point 1.8 yearsMay 31, 2022 08:39:25 ago (+1/-0)

Saved.

Thanks, mage!