A place for developers to talk about building on Farcaster.

/dev

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.

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

Writer. Building @pinatacloud. Working on simple static site hosting https://orbiter.host \ https://polluterofminds.com

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.