Skip to content

armgit / dbx

Public Imported from GitHub
0

25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。

1.3 KB
Raw Blame
export type PostgresTlsMode = "disable" | "prefer" | "require" | "verify-ca" | "verify-full";

export const POSTGRES_LEGACY_TLS_PARAM = "legacy_tls";

export function postgresTlsModeForForm(value: string | undefined, ssl: boolean | undefined): PostgresTlsMode {
  switch ((value || "").trim().toLowerCase()) {
    case "disable":
    case "prefer":
    case "require":
    case "verify-ca":
    case "verify-full":
      return value!.trim().toLowerCase() as PostgresTlsMode;
    case "verify_identity":
    case "verify-identity":
      return "verify-full";
    default:
      // Align with libpq/JDBC: absent mode prefers TLS and can fall back to plaintext.
      // Legacy ssl=true still maps to require.
      return ssl ? "require" : "prefer";
  }
}

export function postgresLegacyTlsEnabled(params: string | undefined): boolean {
  const parsed = new URLSearchParams((params || "").trim().replace(/^\?/, ""));
  return ["1", "true", "yes", "on"].includes((parsed.get(POSTGRES_LEGACY_TLS_PARAM) || "").trim().toLowerCase());
}

export function setPostgresLegacyTlsEnabled(params: string | undefined, enabled: boolean): string {
  const parsed = new URLSearchParams((params || "").trim().replace(/^\?/, ""));
  if (enabled) parsed.set(POSTGRES_LEGACY_TLS_PARAM, "true");
  else parsed.delete(POSTGRES_LEGACY_TLS_PARAM);
  return parsed.toString();
}