News for hackers. Stuff that matters.

A comment on Ask HN: Is there any software you only made for your own use but nobody else?. Parent comment

Re:Ask HN: Is there any software you only made for your own ... by positr0n on Friday July 05, 2024 @11:35AM (#40883647)
How does the full text search work?

On-device copy of all the notes? Text index in another database? Just download them all from s3 when you search?

[ Parent | on HN ]
Re:Ask HN: Is there any software you only made for your own ... by 65 on Friday July 05, 2024 @11:48AM (#40883759)
Text gets indexed in another database every time a note gets saved/deleted/created. There might be better solutions with AWS Athena but using a simple MySQL database was by far the easiest (and quickest in terms of querying) way to add full text search. My database is paid via usage so I don't have to spend much money, if any, to index my notes.
[ Parent | on HN ]