mirrors
/
navidrome
mirror of https://github.com/navidrome/navidrome.git
2
0
Fork 0
Code Issues Projects Releases Wiki Activity
3,715 Commits 11 Branches 91 Tags 67 MiB
Commit Graph

14 Commits

Author SHA1 Message Date
Deluan Quintão 0ca0d5da22
Replace beego/orm with dbx (#2693) 
* Start migration to dbx package

* Fix annotations and bookmarks bindings

* Fix tests

* Fix more tests

* Remove remaining references to beego/orm

* Add PostScanner/PostMapper interfaces

* Fix importing SmartPlaylists

* Renaming

* More renaming

* Fix artist DB mapping

* Fix playlist updates

* Remove bookmarks at the end of the test

* Remove remaining `orm` struct tags

* Fix user timestamps DB access

* Fix smart playlist evaluated_at DB access

* Fix search3
 2023-12-09 13:52:17 -05:00
Deluan Quintão 60a5fbe1fe
Optimize search3, by removing `OFFSET` when paginating (#2655) 
* Optimize pagination, removing offset

* For search, don't add `where` clause for empty queries

* Revert "Replace `COUNT(DISTINCT primary_key)` with `COUNT(*)`"

Genres are required as part of the count queries, so filter by genres work

* Optimize search3 query, using order by id if it is a "" query.

Also fix the optimizePagination query logic

* Allow offset optimizer threshold to be configured
 2023-11-27 13:06:23 -05:00
Deluan 6ee45a9ccc Move project to Navidrome GitHub organization 2021-02-06 21:46:35 -05:00
Deluan 4f90fa9924 Add denormalized list of artist_ids to album, to speed-up artist's albums queries 
This will be removed once we have a proper many-to-many relationship between album and artist
 2020-12-13 14:05:48 -05:00
Deluan 76e522710a New option: SearchFullString, to match query strings anywhere in searchable fields, not only in word boundaries 
Based on feedback from @orlea, in https://github.com/deluan/navidrome/issues/255#issuecomment-683427754
 2020-08-30 13:08:10 -04:00
Deluan aaa4f1531e Ignore brackets in search 2020-05-25 11:05:30 -04:00
Deluan 80c8d85cb9 Fine tune search functionality 2020-04-19 23:29:07 -04:00
Deluan b8d1185f7f Remove duplicated words and extra spaces from full text searchable fields 2020-04-08 23:29:28 -04:00
Deluan 32fbf2e9eb refactor: drop search table, integrated full_text into main tables 2020-03-19 21:44:48 -04:00
Deluan 33ede13eef fix: check if album is starred before adding the starred date in the response. also return "starred" in search responses 2020-02-24 22:06:12 -05:00
Deluan 8a31e80b7a fix: find songs and albums when sending an artist name search query 2020-02-09 19:52:06 -05:00
Deluan 5a95feeedc fix: allow searches with 2 chars. closes #65 2020-02-09 12:20:34 -05:00
Deluan 7c4511e33a refactor: consolidate query executions into two functions `queryOne` and `queryAll` 2020-02-01 17:23:03 -05:00
Deluan 0d0787e656 refactor:clean annotations in GC 2020-02-01 17:23:03 -05:00
Renamed from persistence/search.go (Browse further)