[PR #1441] [CLOSED] doc: add page detailling db structure and tables #1826

New issue

Closed

opened 2026-03-02 11:59:21 +03:00 by kerem · 0 comments

kerem commented

2026-03-02 11:59:21 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/karakeep-app/karakeep/pull/1441
Author: @thiswillbeyourgithub
Created: 5/19/2025
Status: ❌ Closed

Base: main ← Head: doc_db_structure

📝 Commits (1)

4650ecf doc: add db structure

📊 Changes

1 file changed (+490 additions, -1 deletions)

View changed files

📝 docs/docs/07-Development/03-database.md (+490 -1)

📄 Description

This was made to help solve #1403

This was made purely by prompting two state of the art LLMs based on ./packages/db/schema.ts until they converged and stopped modifying anything, as I figured their combined error rates is far below mine. Surprisingly it took more than 10 iterations.

Hence this PR must be proof read by someone who is familiar with sqlite, and was done to reduce the burden on the dev team's shoulders.

Let me know if that's an issue!

_{🔄 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/1441 **Author:** [@thiswillbeyourgithub](https://github.com/thiswillbeyourgithub) **Created:** 5/19/2025 **Status:** ❌ Closed **Base:** `main` ← **Head:** `doc_db_structure` --- ### 📝 Commits (1) - [`4650ecf`](https://github.com/karakeep-app/karakeep/commit/4650ecf2998e27bb111d26bacca34004525a57fb) doc: add db structure ### 📊 Changes **1 file changed** (+490 additions, -1 deletions) <details> <summary>View changed files</summary> 📝 `docs/docs/07-Development/03-database.md` (+490 -1) </details> ### 📄 Description This was made to help solve #1403 This was made purely by prompting two state of the art LLMs based on `./packages/db/schema.ts` until they converged and stopped modifying anything, as I figured their combined error rates is far below mine. Surprisingly it took more than 10 iterations. Hence this PR must be proof read by someone who is familiar with sqlite, and was done to reduce the burden on the dev team's shoulders. Let me know if that's an issue! --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

kerem

2026-03-02 11:59:21 +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#1826

No description provided.

Rows
Columns