starred/1Remote

Fork 0

mirror of https://github.com/1Remote/1Remote.git synced 2026-04-25 13:36:03 +03:00

[GH-ISSUE #870] Add Postgresql support #3623

New issue

Closed

opened 2026-03-13 12:19:36 +03:00 by kerem · 4 comments

kerem commented

2026-03-13 12:19:36 +03:00

Owner

Originally created by @goldenbull on GitHub (Feb 20, 2025).
Original GitHub issue: https://github.com/1Remote/1Remote/issues/870

Originally assigned to: @goldenbull, @VShawn on GitHub.

Any plan for postgresql? I can try to write some code. The mysql implementation is a good reference.

Originally created by @goldenbull on GitHub (Feb 20, 2025). Original GitHub issue: https://github.com/1Remote/1Remote/issues/870 Originally assigned to: @goldenbull, @VShawn on GitHub. Any plan for postgresql? I can try to write some code. The mysql implementation is a good reference.

kerem

2026-03-13 12:19:36 +03:00

closed this issue
added the
meta-feature
label

kerem commented

2026-03-13 12:19:52 +03:00

Author

Owner

@VShawn commented on GitHub (Feb 21, 2025):

I have never used PostgreSQL before, so it would be great if you could help me with making and testing the PostgreSQL module.

@VShawn commented on GitHub (Feb 21, 2025): I have never used PostgreSQL before, so it would be great if you could help me with making and testing the PostgreSQL module.

kerem commented

2026-03-13 12:19:57 +03:00

Author

Owner

@goldenbull commented on GitHub (Feb 21, 2025):

尝试了一下，新增界面、连接pgsql都没问题了，目前主要的困难在于SQL语句的兼容性：

table name和field name：mysql和sqlite的SQL使用back tick，pgsql使用double quotes
字符串：mysql和sqlite使用double quotes， pgsql使用single quotes

目前看起来所有的SQL都在 DapperDataBase.cs 中，我再看看dapper是否可以提供一致的支持

@goldenbull commented on GitHub (Feb 21, 2025): 尝试了一下，新增界面、连接pgsql都没问题了，目前主要的困难在于SQL语句的兼容性： 1. table name和field name：mysql和sqlite的SQL使用back tick，pgsql使用double quotes 2. 字符串：mysql和sqlite使用double quotes， pgsql使用single quotes 目前看起来所有的SQL都在 `DapperDataBase.cs` 中，我再看看dapper是否可以提供一致的支持

kerem commented

2026-03-13 12:20:02 +03:00

Author

Owner

@goldenbull commented on GitHub (Feb 21, 2025):

Writing SQL that works on PostgreSQL, MySQL and SQLite
Quoting differences between MySQL and PostgreSQL

@goldenbull commented on GitHub (Feb 21, 2025): [Writing SQL that works on PostgreSQL, MySQL and SQLite](https://evertpot.com/writing-sql-for-postgres-mysql-sqlite/) [Quoting differences between MySQL and PostgreSQL](https://www.dolthub.com/blog/2024-07-09-mysql-postgres-quoting/)

kerem commented

2026-03-13 12:20:07 +03:00

Author

Owner

@goldenbull commented on GitHub (Feb 21, 2025):

PR created 😄

@goldenbull commented on GitHub (Feb 21, 2025): [PR](https://github.com/1Remote/1Remote/pull/872) created 😄

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#3623

No description provided.

Rows
Columns