search

sontek / notaliens.com

A website for showcasing pyramid powered sites and the hackers that use it!
11 stars 9 forks source link

Using Postgres FTS to minimise the maintenance #28

Open rach opened 10 years ago

rach commented 10 years ago

First, Great initiative. It will be great to have something like that online, we have got some very cool project which has been build with pyramid.

Recently I did loads of works with Elasticsearch for at the end falling back on the Postegres Full-Text search. The main arguments was that for the project needs, Elasticsearch was not bringing any advantage but only more maintenance issues with maintaining the cluster.

I also wrote a post to explain FTS with Postgres: http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/

Only a suggestion to make like easier but otherwise I have an ansible role that I can share for elastic search.

sontek commented 10 years ago

@rach I actually started down that path but I'm most familiar with elasticsearch. I'll look at your post and if it gets me familiar enough with FTS in psql I'd love to have it in (it was the original goal, but since time is limited I went with what I knew)

rach commented 10 years ago

It was only a suggestion to make life easier. Btw, are you planning to sprint on this project during Pycon? It will be very useful for us in London, we start to be a bunch of company/product using Pyramid but no body really have much clues.. Same for hiring. Great initiative.