laconic_postgresql 3.0.1

PostgreSQL driver for the Laconic query builder.

3.0.1

• Republish with a plain semantic version without build metadata.
• Update the core dependency to laconic: ^5.0.1.
• Update README installation examples for the coordinated patch release.
• No runtime behavior changes.

3.0.0

Breaking changes and migration

• Requires laconic: ^5.0.0 and adopts its UNION, cursor-pagination and custom-grammar contracts.
• Reject nested transactions on the same driver instance with LaconicException; separate driver instances keep independent transaction contexts.
• Validate raw SQL binding counts. Native $N positions are local to each raw clause; when mixed with ?, question-mark parameters follow the largest native position. Repeated native positions reuse their binding.

Fixes

• Rebase parameters when embedding raw clauses, EXISTS subqueries and UNION branches without changing quoted text.
• Preserve strings, quoted identifiers, nested comments, dollar-quoted strings and JSON operators during placeholder conversion; support ?? as an explicit question-mark operator escape.
• Prevent cross-driver transaction routing. Serialize transaction cache access and dispose session statements before the transaction session ends, including rollback paths.

Performance

• Cache prepared statements per reusable physical connection, with at most 50 per connection. Dispose statements on eviction or execution errors and remove cache metadata when connections close.
• Convert raw SQL placeholders in a single scan.
• Convert row values directly into shared result metadata while retaining mutable values and duplicate-column behavior.

2.3.0

Features

• LaconicException from driver errors now fills driver: 'postgres' and code with the SQLSTATE error code (e.g. 23505 for a unique violation); non-server errors carry no code.
• PostgresqlDriver.driverName constant identifies the driver.

2.2.0

Changed

• Requires laconic: ^4.0.0 (removes the LaconicException.cause / stackTrace fields)
• Driver errors are embedded in the LaconicException message; an existing LaconicException is rethrown as-is instead of being wrapped again

2.0.0

Breaking Changes

• Requires laconic: ^3.0.0 and implements the new DatabaseDriver.affectingStatement() contract

Features

• update(), delete(), increment(), and decrement() now return the affected row count reported by PostgreSQL

1.3.1

Bug Fixes

• whereTime invalid SQL — Fixed CAST() expression missing closing parenthesis and type specifier; now uses col::time syntax
• whereDay / whereMonth / whereYear invalid SQL — Fixed EXTRACT() expressions missing closing parenthesis
• Refactored _dateFunction → _dateExpression(column) to return complete SQL expressions

Performance

• _convertPlaceholders fast-path — Added String.contains('?') check before regex matching, eliminating unnecessary regex evaluation for Grammar-generated $N SQL

1.3.0

Features

• New Grammar Methods: compileTruncate(), compileInsertOrIgnore(), compileUpsert() — supports new core laconic v2.3.0 features
• Support for date WHERE type: whereDate(), whereTime(), whereDay(), whereMonth(), whereYear() — uses PostgreSQL's DATE(), col::time, and EXTRACT() functions
• Support for exists WHERE type: whereExists() / whereNotExists() — EXISTS subqueries in WHERE and JOIN conditions, with automatic $N placeholder offset in subqueries
• Support for locks: lockForUpdate() compiles to FOR UPDATE; sharedLock() compiles to FOR SHARE
• Upsert: upsert() compiles to INSERT INTO ... ON CONFLICT(...) DO UPDATE SET
• Insert Or Ignore: insertOrIgnore() compiles to INSERT INTO ... ON CONFLICT DO NOTHING

Performance

• Pre-compiled RegExp — _positionalParamRE is now static final, avoiding re-compilation on every query
• Prepared Statement Caching — Frequently used parameterized queries now reuse cached prepared statements (up to 50), eliminating the Parse → Close round-trip on repeated executions

Bug Fixes

• More Robust _compileRawSql — Uses indexOf to explicitly locate ? before replacement, avoiding issues with ? characters inside raw SQL string literals (edge case)

Improvements

• Alignment with laconic v2.3.0: Compile-time compatibility with new SqlGrammar abstract methods and updated compileSelect signature

1.2.0

Refactoring

• Improve Transaction Handling - Replace individual connection management with runZoned for transaction context isolation
• Simplify Query Execution - Refactor query execution into dedicated _executeQuery methods with protocol-based selection, remove placeholder conversion duplication

1.1.0

Features

• Implement compileIncrement() / compileDecrement() - Grammar methods for increment/decrement SQL generation with $N positional placeholders
• JoinClause BETWEEN Support - Add between and betweenColumns type handling in _compileJoinConditions()

Bug Fixes

• Fix Transaction Isolation - Store _transactionSession to ensure all queries within a transaction use the same session

1.0.1

Improvements

• Grammar Singleton - PostgresqlGrammar is now a static singleton instance, avoiding unnecessary allocations on each access
• Enhanced Exception Handling - All catch blocks now preserve the original exception cause and stackTrace in LaconicException

1.0.0

Initial release of the PostgreSQL driver for Laconic query builder.

Features

• PostgreSQL database driver using postgres package with connection pooling (max 10)
• $N positional parameter support (extended query protocol)
• RETURNING clause for insertGetId()
• _convertPlaceholders() safety net for ? → $N conversion
• Transaction support using runZoned for session isolation
• Lazy connection pool initialization
• SSL support via PostgresqlConfig.useSsl