Skip to content

v2.11.1

Choose a tag to compare

View all tags
@tommyknocker tommyknocker released this 02 Dec 18:38
· 34 commits to master since this release
v2.11.1
fdbfded

Release v2.11.1

🎉 Major Features

🖥️ Interactive TUI Dashboard

Real-time database monitoring with a beautiful full-screen terminal interface! Monitor active queries, connection pool, cache statistics, and server metrics in real-time.

Features:

  • Monitor active queries with full query text, execution time, user, and database
  • Kill long-running queries with a single keystroke
  • Keyboard navigation with pane switching, scrolling, and fullscreen mode
  • Real-time refresh with configurable intervals (realtime, 0.5s, 1s, 2s, 5s)
  • Color-coded metrics for performance visualization

Launch: pdodb ui

🚀 Code Generation Command

New pdodb generate command with multiple subcommands for rapid development:

  • pdodb generate api - Generate API controller classes
  • pdodb generate tests - Generate test files
  • pdodb generate dto - Generate Data Transfer Object classes
  • pdodb generate enum - Generate enum classes
  • pdodb generate docs - Generate documentation files
  • pdodb generate model - Generate ActiveRecord model classes
  • pdodb generate repository - Generate repository classes
  • pdodb generate service - Generate service classes

⚡ Benchmark Command

Comprehensive performance testing tools:

  • pdodb benchmark query - Benchmark SQL query performance
  • pdodb benchmark crud - Benchmark CRUD operations
  • pdodb benchmark load - Load testing with multiple connections
  • pdodb benchmark profile - Query profiling with detailed statistics
  • pdodb benchmark compare - Compare query performance

✨ New Features

  • Version Command - pdodb version and --version / -v flag support
  • Index Suggestion - pdodb table suggest-indexes <table> to optimize database performance
  • Oracle Helpers - New Db::toTs(), Db::toDate(), and Db::toChar() functions
  • IDE Autocompletion - Enhanced autocompletion for Model::find() method
  • CLI Improvements - "Did you mean?" command suggestions for typos
  • Event System - Added missing events for better monitoring and auditing

🔧 Improvements

  • All generated namespaces are now automatically converted to lowercase for consistency

🐛 Bug Fixes

  • Fixed loading .env file before checking PDODB_DRIVER in connection list command
  • Fixed parsing command line options without equals sign (--option=value and --option value)
  • Fixed Oracle type helpers example and PHPStan errors
  • Fixed benchmark command tests to use correct path to pdodb binary
  • Added warning when --query is not specified for benchmark compare command
  • Improved test reliability: skip user creation tests when privileges are missing

📚 Documentation

  • Improved IDE autocompletion documentation
  • Clarified PHPStan ignore comments in PdoDb::fromEnv method

🧪 Tests

  • Added comprehensive tests for Oracle-specific helpers and exception handling
  • Improved benchmark command tests with better error handling

Full Changelog: v2.11.0...v2.11.1

Assets 2
Loading