Changes for version 1.02 - 2026-03-21

  • New: Multi-column AND queries now exploit an available index on one of the columns (partial AND index pushdown). Example: WHERE dept = 'Eng' AND salary > 70000 uses the dept or salary index rather than performing a full table scan.
  • New: INTERSECT, INTERSECT ALL, EXCEPT, and EXCEPT ALL set operations are now supported alongside UNION / UNION ALL.
  • Added: t/1011_index_and_setop.t (69 tests) covering both features.
  • Updated: POD and README revised to document the new behaviour.

Documentation

Modules

Pure-Perl flat-file relational database with DBI-like interface

Provides

in lib/DB/Handy.pm
in lib/DB/Handy.pm