Nested Sql Select Statements

DBIx::XMLServer is a Perl module to serve data as XML in response to HTTP requests. SYNOPSIS use XML::LibXML; use DBIx::XMLServer; my $xml_server = new DBIx::XMLServer($dbh, "template.xml"); my $doc = $xml_server->process($QUERY_STRING); die "Error: $doc" unless ref $doc; print...

Tangram::Type::Extending is a Perl module for teaching Tangram about new types. Tangram::Type is the root of a hierarchy of classes that are responsible mapping individual field to SQL entities (columns in the simplest cases). There is one Type object per persistent field. Adding support for...

SQL::Preproc is a Perl module to embed SQL in your Perl (ala SQL preprocessors). SYNOPSIS use SQL::Preproc subclass => Chart, emit => 1, keepsql => 1, syntax => [ Teradata ], pponly => 1, relax => 1, alias => 1, debug => 1; use DBI; use DBI qw(:sql_types); use...


Platforms: *nix

SQL::Amazon::UserGuide is a Perl module with user Guide for DBD/SQL::Amazon. SYNOPSIS # # create the parser, passing in the current Amazon metadata # my $parser = SQL::Amazon::Parser->new(%attrs); # # parse a SQL statement, returning a SQL::Amazon::Statement # my $stmt =...


Platforms: *nix

SqliteQuery is a utility for executing SQL statements on SQLite databases. You can edit and maintain existing databases or create new ones through the user-interface. SqliteQuery comes with the compiled SQLite database library built-in.The main purpose of SqliteQuery is to execute SQL statements...


Platforms: Mac

DoSQL is a FileMaker Pro plug-in for Windows and Macintosh that allows you to to manipulate FileMaker data from FileMaker calculations. The plug-in uses SQL statements to select, update, create or delete FileMaker records. Features:write to FileMaker fields directly, using a calculation with SQL...


Platforms: Mac

logindpostgres is a script that reads SQL select statements from PostgreSQL logs and generates all the indices to optimize the database for each request. logindpostgres has been tested on 1.2 GB of logs.. Get Postgres 8.1 Intelligent Index generator at SourceForge.net. Fast, secure and free...


Platforms: *nix

VIF Lightweight Framework is an object-relational bridge to store and retrieve data in relational database management systems (RDMS). The frameworks building blocks to access data are data object models (DOM objects) and joined data object models (joined DOM objects). A DOM object is used for...


Platforms: *nix

Yet Another dia2sql is a tool that generates SQL statements from Dia XML files. yadia2sql is intended to process diagrams that are compatible with dia2sql.php to some point, and provide features that would allow generation of SQL code for different database systems from single Dia source....


Platforms: *nix

SQL::Interpolate is a Perl module to interpolate Perl variables into SQL statements. SYNOPSIS use SQL::Interpolate qw(:all); # Some sample data to interpolate: my $s = blue; my @v = (5, 6); # Variable references are transformed into bind parameters. # The most basic usage involves...


Platforms: *nix

DBIx::HTML::ClientDB is a Perl module to convert sql into a client-side db with keyed access. Synopsis use DBIx::HTML::ClientDB; my($object) = DBIx::HTML::ClientDB -> new ( dbh => $dbh, row_headings => Unit code,Unit code,Campus name,Unit name, sql => select unit_code, unit_code,...


Platforms: *nix

Alzabo is a Perl module with data modelling tool and RDBMS-OO mapper. SYNOPSIS Cannot be summarized here. What is Alzabo? Alzabo is a suite of modules with two core functions. Its first use is as a data modelling tool. Through either a schema creation GUI, a perl program, or reverse...


Platforms: *nix

DBIx::SQL::Abstract is a Perl module that provides a convenient abstraction layer to a database. SYNOPSIS use DBIx::SQL::Abstract; my $dbh = DBIx::SQL::Abstract->new( %dbcfg ); Building SQL Abstractions. my($query, @bind) = $dbh->select($table, @fields, %where, @order); my($query,...


Platforms: *nix

SQL::Amazon::Request::Help is an Interface to retrieve Help content. SYNOPSIS $dbh = DBI->connect(dbi:Amazon:, $amznid, undef, { amzn_mode => books, amzn_locale => us, amzn_max_pages => 3 }) or die "Cannot connect: " . $DBI::errstr; # # search for some Perl DBI books # $sth =...


Platforms: *nix

SQL VB ASP Code Generator is a powerful multi-purpose tool that lets you effortlessly generate SQL, VB and ASP Code. You can even generate an entire VB application or ASP web application, all derived from the tables in your database with just one click. No more recreating the same old SELECT,...


Platforms: Windows

Stellar Phoenix SQL Database Repair is an advanced professional software that repairs corrupt SQL Server MDF files and recovers all its objects. Whether the database file is corrupt due to virus attack, media read errors, system shutdown, etc. it is capable of performing a recovery in all...


Platforms: Windows, Windows 8, Windows 7, Windows Server

Aglowsoft SQL Query Tools includes three database tools. They are Aglowsoft Schema Tool, Aglowsoft Designer, and Aglowsoft Browser. The tools are designed to allow building of SQL queries with basic knowledge of SQL using user-friendly interface. Result sets from SQL queries are presented in a...


Platforms: Windows, Windows 8, Windows 7, Windows Server

This tool converts SQL table or query results (multiple resultset) to MS Excel file (.xls file). With the help of Convert SQL to Excel you'll be able to easily turn SQL queries as well as tables into XLS files. This tool also allows you to convert/export multiple tables (multiple query results)...


Platforms: Windows, Windows Vista, 7, 7x64

Database Viewer for SmartPhone is designed to help you open your database on your mobile SmartPhone. On your Microsoft windows based SmartPhone view MS Access, Oracle, Foxpro, dBase, MS Excel, MySQL and Any ODBC Compliant Database. You can view the database records in grid of rows and columns...


Platforms: Windows

Free SQL Formater is a simple, accessible and easy-to-use Open Source SQL formatter. Now you can use this tool every time you want to format or unformat your SQL files. All you have to do is select the SQL file you need and the program will do the rest.


Platforms: Windows, Windows Vista, 7