News for hackers. Stuff that matters.
Re:Creating an advanced search engine with PostgreSQL by bshipp on Wednesday July 12, 2023 @03:01PM (#36700020)
I've had good luck using FTS5 in Sqlite for small-scale use scenarios, such as examining scraped data, etc. It's remarkably powerful and quick.

https://www.sqlitetutorial.net/sqlite-full-text-search/

https://www.sqlite.org/fts5.html

Re:Creating an advanced search engine with PostgreSQL by anitil on Wednesday July 12, 2023 @07:43PM (#36703219)
I put together a demo of this for work where I pulled all our private repos and built an index, then used datasette as the front end.

It was incredibly fast, so much so that I found it more useful than github search. The index is pretty out of date now but I still use it purely based on convenience and speed