The following module was proposed for inclusion in the Module List:
modid: SQL::Snippet DSLIP: bdpOp description: Enables an OO Interface to Your RDBMS userid: PRL (Phil R Lawrence) chapterid: 7 (Database_Interfaces) communities: [EMAIL PROTECTED], YAPC::NA 2002 similar: SQL::QueryBuilder::Simple, Relations::Query rationale: [ Tim suggested the chapter 7 (Database) for this module, but SQL:: is associated with chapter 11 (Text, etc.) only at this point. This module should *definately* be in the SQL heirarchy. Should chapter 7 be added to SQL:: in addition to chapter 11? ] [ The whole Rationale has previously been submitted, so here is an abstract. ] -------- ABSTRACT -------- If you work with databases, chances are you have lots of scripts with SQL statements sprinkled throughout them. This situation gives rise to several problems: - Database changes result in hunting down affected SQL statements. - SQL is cut and pasted from script to script, allowing mutation errors. - Flexibility suffers because everything is hardwired. SQL::Snippet allows you to modularize all that SQL into one central repository. Instead of complete SQL statements, the repository contains "snippets" (i.e. little pieces) of SQL. SQL::Snippet will front end these snippets, allowing your code to call for the dynamic creation of complete, optimized SQL statements using straightforward OO (Object Oriented) syntax. There are two kinds of Snippets: 1) populations i.e. people, places, other_objects ... 2) limits applicable to those populations i.e. gender, location, other_attributes ... Real databases are complex beasts with thousands of tables and myriad relationships. SQL::Snippet scales well into the real world -- by viewing your database's structure and data in an OO way, intelligent modularization is possible. enteredby: PRL (Phil R Lawrence) enteredon: Wed Jun 5 17:49:23 2002 GMT The resulting entry would be: SQL:: ::Snippet bdpOp Enables an OO Interface to Your RDBMS PRL Thanks for registering, The Pause Team PS: The following links are only valid for module list maintainers: Registration form with editing capabilities: https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=3e100000_efb2e029b2d601b6&SUBMIT_pause99_add_mod_preview=1 Immediate (one click) registration: https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=3e100000_efb2e029b2d601b6&SUBMIT_pause99_add_mod_insertit=1