[PR #872] [MERGED] add postgresql backend #2831

New issue

Closed

opened 2026-03-01 17:23:26 +03:00 by kerem · 0 comments

kerem commented

2026-03-01 17:23:26 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/1Remote/1Remote/pull/872
Author: @goldenbull
Created: 2/21/2025
Status: ✅ Merged
Merged: 2/22/2025
Merged by: @VShawn

Base: main ← Head: postgres

📝 Commits (1)

d2018ae add postgresql backend

📊 Changes

9 files changed (+571 additions, -27 deletions)

View changed files

📝 Ui/Service/DataSource/DAO/Dapper/DapperDataBase.cs (+43 -16)
📝 Ui/Service/DataSource/DAO/IDataBase.cs (+5 -1)
📝 Ui/Service/DataSource/Model/DataSourceBase.Config.cs (+1 -0)
➕ Ui/Service/DataSource/Model/PgsqlSource.cs (+103 -0)
📝 Ui/Ui.csproj (+1 -0)
📝 Ui/View/Settings/DataSource/DataSourceView.xaml (+19 -0)
📝 Ui/View/Settings/DataSource/DataSourceViewModel.cs (+11 -10)
➕ Ui/View/Settings/DataSource/PgsqlSettingView.xaml (+144 -0)
➕ Ui/View/Settings/DataSource/PgsqlSettingViewModel.cs (+244 -0)

📄 Description

PostgreSQL backend support code is very similar to MySQL, the major difference is the quote character for identifiers.
Since all SQL scripts are quite simple, we can just replace the backtick with double quote to make all DBMS backends work in the same way.

_{🔄 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/1Remote/1Remote/pull/872 **Author:** [@goldenbull](https://github.com/goldenbull) **Created:** 2/21/2025 **Status:** ✅ Merged **Merged:** 2/22/2025 **Merged by:** [@VShawn](https://github.com/VShawn) **Base:** `main` ← **Head:** `postgres` --- ### 📝 Commits (1) - [`d2018ae`](https://github.com/1Remote/1Remote/commit/d2018aece0b3e90a023983091ec557dbf5bd1f0e) add postgresql backend ### 📊 Changes **9 files changed** (+571 additions, -27 deletions) <details> <summary>View changed files</summary> 📝 `Ui/Service/DataSource/DAO/Dapper/DapperDataBase.cs` (+43 -16) 📝 `Ui/Service/DataSource/DAO/IDataBase.cs` (+5 -1) 📝 `Ui/Service/DataSource/Model/DataSourceBase.Config.cs` (+1 -0) ➕ `Ui/Service/DataSource/Model/PgsqlSource.cs` (+103 -0) 📝 `Ui/Ui.csproj` (+1 -0) 📝 `Ui/View/Settings/DataSource/DataSourceView.xaml` (+19 -0) 📝 `Ui/View/Settings/DataSource/DataSourceViewModel.cs` (+11 -10) ➕ `Ui/View/Settings/DataSource/PgsqlSettingView.xaml` (+144 -0) ➕ `Ui/View/Settings/DataSource/PgsqlSettingViewModel.cs` (+244 -0) </details> ### 📄 Description PostgreSQL backend support code is very similar to MySQL, the major difference is the quote character for identifiers. Since all SQL scripts are quite simple, we can just replace the backtick with double quote to make all DBMS backends work in the same way. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

kerem

2026-03-01 17:23:26 +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/1Remote#2831

No description provided.

Rows
Columns