[PR #239] [MERGED] Replace custom sqlite dbms with prisma #3259

Closed
opened 2026-02-22 18:33:24 -05:00 by yindo · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/Mintplex-Labs/anything-llm/pull/239
Author: @shatfield4
Created: 9/14/2023
Status: Merged
Merged: 9/28/2023
Merged by: @timothycarambat

Base: masterHead: 237-replace-custom-sqlite-dbms-with-prisma


📝 Commits (10+)

  • 064b0b8 WIP converted all sqlite models into prisma calls
  • e1368ea modify db setup and fix ApiKey model calls in admin.js
  • ee4013f renaming function params to be consistent
  • 7cc4e04 converted adminEndpoints to utilize prisma orm
  • 056b7da converted chatEndpoints to utilize prisma orm
  • 067cd09 converted inviteEndpoints to utilize prisma orm
  • db0886a converted systemEndpoints to utilize prisma orm
  • 78d1094 converted workspaceEndpoints to utilize prisma orm
  • 191763b converting sql queries to prisma calls
  • 902b0ce fixed default param bug for orderBy and limit

📊 Changes

44 files changed (+9521 additions, -1383 deletions)

View changed files

📝 .gitignore (+1 -1)
📝 docker/Dockerfile (+4 -0)
📝 frontend/src/components/Modals/MangeWorkspace/Documents/index.jsx (+1 -1)
📝 frontend/src/components/Modals/MangeWorkspace/Settings/index.jsx (+17 -1)
📝 package.json (+6 -2)
📝 server/.gitignore (+2 -1)
📝 server/endpoints/admin.js (+24 -21)
📝 server/endpoints/api/admin/index.js (+43 -44)
📝 server/endpoints/api/workspace/index.js (+28 -29)
📝 server/endpoints/chat.js (+19 -12)
📝 server/endpoints/invite.js (+2 -3)
📝 server/endpoints/system.js (+6 -5)
📝 server/endpoints/workspaces.js (+16 -18)
📝 server/index.js (+1 -2)
📝 server/models/apiKeys.js (+69 -104)
📝 server/models/documents.js (+40 -102)
📝 server/models/invite.js (+90 -160)
📝 server/models/systemSettings.js (+65 -107)
📝 server/models/telemetry.js (+17 -12)
📝 server/models/user.js (+60 -153)

...and 24 more files

📄 Description

Integrating Prisma ORM to replace the custom sqlite dbms to improve developer experience.

resolves #237


🔄 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/Mintplex-Labs/anything-llm/pull/239 **Author:** [@shatfield4](https://github.com/shatfield4) **Created:** 9/14/2023 **Status:** ✅ Merged **Merged:** 9/28/2023 **Merged by:** [@timothycarambat](https://github.com/timothycarambat) **Base:** `master` ← **Head:** `237-replace-custom-sqlite-dbms-with-prisma` --- ### 📝 Commits (10+) - [`064b0b8`](https://github.com/Mintplex-Labs/anything-llm/commit/064b0b8e6492d8a2c53c78c42f45e01a08b5db54) WIP converted all sqlite models into prisma calls - [`e1368ea`](https://github.com/Mintplex-Labs/anything-llm/commit/e1368ea226d97ad3ad56262322127e6d370c325f) modify db setup and fix ApiKey model calls in admin.js - [`ee4013f`](https://github.com/Mintplex-Labs/anything-llm/commit/ee4013f7516e2dd53bca9486fefccac8db9ee21e) renaming function params to be consistent - [`7cc4e04`](https://github.com/Mintplex-Labs/anything-llm/commit/7cc4e0480bbbdce9d06390c2dec36538ba3ff0e2) converted adminEndpoints to utilize prisma orm - [`056b7da`](https://github.com/Mintplex-Labs/anything-llm/commit/056b7da9502e8a02acca0e1254c2055ec10d36cd) converted chatEndpoints to utilize prisma orm - [`067cd09`](https://github.com/Mintplex-Labs/anything-llm/commit/067cd094193e0864d0df33362e24c4f9e1d607ae) converted inviteEndpoints to utilize prisma orm - [`db0886a`](https://github.com/Mintplex-Labs/anything-llm/commit/db0886a27711e1de1697c5f315b0ccd29dcec3e0) converted systemEndpoints to utilize prisma orm - [`78d1094`](https://github.com/Mintplex-Labs/anything-llm/commit/78d1094684c959d3e1b48851c023e66a1639ebfd) converted workspaceEndpoints to utilize prisma orm - [`191763b`](https://github.com/Mintplex-Labs/anything-llm/commit/191763b28b34fe8929d980a04d24933242f189b0) converting sql queries to prisma calls - [`902b0ce`](https://github.com/Mintplex-Labs/anything-llm/commit/902b0cea2abb7dcab3a12e8631587a3b22999f3a) fixed default param bug for orderBy and limit ### 📊 Changes **44 files changed** (+9521 additions, -1383 deletions) <details> <summary>View changed files</summary> 📝 `.gitignore` (+1 -1) 📝 `docker/Dockerfile` (+4 -0) 📝 `frontend/src/components/Modals/MangeWorkspace/Documents/index.jsx` (+1 -1) 📝 `frontend/src/components/Modals/MangeWorkspace/Settings/index.jsx` (+17 -1) 📝 `package.json` (+6 -2) 📝 `server/.gitignore` (+2 -1) 📝 `server/endpoints/admin.js` (+24 -21) 📝 `server/endpoints/api/admin/index.js` (+43 -44) 📝 `server/endpoints/api/workspace/index.js` (+28 -29) 📝 `server/endpoints/chat.js` (+19 -12) 📝 `server/endpoints/invite.js` (+2 -3) 📝 `server/endpoints/system.js` (+6 -5) 📝 `server/endpoints/workspaces.js` (+16 -18) 📝 `server/index.js` (+1 -2) 📝 `server/models/apiKeys.js` (+69 -104) 📝 `server/models/documents.js` (+40 -102) 📝 `server/models/invite.js` (+90 -160) 📝 `server/models/systemSettings.js` (+65 -107) 📝 `server/models/telemetry.js` (+17 -12) 📝 `server/models/user.js` (+60 -153) _...and 24 more files_ </details> ### 📄 Description Integrating Prisma ORM to replace the custom sqlite dbms to improve developer experience. resolves #237 --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
yindo added the pull-request label 2026-02-22 18:33:24 -05:00
yindo closed this issue 2026-02-22 18:33:24 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Mintplex-Labs/anything-llm#3259