The connection URL parser in lib/features/connections/connection_url_parser.dart sets useSSL = true when sslmode is prefer, but the postgres package throws ArgumentError for sslmode=prefer at connect time.
Impact: A user can save a postgresql://...?sslmode=prefer URL via the UI and only discover it fails when they actually try to connect.
Expected: Reject prefer (or any unsupported sslmode value) at parse time, or at minimum do not mark it as SSL-enabled.
Related: test/core/database/postgres_connection_string_parse_test.dart already documents the driver behavior.
Acceptance criteria:
The connection URL parser in
lib/features/connections/connection_url_parser.dartsetsuseSSL = truewhensslmodeisprefer, but thepostgrespackage throwsArgumentErrorforsslmode=preferat connect time.Impact: A user can save a
postgresql://...?sslmode=preferURL via the UI and only discover it fails when they actually try to connect.Expected: Reject
prefer(or any unsupportedsslmodevalue) at parse time, or at minimum do not mark it as SSL-enabled.Related:
test/core/database/postgres_connection_string_parse_test.dartalready documents the driver behavior.Acceptance criteria:
parseConnectionUrlInputreturns an error forsslmode=preferon PostgreSQL URLs.prefer,allow, and other unsupported modes.