.\" Automatically generated by Pod::Man 4.14 (Pod::Simple 3.42) .\" .\" Standard preamble: .\" ======================================================================== .de Sp \" Vertical space (when we can't use .PP) .if t .sp .5v .if n .sp .. .de Vb \" Begin verbatim text .ft CW .nf .ne \\$1 .. .de Ve \" End verbatim text .ft R .fi .. .\" Set up some character translations and predefined strings. \*(-- will .\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left .\" double quote, and \*(R" will give a right double quote. \*(C+ will .\" give a nicer C++. Capital omega is used to do unbreakable dashes and .\" therefore won't be available. \*(C` and \*(C' expand to `' in nroff, .\" nothing in troff, for use with C<>. .tr \(*W- .ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p' .ie n \{\ . ds -- \(*W- . ds PI pi . if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch . if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\" diablo 12 pitch . ds L" "" . ds R" "" . ds C` "" . ds C' "" 'br\} .el\{\ . ds -- \|\(em\| . ds PI \(*p . ds L" `` . ds R" '' . ds C` . ds C' 'br\} .\" .\" Escape single quotes in literal strings from groff's Unicode transform. .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" .\" If the F register is >0, we'll generate index entries on stderr for .\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index .\" entries marked with X<> in POD. Of course, you'll have to process the .\" output yourself in some meaningful fashion. .\" .\" Avoid warning from groff about undefined register 'F'. .de IX .. .nr rF 0 .if \n(.g .if rF .nr rF 1 .if (\n(rF:(\n(.g==0)) \{\ . if \nF \{\ . de IX . tm Index:\\$1\t\\n%\t"\\$2" .. . if !\nF==2 \{\ . nr % 0 . nr F 2 . \} . \} .\} .rr rF .\" .\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2). .\" Fear. Run. Save yourself. No user-serviceable parts. . \" fudge factors for nroff and troff .if n \{\ . ds #H 0 . ds #V .8m . ds #F .3m . ds #[ \f1 . ds #] \fP .\} .if t \{\ . ds #H ((1u-(\\\\n(.fu%2u))*.13m) . ds #V .6m . ds #F 0 . ds #[ \& . ds #] \& .\} . \" simple accents for nroff and troff .if n \{\ . ds ' \& . ds ` \& . ds ^ \& . ds , \& . ds ~ ~ . ds / .\} .if t \{\ . ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u" . ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u' . ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u' . ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u' . ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u' . ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u' .\} . \" troff and (daisy-wheel) nroff accents .ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V' .ds 8 \h'\*(#H'\(*b\h'-\*(#H' .ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#] .ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H' .ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u' .ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#] .ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#] .ds ae a\h'-(\w'a'u*4/10)'e .ds Ae A\h'-(\w'A'u*4/10)'E . \" corrections for vroff .if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u' .if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u' . \" for low resolution devices (crt and lpr) .if \n(.H>23 .if \n(.V>19 \ \{\ . ds : e . ds 8 ss . ds o a . ds d- d\h'-1'\(ga . ds D- D\h'-1'\(hy . ds th \o'bp' . ds Th \o'LP' . ds ae ae . ds Ae AE .\} .rm #[ #] #H #V #F C .\" ======================================================================== .\" .IX Title "Alzabo::Runtime::Schema 3pm" .TH Alzabo::Runtime::Schema 3pm "2022-06-14" "perl v5.34.0" "User Contributed Perl Documentation" .\" For nroff, turn off justification. Always turn off hyphenation; it makes .\" way too many mistakes in technical documents. .if n .ad l .nh .SH "NAME" Alzabo::Runtime::Schema \- Schema objects .SH "SYNOPSIS" .IX Header "SYNOPSIS" .Vb 1 \& use Alzabo::Runtime::Schema qw(some_schema); \& \& my $schema = Alzabo::Runtime::Schema\->load_from_file( name => \*(Aqfoo\*(Aq ); \& $schema\->set_user( $username ); \& $schema\->set_password( $password ); \& \& $schema\->connect; .Ve .SH "DESCRIPTION" .IX Header "DESCRIPTION" Objects in this class represent schemas, and can be used to retrieve data from that schema. .PP This object can only be loaded from a file. The file is created whenever a corresponding \&\f(CW\*(C`Alzabo::Create::Schema\*(C'\fR object is saved. .SH "INHERITS FROM" .IX Header "INHERITS FROM" \&\f(CW\*(C`Alzabo::Schema\*(C'\fR .PP Note: all relevant documentation from the superclass has been merged into this document. .SH "METHODS" .IX Header "METHODS" .ie n .SS "load_from_file ( name => $schema_name )" .el .SS "load_from_file ( name => \f(CW$schema_name\fP )" .IX Subsection "load_from_file ( name => $schema_name )" Loads a schema from a file. This is the only constructor for this class. It returns an \f(CW\*(C`Alzabo::Runtime::Schema\*(C'\fR object. Loaded objects are cached in memory, so future calls to this method may return the same object. .PP Throws: \f(CW\*(C`Alzabo::Exception::Params\*(C'\fR, \&\f(CW\*(C`Alzabo::Exception::System\*(C'\fR .SS "set_user ($user)" .IX Subsection "set_user ($user)" Sets the username to use when connecting to the database. .SS "user" .IX Subsection "user" Return the username used by the schema when connecting to the database. .SS "set_password ($password)" .IX Subsection "set_password ($password)" Set the password to use when connecting to the database. .SS "password" .IX Subsection "password" Returns the password used by the schema when connecting to the database. .SS "set_host ($host)" .IX Subsection "set_host ($host)" Set the host to use when connecting to the database. .SS "host" .IX Subsection "host" Returns the host used by the schema when connecting to the database. .SS "set_port ($port)" .IX Subsection "set_port ($port)" Set the port to use when connecting to the database. .SS "port" .IX Subsection "port" Returns the port used by the schema when connecting to the database. .SS "set_referential_integrity ($boolean)" .IX Subsection "set_referential_integrity ($boolean)" Turns referential integrity checking on or off. If it is on, then when \f(CW\*(C`Alzabo::Runtime::Row\*(C'\fR objects are deleted, updated, or inserted, they will report this activity to any relevant \f(CW\*(C`Alzabo::Runtime::ForeignKey\*(C'\fR objects for the row, so that the foreign key objects can take appropriate action. .PP This defaults to false. If your \s-1RDBMS\s0 supports foreign key constraints, these should be used instead of Alzabo's built-in referential integrity checking, as they will be much faster. .SS "referential_integrity" .IX Subsection "referential_integrity" Returns a boolean value indicating whether this schema will attempt to maintain referential integrity. .SS "set_quote_identifiers ($boolean)" .IX Subsection "set_quote_identifiers ($boolean)" If this is true, then all \s-1SQL\s0 constructed for this schema will have quoted identifiers (like `Table`.`column` in MySQL). .PP This defaults to false. Turning this on adds some overhead to all \s-1SQL\s0 generation. .SS "connect (%params)" .IX Subsection "connect (%params)" Calls the \f(CW\*(C`Alzabo::Driver\->connect\*(C'\fR method for the driver owned by the schema. The username, password, host, and port set for the schema will be passed to the driver, as will any additional parameters given to this method. See the \f(CW\*(C`Alzabo::Driver\->connect() method\*(C'\fR for more details. .SS "disconnect" .IX Subsection "disconnect" Calls the \f(CW\*(C`Alzabo::Driver\->disconnect()\*(C'\fR method for the driver owned by the schema. .SS "join" .IX Subsection "join" Joins are done by taking the tables provided in order, and finding a relation between them. If any given table pair has more than one relation, then this method will fail. The relations, along with the values given in the optional where clause will then be used to generate the necessary \s-1SQL.\s0 See \&\f(CW\*(C`Alzabo::Runtime::JoinCursor\*(C'\fR for more information. .PP This method takes the following parameters: .IP "\(bu" 4 join => .Sp This parameter can either be a simple array reference of tables or an array reference of array references. In the latter case, each array reference should contain two tables. These array references can also include an optional modifier specifying a type of join for the two tables, like 'left_outer_join', an optional foreign key object which will be used to join the two tables, and an optional where clause used to restrict the join. .Sp If a simple array reference is given, then the order of these tables is significant when there are more than 2 tables. Alzabo expects to find relationships between tables 1 & 2, 2 & 3, 3 & 4, etc. .Sp For example, given: .Sp .Vb 1 \& join => [ $table_A, $table_B, $table_C ] .Ve .Sp Alzabo would expect that table A has a relationship to table B, which in turn has a relationship to table C. If you simply provide a simple array reference, you cannot include any outer joins, and every element of the array reference must be a table object. .Sp If you need to specify a more complicated set of relationships, this can be done with a slightly more complicated data structure, which looks like this: .Sp .Vb 4 \& join => [ [ $table_A, $table_B ], \& [ $table_A, $table_C ], \& [ $table_C, $table_D ], \& [ $table_C, $table_E ] ] .Ve .Sp This is fairly self explanatory. Alzabo will expect to find a relationship between each pair of tables. This allows for the construction of arbitrarily complex join clauses. .Sp For even more complex needs, there are more options: .Sp .Vb 3 \& join => [ [ left_outer_join => $table_A, $table_B ], \& [ $table_A, $table_C, $foreign_key ], \& [ right_outer_join => $table_C, $table_D, $foreign_key ] ] .Ve .Sp In this example, we are specifying two types of outer joins, and in two of the three cases, specifying which foreign key should be used to join the two tables. .Sp It should be noted that if you want to join two tables that have more than one foreign key between them, you \fBmust\fR provide a foreign key object when using them as part of your query. .Sp The way an outer join is interpreted is that this: .Sp .Vb 1 \& [ left_outer_join => $table_A, $table_B ] .Ve .Sp is interepreted to mean .Sp .Vb 1 \& SELECT ... FROM table_A LEFT OUTER JOIN table_B ON ... .Ve .Sp Table order is relevant for right and left outer joins, obviously. .Sp However, for regular (inner) joins, table order is not important. .Sp It is also possible to apply restrictions to an outer join, for example: .Sp .Vb 6 \& join => [ [ left_outer_join => $table_A, $table_B, \& # outer join restriction \& [ [ $table_B\->column(\*(Aqsize\*(Aq) > 2 ], \& \*(Aqand\*(Aq, \& [ $table_B\->column(\*(Aqname\*(Aq), \*(Aq!=\*(Aq, \*(AqFoo\*(Aq ] ], \& ] ] .Ve .Sp This corresponds to this \s-1SQL\s0; .Sp .Vb 3 \& SELECT ... FROM table_A \& LEFT OUTER JOIN table_B ON ... \& AND (table_B.size > 2 AND table_B.name != \*(AqFoo\*(Aq) .Ve .Sp These restrictions are only allowed when performing an outer join, since there is no point in using them for regular inner joins. An inner join restriction has the same effect when included in the \&\*(L"\s-1WHERE\*(R"\s0 clause. .Sp If the more multiple array reference of specifying tables is used and no \*(L"select\*(R" parameter is provided, then the order of the rows returned from calling \f(CW\*(C`Alzabo::Runtime::JoinCursor\->next()\*(C'\fR is not guaranteed. In other words, the array that the cursor returns will contain a row from each table involved in the join, but the which row belongs to which table cannot be determined except by examining the objects. The order will be the same every time \f(CW\*(C`Alzabo::Runtime::JoinCursor\->next()\*(C'\fR is called, however. It may be easier to use the \f(CW\*(C`Alzabo::Runtime::JoinCursor\->next_as_hash()\*(C'\fR method in this case. .IP "\(bu" 4 select => \f(CW\*(C`Alzabo::Runtime::Table\*(C'\fR object or objects (optional) .Sp This parameter specifies from which tables you would like rows returned. If this parameter is not given, then the \*(L"distinct\*(R" or \&\*(L"join\*(R" parameter will be used instead, with the \*(L"distinct\*(R" parameter taking precedence. .Sp This can be either a single table or an array reference of table objects. .IP "\(bu" 4 distinct => \f(CW\*(C`Alzabo::Runtime::Table\*(C'\fR object or objects (optional) .Sp If this parameter is given, it indicates that results from the join should never contain repeated rows. .Sp This can be used in place of the \*(L"select\*(R" parameter to indicate from which tables you want rows returned. The \*(L"select\*(R" parameter, if given, supercedes this parameter. .Sp For some databases (notably Postgres), if you want to do a \*(L"\s-1SELECT DISTINCT\*(R"\s0 query then all of the columns mentioned in your \*(L"\s-1ORDER BY\*(R"\s0 clause must also be in your \s-1SELECT\s0 clause. Alzabo will make sure this is the case, but it may cause more rows to be returned than you expected, though this depends on the query. .Sp \&\fB\s-1NOTE:\s0\fR The adding of columns to the \s-1SELECT\s0 clause from the \s-1ORDER BY\s0 clause is considered experimental, because it can change the expected results in some cases. .IP "\(bu" 4 where (optional) .Sp See the documentation on where clauses for the Alzabo::Runtime::Table class. .IP "\(bu" 4 order_by (optional) .Sp See the documentation on order by clauses for the Alzabo::Runtime::Table class. .IP "\(bu" 4 limit (optional) .Sp See the documentation on limit clauses for the Alzabo::Runtime::Table class. .PP If the \*(L"select\*(R" parameter specified that more than one table is desired, then this method will return n JoinCursor object representing the results of the join. Otherwise, the method returns a RowCursor object. .PP Throws: \f(CW\*(C`Alzabo::Exception::Logic\*(C'\fR, \&\f(CW\*(C`Alzabo::Exception::Params\*(C'\fR .SS "one_row" .IX Subsection "one_row" This method takes the exact same parameters as the \&\f(CW\*(C`join()\*(C'\fR method but instead of returning a cursor, it returns a single array of row objects. These will be the rows representing the first row (a set of one or more table's primary keys) that is returned by the database. .PP Throws: \f(CW\*(C`Alzabo::Exception::Logic\*(C'\fR, \&\f(CW\*(C`Alzabo::Exception::Params\*(C'\fR .SS "function and select" .IX Subsection "function and select" These two methods differ only in their return values. .PP They both take the following parameters: .IP "\(bu" 4 select => \f(CW$function\fR or [ scalars, \s-1SQL\s0 functions and/or \f(CW\*(C`Alzabo::Column\*(C'\fR objects ] .Sp If you pass an array reference for this parameter, it may contain scalars, \s-1SQL\s0 functions, or column objects. For example: .Sp .Vb 6 \& $schema\->function( select => \& [ 1, \& $foo\->column(\*(Aqname\*(Aq), \& LENGTH( $foo\->column(\*(Aqname\*(Aq) ) ], \& join => [ $foo, $bar_table ], \& ); .Ve .Sp This is equivalent to the following \s-1SQL:\s0 .Sp .Vb 3 \& SELECT 1, foo.name, LENGTH( foo.name ) \& FROM foo, bar \& WHERE ... .Ve .IP "\(bu" 4 join .Sp See the documentation on the join parameter for the join method. .IP "\(bu" 4 where .Sp See the documentation on where clauses for the Alzabo::Runtime::Table class. .IP "\(bu" 4 order_by .Sp See the documentation on order by clauses for the Alzabo::Runtime::Table class. .IP "\(bu" 4 group_by .Sp See the documentation on group by clauses for the Alzabo::Runtime::Table class. .IP "\(bu" 4 having .Sp This parameter is specified in the same way as the \*(L"where\*(R" parameter, but is used to generate a \*(L"\s-1HAVING\*(R"\s0 clause. It only allowed when you also specify a \*(L"group_by\*(R" parameter. .IP "\(bu" 4 limit .Sp See the documentation on limit clauses for the Alzabo::Runtime::Table class. .PP These methods are used to call arbitrary \s-1SQL\s0 functions such as '\s-1AVG\s0' or '\s-1MAX\s0', and to select data from individual columns. The function (or functions) should be the return values from the functions exported by the SQLMaker subclass that you are using. Please see Using \s-1SQL\s0 functions for more details. .PP Throws: \f(CW\*(C`Alzabo::Exception::Logic\*(C'\fR, \&\f(CW\*(C`Alzabo::Exception::Params\*(C'\fR .PP \fI\f(BIfunction()\fI return values\fR .IX Subsection "function() return values" .PP The return value of this method is highly context sensitive. .PP If you only requested a single element in your \*(L"select\*(R" parameter, such as \*(L"\s-1DISTINCT\s0(foo)\*(R", then it returns the first value in scalar context and all the values as an array in list context. .PP If you requested multiple functions such as \*(L"\s-1AVG\s0(foo), \s-1MAX\s0(foo)\*(R", then it returns a single array reference, the first row of values, in scalar context and a list of array references in list context. .PP \fI\f(BIselect()\fI return values\fR .IX Subsection "select() return values" .PP This method always returns a new \&\f(CW\*(C`Alzabo::DriverStatement\*(C'\fR object containing the results of the query. This object has an interface very similar to the Alzabo cursor interface, and has methods such as \f(CW\*(C`next()\*(C'\fR, \f(CW\*(C`next_as_hash()\*(C'\fR, etc. .SS "row_count" .IX Subsection "row_count" This method is simply a shortcut to get the result of \s-1COUNT\s0('*') for a join. It equivalent to calling \f(CW\*(C`function()\*(C'\fR with a \*(L"select\*(R" parameter of \f(CW\*(C`COUNT(\*(Aq*\*(Aq)\*(C'\fR. .PP Throws: \f(CW\*(C`Alzabo::Exception::Logic\*(C'\fR, \&\f(CW\*(C`Alzabo::Exception::Params\*(C'\fR .SS "prefetch_all" .IX Subsection "prefetch_all" This method will set all the tables in the schema to prefetch all their columns. See the lazy column loading section in \&\f(CW\*(C`Alzabo::Runtime::Table\*(C'\fR for more details. .SS "prefetch_all_but_blobs" .IX Subsection "prefetch_all_but_blobs" This method will set all the tables in the schema to prefetch all their non-blob-type columns. .PP This method is called as soon as a schema is loaded. .SS "prefetch_none" .IX Subsection "prefetch_none" This method turns of all prefetching. .SS "name" .IX Subsection "name" Returns a string containing the name of the schema. .SS "tables (@optional_list)" .IX Subsection "tables (@optional_list)" If no arguments are given, this method returns a list of all \&\f(CW\*(C`Alzabo::Runtime::Table\*(C'\fR objects in the schema, or in a scalar context the number of such tables. If one or more arguments are given, returns a list of table objects with those names, in the same order given (or the number of such tables in a scalar context, but this isn't terribly useful). .PP An \f(CW\*(C`Alzabo::Exception::Params\*(C'\fR exception is throws if the schema does not contain one or more of the specified tables. .SS "table ($name)" .IX Subsection "table ($name)" Returns an \f(CW\*(C`Alzabo::Runtime::Table\*(C'\fR object representing the specified table. .PP An \f(CW\*(C`Alzabo::Exception::Params\*(C'\fR exception is throws if the schema does not contain the table. .SS "has_table ($name)" .IX Subsection "has_table ($name)" Returns a boolean value indicating whether the table exists in the schema. .SS "begin_work" .IX Subsection "begin_work" Starts a transaction. Calls to this function may be nested and it will be handled properly. .SS "rollback" .IX Subsection "rollback" Rollback a transaction. .SS "commit" .IX Subsection "commit" Finishes a transaction with a commit. If you make multiple calls to \&\f(CW\*(C`begin_work()\*(C'\fR, make sure to call this method the same number of times. .SS "run_in_transaction ( sub { code... } )" .IX Subsection "run_in_transaction ( sub { code... } )" This method takes a subroutine reference and wraps it in a transaction. .PP It will preserve the context of the caller and returns whatever the wrapped code would have returned. .SS "driver" .IX Subsection "driver" Returns the \f(CW\*(C`Alzabo::Driver\*(C'\fR object for the schema. .SS "rules" .IX Subsection "rules" Returns the \f(CW\*(C`Alzabo::RDBMSRules\*(C'\fR object for the schema. .SS "sqlmaker" .IX Subsection "sqlmaker" Returns the \f(CW\*(C`Alzabo::SQLMaker\*(C'\fR object for the schema. .SH "JOINING A TABLE MORE THAN ONCE" .IX Header "JOINING A TABLE MORE THAN ONCE" It is possible to join to the same table more than once in a query. Table objects contain an \f(CW\*(C`alias()\*(C'\fR method that, when called, returns an object that can be used in the same query as the original table object, but which will be treated as a separate table. This faciliaties queries similar to the following \&\s-1SQL::\s0 .PP .Vb 1 \& SELECT ... FROM Foo AS F1, Foo as F2, Bar AS B ... .Ve .PP The object returned from the table functions more or less exactly like a table object. When using this table to set where clause or order by (or any other) conditions, it is important that the column objects for these conditions be retrieved from the alias object. .PP For example: .PP .Vb 1 \& my $foo_alias = $foo\->alias; \& \& my $cursor = $schema\->join( select => $foo, \& join => [ $foo, $bar, $foo_alias ], \& where => [ [ $bar\->column(\*(Aqbaz\*(Aq), \*(Aq=\*(Aq, 10 ], \& [ $foo_alias\->column(\*(Aqquux\*(Aq), \*(Aq=\*(Aq, 100 ] ], \& order_by => $foo_alias\->column(\*(Aqbriz\*(Aq) ); .Ve .PP If we were to use the \f(CW$foo\fR object to retrieve the 'quux' and \&'briz' columns then the join would simply not work as expected. .PP It is also possible to use multiple aliases of the same table in a join, so that this will work properly: .PP .Vb 2 \& my $foo_alias1 = $foo\->alias; \& my $foo_alias2 = $foo\->alias; .Ve .SH "USER AND PASSWORD INFORMATION" .IX Header "USER AND PASSWORD INFORMATION" This information is never saved to disk. This means that if you're operating in an environment where the schema object is reloaded from disk every time it is used, such as a \s-1CGI\s0 program spanning multiple requests, then you will have to make a new connection every time. In a persistent environment, this is not a problem. For example, in a mod_perl environment, you could load the schema and call the \&\f(CW\*(C`set_user()\*(C'\fR and \&\f(CW\*(C`set_password()\*(C'\fR methods in the server startup file. Then all the mod_perl children will inherit the schema with the user and password already set. Otherwise you will have to provide it for each request. .PP You may ask why you have to go to all this trouble to deal with the user and password information. The basic reason was that I did not feel I could come up with a solution to this problem that was secure, easy to configure and use, and cross-platform compatible. Rather, I think it is best to let each user decide on a security practice with which they feel comfortable. .PP In addition, there are a number of modules aimed at helping store and use this sort of information on \s-1CPAN,\s0 including \f(CW\*(C`DBIx::Connect\*(C'\fR and \&\f(CW\*(C`AppConfig\*(C'\fR, among others. .SH "AUTHOR" .IX Header "AUTHOR" Dave Rolsky,