Sql Select Distinct
logindpostgres is a script that reads SQL select statements from PostgreSQL logs and generates all the indices to optimize the database for each request. logindpostgres has been tested on 1.2 GB of logs.. Get Postgres 8.1 Intelligent Index generator at SourceForge.net. Fast, secure and free...
|License: Freeware||Size: 8.19 KB||Download (72): logindpostgres 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...
|License: Freeware||Size: 57.34 KB||Download (72): SQL::Interpolate Download|
SQL SELECT, INSERT, UPDATE and DELETE queries can be generated with the specified table name, arrays of fields and corresponding values and the additional clauses.
|License: Freeware||Size: 10 KB||Download (18): SQL String Generator Download|
SQL SELECT queries can be executed and the fields of each result set row can be retrieved into class variables.Object based MySQL can also insert or update records of a table getting the values from class variables with the same name as the fields.
|License: Freeware||Size: 10 KB||Download (19): Object based MySQL Download|
Oh!DB Table Data Gateway can perform the following operations:- Execute SQL SELECT queries from list of fields of a table- Retrieve the highest or the lowest value from an integer primary key table field- Get or delete one record of a table with a given primary key value- Delete all records of a...
|License: Freeware||Size: 10 KB||Download (18): Oh!DB Table Data Gateway Download|
sql4array can execute SQL SELECT queries on bi-dimensional array, for which the first dimension is the row number and the second dimension the field names.The WHERE clause can be used to specify conditions with operators such as =, >,The results are returned as arrays and can be sorted with the...
|License: Freeware||Size: 10 KB||Download (18): sql4array Download|
SQL SELECT queries can be executed to retrieve values of individual rows with a specified primary key value into an array.DELETE queries can be executed to remove rows with a given primary key value.
|License: Freeware||Size: 10 KB||Download (18): MySQL object approach Download|
Easy Connect to MySQL is a very simple class that can be used to connect to a MySQL database and execute a SQL SELECT query.It consists of a single function that does everything at once: connects to a given MySQL database, executes a given SELECT query and returns the query results in a...
|License: Freeware||Size: 10 KB||Download (18): Easy Connect to MySQL Download|
sql_query_generator will generate a large range of SQL SELECT queries from a submitted form.It provides facilites for simple queries on one field on a table, joins, selection of fields to be returned, aliasing of fields (eg. SUM(Price) AS Total), ORDER BY, even multiple queries from one...
|License: Freeware||Size: 10 KB||Download (20): sql_query_generator Download|
Apache SQL analyser can query Apache logfiles via SQL. asql is a simple console shell which allows you to run SQL queries against an Apache logfile, something that can be very useful - especially at getting information which is not easily available via static logfile analysers. An overview of...
|License: Freeware||Size: 10.24 KB||Download (18): Apache SQL analyser 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...
|License: Freeware||Size: 14.34 KB||Download (81): SQL::Abstract::Limit Download|
SQLizer is a Java utility library intended for generating sql from the search input. Synopsis: import stanford.netdb.utils.*; String sql_1 = Feild2SQL.parseField(type,table, column, input_str, field_display_name, post_filter); String sql_2 = Feild2SQL.parseStringField(table, column,...
|License: Freeware||Size: 6.14 KB||Download (75): SQLizer Download|
DBIx::HTML::ClientDB is a Perl module to convert sql into a client-side db with keyed access. Synopsis use DBIx::HTML::ClientDB; my($object) = DBIx::HTML::ClientDB -> new ( dbh => $dbh, row_headings => Unit code,Unit code,Campus name,Unit name, sql => select unit_code, unit_code,...
|License: Freeware||Size: 11.26 KB||Download (70): DBIx::HTML::ClientDB Download|
Query constructor is a handy, simple, easy to use application specially designed to offer you a structured visual SQL text constructor. Help manage and edit text in standard SQL (SELECT queries only).
|License: Freeware||Download (27): Query constructor Download|
The base calls establishes MySQL database connections, sanitizes values used in SQL queries, executes SQL queries, retrieves SELECT query results into arrays and retrieves the last inserted identifier.There is also a sub-class that can retrieve the list of fields of a table, compose and execute...
|License: Freeware||Size: 10 KB||Download (18): MySQL DB Class and Data Manipulation Class Download|
Search Query Generator for MySQL Database is a very simple class that can be used to build a SQL WHERE clause for performing a query that search for given field values.Search Query Generator for MySQL Database takes as parameter an associative array with the field names as indexes and the field...
|License: Freeware||Size: 10 KB||Download (18): Search Query Generator for MySQL Database Download|
Simple MySQL dump can be used to dump a MySQL database as a list of SQL statements. It can retrieve the database tables metadata and execute and SQL SELECT query to retrieve all the data of the tables to be dumped.Simple MySQL dump returns a string with the table creation and record insertion...
|License: Freeware||Size: 10 KB||Download (18): Simple MySQL dump Download|
DBIx::XMLMessage is a Perl module for XML Message exchange between DBI data sources. The package maintains simple XML templates that describe object structure. The package is capable of generating SQL statements based on these templates and executing them against DBI data sources. After...
|License: Freeware||Size: 25.6 KB||Download (70): DBIx::XMLMessage Download|
This script implements the three standard relational join algorithms: nested loops join, hash join, and merge join, using the iterator algebra support in Python.This script also presents code that can be used for inner join, left outer join, full outer join, and semijoins. The nested loops join...
Platforms: Windows, Mac, *nix, Python, BSD Solaris
|License: Freeware||Download (28): Relational Join Algorithms Download|
This class Small MySQL Connection is a very simple wrapper to access a MySQL database.Functions of Small MySQL Connection:- Establish database connections- Execute manipulation queries and return the number of affected table rows- Execute an SQL SELECT queries and return the result set data in a...
|License: Freeware||Size: 10 KB||Download (20): Small MySQL Connection Download|