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.

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

my $excel = DateTime::Format::Excel->new();
print $excel->parse_datetime( 25569 )->ymd; # 1970-01-01

# Back to Excel number:

use DateTime;
my $dt = DateTime->new( year => 1979, month => 7, day => 16 );
my $daynum = DateTime::Format::Excel->format_datetime( $dt );
print $daynum; # 29052

# or via an object
my $other_daynum = $excel->format_datetime( $dt );
print $other_daynum; # 29052

Excel uses a different system for its dates than most Unix programs. This module allows you to convert between a few of the Excel raw formats and DateTime objects, which can then be further converted via any of the other DateTime::Format::* modules, or just with DateTimes methods.

If you happen to be dealing with dates between 1 Jan 1900 and 1 Mar 1900 please read the notes on epochs.

If youre wanting to handle actual spreadsheet files, you may find Spreadsheet::WriteExcel and Spreadsheet::ParseExcel of use.

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);
$excel_obj->declare_doctype(%attr);

$excel_obj->print_xml(file_name, %attr);

XML::Excel is a new module which is going to be upgraded very often as my time permits. For the time being it uses Spreadsheet::ParseExcel module object default values to parse the (*.xls) document and then creates a perl data structure with xml tags names and data. At this point it does not allow for a write as you parse interface but is the first upgrade for the next release. I will also allow more access to the data structures and more documentation.

I will also put in more support for XML, since currently it only allows a simple XML structure. Currently you can modify the tag structure to allow for attributes. No DTD support is currently available, but will be implemented in a soon coming release. As the module will provide both: object and event interfaces, it will be used upon individual needs, system resources, and required performance. Ofcourse the DOM implementation takes up more resources and in some instances timing, its the easiest to use.

Skeleton Engine for MySQL is a full framework to plug in a new storage engine. Comes with prebuild autoconf files, and a full framework to plug in your own design.

The AWS, HTTP, Memcache, Nitro, PBXT, and many other engines were put together from the skeleton engine.

To install, grab a copy of the mysql source code and run this:
./configure --with-mysql=/home/brian/mysql-5.1/ --libdir=/usr/local/lib/mysql/
make install

And then inside of MySQL:

mysql> INSTALL PLUGIN skeleton SONAME libskeleton_engine.so;

mysql> CREATE TABLE `d` (`a` varchar(125), b text, primary key(a)) ENGINE=skeleton DEFAULT
CHARSET=latin1;
Query OK, 0 rows affected (0.01 sec)

You will probably need to edit the Makefile.am in the src/ tree if you want to build on anything other then Linux (and the Makefile assumes that the server was not compiled for debug).

MySQL Backup for lazy sysadmins (mysqlblasy) is a Perl script for automating MySQL database backups. It uses "mysqldump" for dumping mysql databases to the files sytem. MySQL Backup for lazy sysadmins program was written with automated usage in mind.

For example, it is silent during operation, and only produces noise on errors/problems. It rotates backups automatically to prevent the backup disk from getting full when the administrator is on vacation (or is lazy).

Here are some key features of "MySQL Backup for lazy sysadmins":

· syslog facility
· unix output (loglevels, errors to stderr)
· dump some or all databases from a database instance
· compress dumps (using gzip,bzip2 or perl modules)
· backup rotation to avoid disc overflow
· no shell on external commands!
· can be run as unpriviledged user
· perfect for cron jobs

Memcache Engine for MySQL project allows memcache to work as a storage engine to MySQL.

This means that you can SELECT/UPDATE/ INSERTE/DELETE from it as though it is a table in MySQL. This is very experimental.

This is still very experimental.

Memcached is a high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load.

Whats New in This Release:

· Support for discovery of tables was added.
· Row level locks were implemented.
· A major bug in duplicate keys was fixed, along with phantom rows for updates.
· The server status has been updated.

UDF collection for MySQL project contains utility UDFs that are supposed to be built and loaded as shared objects.

Its available functions are HUMANAGE() (which returns the age in years relative to a custom date or NOW()), URLENCODE() and URLDECODE().

Installation:

The simplest way to compile this package is:

1. `cd to the directory containing the packages source code and type `./configure to configure the package for your system. If youre using `csh on an old version of System V, you might need to type `sh ./configure instead to prevent `csh from trying to execute `configure itself.

Running `configure takes awhile. While running, it prints some messages telling which features it is checking for.

2. Type `make to compile the package.

3. Optionally, type `make check to run any self-tests that come with the package.

4. Type `make install to install the programs and any data files and documentation.

5. You can remove the program binaries and object files from the source code directory by typing `make clean. To also remove the files that `configure created (so you can compile the package for a different kind of computer), type `make distclean. There is also a `make maintainer-clean target, but that is intended mainly for the packages developers. If you use it, you may have to get all sorts of other programs in order to regenerate files that came with the distribution.

