Post by mdorman

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

Feedback welcome.