[PR #2246] [MERGED] fix: add more indicies for faster bookmark queries #2038

Closed
opened 2026-03-02 12:00:17 +03:00 by kerem · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/karakeep-app/karakeep/pull/2246
Author: @MohamedBassem
Created: 12/11/2025
Status: Merged
Merged: 12/11/2025
Merged by: @MohamedBassem

Base: mainHead: db-indicies


📝 Commits (2)

  • c2215e7 fix: add more indicies for faster bookmark queries
  • 960a9cb Merge branch 'main' into db-indicies

📊 Changes

5 files changed (+3129 additions, -117 deletions)

View changed files

packages/db/drizzle/0068_optimize_bookmark_indicies.sql (+8 -0)
packages/db/drizzle/meta/0068_snapshot.json (+2948 -0)
📝 packages/db/drizzle/meta/_journal.json (+7 -0)
📝 packages/db/schema.ts (+26 -2)
📝 packages/trpc/models/bookmarks.ts (+140 -115)

📄 Description

No description provided


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/karakeep-app/karakeep/pull/2246 **Author:** [@MohamedBassem](https://github.com/MohamedBassem) **Created:** 12/11/2025 **Status:** ✅ Merged **Merged:** 12/11/2025 **Merged by:** [@MohamedBassem](https://github.com/MohamedBassem) **Base:** `main` ← **Head:** `db-indicies` --- ### 📝 Commits (2) - [`c2215e7`](https://github.com/karakeep-app/karakeep/commit/c2215e74501af197e6aeb037cfb329f03cedadbd) fix: add more indicies for faster bookmark queries - [`960a9cb`](https://github.com/karakeep-app/karakeep/commit/960a9cbcc8c79993781011c665f7535b7cc641e5) Merge branch 'main' into db-indicies ### 📊 Changes **5 files changed** (+3129 additions, -117 deletions) <details> <summary>View changed files</summary> ➕ `packages/db/drizzle/0068_optimize_bookmark_indicies.sql` (+8 -0) ➕ `packages/db/drizzle/meta/0068_snapshot.json` (+2948 -0) 📝 `packages/db/drizzle/meta/_journal.json` (+7 -0) 📝 `packages/db/schema.ts` (+26 -2) 📝 `packages/trpc/models/bookmarks.ts` (+140 -115) </details> ### 📄 Description _No description provided_ --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
kerem 2026-03-02 12:00:17 +03:00
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/karakeep#2038
No description provided.