Full text vs Q search in django

Question

Django

Greetings!

I recently started learning django, now I'm faced with the issue of searching the database. There is a job advertisement model, you need to organize a search by position name, skills (skills are indicated separated by commas), city and salary. Made an implementation using Q expressions. I especially didn't like the skill field part because I create a Q expression for each keyword. It turns out a very dirty implementation. In production, I assume that 20-30 ads per day will be possible, no more than 500-600 ads at the same time active for search. The question is, should I use sphinx and other libraries for full-text search, or leave the implementation as it is?

Thank you in advance for your response.

Answer 1

It's not very clear how you use Q for each word, do you just collect an expression from them with __icontains through filter along the chain? It and so on idea uses full-text search if the DB allows, emnip. What is the DB anyway?

Answer 2

Many thanks to everyone for the good advice. I decided that I would launch a site with the current implementation, and later, if necessary, I would start using third-party libraries for full-text search.