The "Excel::Writer::XLSX" module can be used to create an Excel file in the 2007+ XLSX format. The XLSX format is the Office Open XML (OOXML) format used by Excel 2007 and later. Multiple worksheets can be added to a workbook and formatting can be ap...

The goal of OOPS is to make perl objects easily and transparently persistent. OOPS handles deeply nested and cross-linked objects -- even object hierarchies that are too large to fit in memory and (with a hint) individual hash tables that are too lar...

The origin of the name PONAPI (pronounced: Po-Na-Pi) is JSONAPI. We jokingly decided to replace the JavaScript reference (JS) with a Perl one (P). This document describes how to use and set up "PONAPI::Server". The latter parts describe how to set up...

NB: 0.07 is an interim release - the next version will contain significant changes, including changes to the UI. Data::Sync is a simple metadirectory/data pump module. It automates a number of the common tasks required when writing code to migrate/sy...

SQL::Shell is a command-interpreter API for building shells and batch scripts. A command-line interface with readline support - sqlsh.pl - is included as part of the CPAN distribution. See <SQL::Shell::Manual> for a user guide. SQL::Shell offers feat...

This class ties data from a DBI datasource to widgets in a Gtk2+ window ( generated by Glade ). All that is required is that you name your widgets the same as the fields in your data source. You have to set up combo boxes ( ie create your Gtk2::ListS...

• Rose::DB::Object::Metadata - Database object metadata.
• Rose::DB::Object::Metadata::Column - Base class for database column metadata objects.

This package facilitates reading and writing dBASE III PLUS DBF files. This is made possible by documentation generously released by Borland at <http://community.borland.com/article/0,1410,15838,00.html> Currently, only version III PLUS files are rea...

See the the documentation of Module::Which....

• Module::Which - find version and path of locally installed modules

This is an SQL to OO mapper with an object API inspired by Class::DBI (with a compatibility layer as a springboard for porting) and a resultset API that allows abstract encapsulation of database operations. It aims to make representing queries in you...

• DBIx::Class - Extensible and flexible object <-> relational mapper.
• DBIx::Class::ResultSet - Represents a query used for fetching a set of results.
• DBIx::Class::Storage::DBI - DBI storage handler
• 26 more results from DBIx-Class »

Kasago is a module for indexing Perl source code. You can index source trees, and then query the index for symbols, strings, and documentation. Kasago uses the PPI module to parse Perl and stores the index in a PostegreSQL database. Thus you need to ...

This is the Perl API client for the Sphinx open-source SQL full-text indexing search engine, <http://www.sphinxsearch.com>. Since 0.9.9, Sphinx supports a native MySQL-protocol client, i.e. DBI with DBD::mysql. That is, you can configure the server t...

This document describes version 2 of the CPAN distribution metadata specification, also known as the "CPAN Meta Spec". Revisions of this specification for typo corrections and prose clarifications may be issued as CPAN::Meta::Spec 2.*x*. These revisi...

• CPAN::Meta::History::Meta_1_3 - Version 1.3 metadata specification for META.yml
• CPAN::Meta::History::Meta_1_4 - Version 1.4 metadata specification for META.yml

Net::Wire10 is a Pure Perl connector that talks to MySQL, Sphinx and Drizzle servers. Net::Wire10 implements the low-level network protocol, alias the MySQL wire protocol version 10, necessary for talking to one of the aforementioned servers without ...

• Mail::Toaster::Setup - methods to configure and build all the components of a modern email server.
• Mail::Toaster::Mysql - so much more than just installing mysql

接続/切断は自動で行われる。 手動で接続/切断する場合は、connect/disconnectを使うこともできるが、なるべく使用しないことを推奨。 実行クエリの処理時間・実行計画・結果を記録するデバッグモード。 prepare/executeを分けない。fetchは分けることもできる。 拡張プレースホルダ機能 $db->execute(q{select * from a where mode in (??)}, ['a', 'b']) と記述すると、 $db->execute(q{select ...