If you're using a PostgreSQL you might want to look at using a tsvector column instead which will ignore stop words (the, or, of, ...) and map lexemes to their number of occurrence and position in the lyrics[0]. Assuming you were to index this column you'd be able to efficiently query it for existence of a particular lexeme or multiple of them.
You could then a union of all a user's song lyrics tsvector and even apply weights based on their listening frequency or their favorite songs. Cheers, Simon [0] https://stackoverflow.com/questions/25445670/retrieving-position-and-number-of-lexem-occurrences-from-tsvector Le lundi 5 juillet 2021 à 13:51:48 UTC-4, [email protected] a écrit : > Thank you Lalit bhai. > it seems to be a solution. > but what if I want to get the result for each single word rather than > single letter? > > > On Mon, Jul 5, 2021 at 5:43 PM Lalit Suthar <[email protected]> wrote: > >> https://www.guru99.com/python-counter-collections-example.html >> Counter can be helpful for this situation >> >> On Mon, 5 Jul 2021 at 17:07, DJANGO DEVELOPER <[email protected]> >> wrote: >> >>> Hi there. >>> I am developing a project based on adding songs to the user's library >>> and to the home page. >>> other users can also purchase the songs like wise people do shopping on >>> eCommerce stores. >>> *Problem:(Question)* >>> The problem that I want to discuss here is that when a user adds a sing >>> through django forms, and now that song is added to the user's personal >>> library. >>> now what I want to do is : >>> >>> >>> *When the lyrics of a song are added as a record to the "Song" table, >>> the individual words in that song should be added to a 2nd table with their >>> frequency of usage within that song (so the words need to be counted and a >>> signal needs to be created).Also, when a user adds the song to his/her >>> personal library, all of the words from the song and their frequencies >>> within that song should be added to another table and associated with that >>> user.* >>> >>> how to count same word within a song? >>> >>> can anyone help me here? >>> your help would be appreciated. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Django users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/bc7bc37b-6f26-465c-b330-d275ab86b76an%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/django-users/bc7bc37b-6f26-465c-b330-d275ab86b76an%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/CAGp2JVHuos6d4%3D-_S%3DR-q8hq48Yzf%3D-xgmPziKEA2a3DYXAzbg%40mail.gmail.com >> >> <https://groups.google.com/d/msgid/django-users/CAGp2JVHuos6d4%3D-_S%3DR-q8hq48Yzf%3D-xgmPziKEA2a3DYXAzbg%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/c77799f3-1492-459a-8187-8d62985407b6n%40googlegroups.com.
