search

Quran-Journey / backend

The main backend service for Quran Journey
5 stars 1 forks source link

Add a search feature to search through certain columns in the database #142

Open osamaramihafez opened 2 years ago

osamaramihafez commented 2 years ago

We need to be able to search for a surah based on a substring of the surah name.

Quran.com also allows you to search by surah number, page number, a surah:verse key, etc.

A good video on implementing search in postgres: https://www.youtube.com/watch?v=szfUbzsKvtE&

What ts_vectors are and how they help with full text search: https://forestry.io/blog/full-text-searching-with-postgres/#:~:text=The%20tsvector%20Type,of%20distinct%20words%20called%20lexemes.

udokaokoye commented 2 years ago

Do you have a remote database? or an export of your current database?

osamaramihafez commented 2 years ago

No, we currently just have the schema and a few scripts that populate the database with incomplete mock data. @udokaokoye

To find them, check our db folder in the master branch