~sircmpwn/godocs.io

gddo: internal/database: Improve search SQL query v1 APPLIED

Adnan Maolood: 1
 internal/database: Improve search SQL query

 1 files changed, 2 insertions(+), 1 deletions(-)
Export patchset (mbox)
How do I use this?

Copy & paste the following snippet into your terminal to import this patchset into git:

curl -s https://lists.sr.ht/~sircmpwn/godocs.io/patches/22443/mbox | git am -3
Learn more about email & git
View this thread in the archives

[PATCH gddo] internal/database: Improve search SQL query Export this patch

Rank the results by relevance first, and then by score.
---
 internal/database/database.go | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/internal/database/database.go b/internal/database/database.go
index 5de50bd..5fd8d18 100644
--- a/internal/database/database.go
+++ b/internal/database/database.go
@@ -132,7 +132,8 @@ func (db *Database) Search(ctx context.Context, q string) ([]Package, error) {
			WHERE p.searchtext @@ websearch_to_tsquery('english', $1)
				AND m.module_path = p.module_path AND p.version = m.latest_version
				AND i.import_path = p.import_path
			ORDER BY score DESC, import_path ASC
			ORDER BY ts_rank(p.searchtext, to_tsquery('english', $1)) DESC,
				p.score ASC
			LIMIT 20;
			`, q)
		if err != nil {
-- 
2.31.1
Thanks!

To git@git.sr.ht:~sircmpwn/gddo
   dfc2f02..24ba5a5  master -> master