[Flask] Search options for Flask

Scott Werner scott.werner.vt at gmail.com
Mon Sep 12 15:39:48 EDT 2016

I would look into using full text search
<https://www.postgresql.org/docs/9.5/static/textsearch.html> for
PostgreSQL. It was pretty straight forward to implement and was good enough
for my app. However, since you have the requirement for SQLite, you will
need to look into the SQLite FTS5 Extension <https://sqlite.org/fts5.html>

On Mon, Sep 12, 2016 at 3:10 PM, Alex Alex <alex-alex-90 at wp.pl> wrote:

> I'm looking for a database search solution compatible with SQLAlchemy with
> sqlite and postgresql. At first flask-whooshalchemy seemed like a great
> option but it seems its development has stopped and it generates some
> compatybility warnings and according to this
> https://github.com/gyllstromk/Flask-WhooshAlchemy/issues/21 it requires
> SQLALCHEMY_TRACK_MODIFICATIONS to be set to True. But even after those
> changes it still misses some search result on text columns. So I like the
> idea how it
> supposed to work, but it is not working correctly in my case and it seems
> it is using deprecated options.
> Elasticsearch is another option but it requires additional process to be
> run and I would like to keep my architecture as simple as possible (and at
> one point I will need to run celery and redis to handle async jobs but that
> is future).
> I could get away for some cases with SQLAlchemy filter.like('%%') queries
> but those will not handle all the search cases.
> My question is what are you guys using for searching through text data?
> What are your recommendations?
> Cheers,
> Alex
> _______________________________________________
> Flask mailing list
> Flask at python.org
> https://mail.python.org/mailman/listinfo/flask

Scott Werner
scott.werner.vt at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/flask/attachments/20160912/17dfd016/attachment.html>

More information about the Flask mailing list