[PR #2424] [CLOSED] Add indexing timestamps to bookmarks and bookmark links #2098

New issue

Closed

opened 2026-03-02 12:00:33 +03:00 by kerem · 0 comments

kerem commented

2026-03-02 12:00:33 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/karakeep-app/karakeep/pull/2424
Author: @MohamedBassem
Created: 1/25/2026
Status: ❌ Closed

Base: main ← Head: claude/add-bookmark-indexing-timestamps-96bPj

📝 Commits (1)

f3ed2b7 feat(db): add bookmark indexing timestamp fields

📊 Changes

4 files changed (+3048 additions, -0 deletions)

View changed files

➕ packages/db/drizzle/0077_add_bookmark_indexing_timestamps.sql (+2 -0)
➕ packages/db/drizzle/meta/0077_snapshot.json (+3037 -0)
📝 packages/db/drizzle/meta/_journal.json (+7 -0)
📝 packages/db/schema.ts (+2 -0)

📄 Description

Summary

This PR adds timestamp tracking for bookmark indexing operations to improve visibility into the indexing pipeline and enable better debugging and monitoring of the bookmark crawling process.

Changes

Added indexedAt timestamp field to the bookmarks table to track when a bookmark was indexed
Added indexedPostCrawlingAt timestamp field to the bookmarkLinks table to track when a bookmark link was indexed after crawling
Created new database migration (0077) to add these columns to the schema
Updated the schema definitions in packages/db/schema.ts to reflect the new fields

Implementation Details

Both timestamp fields use SQLite's integer mode with timestamp conversion for consistency with existing timestamp fields in the schema
The migration includes proper breakpoint configuration for Drizzle ORM
These fields will enable tracking of the indexing workflow and help identify any delays or issues in the indexing process

_{🔄 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/2424 **Author:** [@MohamedBassem](https://github.com/MohamedBassem) **Created:** 1/25/2026 **Status:** ❌ Closed **Base:** `main` ← **Head:** `claude/add-bookmark-indexing-timestamps-96bPj` --- ### 📝 Commits (1) - [`f3ed2b7`](https://github.com/karakeep-app/karakeep/commit/f3ed2b7ff36a1daa6677f01db44344c4dc456c10) feat(db): add bookmark indexing timestamp fields ### 📊 Changes **4 files changed** (+3048 additions, -0 deletions) <details> <summary>View changed files</summary> ➕ `packages/db/drizzle/0077_add_bookmark_indexing_timestamps.sql` (+2 -0) ➕ `packages/db/drizzle/meta/0077_snapshot.json` (+3037 -0) 📝 `packages/db/drizzle/meta/_journal.json` (+7 -0) 📝 `packages/db/schema.ts` (+2 -0) </details> ### 📄 Description ## Summary This PR adds timestamp tracking for bookmark indexing operations to improve visibility into the indexing pipeline and enable better debugging and monitoring of the bookmark crawling process. ## Changes - Added `indexedAt` timestamp field to the `bookmarks` table to track when a bookmark was indexed - Added `indexedPostCrawlingAt` timestamp field to the `bookmarkLinks` table to track when a bookmark link was indexed after crawling - Created new database migration (0077) to add these columns to the schema - Updated the schema definitions in `packages/db/schema.ts` to reflect the new fields ## Implementation Details - Both timestamp fields use SQLite's integer mode with timestamp conversion for consistency with existing timestamp fields in the schema - The migration includes proper breakpoint configuration for Drizzle ORM - These fields will enable tracking of the indexing workflow and help identify any delays or issues in the indexing process --- <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:33 +03:00

closed this issue
added the
pull-request
label

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#2098

No description provided.

Rows
Columns