Free relations query 0.93 software for linux

Relations::Query is a Perl Object for building queries with DBI/DBD::mysql.

SYNOPSIS

# Relations::Query Script that creates some queries.

use Relations::Query;

$query = new Relations::Query(-select => {fife => barney},
-from => {green_teeth => moogoo},
-where => "flotsam>jetsam",
-group_by => "denali",
-having => {fortune => cookie},
-order_by => [was,is,will],
-limit => 1);

$get_query = $query->get();

$query->set(-select => {clean => sparkle},
-from => {lean => book},
-where => "fighting is between courage and chaos",
-limit => 123);

$set_query = $query->get();

$get_add_query = $query->get_add(-select => {mean => dog},
-where => "running is null",
-having => {kitties=> on_tv},
-limit => [9678]);

$query = to_string({select => this,
from => that});

Relations::Family is a DBI/DBD::mysql Relational Query Engine module.

SYNOPSIS

# DBI, Relations::Family Script that creates some queries.

#!/usr/bin/perl

use DBI;
use Relations::Family;

$dsn = "DBI:mysql:finder";

$username = "root";
$password = ;

$dbh = DBI->connect($dsn,$username,$password,{PrintError => 1, RaiseError => 0});

$abstract = new Relations::Abstract($dbh);

$family = new Relations::Family($abstract);

$family->add_member(-name => account,
-label => Cust. Account,
-database => finder,
-table => account,
-id_field => acc_id,
-query => {-select => {id => acc_id,
label => "concat(cust_name, - ,balance)"},
-from => [account,customer],
-where => "customer.cust_id=account.cust_id",
-order_by => "cust_name"});

$family->add_member(-name => customer,
-label => Customer,
-database => finder,
-table => customer,
-id_field => cust_id,
-query => {-select => {id => cust_id,
label => cust_name},
-from => customer,
-order_by => "cust_name"});

$family->add_member(-name => purchase,
-label => Purchase,
-database => finder,
-table => purchase,
-id_field => pur_id,
-query => {-select => {id => pur_id,
label => "concat(
cust_name,
- ,
date_format(date, %M %D, %Y)
)"},
-from => [purchase,
customer],
-where => customer.cust_id=purchase.cust_id,
-order_by => [date desc,
cust_name]});

$family->add_lineage(-parent_name => customer,
-parent_field => cust_id,
-child_name => purchase,
-child_field => cust_id);

$family->add_rivalry(-brother_name => customer,
-brother_field => cust_id,
-sister_name => account,
-sister_field => cust_id);

$family->set_chosen(-label => Customer,
-ids => 2,4);

$available = $family->get_available(-label => Purchase);

print "Found $available->{count} Purchases:n";

foreach $id (@{$available->{ids_array}}) {

print "Id: $id Label: $available->{labels_hash}->{$id}n";

}

$family->add_value(-name => Cust. Account,
-sql => "concat(cust_name, - ,balance)",
-member_names => customer,account);

$family->add_value(-name => Paid,
-sql => "if(balance > 0,NO,YES)",
-member_names => account);

$family->add_value(-name => Customer,
-sql => cust_name,
-member_names => customer);

$family->add_value(-name => Purchase,
-sql => "concat(
cust_name,
- ,
date_format(date, %M %D, %Y)
)",
-member_names => purchase,customer);

$reunion = $family->get_reunion(-data => Paid,Purchase,
-use_labels => Customer,
-order_by => Customer,Purchase);

$matrix = $abstract->select_matrix(-query => $reunion);

print "Found " . scalar @$matrix . " Values:n";

foreach $row (@$matrix) {

print "Customer: $row->{Customer}n";
print "Purchase: $row->{Purchase}n";
print "Paid: $row->{Paid}nn";

}

$dbh->disconnect();

Remote MySQL Query is a PHP class that can easily execute queries on a remote MySQL server using only HTTP.

It works by accessing a PHP script on the remote web server that executes queries based on passed in URL parameters.

The client passes a secret key to the remote script to prevent unauthorized access.

The remote script passes back the results to the requesting client using XML to marshal the data.

The class parses the results XML data returned by the server script and returns an array.

It, also, retrieves (into class variables) the number of records returned by the query and the time the query took to execute.

The server script may be used to execute MySQL queries that can be retrieved by programs written in other languages besides PHP.

E*Reminders is a series of PHP scripts that interact with a MySQL database to setup email reminders for any events or occasions youd like.
It includes recurring reminders, advance notices, and password authentication for email addresses. It can be used for an entire company, as a service for Internet users on your site, or privately.
Enhancements:
- Ive merged david roses release with the last main release of EReminders.
- EReminders now supports htaccess user authentication and all remaining timezone logic is redone and now makes more sense.
- Also, some minor changes along the way.

Konverter is an easy to use but powerfull KDE video conversion tool. Konverter helps to convert almost every videofile into the most common different videoformats and codecs.

Beside converting, Konverter is also able to scale/crop your videos, change codec details or just changes the audio format of your file.

Also other features like splitting and concat videos, integrated realtime preview are included.

Practical Query Analyzer produces HTML reports on the most frequent queries, slowest queries, queries by type (select/insert/update/delete), and more for both PostgreSQL and MySQL log files.

Jmatrix project generates the Matrix the movie eye candy thingy.

jmatrix is a cute little non-ncurses green letter matrix-the-movie eye candy thingy.

It has about 20 things that you can configure to create your own matrix experience.

It is not just like the movie, though it could be fooled into being that way.

This project was inspired by Cmatrix (which you can also locate on freashmeat). My computer was just plain too slow to run the ncurses implementation of the matrix green letter thing.

Now... I went to see the movie again, and mine isnt very movie-correct. Neither is Cmatrix. They are both cool though.

In the movie, the letters dont scroll anywhere. They get poped in after a white & goes by... then they fade out. Dull eh?

Jmatrix has some pull_down() effects... and the white heads have a creap_back() method that creates some interesting effects.

Jmatrix is also very configurable. You can change almost everything.

morigin email classifier is a filter that classifies and tags email messages based on the DNS information of the system submitting the mail to your organization.

morigin email classifier can then be used to improve upon existing spam filters such as SpamAssassin.