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`

Ian Wagner @ianthetechie@fosstodon.org

9/17/2025, 3:46:52 AM

Public

Hot take: everyone (including me, sometimes) loves to hate on SQL and regular expressions. IMO they are fantastic examples of DSLs which, despite having a bit of a learning curve and diverse implementations, are extremely valuable.

SQL in particular is only getting stronger. Over the last few months, I’ve been able to architect extremely flexible data pipelines using DuckDB and DataFusion. The iteration speed I achieved simply wouldn’t be possible without SQL.

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