Sql::Simple Sql::Simple is an Sql statement generation and execution library (for simple tasks).
Download

Sql::Simple Ranking & Summary

Sql::Simple Tags

SQL statement SQL Perl module perl statement execution library

Sql::Simple Description

Sql::Simple is an Sql statement generation and execution library (for simple tasks). Sql::Simple is an Sql statement generation and execution library (for simple tasks).SYNOPSIS: Sql::Simple->setdbh($dbh); # select price, weight from fruit where onSale = 'true' my $result = Sql::Simple->query($dbh, , 'fruit', { 'onSale' => 'true' });This module is a re-hash of like fifty different modules already on CPAN. TWMTODI is a good thing, but sadly this is more of the case of being tired of seeing patch submissions being rejected into similar modules. The upside to this module is that it handles table joins rather elegantly (ie: no creation of seperate classes, config files, xml, GPS coordinates, or cat scans). The downside is probably the fact that I wrote it, as there are a few inefficient quirks to my coding style (comments appreciated).Of course, this module covers the basics of sql... insert, update, delete, and select's. The ability to do things in mass is available as well, to assist you with large data maniuplations. (taking advantage of a database that takes advantage of placeholders, and setting AutoCommit to 0).IMHO, this module is almost mostly DWIM. A nice OO approach is in the works, just needed some pointers from some friends before I could break ground on it. (I do not do a lot of web programming with perl anymore, more data transformation stuff, so this module suits me for what I do).This module currently ONLY SUPPORTS ANSI SQL-92, there has been suggestions to make this more modular, but I think the db's will catch up before I do.This module will only work with the following database servers (that I have personally tested so far). Requirements: · Perl

Sql::Simple Related Software