Justin Hunter on Warpcast

Content pfp

0 reply

0 recast

2 reactions

Justin Hunter pfp

@polluterofminds

I love articles like this because I think many developers will reach for another bespoke service to do something. Often they’ve been told it’s the only way or they think they need to build for a scale that doesn’t exist yet. https://anyblockers.com/posts/postgres-as-a-search-engine

4 replies

4 recasts

9 reactions

Daniel Lombraña pfp

Daniel Lombraña

If you like this vein of article you might like this one that I wrote a long time ago about building a full text search engine without having any back end 😆 https://daniellombrana.es/blog/2019/02/20/fulltextsearchclient

1 reply

1 recast

1 reaction

Daniel Lombraña pfp

Daniel Lombraña

For my citizen science framework (pybossa), I used Postgresql for fuzzy searches, and it worked well. It was a full search engine finding empty tasks for people to help contribute (i.e., we built a project to tag gluten-free products for kids as you need to read the ingredients and the labels to find out). When a majority (up to 100 people) reviewed each item, we computed some statistical analysis on the contributions to build a canonical tag for the product. The project had a search engine that allowed you to find any product using synonyms, translations, fuzzy searches, etc. Postgresql is beyond amazing. We also use it nowadays as a queue system, so you can avoid installing it in your stack rabbitmq, Kafka, or anything like that. Just simple SQL for background jobs.

0 reply

0 recast

1 reaction

Samuel ツ pfp

@samuellhuber.eth

Keep sharing these🙏💜

0 reply

0 recast

1 reaction

Complexlity pfp

Thanks of sharing man. Really enjoy reading the articles you share. Polluting my mind that's for sure 🫡

0 reply

0 recast

0 reaction