Whats New in This Release:

· A bug in HUMANAGE() regarding a last adjustment of mon/mday in sll2tm() was fixed.
· A bug in HUMANAGE() in which day() just looped over the first year was fixed.

MySQL Activity Report is a valuable database tuning aid.

The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes.

The most important component of the MySQL Activity Report is mysqlard. This daemon collects the data from a MySQL server and stores these values in a Round Robin Database.

The mysqlard package also contains example graphing, cron and php scripts. The cron scripts can be used to keep archives of the generated graphics and the php script shows the generated graphics and tries to give some tuning tips.

MySQL Pack for QNAP TS-101/TS-201 was created to install MySQL on the QNAP NAS server, TS-101/TS-201. It contains a pre-compiled MySQL server and install programs. The php module supporting MySQL client will be also included if its necessary. The Pack also contains simple webpages for start/stop mysql.

Installation:

Create a share folder named MySQL. You may directly create Network Shares named MySQL on TS-101 Administration page. Please make sure both the real folder name and share volume name be MySQL.
Upload and unzip the package file (e.g. MySQL-4.1.21-TS-101-v0.2.tar) to the share folder created in the step 1. Here, using administrator to access the share folder is recommanded.
login in your TS-101 through Telnet Refer to http://scratchpad.wikia.com/wiki/Open_Turbostation:TS101, or find a TS-101 firmware with telnet enabled (You may find it on http://tech.groups.yahoo.com/group/OpenTurbostation/)
Run install.sh to install MySQL > /share/MySQL/install.sh /share/MySQL/mysql-4.1.21-TS-101.tgz /share/MySQL
Run mysqld.sh to start/stop MySQL > /usr/local/mysql/mysqld.sh start > /usr/local/mysql/mysqld.sh stop
Try to connect MySQL If you could connect MySQL with the following command, it means that your MySQL works. > /usr/local/mysql/bin/mysql mysql -u root --password=admin
After installation finished, MySQL will automatically start while booting. You may also run sys_initialize.sh to re-initialize MySQL. sys_initialize.sh wont remove the existed MySQL Pack and your database. > /share/MySQL/sys_initialize.sh /share/MySQL

Whats New in This Release:

· PHP supports sockets.
· gd-jpeg errors that occurred in PHP have been fixed.

Zmanda Recovery Manager for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. With ZRM for MySQL you can:

· Schedule full and incremental logical or raw backups of your MySQL database
· Perform backup that is the best match for your storage engine and your MySQL configuration
· Get e-mail notification about status of your backups
· Monitor and browse your backups
· Recover database easily to any point in time or to any particular transaction

A MySQL Storage Engine for AWS S3 project is a plugin storage engine that allows MySQL to access Amazon Web Services Simple Storage Service (AWS S3) buckets and items.

You need a MySQL source tree, and you need to have it built.

Figure out where the source tree is.
In my case its /home/mark/mysql/mysql-5.1-arch
Figure out where the target install tree is.
In my case its /home/mark/mysql/builds/example
Figure out where the MySQL build puts storage engine plugins.
Its probably in lib/mysql under the install tree
Or its /usr/lib/mysql
Or its /usr/local/lib/mysql
For me its /home/mark/mysql/builds/example/lib/mysql

Then run:

./config/bootstrap
./configure --with-mysql=/path/to/mysql-source --libdir=/path/to/mysql-plugins
make && make install

You can optionally copy the "src" directory here into storage/ in the
MySQL server source, rebuild MySQL, and things should compile.

Next, you should probably install the S3 command line tools.
They depend on you having Python.

Get them at http://www.hanzoarchives.com/development-projects/s3-tools/

If you dont have one yet, you need an Amazon AWS account, and then
request that they enable S3. Go to http://amazonaws.com/ to do that.
You will need to get your "AWS Access Key Identifiers".

Assume they are

FV8CY5793BC7CY32YOSN
W9oQxQNJizGgjxNc82giE9/ipefQW19tuO2xpC9G

(I just made those up with a random number generator.)

Put this in your .bashrc file

AWS_ACCESS_KEY_ID=FV8CY5793BC7CY32YOSN
AWS_ACCESS_KEY_SECRET=W9oQxQNJizGgjxNc82giE9/ipefQW19tuO2xpC9G
export AWS_ACCESS_KEY_ID AWS_ACCESS_KEY_SECRET

This isnt used by the storage engine, but it makes using the s3 command
line tools easier.

Use s3mkbucket to create a bucket. Remember that buckets are in a
global namespace, and there are advantages to having them look lik a
domain name. I suggest you snap up "s3.example.com", where
"example.com" is your own domain name.

