laconic_postgresql 1.2.0

PostgreSQL driver for the Laconic query builder.

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

• PostgresqlDriver - PostgreSQL database driver implementing DatabaseDriver interface

  • Connection pooling with configurable max connections (default: 10)
  • Automatic ? to $1, $2, ... parameter placeholder conversion
  • RETURNING id clause support for insertGetId()
  • SSL connection support
  • Transaction support
  • Proper connection pool cleanup on close

• PostgresqlGrammar - PostgreSQL-specific SQL grammar extending SqlGrammar

  • PostgreSQL-specific syntax compilation
  • $1, $2, ... positional parameter binding
  • RETURNING clause for insert operations

• PostgresqlConfig - Configuration class for PostgreSQL connections

  • host - Database server host (default: localhost)
  • port - Database server port (default: 5432)
  • database - Database name (required)
  • username - Database username (default: postgres)
  • password - Database password (required)
  • useSsl - Use SSL connection (default: false)

Usage

import 'package:laconic/laconic.dart';
import 'package:laconic_postgresql/laconic_postgresql.dart';

final laconic = Laconic(PostgresqlDriver(PostgresqlConfig(
  database: 'database',
  password: 'password',
)));

final users = await laconic.table('users').get();

await laconic.close();

Dependencies

• laconic: ^2.0.0
• postgres: ^3.5.4