Sql Excel Reports
Chemistry::SQL is an access database functions module. SYNOPSIS use strict; use Chemistry::SQL; use Chemistry::Artificial::SQL; my $db_name = $ARGV[0]; my $file = $ARGV[1]; my $db1 = Chemistry::SQL::new(db_host=>"127.0.0.1",db_user=>"root",db_port=>"3306",db_pwd=>"",...
Platforms: *nix
License: Freeware | Size: 14.34 KB | Download (107): Chemistry::SQL Download |
SQL::Routine::Language is a Perl module for what language or grammar SQL::Routine speaks. SQL::Routine contains SQL schemas and queries, represented as a tree of atomic tokens; it is structurally like an abstract syntax tree or an XML DOM, but one that only accepts, respectively, a specific...
Platforms: *nix
License: Freeware | Size: 174.08 KB | Download (93): SQL::Routine::Language Download |
SQL::Abstract::Limit is a portable LIMIT emulation. SYNOPSIS use SQL::Abstract::Limit; my $sql = SQL::Abstract::Limit->new( limit_dialect => LimitOffset );; # or autodetect from a DBI $dbh: my $sql = SQL::Abstract::Limit->new( limit_dialect => $dbh ); # or from a Class::DBI class: my...
Platforms: *nix
License: Freeware | Size: 14.34 KB | Download (98): SQL::Abstract::Limit Download |
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
License: Freeware | Size: 57.34 KB | Download (88): SQL::Interpolate Download |
SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux..
Platforms: *nix
License: Freeware | Size: 8.6 MB | Download (93): SQL Relay Download |
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
License: Freeware | Size: 52.22 KB | Download (94): SQL::Preproc Download |
BZbyte Reports provides a Web-based reporting solution. BZbyte Reports is a reliable and easy-to-use reporting application that supports features expected from a reporting tool such as Crystal Reports, MS Access, Jasper, and iReports. It is completely Web-based and uses dynamic HTML to...
Platforms: *nix
License: Freeware | Size: 40.3 MB | Download (97): BZbyte Reports 2.0.1 Download |
SQL Admin is a Java client application to connect and send queries to different databases through JDBC. SQLAdmin uses the brand new SWT Toolkit. The main idea is to create a multiplatform and multidatabase thin client. For example, you can connect to an Microsoft SQL Server from a Linux...
Platforms: *nix
License: Freeware | Size: 89.09 KB | Download (114): SQL Admin Download |
SQL::Translator::Manual is a Perl module that contains a manual for SQL translator. SYNOPSIS SQL::Translator (AKA "SQLFairy") is a collection of modules for transforming (mainly) SQL DDL files into a variety of other formats, including other SQL dialects, documentation, images, and code. In...
Platforms: *nix
License: Freeware | Size: 317.44 KB | Download (108): SQL::Translator::Manual Download |
SQL::Translator::Producer::GraphViz is a GraphViz producer for SQL::Translator. SYNOPSIS use SQL::Translator; my $trans = new SQL::Translator( from => MySQL, # or your db of choice to => GraphViz, producer_args => { out_file => schema.png, add_color => 1, show_constraints => 1,...
Platforms: *nix
License: Freeware | Size: 317.44 KB | Download (201): SQL::Translator::Producer::GraphViz Download |
Oracle::SQL is a Perl extension for building SQL statements. SYNOPSIS use Oracle::SQL; No automatically exported routines. You have to specifically to import the methods into your package. use Oracle::SQL qw(:sql); use Oracle::SQL /:sql/; use Oracle::SQL :sql; This is a package...
Platforms: *nix
License: Freeware | Size: 8.19 KB | Download (200): Oracle::SQL Download |
DateTime::Format::Excel is a Perl module that can convert between DateTime and Excel dates. SYNOPSIS use DateTime::Format::Excel; # From Excel via class method: my $datetime = DateTime::Format::Excel->parse_datetime( 37680 ); print $datetime->ymd(.); # 2003.02.28 # or via an object...
Platforms: *nix
License: Freeware | Size: 15.36 KB | Download (198): DateTime::Format::Excel Download |
XML::Excel is a Perl extension converting Excel files to XML. SYNOPSIS use XML::Excel; $excel_obj = XML::Excel->new(); $excel_obj = XML::Excel->new(%attr); $status = $excel_obj->parse_doc(file_name); $status = $excel_obj->parse_doc(file_name, %attr); $excel_obj->declare_xml(%attr);...
Platforms: *nix
License: Freeware | Size: 10.24 KB | Download (112): XML::Excel Download |
SQL::Statement::Embed can embed a SQL engine in a DBD or module. SQL::Statement is designed to be easy to embed in other modules and to be especially easy to embed in DBI drivers. It provides a SQL Engine and the other module needs to then provide a data source and a storage mechanism. For...
Platforms: *nix
License: Freeware | Size: 87.04 KB | Download (98): SQL::Statement::Embed Download |
Dimedis::Sql is a SQL/DBI Interface for banking applications. SYNOPSIS use Dimedis::Sql; my $sqlh = new Dimedis::Sql ( ... ); $sqlh->install ( ... ); my $seq_id = $sqlh->insert ( ... ); my $modified = $sqlh->update ( ... ); my $blob_sref = $sqlh->blob_read ( ... ); $sqlh->use_db (...
Platforms: *nix
License: Freeware | Size: 58.37 KB | Download (93): Dimedis::Sql Download |
SQL::Shell is a command interpreter for DBI shells. SYNOPSIS use SQL::Shell; #Initialise and configure my $sqlsh = new SQL::Shell(%settings); $sqlsh->set($setting, $new_value); $value = $sqlsh->get($setting); #Interpret commands $sqlsh->execute_command($command);...
Platforms: *nix
License: Freeware | Size: 30.72 KB | Download (158): SQL::Shell Download |
MillScript-Excel project is a Java library for reading and writing Excel spreadsheets. The goal of the library is primarily to support all versions of Microsoft Excel, but other spreadsheet formats should also be added. The API is geared towards easy integration with other applications..
Platforms: *nix
License: Freeware | Size: 512 KB | Download (126): MillScript-Excel Download |
SQL::Generator is a Perl module to generate SQL-statements with oo-perl. SYNOPSIS use SQL::Generator; With this module you can easily (and very flexible) generate/construct sql-statements. As a rookie, you are used to write a lot of sprintf`s every time i needed a statement (i.e.for DBI)....
Platforms: *nix
License: Freeware | Size: 13.31 KB | Download (124): SQL::Generator Download |
DL/SQL is declarative, turing-complete programming language based on top of SQL database. The main idea is to store both program and data in one SQL table and make all the computations in it. The current version of interpreter written in PHP contains quasi-lazy evaluation and simple caching....
Platforms: *nix
License: Freeware | Size: 21.5 KB | Download (98): DL/SQL Download |
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
License: Freeware | Size: 58.37 KB | Download (88): SQL::Amazon::Request::Help Download |