Add text search based on title, authors, abstract and potentially full text #242
Description
Stick to Postgres.
Explore using pg_search:
- https://www.paradedb.com/blog/introducing-search
- https://github.com/paradedb/paradedb/tree/main/pg_search
- https://pgxn.org/dist/pg_search/
Challenge: need to have an image that works with PostGIS and Django:
- Add
pg_searchsupport to Django paradedb/paradedb#1098 - Support for Geospatial data using GeoParquet (or similar) paradedb/paradedb#865 (base image seems to have PostGIS)
- https://code.djangoproject.com/ticket/35421
Related to #146