perl-DBX-Simple - Yet another DBI simplification wrapper

Property Value
Distribution ALT Linux Sisyphus
Repository Autoimports noarch
Package filename perl-DBX-Simple-0.01-alt1.noarch.rpm
Package name perl-DBX-Simple
Package version 0.01
Package release alt1
Package architecture noarch
Package type rpm
Category Development/Perl
Homepage -
License -
Maintainer -
Download size 10.58 KB
Installed size 10.58 KB
This is my DBI wrapper. There are many like it, but this one is mine.
I have a horrible memory for syntactic detail. This is one reason I've been developing a semantically oriented programming
language for the past decade, but in the meantime, when I write Perl to manage my accounting or suck data from the Web,
I use SQLite through DBI and I just can't ever remember the syntax. I don't know why. I'm usually fine on SQL syntax, at
least for the basic things I do most of the time, but the actual DBI methods escape me again and again.
This module is the syntax in my head, just so I don't have to keep looking everything up every single time. The class
subclasses DBI anyway, so anything you would do in DBI, you can do here - but with some simplifying alternative methods
as well.
use DBX::Simple;
my $dbh->DBX::Simple->connect(--DBI syntax--);  # Just so I can support everything DBI supports, after looking it up.
my $dbh->DBX::Simple->open('sqlite file');      # 99% of my work. ->mysql and ->postgresql would also be reasonable.
my $value = $dbh->get ('select value from table where id=?', $id);  # Single value retrieval in one whack.
my @rows = $dbh->select ('select * from table'); # Rowset retrieval. Yes, I know about selectrow_array. I just can't remember it.
my $iter = $dbh->iterate ('select * from table'); # Returns an iterator that returns row arrayrefs.
my $sth = $dbh->prepare (--DBI syntax--);
$dbh->do ("insert ...");  # Regular insertion, just like in DBI, except the hashref is skipped because I can never remember it.
my $record = $dbh->insert ("insert ..."); # Calls last_insert_id ('', '', '', ''), which will likely fail except with SQLite.
Simple. Like the name says. And exposes DBI anyway for when simple won't cut it, or when DBI is already simple.
One thing to notice: the class structure differs from DBI. DBX::Simple actually subclasses DBI::db - except for the `connect'
method. So any class-level calls should still be done through DBI, not DBX::Simple. (Easy for me to forget, as I never actually
do class-level stuff, except for those very rare times when I do.)


Package Version Architecture Repository
perl-DBX-Simple - - -


Name Value
/usr/share/perl5 -
perl( -
rpmlib(PayloadIsLzma) -


Name Value
perl(DBX/ = 0.010
perl-DBX-Simple = 0.01-alt1


Type URL
Binary Package perl-DBX-Simple-0.01-alt1.noarch.rpm
Source Package perl-DBX-Simple-0.01-alt1.src.rpm

Install Howto

  1. Add the following line to /etc/apt/sources.list:
    rpm [Sisyphus] noarch autoimports
    rpm [Sisyphus] noarch autoimports
  2. Update the package index:
    # sudo apt-get update
  3. Install perl-DBX-Simple rpm package:
    # sudo apt-get install perl-DBX-Simple



See Also

Package Description
perl-DB_File-DB_Database-0.031-alt1.noarch.rpm Perl module for reading and writing the DB_File data as a mutifield table
perl-DB_File-Lock-0.05-alt2_10.noarch.rpm DB_File-Lock module for perl
perl-DB_File-Utils-0.006-alt1.noarch.rpm Creates db_util command line for DB_File management
perl-DB_File-Utils-scripts-0.006-alt1.noarch.rpm DB_File-Utils scripts
perl-DBass-0.53-alt1.noarch.rpm perl module DBass
perl-DBedit-1.96-alt1.noarch.rpm Class to handle database editing
perl-DBomb-0.20-alt1.noarch.rpm The DBomb Release Version
perl-DBomb-scripts-0.20-alt1.noarch.rpm DBomb scripts
perl-DCE-Perl-RPC-0.01-alt1.noarch.rpm perl module DCE-Perl-RPC
perl-DCI-0.013-alt1.noarch.rpm Collection of utilities for writing perl code that fits the DCI
perl-DCOLLINS-ANN-Locals-0.004-alt1.noarch.rpm a wrapper for AI::ANN
perl-DCOP-0.038-alt2_9.noarch.rpm Extensible inheritable class to dcop
perl-DCOP-Amarok-0.036-alt1.noarch.rpm perl module DCOP-Amarok
perl-DCOP-Amarok-Player-0.037-alt1.noarch.rpm Perl extension to speak to an amaroK player object via system's DCOP
perl-DCOP-Amarok-Playlist-0.009-alt1.noarch.rpm Perl extension to speak to an amaroK player object via system's DCOP