github.com/jackc/pgx/v5

• Add StrictNamedArgs (Tomas Zahradnicek)
• Add support for macaddr8 type (Carlos Pérez-Aradros Herce)
• Add SeverityUnlocalized field to PgError / Notice
• Performance optimization of RowToStructByPos/Name (Zach Olstein)
• Allow customizing context canceled behavior for pgconn
• Add ScanLocation to pgtype.Timestamp[tz]Codec
• Add custom data to pgconn.PgConn
• Fix ResultReader.Read() to handle nil values
• Do not encode interval microseconds when they are 0 (Carlos Pérez-Aradros Herce)
• pgconn.SafeToRetry checks for wrapped errors (tjasko)
• Failed connection attempts include all errors
• Optimize LargeObject.Read (Mitar)
• Add tracing for connection acquire and release from pool (ngavinsir)
• Fix encode driver.Valuer not called when nil
• Add support for custom JSON marshal and unmarshal (Mitar)
• Use Go default keepalive for TCP connections (Hans-Joachim Kliemeck)

Use spaces instead of parentheses for SQL sanitization.

This still solves the problem of negative numbers creating a line comment, but this avoids breaking edge cases such as set foo to $1 where the substitution is taking place in a location where an arbitrary expression is not allowed.

Fix CVE-2024-27304

SQL injection can occur if an attacker can cause a single query or bind message to exceed 4 GB in size. An integer overflow in the calculated message size can cause the one large message to be sent as multiple messages under the attacker's control.

Thanks to Paul Gerste for reporting this issue.

• Fix behavior of CollectRows to return empty slice if Rows are empty (Felix)
• Fix simple protocol encoding of json.RawMessage
• Fix *Pipeline.getResults should close pipeline on error
• Fix panic in TryFindUnderlyingTypeScanPlan (David Kurman)
• Fix deallocation of invalidated cached statements in a transaction
• Handle invalid sslkey file
• Fix scan float4 into sql.Scanner
• Fix pgtype.Bits not making copy of data from read buffer. This would cause the data to be corrupted by future reads.

• Fix: prepared statement already exists
• Improve CopyFrom auto-conversion of text-ish values
• Add ltree type support (Florent Viel)
• Make some properties of Batch and QueuedQuery public (Pavlo Golub)
• Add AppendRows function (Edoardo Spadolini)
• Optimize convert UUID [16]byte to string (Kirill Malikov)
• Fix: LargeObject Read and Write of more than ~1GB at a time (Mitar)

• Allow NamedArgs to start with underscore
• pgproto3: Maximum message body length support (jeremy.spriet)
• Upgrade golang.org/x/crypto to v0.17.0
• Add snake_case support to RowToStructByName (Tikhon Fedulov)
• Fix: update description cache after exec prepare (James Hartig)
• Fix: pipeline checks if it is closed (James Hartig and Ryan Fowler)
• Fix: normalize timeout / context errors during TLS startup (Samuel Stauffer)
• Add OnPgError for easier centralized error handling (James Hartig)