s3mkbucket s3.example.com
s3put -k solfege/Do -s "a deer, a female deer" s3.example.com
s3put -k solfege/Re -s "a drop of golden sun" s3.example.com
s3put -k solfege/Mi -s "a name I call myself" s3.example.com
s3put -k solfege/Fa -s "a long long way to run" s3.example.com
s3put -k solfege/So -s "a needle pulling thread" s3.example.com
s3put -k solfege/La -s "a note to follow So" s3.example.com
s3put -k solfege/Ti -s "a drink with jam and bread" s3.example.com

Then at the mysql> prompt

create table s3notes (s3id varchar(255) not null primary key, s3val blob)
engine=AWSS3
connection=awss3 s3.example.com FV8CY5793BC7CY32YOSN W9oQxQNJizGgjxNc82giE9/ipefQW19tuO2xpC9G;
select * from s3notes where s3id=solfege/Re;
insert into s3notes (s3id, s3val) values (color/Red, ff 00 00);
select * from s3notes where s3id=color/Red;
delete from s3notes where s3id=color/Red;

You can name the table anything you want, but the fields must be named s3id and s3val, and s3id must be the primary key.

Whats New in This Release:

· More flexible schema, CREATE SERVER, and SELECT without WHERE are supported.

Web Service Engine for MySQL is a storage engine for the MySQL database. The project takes basic SQL and translates this through the engine interface into HTTP request methods.

This gives you the ability to create, read, and delete pages on Web servers. Wikipedia becomes a table you can select on from your database.

Whats New in This Release:

· Multiple attributes per table are now supported.
· The engine now handles tables with more than two columns by generating XML that is stored on the remote server.
· Tables with only two columns are stored as before, with the non-keyed attribute being directly provided to the remote provider.

ConfigFile for Haskell is a configuration file parser and writer library for Haskell.

The ConfigFile module works with configuration files in a standard format that is easy for the user to edit, easy for the programmer to work with, yet remains powerful and flexible. It is inspired by, and compatible with, Pythons ConfigParser module. It uses files that resemble Windows .INI-style files, but with numerous improvements.

ConfigFile provides simple calls to both read and write config files. Its possible to make a config file parsable by this module, the Unix shell, and make.

Whats New in This Release:

· This package was formerly part of MissingH and is being split off as part of the MissingH transition plan.

binpatch is a framework for creating binary patches for OpenBSD on all platforms in a semi-automatic way.

These binary patches in turn can be distributed across a network and applied easily to any number of servers with a custom script. Since they are just simple compressed tar balls with the programs/libraries patched, applied is as easy as

# tar xzpf binpatch-3.8-i386-001.tgz -C /

Binary patches is a convenient way to keep your servers up to date with security and reliability patches. Unlike the traditional method of patching the source tree, applying binary patches doesnt need extra disk space to hold the whole source tree, compilers or a powerful enough CPU to build the programs patched in a reasonable period of time.

Usage:

The binpatch framework resemblances the OpenBSD ports subsystem in many ways. Its no coincidence since binpatch took ideas from the OpenBSD ports subsystem.

binpatch is a make script with routines that automate downloading, applying, building and packaging binary patches. Using binpatch means executing the following tasks: maintenance, building and installation.

Maintenance and building are not intended for end users of binary patches. If you are insterested only on installing a binary patch you can safely skip the following two sections.

The magic in binpatch must be invoked by a custom Makefile that informs binpatch about the patches available and how they should be built. Its similar as making a port, where you need to write a Makefile with directions about how a port must be built. A sample self-documented Makefile is included in this distribution. After editing a Makefile, we have to build the patched files.

This is the sequence of targets:

init: "fake" install of a complete OpenBSD system
extract: unpacks the OpenBSD sources
patch: downloads the patch given from the master site and applies it
build: builds the programs/libraries affected
plist: creates the PLIST with the names of the files modified

Theres no fetch target. binpatch doesnt currently download neither the installation sets nor the sources. You have to put them manually under the required directory.

nmGoSearch extension for PHP is a complete PHP binding for the mnoGoSearch API.

If used with mysql you should not use bundled mysql library in the php distribution. You should use native mysql library. To do this you should compile php with specefying mysql-dir (for example --with-mysql=/usr, not --with-mysql).

To compile PHP with CVS versions of mnogosearch (not with official releases) you must open configure script of mnogosearch in your editor. Find line like the following:

VERSION=x.x.x-`date "+%d%m%Y"`

where x.x.x is the mnogosearch version number like 3.2.16 or so.

Then just remove -`date "+%d%m%Y"`. After that this line should be VERSION=x.x.x

After complete you should reconfigure, recompile, reinstall mnogosearch and php.