[Flask] Search options for Flask

Corey Boyle coreybrett at gmail.com
Mon Sep 12 15:53:14 EDT 2016

@Alex - Are you using SQLite for development only?

I was doing that for awhile, but kept finding errors in my code that
were not triggered by SQLite, but were by PostgreSQL.

I ended up switching to PostgreSQL for my dev environment as well.

On Mon, Sep 12, 2016 at 3:39 PM, Scott Werner <scott.werner.vt at gmail.com> wrote:
> I would look into using full text search 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 also.
> 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
> _______________________________________________
> Flask mailing list
> Flask at python.org
> https://mail.python.org/mailman/listinfo/flask

More information about the Flask mailing list