[PR #14411] [CLOSED] feat Postgres JSONB Support #23466

New Issue

GiteaMirror · 2026-04-20T04:50:32-05:00

GiteaMirror commented

2026-04-20 04:50:32 -05:00

📋 Pull Request Information

Original PR: https://github.com/open-webui/open-webui/pull/14411
Author: @PVBLIC-F
Created: 5/27/2025
Status: ❌ Closed

Base: dev ← Head: dev

📝 Commits (10+)

bea7b2c Update chats.py
c0a4aee Update chats.py
eb42cce Update chats.py
9d4dbf5 Update chats.py
4d915a9 Update chats.py
600614c Update chats.py
6456e83 Update chats.py
c95a6fa Update chats.py
a323ff9 Update chats.py
62711db Update retrieval.py

📊 Changes

2 files changed (+830 additions, -202 deletions)

View changed files

📝 backend/open_webui/models/chats.py (+586 -161)
📝 backend/open_webui/routers/retrieval.py (+244 -41)

📄 Description

Pull Request Checklist

Note to first-time contributors: Please open a discussion post in Discussions and describe your changes before submitting a pull request.

Before submitting, make sure you've checked the following:

Target branch: Please verify that the pull request targets the dev branch.
Description: Provide a concise description of the changes made in this pull request.
Changelog: Ensure a changelog entry following the format of Keep a Changelog is added at the bottom of the PR description.
Documentation: Have you updated relevant documentation Open WebUI Docs, or other documentation sources?
Dependencies: Are there any new dependencies? Have you updated the dependency versions in the documentation?
Testing: Have you written and run sufficient tests to validate the changes?
Code review: Have you performed a self-review of your code, addressing any coding standard issues and ensuring adherence to the project's coding standards?
Prefix: To clearly categorize this pull request, prefix the pull request title using one of the following:
- BREAKING CHANGE: Significant changes that may affect compatibility
- build: Changes that affect the build system or external dependencies
- ci: Changes to our continuous integration processes or workflows
- chore: Refactor, cleanup, or other non-functional code changes
- docs: Documentation update or addition
- feat: Introduces a new feature or enhancement to the codebase
- fix: Bug fix or error correction
- i18n: Internationalization or localization changes
- perf: Performance improvement
- refactor: Code restructuring for better maintainability, readability, or scalability
- style: Changes that do not affect the meaning of the code (white space, formatting, missing semi-colons, etc.)
- test: Adding missing tests or correcting existing tests
- WIP: Work in progress, a temporary label for incomplete or ongoing work

Changelog Entry

Description

Only Added JSONB Support for Postgres

-DatabaseAdapter System
The DatabaseAdapter pattern remains fully functional, providing:
Automatic database type detection with intelligent caching
Template-based query generation for cross-database compatibility
Graceful degradation for unsupported database features

Enterprise-Grade Features
All features continue to work seamlessly:
Multi-tag filtering with AND/OR logic
Content search across chat messages
Untagged chat identification
Pagination and sorting capabilities
Index optimization for large datasets
Quality Assessment
Clean separation of concerns between database adaptation and business logic
Comprehensive type safety and error handling
Sophisticated abstraction layers that hide database complexity
Performance optimizations without sacrificing code clarity

Added

[List any new features, functionalities, or additions]

Changed

[List any changes, updates, refactorings, or optimizations]

Deprecated

[List any deprecated functionality or features that have been removed]

Removed

[List any removed features, files, or functionalities]

Fixed

[List any fixes, corrections, or bug fixes]

Security

[List any new or updated security-related changes, including vulnerability fixes]

Breaking Changes

BREAKING CHANGE: [List any breaking changes affecting compatibility or functionality]

Additional Information

[Insert any additional context, notes, or explanations for the changes]
- [Reference any related issues, commits, or other relevant information]

Screenshots or Videos

[Attach any relevant screenshots or videos demonstrating the changes]

Contributor License Agreement

By submitting this pull request, I confirm that I have read and fully agree to the Contributor License Agreement (CLA), and I am providing my contributions under its terms.

_{🔄 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/open-webui/open-webui/pull/14411 **Author:** [@PVBLIC-F](https://github.com/PVBLIC-F) **Created:** 5/27/2025 **Status:** ❌ Closed **Base:** `dev` ← **Head:** `dev` --- ### 📝 Commits (10+) - [`bea7b2c`](https://github.com/open-webui/open-webui/commit/bea7b2c4fc6f676c162908f62845f15f9c3798d3) Update chats.py - [`c0a4aee`](https://github.com/open-webui/open-webui/commit/c0a4aee114bde10cdceafb069954d5297da23577) Update chats.py - [`eb42cce`](https://github.com/open-webui/open-webui/commit/eb42cce7f52672f90de1fb9514409d0bfec603f0) Update chats.py - [`9d4dbf5`](https://github.com/open-webui/open-webui/commit/9d4dbf54e34465ff55d03e0b23571d88cd2f0c74) Update chats.py - [`4d915a9`](https://github.com/open-webui/open-webui/commit/4d915a93ab8f8cac2c417fd42ccb4bd562fba49a) Update chats.py - [`600614c`](https://github.com/open-webui/open-webui/commit/600614cfda4c24d7bad42f6cb11e795474c03840) Update chats.py - [`6456e83`](https://github.com/open-webui/open-webui/commit/6456e834d9eea2634784e2553839fa6780c4a325) Update chats.py - [`c95a6fa`](https://github.com/open-webui/open-webui/commit/c95a6fa384efc6703adbcc4d919dde79abe9e723) Update chats.py - [`a323ff9`](https://github.com/open-webui/open-webui/commit/a323ff992e796af8c49e0bbff5daced63ffd6f6f) Update chats.py - [`62711db`](https://github.com/open-webui/open-webui/commit/62711db6c5d521646cc9877988f96e91a0598603) Update retrieval.py ### 📊 Changes **2 files changed** (+830 additions, -202 deletions) <details> <summary>View changed files</summary> 📝 `backend/open_webui/models/chats.py` (+586 -161) 📝 `backend/open_webui/routers/retrieval.py` (+244 -41) </details> ### 📄 Description # Pull Request Checklist ### Note to first-time contributors: Please open a discussion post in [Discussions](https://github.com/open-webui/open-webui/discussions) and describe your changes before submitting a pull request. **Before submitting, make sure you've checked the following:** - [ ] **Target branch:** Please verify that the pull request targets the `dev` branch. - [ ] **Description:** Provide a concise description of the changes made in this pull request. - [ ] **Changelog:** Ensure a changelog entry following the format of [Keep a Changelog](https://keepachangelog.com/) is added at the bottom of the PR description. - [ ] **Documentation:** Have you updated relevant documentation [Open WebUI Docs](https://github.com/open-webui/docs), or other documentation sources? - [ ] **Dependencies:** Are there any new dependencies? Have you updated the dependency versions in the documentation? - [ ] **Testing:** Have you written and run sufficient tests to validate the changes? - [ ] **Code review:** Have you performed a self-review of your code, addressing any coding standard issues and ensuring adherence to the project's coding standards? - [ ] **Prefix:** To clearly categorize this pull request, prefix the pull request title using one of the following: - **BREAKING CHANGE**: Significant changes that may affect compatibility - **build**: Changes that affect the build system or external dependencies - **ci**: Changes to our continuous integration processes or workflows - **chore**: Refactor, cleanup, or other non-functional code changes - **docs**: Documentation update or addition - **feat**: Introduces a new feature or enhancement to the codebase - **fix**: Bug fix or error correction - **i18n**: Internationalization or localization changes - **perf**: Performance improvement - **refactor**: Code restructuring for better maintainability, readability, or scalability - **style**: Changes that do not affect the meaning of the code (white space, formatting, missing semi-colons, etc.) - **test**: Adding missing tests or correcting existing tests - **WIP**: Work in progress, a temporary label for incomplete or ongoing work # Changelog Entry ### Description - Only Added JSONB Support for Postgres -DatabaseAdapter System The DatabaseAdapter pattern remains fully functional, providing: Automatic database type detection with intelligent caching Template-based query generation for cross-database compatibility Graceful degradation for unsupported database features - Enterprise-Grade Features All features continue to work seamlessly: Multi-tag filtering with AND/OR logic Content search across chat messages Untagged chat identification Pagination and sorting capabilities Index optimization for large datasets - Quality Assessment Clean separation of concerns between database adaptation and business logic Comprehensive type safety and error handling Sophisticated abstraction layers that hide database complexity Performance optimizations without sacrificing code clarity ### Added - [List any new features, functionalities, or additions] ### Changed - [List any changes, updates, refactorings, or optimizations] ### Deprecated - [List any deprecated functionality or features that have been removed] ### Removed - [List any removed features, files, or functionalities] ### Fixed - [List any fixes, corrections, or bug fixes] ### Security - [List any new or updated security-related changes, including vulnerability fixes] ### Breaking Changes - **BREAKING CHANGE**: [List any breaking changes affecting compatibility or functionality] --- ### Additional Information - [Insert any additional context, notes, or explanations for the changes] - [Reference any related issues, commits, or other relevant information] ### Screenshots or Videos - [Attach any relevant screenshots or videos demonstrating the changes] ### Contributor License Agreement By submitting this pull request, I confirm that I have read and fully agree to the [Contributor License Agreement (CLA)](/CONTRIBUTOR_LICENSE_AGREEMENT), and I am providing my contributions under its terms. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

GiteaMirror added the pull-request label 2026-04-20 04:50:32 -05:00

GiteaMirror closed this issue

2026-04-20 04:50:33 -05:00

GiteaMirror referenced this issue

2026-04-25 09:43:39 -05:00

[GH-ISSUE #23466] issue: Random response stops after tool call #35519

GiteaMirror referenced this issue

2026-05-05 23:39:19 -05:00

[GH-ISSUE #23466] issue: Random response stops after tool call #58656

GiteaMirror referenced this issue

2026-05-13 07:23:34 -05:00

[GH-ISSUE #23466] issue: Random response stops after tool call #74594