I just put out the first official release of my DBIx::POS module (which, incidentally, is my first ever CPAN entry in roughly ten years of Perl development).
This is the end-product of more than a years worth of effort in finding a good lightweight way of organizing and documenting the SQL code associated with a large application.
This is not any sort of object mapping layer or automatic SQL generator; I keep looking at those sorts of things, and experimenting with them, and I keep coming back to plain old SQL. This will not save you any keystrokes–in fact, it’s going to take more, because this is as much about documentation as anything else.
All this is is a way to try and organize and document your SQL as a component along-side (rather than an integral part) of your perl code.
There’s still lots to do–at the very least, I want to put together tools for turning your POS (that’s Plain Old SQL, and a reference to POD, the format from which it is derived) into DocBook or POD–but for the moment, this works, and, I believe, works well.
You can find it “here”:http://search.cpan.org/~mdorman/DBIx-POS-0.03/
Feedback welcome.
