3 ms·
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?
by positr0n 2y ago
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?
- 65 2y agoText 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.