laconic 1.0.1

laconic: ^1.0.1 copied to clipboard

Features #

• PostgreSQL Support - Add full PostgreSQL database support
  • New Laconic.postgresql(config) constructor
  • PostgreSQL-specific parameter binding ($1, $2, $3...)
  • RETURNING id clause for insertGetId()
  • Connection pooling with up to 10 concurrent connections
  • SSL connection support

Architecture #

• Add PostgresqlGrammar class for PostgreSQL-specific SQL generation
• Add compileInsertGetId() method to Grammar interface
  • Separates INSERT and INSERT RETURNING logic
  • PostgreSQL uses RETURNING id clause
  • MySQL/SQLite use lastInsertId mechanism
• Add PostgresqlConfig for PostgreSQL connection configuration

Testing #

• Add comprehensive PostgreSQL test suite (64 tests)
• Unify test data structure across SQLite, MySQL, and PostgreSQL
• All 187 tests passing across three databases

Features #

• Add advanced query methods: whereAll(), whereAny(), whereNone()
• Add column comparison methods: whereBetweenColumns(), whereColumn()
• Enhanced JOIN support: orOn(), where(), orWhere() conditions
• Add batch insert functionality, support inserting lists of data
• Add transaction support for MySQL and SQLite
• Add query listener for SQL debugging and logging
• Add addSelect() method for appending select fields
• Add when() conditional method

Breaking Changes #

• Refactor AST-based query builder to Grammar pattern
  • Simplified code structure for better maintainability
  • More flexible SQL generation mechanism
  • Easier to extend support for new databases

Documentation #

• Add Chinese documentation and improve English README
• Add comprehensive comparison report between Laconic and Laravel Query Builder
• Update CLAUDE.md with architecture details and development guide
• Enhanced example code with comprehensive usage demonstrations
• Add Flutter dependency requirement note

Improvements #

• Unify API naming: rename mysqlLaconic and sqliteLaconic to laconic
• Improve constructors to accept config parameters directly
• Optimize connection management with proper close calls

• Initial version.