XML::EasySQL is a two-way SQL/XML base class that I wrote for Perl. It was featured in The Perl Journal in August 2004.

Features:

  • two-way transforms between XML and SQL data
  • smart SQL updates: only altered tables are updated
  • unlimited tree depth
  • multiple SQL tables can merge into one XML tree, then back again
  • precise control over how data is translated
  • offers either an easy XML interface or plain DOM
  • database independent

XML::EasySQL works by first taking data spat out by DBI, and turning it into an XML tree. The programmer is then free to modify the data using the easy XML interface that's provided, or he can start hacking directly on the underlying XML::DOM. When he's ready to dump the changed data back to the database, he only has to call one method.

To read more about the module or to download it, just visit CPAN: http://search.cpan.org/~curtisf/XML-EasySQL/.