Say I have a large txt or CSV file with data I want to search. And say I have several files.
What is the best way to index and make this data searchable? I’ve been using grep, but it is not ideal.
Is there any self hostable docker container for indexing and searching this? Or maybe should I use SQL?
Why bother setting up a hosted DB server when you can get all of the RDBMS optimizations in an in-process service? DuckDB is pretty cool
https://duckdb.org/