Support PostgreSQL (PGv15) to allow PG and YugabyteDB as Database

[crocinsocks]

CockroachDB began as open source under Apache 2.0 but shifted in 2019 to a restrictive “source-available” license and by 2024 moved entirely to a proprietary-style Enterprise license. The free tier is now limited to companies under $10M revenue with larger deployments requiring paid licenses and mandatory telemetry. As a result, CockroachDB is no longer truly open source and many in the community view its licensing as restrictive compared to alternatives like YugabyteDB which remains fully open source under Apache 2.0.

YugabyteDB offers true PostgreSQL compatibility unlike CockroachDB (PGv15 currently) along with the benefits of high availability and horizontal scalability and the performance to match.

Within the open-source community, there has been a steady and growing migration from CockroachDB to YugabyteDB. CockroachDB’s marketing is far more visible than YugabyteDB so I wanted to highlight YugabyteDB and ensure members of this project are aware of it's existence and the issues surrounding CockroachDB.

Thanks

[huly-github-staging]

Connected to Huly®: UBERF-13633

[crocinsocks]

Issue Summary:
I can confirm Huly currently only supports CockroachDB's proprietary protocol and does not work with standard PostgreSQL databases.

Request:
I would like to request/enhance support for standard PostgreSQL databases. Based on my code review, this appears to be achievable by:

1. Updating database migrations to use PostgreSQL-compatible syntax
2. Modifying the transaction handler to work with standard PostgreSQL instead of CockroachDB-specific client behaviors
3. Implementing database type detection in connection strings

Proposed Implementation:
Add support for database type prefixes in connection strings:

• cockroach|... - CockroachDB (should remain default for backward compatibility)
• pg|... - PostgreSQL

Technical Assessment:
After reviewing the current migrations and codebase, I don't anticipate any significant technical barriers to implementing this feature. The changes would likely be straightforward updates to:

• Migration scripts
• Transaction handling logic
• Connection string parsing

Justification:
Adding PostgreSQL support would broaden Huly's compatibility and allow users to leverage standard PostgreSQL deployments while maintaining existing CockroachDB functionality.

Classification:
This could be treated as either:

• Bug: If PostgreSQL compatibility was intended
• Feature Request: If CockroachDB-only support was intentional

Would appreciate feedback on the feasibility and priority of this enhancement.