github-starred/open-webui
2
0
Fork 0
mirror of https://github.com/open-webui/open-webui.git synced 2026-03-25 12:32:58 -05:00
Code Issues 308 Packages Projects Releases 100 Wiki Activity

feat: external DB support #582

New Issue
Closed
opened 2025-11-11 14:26:43 -06:00 by GiteaMirror · 8 comments
GiteaMirror commented 2025-11-11 14:26:43 -06:00
Owner
Copy Link

Originally created by @tjbck on GitHub (Apr 2, 2024).

Originally created by @tjbck on GitHub (Apr 2, 2024).
GiteaMirror added the enhancementgood first issuehelp wantedcore labels 2025-11-11 14:26:43 -06:00
GiteaMirror commented 2025-11-11 14:26:44 -06:00
Author
Owner
Copy Link

@Lanhild commented on GitHub (Apr 8, 2024):

PostgreSQL would be a good candidate IMO

@Lanhild commented on GitHub (Apr 8, 2024): PostgreSQL would be a good candidate IMO
GiteaMirror commented 2025-11-11 14:26:44 -06:00
Author
Owner
Copy Link

@ghost commented on GitHub (Apr 11, 2024):

PostgreSQL would be a good candidate IMO

I agree but I think the best consideration is to support ORM, something like SQLAlchemy ORM. As long as we adhere to Object Relational Mapper compatible statements, many major databases could be supported! SQLAlchemy presently supports a variety of dialects including PostgreSQL, MySQL and MariaDB, SQLite, Oracle, and Microsoft SQL Server.

@ghost commented on GitHub (Apr 11, 2024): > PostgreSQL would be a good candidate IMO I agree but I think the best consideration is to support ORM, something like [SQLAlchemy ORM](https://docs.sqlalchemy.org/en/20/orm/index.html#sqlalchemy-orm). As long as we adhere to **Object Relational Mapper** compatible statements, many major databases could be supported! SQLAlchemy presently supports a variety of [dialects](https://docs.sqlalchemy.org/en/20/dialects/index.html#dialects) including [PostgreSQL](https://docs.sqlalchemy.org/en/20/dialects/postgresql.html), [MySQL and MariaDB](https://docs.sqlalchemy.org/en/20/dialects/mysql.html), [SQLite](https://docs.sqlalchemy.org/en/20/dialects/sqlite.html), [Oracle](https://docs.sqlalchemy.org/en/20/dialects/oracle.html), and [Microsoft SQL Server](https://docs.sqlalchemy.org/en/20/dialects/mssql.html).
GiteaMirror commented 2025-11-11 14:26:45 -06:00
Author
Owner
Copy Link

@justinh-rahb commented on GitHub (Apr 11, 2024):

@lainedfles I am in full agreement that we need a more flexible solution to data storage, but I get real nervous about ORMs, heard too many horror stories of absolutely unhinged monstrosities of queries full of JOINS being emitted by them. They can make writing the code easier, but it's usually at the cost of efficiency.

@justinh-rahb commented on GitHub (Apr 11, 2024): @lainedfles I am in full agreement that we need a more flexible solution to data storage, but I get real nervous about ORMs, heard too many horror stories of absolutely unhinged monstrosities of queries full of JOINS being emitted by them. They can make writing the code easier, but it's usually at the cost of efficiency.
GiteaMirror commented 2025-11-11 14:26:45 -06:00
Author
Owner
Copy Link

@buroa commented on GitHub (Apr 11, 2024):

Postgres would be the best use case here.

@buroa commented on GitHub (Apr 11, 2024): Postgres would be the best use case here.
GiteaMirror commented 2025-11-11 14:26:45 -06:00
Author
Owner
Copy Link

@sourabratabose commented on GitHub (Apr 14, 2024):

Any update on this one? Where is the data being handled to be stored in database? at /rag/utils.py ?

@sourabratabose commented on GitHub (Apr 14, 2024): Any update on this one? Where is the data being handled to be stored in database? at /rag/utils.py ?
GiteaMirror commented 2025-11-11 14:26:45 -06:00
Author
Owner
Copy Link

@sfn-git commented on GitHub (Apr 14, 2024):

Any update on this one? Where is the data being handled to be stored in database? at /rag/utils.py ?

Not sure whether you are talking about storing the information relating to connecting to the database but I do not believe this path has any relation to that.

I am currently looking at creating relational diagram based off of the models located at backend\apps\web\models. I also believe SQLAlchemy ORM is the best option to implement this from a relational database perspective.

Would there also be considerations for something like Mongo in the future?

@sfn-git commented on GitHub (Apr 14, 2024): > Any update on this one? Where is the data being handled to be stored in database? at /rag/utils.py ? Not sure whether you are talking about storing the information relating to connecting to the database but I do not believe this path has any relation to that. I am currently looking at creating relational diagram based off of the models located at backend\apps\web\models. I also believe [SQLAlchemy ORM](https://docs.sqlalchemy.org/en/20/orm/index.html#sqlalchemy-orm) is the best option to implement this from a relational database perspective. Would there also be considerations for something like Mongo in the future?
GiteaMirror commented 2025-11-11 14:26:46 -06:00
Author
Owner
Copy Link

@Lanhild commented on GitHub (Apr 15, 2024):

Would there also be considerations for something like Mongo in the future?
@sfn-git

IMO, MongoDB isn't appropriate for the practical use case here as Open WebUI database is well defined and structured

@Lanhild commented on GitHub (Apr 15, 2024): > Would there also be considerations for something like Mongo in the future? @sfn-git IMO, MongoDB isn't appropriate for the practical use case here as Open WebUI database is well defined and structured
GiteaMirror commented 2025-11-11 14:26:46 -06:00
Author
Owner
Copy Link

@swatchion commented on GitHub (Nov 14, 2024):

The latest version works on postgresql 16, the only exception is that primary key is not set for some table, like auth table and others. Guess caused by ORM miss-configuration? Or it is intend to configure the table to has no primary key.

Test and deployed by github container images with external postgresql container instance.

@swatchion commented on GitHub (Nov 14, 2024): The latest version works on postgresql 16, the only exception is that primary key is not set for some table, like auth table and others. Guess caused by ORM miss-configuration? Or it is intend to configure the table to has no primary key. Test and deployed by github container images with external postgresql container instance.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
core
documentation
enhancement
good first issue
help wanted
non-core
pull-request
Mirrored from GitHub Pull Request
 python
question
testing wanted
No Label core enhancement good first issue help wanted
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/open-webui#582
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?