Hackers' Pub

Syntax	Description	Examples
`"` keyword `"`	Finds the string within quotes, including spaces. Case-insensitive. (Escape quotes inside with `\"`)	`"Hackers' Pub"`
`from:` handle	Finds content written by the specified user.	`from:hongminhee` `from:hongminhee@hollo.social`
`lang:` ISO 639-1	Finds content written in the specified language.	`lang:en`
`#` tag	Finds content with the specified tag. Case-insensitive.	`#HackersPub`
condition condition	Finds content that satisfies both conditions on either side of the space (logical AND).	`"Hackers' Pub" lang:en`
condition `OR` condition	Finds content that satisfies at least one of the conditions on either side of the OR operator (logical OR).	`#HackersPub OR "Hackers' Pub" lang:en`
`(` condition `)`	Combines the operators within the parentheses first.	`(#HackersPub OR "Hackers' Pub" OR "Hackers Pub") lang:en`

JasonPunyon @jasonpunyon@hachyderm.io

4/27/2025, 9:49:35 PM

Public

Ever wanted to do something with the #stackoverflow data dumps but found their multi gigabyte XML files too hard to deal with? That is...if you could find them at all after they stopped posting to the internet archive?

SEqlite's for you! It's the info from the dumps you probably care about, preprocessed into SQLite databases with indexes.

https://seqlite.puny.engineering

sleeping shaq meme

stack exchange data dump in pile of xml files: i sleep

stack exchange data dump in sqlite databases with indexes, y'know so you can actually use it: real shit

If you have a fediverse account, you can quote this note from your own instance. Search https://hachyderm.io/users/jasonpunyon/statuses/114412131150209784 on your instance and quote it. (Note that quoting is not supported in Mastodon.)