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`

marius @mariusor@metalhead.club

1/8/2026, 11:31:17 AM

Public

If anyone is using the latest versions of mattn/go-sqlite3 module you might have an unpleasant surprise if your tables contain JSON data in BLOB columns and the table is also using STRICT.

Since sqlite 3.45.1 it's encouraged to move those columns to TEXT.

https://sqlite.org/json1.html#the_json_blob_input_bug

I spent two days trying to find why the #GoActivityPub sqlite storage
has started to fail out of the blue (well, not really "out of the blue", rather an unfortunate congruence of dependency updates and adding extra stress to the json payloads saving/updates).

#Go #sqlite

JSON Functions And Operators

sqlite.org

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