Free powerful mysql software for linux

Simply Powerful ToolKit in short SPTK is a powerful widget toolkit based on the Fast and Light ToolKit (FLTK).
The goal of this library is to create the easy-to-use, compact and effective library of controls to extend the abilities of FLTK library.
It is geared for business-style application development with database support (ODBC). All the widgets support database connectivity. A special CDialog class makes editing database records very easy. Every widget can be connected to the field, and CDialog can be connected to the database table.
Most of the controls are database-bound. If you place them on the CDialog-derived window they can load and save information from/to database.
This is the first release version of my controls(widgets) library that was designed to work with FLTK. Im using it for about a year in the production project.
Enhancements:
- Fixed a bug in CField::asString() that cause returning an empty string for some non-empty fields.
- Added couple of small fixes for better error hanling in CRegistry.

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.
Enhancements:
- 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.

mpg123-mysql consists of some patches to mpg123 which make it support MySQL. This adds some bells and whistles, including rating support and playlist support.
In addition to that, mpg123-mysql offers the following facilities:
mpg123-mysql uses setproctitle(3) to show ps(1) which title it is playing at the moment. You can use this feature with the included "np" script. Unfortunately, this works on FreeBSD only at the moment.
by sending a SIGTSTP signal to mpg123-mysql, it stops playing and closes the audio device so that another process can open it temporarily. You can try this out with "killall -TSTP mpg123", for example.
Main features:
- rating support:
- When a file is played completely, it gets some (e.g. 2) points. When playing is interrupted by sending the usual "INT" signal to mpg123, the song gets less points. After a while, you can build your own "Top 10" or sort out those files you dont want
- to have any longer. Additionally, mpg123-mysql is able to skip titles with a bad (negative) rating
-
- playlist support:
- You can tell mpg123 to use your database as the source for your playlist. This also works in shuffle (-z) mode.

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.
Enhancements:
- 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.

Netacct-mysql is modified version of traffic accounting daemon net-acct which stores collected data in MySQL. It supports writing accounting information in a single line in MySQL per day for every IP (mrta style).
Netacct functions by analogy with sniffer, i.e. it keeps track of all the traffic passing through the network interfaces assigned by the configuration file. Data are stored in the memory and periodically saved in the database. The default data save period is 300 seconds (see option "flush" in the config file).
The application is used for accounting of the network traffic passed through your router/gateway. It is based on the libpcap library and functions as a userspace daemon. Options for dividing the network traffic into 4 categories:
- international
- peering
- direct
- local
The traffic accounts are saved in a database, and for the time being MySQL and Oracle are supported. As libpcap is used for gathering the network data the application runs (for the moment) on the following operating systems:
- Linux
- FreeBSD
- OpenBSD
- Solaris
For more detailed information regarding a particular OS, please read the FAQ file.
Enhancements:
- netacct.h:
- process.c:
- naccttab.sample:
- fixed disable fields in config file, now it works does not write some fields in dump file - fixed

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.
Enhancements:
- 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.

DBD::mysql is a Perl module with MySQL driver for the Perl5 Database Interface (DBI).

SYNOPSIS

use DBI;

$dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";

$dbh = DBI->connect($dsn, $user, $password);


$drh = DBI->install_driver("mysql");
@databases = DBI->data_sources("mysql");
or
@databases = DBI->data_sources("mysql",
{"host" => $host, "port" => $port});

$sth = $dbh->prepare("SELECT * FROM foo WHERE bla");
or
$sth = $dbh->prepare("LISTFIELDS $table");
or
$sth = $dbh->prepare("LISTINDEX $table $index");
$sth->execute;
$numRows = $sth->rows;
$numFields = $sth->{NUM_OF_FIELDS};
$sth->finish;

$rc = $drh->func(createdb, $database, $host, $user, $password, admin);
$rc = $drh->func(dropdb, $database, $host, $user, $password, admin);
$rc = $drh->func(shutdown, $host, $user, $password, admin);
$rc = $drh->func(reload, $host, $user, $password, admin);

$rc = $dbh->func(createdb, $database, admin);
$rc = $dbh->func(dropdb, $database, admin);
$rc = $dbh->func(shutdown, admin);
$rc = $dbh->func(reload, admin);

EXAMPLE

#!/usr/bin/perl

use strict;
use DBI();

# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost",
"joe", "joes password",
{RaiseError => 1});

# Drop table foo. This may fail, if foo doesnt exist.
# Thus we put an eval around it.
eval { $dbh->do("DROP TABLE foo") };
print "Dropping foo failed: $@n" if $@;

# Create a new table foo. This must not fail, thus we dont
# catch errors.
$dbh->do("CREATE TABLE foo (id INTEGER, name VARCHAR(20))");

# INSERT some data into foo. We are using $dbh->quote() for
# quoting the name.
$dbh->do("INSERT INTO foo VALUES (1, " . $dbh->quote("Tim") . ")");

# Same thing, but using placeholders
$dbh->do("INSERT INTO foo VALUES (?, ?)", undef, 2, "Jochen");

# Now retrieve data from the table.
my $sth = $dbh->prepare("SELECT * FROM foo");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{id}, name = $ref->{name}n";
}
$sth->finish();

# Disconnect from the database.
$dbh->disconnect();

DBD::mysql is the Perl5 Database Interface driver for the MySQL database. In other words: DBD::mysql is an interface between the Perl programming language and the MySQL programming API that comes with the MySQL relational database management system. Most functions provided by this programming API are supported. Some rarely used functions are missing, mainly because noone ever requested them.

MySQLfs is Linux userspace filesystem which stores data in a MySQL database. The project uses FUSE to interface with the kernel.