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`

Point-Free @pointfreeco@hachyderm.io

9/24/2025, 6:25:17 PM

Public

These 35 lines of code power full-text search in our Reminders app rewrite, and they pack a punch!

🏷️Searches can be tokenized on tag
📍…and search term proximity
🏅Results are returned in ranked order,
🖍️…and matches are highlighted!

Learn how we built it all from scratch in our series on “Modern Search” in Swift: https://www.pointfree.co/collections/modern-persistence/full-text-search

$The following code: Reminder .join(ReminderText.all) { $0.id.eq($1.reminderID) } .where { reminder, reminderText in if !searchText.isEmpty { reminderText.match(searchText.quoted()) } } .where { _, reminderText in for token in searchTokens where !token.value.isEmpty { switch token.kind { case .near: reminderText.match("NEAR(\(token.value))") case .tag: reminderText.tags.match(token.value) } } } .join(RemindersList.all) { $0.remindersListID.eq($2.id) } .order { reminder, reminderText, _ in ( reminder.isCompleted, reminderText.rank ) } .select { reminder, reminderText, remindersList in Row.Columns( color: remindersList.color, formattedNotes: reminderText.notes.snippet("**", "**", "...", 64), formattedTitle: reminderText.title.highlight("**", "**"), isPastDue: reminder.isPastDue, reminder: reminder, tags: reminderText.tags.highlight("**", "**") ) } .fetchAll(db)$

Tim De Jong @tjadejong@mastodon.social

9/24/2025, 7:11:46 PM

Public

@pointfreecoPoint-Free loved the episode! Awesome how easy you guys (and sqlite) made it too implement such complex functionality!

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