I'm on here looking for text indexers and everything is 'lightning fast exoscale terafloops that scales to enterprise quantawarbles with polytopplic performanations' and it would be great if this industry could breathe into a bag until it remembers that one person with one computer is a constituency that matters.
@mhoye if it's data usable by a single person, sqlite is almost always the easiest choice and is usually good enough. for text indexing you'd need a fts5 table, i've never used this extension though so take this advice with a grain of salt.
@Pashhur @mhoye I've used FTS5 and its predecessors, they take just a little bit of schema creation work but then they just work perfectly, speedily, every time. You're offered a lot of very rich query functionality but you don't actually need to learn or use any of it to get good results out of the box.