thanks Simon but I am not using postgresql. I am using sqlite3 database. so I want a global solution, that work in all the databases.
On Tue, Jul 6, 2021 at 1:54 AM Simon Charette <charett...@gmail.com> wrote: > 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, abubak...@gmail.com 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 <sutharl...@gmail.com> 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 <abubak...@gmail.com> >>> 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 django-users...@googlegroups.com. >>>> 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 django-users...@googlegroups.com. >>> >> 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 django-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/c77799f3-1492-459a-8187-8d62985407b6n%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/c77799f3-1492-459a-8187-8d62985407b6n%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 django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKPY9pnp0GG%2BwUHf68gfbMXUMV9BiY7qsR%3D_Dw1yrmsEkK6SdA%40mail.gmail.com.
