use Class::DBI::Loader;

my $loader = Class::DBI::Loader->new(
    dsn => 'dbi:mysql:dbname',
    user => 'user',
    password => 'p455w0rd',
    namespace => 'MyApp',
  );

# MyObject is one of the tables in the database
package MyApp::MyObject;

# define various methods on that class

1;