implementations of sql
Sponsored Links
Sponsored Links
Secleted [ 0 ] software to compare
Results 1 - 15 of about 2645
Fast MD5 Implementation in Java 2.6.1
Fast MD5 Implementation in Java is a heavily optimized implementation of the MD5 hashing algorithm written in Java. more>>
Fast MD5 Implementation in Java is a heavily optimized implementation of the MD5 hashing algorithm written in Java.
Fast MD5 Implementation in Java includes an optional native method for even greater speed improvements.
How Fast Is It?
Short answer:Much faster than any other Java implementation that I have tested and (surprisingly) even faster than the native, non-Java MD5 implementation on some systems.
Long answer:First of all, it is important to note that the term "fast" is used here in relative terms. The implementation of the MD5 message digest algorithm available on this page is written in Java and is fast compared with other implementations written in Java, both because it is heavily optimized by itself and because there is an optional native method that makes it even faster when the platform supports it. How it compares to a sensible implementation written in a language, such as C, that is compiled directly to machine code, is heavily dependent upon how good of a job the JIT compiler in your JVM does in compiling the code or whether you are able to use the optional native method.
Enhancements:
- Martin West contributed a bug fix and some code refactoring to make all targets work out of the box in the Ant build file. Previously, the "dist" target did not work if the "docs" directory was not present.
<<lessFast MD5 Implementation in Java includes an optional native method for even greater speed improvements.
How Fast Is It?
Short answer:Much faster than any other Java implementation that I have tested and (surprisingly) even faster than the native, non-Java MD5 implementation on some systems.
Long answer:First of all, it is important to note that the term "fast" is used here in relative terms. The implementation of the MD5 message digest algorithm available on this page is written in Java and is fast compared with other implementations written in Java, both because it is heavily optimized by itself and because there is an optional native method that makes it even faster when the platform supports it. How it compares to a sensible implementation written in a language, such as C, that is compiled directly to machine code, is heavily dependent upon how good of a job the JIT compiler in your JVM does in compiling the code or whether you are able to use the optional native method.
Enhancements:
- Martin West contributed a bug fix and some code refactoring to make all targets work out of the box in the Ant build file. Previously, the "dist" target did not work if the "docs" directory was not present.
Download (0.073MB)
Added: 2006-03-06 License: LGPL (GNU Lesser General Public License) Price:
1350 downloads
Procinfo NG 1.0 (Perl Implementation)
Procinfo NG is a ground-up rewrite of the procinfo program. more>>
Procinfo NG is a ground-up rewrite of the procinfo program. The projects goal is to make the code more readable (and reusable) and to restore broken functionality of the original program The original program was written for Linux 1.0, and updated through 2.2. This version is for 2.6.
Enhancements:
- This script emulates procinfo -DSn2, but only takes one parameter, namely the -i option with a number of seconds.
<<lessEnhancements:
- This script emulates procinfo -DSn2, but only takes one parameter, namely the -i option with a number of seconds.
Download (0.010MB)
Added: 2007-05-10 License: GPL (GNU General Public License) Price:
897 downloads
Dimedis::Sql 0.44
Dimedis::Sql is a SQL/DBI Interface for banking applications. more>>
Dimedis::Sql is a SQL/DBI Interface for banking applications.
SYNOPSIS
use Dimedis::Sql;
my $sqlh = new Dimedis::Sql ( ... );
$sqlh->install ( ... );
my $seq_id = $sqlh->insert ( ... );
my $modified = $sqlh->update ( ... );
my $blob_sref = $sqlh->blob_read ( ... );
$sqlh->use_db ( ...)
my $db_prefix = $sqlh->db_prefix ( ...)
my $modified = $sqlh->do ( ... );
my $href = $sqlh->get ( ... );
my @row = $sqlh->get ( ... );
my ($from, $where) = $sqlh->outer_join ( ... );
my $cond = $sqlh->cmpi ( ... );
my $where = $sqlh->contains ( ... );
my $feature_href = $sqlh->get_features;
<<lessSYNOPSIS
use Dimedis::Sql;
my $sqlh = new Dimedis::Sql ( ... );
$sqlh->install ( ... );
my $seq_id = $sqlh->insert ( ... );
my $modified = $sqlh->update ( ... );
my $blob_sref = $sqlh->blob_read ( ... );
$sqlh->use_db ( ...)
my $db_prefix = $sqlh->db_prefix ( ...)
my $modified = $sqlh->do ( ... );
my $href = $sqlh->get ( ... );
my @row = $sqlh->get ( ... );
my ($from, $where) = $sqlh->outer_join ( ... );
my $cond = $sqlh->cmpi ( ... );
my $where = $sqlh->contains ( ... );
my $feature_href = $sqlh->get_features;
Download (0.057MB)
Added: 2007-07-11 License: Perl Artistic License Price:
837 downloads
ZZEE Active SQL Backup 0.9.2
ZZEE Active SQL Backup can perform *incremental* backup of MySQL database. more>>
Since MySQL is the most popular SQL server that is used in conjunction with web sites, there was a need for incremental backup utility. ZZEE Active SQL Backup is designed for clients of web hosting companies, and can be useful to system administrators as well.
Main features:
- Can perform *incremental* backup of MySQL database
- Can perform full backup of MySQL database
- Can replicate database
- Can process SQL queries
- Can dump database structure
- Can suggest database changes needed to process incremental backup
- Can send data backed up by email
- Can transfer backed up data by FTP to other computer (if Net::FTP is installed)
- Can compress backed up data
Usage synopsis
Active SQL Backup can do incremental or full backups of MySQL database as often as needed. It is suitable both for the clients of web hosting companies who can not get access to MySQL update logs and for the host administrators. Backup syntax is:
shell> ./zmdb.pl -b
It stores backup files in BACKUP_DIR, specified in user_settings.txt, named like YYYY_MM_DD_hh_mm_ss.sql[.gz]. The backup files consist of series of SQL INSERT statements and may contain DELETE statements. The database scheme is stored in file database_name.create.sql. If gzip is available, then Active SQL Backup automatically uses it to compress stored data. The program can automatically send backed up files by email or upload to the other computer by FTP.
If the system fails, Active SQL Backup can restore the database. Restore syntax for incremental backups is:
shell> ./zmdb.pl -r
If you make full backups, restore syntax is the following:
shell> ./zmdb.pl -e < BACKUP_DIR/database_name.create.sql
shell> ./zmdb.pl -e < BACKUP_DIR/YYYY_MM_DD_hh_mm_ss.sql &
The first line is needed to restore database structure, and the second is the *most recent* data file. You may need to "gunzip" it before supplying to restore.
You can use the program to dump database structure
shell> ./zmdb.pl -s > structure_dump_file
or to process queries. The latter feature is useful if you need to process queries regularly, for example, to update membership status of the users of your online service. The syntax to execute SQL queries is:
shell> ./zmdb.pl -e < some_sql_file
Where format of some_sql_file is the same as with Mysql utility: SQL statements are separated by semicolon. Note that if you pass SELECT queries to Active SQL Backup, then no result will be returned.
Syntax summary is:
zmdb.pl [SINGLE_OPTION]
-a --advice suggest database modifications and tables_config.txt
-b --backup backup database structure and data
-e --execute execute SQL queries [from STDIN]
-h --help print this screen
-r --restore restore database structure and data
-s --structure dump database structure [to STDOUT]
<<lessMain features:
- Can perform *incremental* backup of MySQL database
- Can perform full backup of MySQL database
- Can replicate database
- Can process SQL queries
- Can dump database structure
- Can suggest database changes needed to process incremental backup
- Can send data backed up by email
- Can transfer backed up data by FTP to other computer (if Net::FTP is installed)
- Can compress backed up data
Usage synopsis
Active SQL Backup can do incremental or full backups of MySQL database as often as needed. It is suitable both for the clients of web hosting companies who can not get access to MySQL update logs and for the host administrators. Backup syntax is:
shell> ./zmdb.pl -b
It stores backup files in BACKUP_DIR, specified in user_settings.txt, named like YYYY_MM_DD_hh_mm_ss.sql[.gz]. The backup files consist of series of SQL INSERT statements and may contain DELETE statements. The database scheme is stored in file database_name.create.sql. If gzip is available, then Active SQL Backup automatically uses it to compress stored data. The program can automatically send backed up files by email or upload to the other computer by FTP.
If the system fails, Active SQL Backup can restore the database. Restore syntax for incremental backups is:
shell> ./zmdb.pl -r
If you make full backups, restore syntax is the following:
shell> ./zmdb.pl -e < BACKUP_DIR/database_name.create.sql
shell> ./zmdb.pl -e < BACKUP_DIR/YYYY_MM_DD_hh_mm_ss.sql &
The first line is needed to restore database structure, and the second is the *most recent* data file. You may need to "gunzip" it before supplying to restore.
You can use the program to dump database structure
shell> ./zmdb.pl -s > structure_dump_file
or to process queries. The latter feature is useful if you need to process queries regularly, for example, to update membership status of the users of your online service. The syntax to execute SQL queries is:
shell> ./zmdb.pl -e < some_sql_file
Where format of some_sql_file is the same as with Mysql utility: SQL statements are separated by semicolon. Note that if you pass SELECT queries to Active SQL Backup, then no result will be returned.
Syntax summary is:
zmdb.pl [SINGLE_OPTION]
-a --advice suggest database modifications and tables_config.txt
-b --backup backup database structure and data
-e --execute execute SQL queries [from STDIN]
-h --help print this screen
-r --restore restore database structure and data
-s --structure dump database structure [to STDOUT]
Download (0.027MB)
Added: 2006-03-08 License: Other/Proprietary License Price:
1325 downloads
Chemistry::SQL 0.01
Chemistry::SQL is an access database functions module. more>>
Chemistry::SQL is an access database functions module.
SYNOPSIS
use strict;
use Chemistry::SQL;
use Chemistry::Artificial::SQL;
my $db_name = $ARGV[0];
my $file = $ARGV[1];
my $db1 = Chemistry::SQL::new(db_host=>"127.0.0.1",db_user=>"root",db_port=>"3306",db_pwd=>"",
db_name=>$db_name,db_driver=>"mysql");
if ($db1->db_exist)
{ $db1->connect_db;
$db1->del_tables;
$db1->create_tables_mysql;
$db1->inscomp_from_file("$file");
}
else
{
$db1->create_db;
$db1->connect_db;
$db1->create_tables_mysql;
$db1->inscomp_from_file("$file");
}
# Reaction Insertion
my $qart = Chemistry::Artificial::SQL::new($db1);
my $qr =$qart->q_reaccion(C=CC=C.C=C>>C1=CCCCC1,smiles);
$db1->reactionsert($qr,"","0");
This package provides the necessary functions to interact with the database. The methods implemented in this module are oriented to give users control of the database without knowing how to use SQL queries.
<<lessSYNOPSIS
use strict;
use Chemistry::SQL;
use Chemistry::Artificial::SQL;
my $db_name = $ARGV[0];
my $file = $ARGV[1];
my $db1 = Chemistry::SQL::new(db_host=>"127.0.0.1",db_user=>"root",db_port=>"3306",db_pwd=>"",
db_name=>$db_name,db_driver=>"mysql");
if ($db1->db_exist)
{ $db1->connect_db;
$db1->del_tables;
$db1->create_tables_mysql;
$db1->inscomp_from_file("$file");
}
else
{
$db1->create_db;
$db1->connect_db;
$db1->create_tables_mysql;
$db1->inscomp_from_file("$file");
}
# Reaction Insertion
my $qart = Chemistry::Artificial::SQL::new($db1);
my $qr =$qart->q_reaccion(C=CC=C.C=C>>C1=CCCCC1,smiles);
$db1->reactionsert($qr,"","0");
This package provides the necessary functions to interact with the database. The methods implemented in this module are oriented to give users control of the database without knowing how to use SQL queries.
Download (0.014MB)
Added: 2006-07-31 License: Perl Artistic License Price:
1185 downloads
Metafox 0.8.12
Metafox is an enterprise Content Management System which uses a special template system. more>>
Metafox project is an enterprise Content Management System which uses a special template system. With that template system, you can easily create any Web site with a particular design and code characteristics.
All content data are stored in a relational SQL database, and administration via the Web interface is easy, fast, and effective.
Enhancements:
- Newsletter and poll implementations were added.
- Server-side image resizing was implemented.
- Support for serving content through custom templates, such as RSS2, was added.
- Content inclusion from one article to another article was added.
- The administration interface was improved by splitting content to static pages and dynamic articles.
- This version works better with new versions of MySQL (such as 5.0), and has better support for the UTF-8 encoding.
- Long links submitted to the discussions are truncated.
- Several bugfixes and tiny improvements were made.
<<lessAll content data are stored in a relational SQL database, and administration via the Web interface is easy, fast, and effective.
Enhancements:
- Newsletter and poll implementations were added.
- Server-side image resizing was implemented.
- Support for serving content through custom templates, such as RSS2, was added.
- Content inclusion from one article to another article was added.
- The administration interface was improved by splitting content to static pages and dynamic articles.
- This version works better with new versions of MySQL (such as 5.0), and has better support for the UTF-8 encoding.
- Long links submitted to the discussions are truncated.
- Several bugfixes and tiny improvements were made.
Download (0.043MB)
Added: 2006-09-27 License: GPL (GNU General Public License) Price:
1124 downloads
libstratanetsh 2.3.0
libstratanetsh is used in development of applications which require direct communication with a Foxmoxie Networks STRATA routers more>>
libstratanetsh project provides source-code to a library (formerly called libnetshclient) for use in the development of applications which require direct communication (using the netsh protocol) with a Foxmoxie Networks STRATA-family router, or any STRATA protocol-capable implementation.
This library may be used to develop client or server implementations, and has also been used for purposes ranging from file transfer to voice applications.
Enhancements:
- TLS implementation optimized, updated API, server-operation support, bugfixes
<<lessThis library may be used to develop client or server implementations, and has also been used for purposes ranging from file transfer to voice applications.
Enhancements:
- TLS implementation optimized, updated API, server-operation support, bugfixes
Download (0.015MB)
Added: 2007-06-07 License: GPL (GNU General Public License) Price:
869 downloads
Gladius DB 0.7.0
Gladius DB is a fast and efficient PHP flatfile database engine written in pure PHP. more>>
Gladius DB is a fast and efficient PHP flatfile database engine written in pure PHP; its SQL syntax is compatible with a subset of intermediate SQL92.
You will not need any specific extension to have it work, and it is bundled with an adoDB lite driver.
This project is licensed under the GNU General Public License, be sure to have read and understood it before using Gladius in your own software.
SQL Conformance
The formal name of the SQL standard is ISO/IEC 9075 "Database Language SQL". The version this document refers to is ISO/IEC 9075:2003, or simply SQL:2003. The versions prior to that were SQL:1999 and SQL-92. Each version supersedes the previous one, so claims of conformance to earlier versions have no official standing.
Starting with SQL:1999, the SQL standard defines a large set of individual features rather than the three levels (Entry, Intermediate and Full) declared in SQL-92. A large subset of these features represents the "Core" (mandatory) features, SQL implementation must supply in order to claim conformance. The rest of the features are purely optional.
In the following sections, we provide a list of all SQL:2003 features with an indication of whether it is supported by Gladius DB; every feature consists of an unique identifier and a name. Feature identifiers containing a hyphen are subfeatures. If a particular subfeature is not supported, the main feature is listed as partly supported. Comments are provided where necessary.
Version restrictions:
- performance slowdown with a huge number of records
- no storage gain for binary fields (for example, numbers)
- non-validating SQL parser (an SQL query that works with Gladius may not be syntactically correct)
- all strings are considered binary and should always be Unicode safe
- no specific collation or character set support
- cannot SELECT calculated or immediate values
- CHAR VARYING, DOUBLE PRECISION and INTERVAL data types (specified in the SQL92 standard) are not recognized
- no specific date/time functions (as of Gladius DB v0.6.2)
<<lessYou will not need any specific extension to have it work, and it is bundled with an adoDB lite driver.
This project is licensed under the GNU General Public License, be sure to have read and understood it before using Gladius in your own software.
SQL Conformance
The formal name of the SQL standard is ISO/IEC 9075 "Database Language SQL". The version this document refers to is ISO/IEC 9075:2003, or simply SQL:2003. The versions prior to that were SQL:1999 and SQL-92. Each version supersedes the previous one, so claims of conformance to earlier versions have no official standing.
Starting with SQL:1999, the SQL standard defines a large set of individual features rather than the three levels (Entry, Intermediate and Full) declared in SQL-92. A large subset of these features represents the "Core" (mandatory) features, SQL implementation must supply in order to claim conformance. The rest of the features are purely optional.
In the following sections, we provide a list of all SQL:2003 features with an indication of whether it is supported by Gladius DB; every feature consists of an unique identifier and a name. Feature identifiers containing a hyphen are subfeatures. If a particular subfeature is not supported, the main feature is listed as partly supported. Comments are provided where necessary.
Version restrictions:
- performance slowdown with a huge number of records
- no storage gain for binary fields (for example, numbers)
- non-validating SQL parser (an SQL query that works with Gladius may not be syntactically correct)
- all strings are considered binary and should always be Unicode safe
- no specific collation or character set support
- cannot SELECT calculated or immediate values
- CHAR VARYING, DOUBLE PRECISION and INTERVAL data types (specified in the SQL92 standard) are not recognized
- no specific date/time functions (as of Gladius DB v0.6.2)
Download (0.056MB)
Added: 2007-07-16 License: GPL (GNU General Public License) Price:
516 downloads
Anemon Dhcp Server 0.1a
Anemon Dhcp Servers goal is to create an implementation of the DHCP protocol under GPL. more>>
Anemon Dhcp Servers goal is to create an implementation of the DHCP protocol under GPL and a lot of stuff around to facilitate network management.
The python sqlobject modules gives anemon the ability to use many database as backend (mysql, postgresql, mssql, sqllite, sybase, etc..)
The project is subdivised (at the moment) in 4 components :
- The Anemon Dhcp Server is a Python/SQL implementation of the DHCP server protocol
- The Anemon Web Center is a web management interface to Anemon Dhcp Server and MyDNS
- The Anemon Dhcp Client will be a Python implementation of the DHCP client protocol
- The Anemon Dhcp relay will be a Python implementation of the DHCP relay protocol
<<lessThe python sqlobject modules gives anemon the ability to use many database as backend (mysql, postgresql, mssql, sqllite, sybase, etc..)
The project is subdivised (at the moment) in 4 components :
- The Anemon Dhcp Server is a Python/SQL implementation of the DHCP server protocol
- The Anemon Web Center is a web management interface to Anemon Dhcp Server and MyDNS
- The Anemon Dhcp Client will be a Python implementation of the DHCP client protocol
- The Anemon Dhcp relay will be a Python implementation of the DHCP relay protocol
Download (0.023MB)
Added: 2006-05-11 License: GPL (GNU General Public License) Price:
1263 downloads
Mono SQL Sharp for GTK Sharp 0.2
Mono SQL Sharp for GTK# is a GUI client for entering and running SQL commands and scripts. more>>
Mono SQL Sharp for GTK# is a GUI client for entering and running SQL commands and scripts. Database objects, such as, tables and table columns can be browsed.
Mono SQL Sharp for GTK Sharp is built for Mono 1.1.7 and GTK# 1.9.3 or higher. It works on Linux and Windows 2000/XP. It has support for various databases via Monos ADO.NET implementation and data providers.
Providers supported:
- Npgsql for PostgreSQL
- ByteFX.Data.MySqLClient for MySQL
- FirebirdSql.Data.Firebird for Firebird
- System.Data.SqlClient for Microsoft SQL Server 7.0/2000/2005
- System.Data.OracleClient for Oracle 8i, 9i, and 10g
- Mono.Data.SybaseClient for Sybase 12.x
- Mono.Data.SqliteClient for SQL Lite
- System.Data.Odbc for ODBC
- And whatever provider you add to the xml configuration settings file sqlsharpgtk.exe.config
Results can be shown in a grid or a text log. Files can be loaded into the SQL text editor or saved.
Mono SQL# for GTK# has a command-line version, sqlsharp.exe, which is included with Mono. Mono SQL# for GTK# is a separate project for the GTK# GUI version.
<<lessMono SQL Sharp for GTK Sharp is built for Mono 1.1.7 and GTK# 1.9.3 or higher. It works on Linux and Windows 2000/XP. It has support for various databases via Monos ADO.NET implementation and data providers.
Providers supported:
- Npgsql for PostgreSQL
- ByteFX.Data.MySqLClient for MySQL
- FirebirdSql.Data.Firebird for Firebird
- System.Data.SqlClient for Microsoft SQL Server 7.0/2000/2005
- System.Data.OracleClient for Oracle 8i, 9i, and 10g
- Mono.Data.SybaseClient for Sybase 12.x
- Mono.Data.SqliteClient for SQL Lite
- System.Data.Odbc for ODBC
- And whatever provider you add to the xml configuration settings file sqlsharpgtk.exe.config
Results can be shown in a grid or a text log. Files can be loaded into the SQL text editor or saved.
Mono SQL# for GTK# has a command-line version, sqlsharp.exe, which is included with Mono. Mono SQL# for GTK# is a separate project for the GTK# GUI version.
Download (0.67MB)
Added: 2005-08-08 License: GPL (GNU General Public License) Price:
1541 downloads
SQL::Statement::Embed 1.15
SQL::Statement::Embed can embed a SQL engine in a DBD or module. more>>
SQL::Statement::Embed can embed a SQL engine in a DBD or module.
SQL::Statement is designed to be easy to embed in other modules and to be especially easy to embed in DBI drivers. It provides a SQL Engine and the other module needs to then provide a data source and a storage mechanism. For example, the DBD::CSV module uses SQL::Statement as an embedded SQL engine by implementing a file-based data source and by using DBI as the user interface. Similarly DBD::Amazon uses SQL::Statement as its SQL engine, provides its own extensions to the supported SQL syntax, and uses on-the-fly searches of Amazon.com as its data source.
SQL::Statement is the basis for eight existing DBDs (DBI database drivers). If you have a new data source, you too can create a DBD without having to reinvent the SQL wheel. Its fun, its easy, become a DBD author today!
SQL::Statement can be also be embedded without DBI. Well explore that first since developing a DBD uses most of the same methods and techniques.
The role of SQL::Statement subclasses
SQL::Statement provides a SQL parsing and execution engine. It does not provide a data source or storage mechanism other than in-memory tables. The DBD::File module is a subclass of SQL::Statement that provides access to file-based storage mechanisms. Its quite possible to use things other than files as data souces, in which case we wouldnt use DBD::File, instead wed replace DBD::Files methods with our own. In the examples below, well use DBD::File, replacing only a few methods.
SQL::Statement provides SQL parsing and evaluation and DBD::File provides file-based storage. The only thing missing is a data source - what we actually want to store and query. As an example suppose we are going to create a subclass called Foo that will provide as a data source a simple file similar to a passwd file - one record per line, fields separated by colons, with only three fields "username, uid, gid".
Consider what needs to happen to perform a SELECT query on our Foo data:
* recieve a SQL string
* parse the SQL string into a request structure
* open the table(s) specified in the request
* define column names and postions for the table
* read rows from the table
* convert the rows from colon-separated format into perl arrays
* match the columns and rows against the requested selection criteria
* return requested rows and columns to the user
To perform operations like INSERT and DELETE, we also need to:
* convert rows from perl arrays into colon-separated format
* write rows
* delete rows
SQL::Statement takes care of all of the SQL parsing and evaluation. DBD::File takes care of file opening, reading, writing, and deleting. So the only things Foo is really responsible for are:
* define column names and postions for the table
* convert rows from colon-separated format into perl arrays
* convert rows from perl arrays into colon-separated format
In SQL::Statement subclasses these responsibilities are assigned to two objects, a ::Statement object is responsible for opening the table, defining the column names and positions, and for creating new ::Table objects. A ::Table object is responsible for reading, converting, writing, and deleting data.
<<lessSQL::Statement is designed to be easy to embed in other modules and to be especially easy to embed in DBI drivers. It provides a SQL Engine and the other module needs to then provide a data source and a storage mechanism. For example, the DBD::CSV module uses SQL::Statement as an embedded SQL engine by implementing a file-based data source and by using DBI as the user interface. Similarly DBD::Amazon uses SQL::Statement as its SQL engine, provides its own extensions to the supported SQL syntax, and uses on-the-fly searches of Amazon.com as its data source.
SQL::Statement is the basis for eight existing DBDs (DBI database drivers). If you have a new data source, you too can create a DBD without having to reinvent the SQL wheel. Its fun, its easy, become a DBD author today!
SQL::Statement can be also be embedded without DBI. Well explore that first since developing a DBD uses most of the same methods and techniques.
The role of SQL::Statement subclasses
SQL::Statement provides a SQL parsing and execution engine. It does not provide a data source or storage mechanism other than in-memory tables. The DBD::File module is a subclass of SQL::Statement that provides access to file-based storage mechanisms. Its quite possible to use things other than files as data souces, in which case we wouldnt use DBD::File, instead wed replace DBD::Files methods with our own. In the examples below, well use DBD::File, replacing only a few methods.
SQL::Statement provides SQL parsing and evaluation and DBD::File provides file-based storage. The only thing missing is a data source - what we actually want to store and query. As an example suppose we are going to create a subclass called Foo that will provide as a data source a simple file similar to a passwd file - one record per line, fields separated by colons, with only three fields "username, uid, gid".
Consider what needs to happen to perform a SELECT query on our Foo data:
* recieve a SQL string
* parse the SQL string into a request structure
* open the table(s) specified in the request
* define column names and postions for the table
* read rows from the table
* convert the rows from colon-separated format into perl arrays
* match the columns and rows against the requested selection criteria
* return requested rows and columns to the user
To perform operations like INSERT and DELETE, we also need to:
* convert rows from perl arrays into colon-separated format
* write rows
* delete rows
SQL::Statement takes care of all of the SQL parsing and evaluation. DBD::File takes care of file opening, reading, writing, and deleting. So the only things Foo is really responsible for are:
* define column names and postions for the table
* convert rows from colon-separated format into perl arrays
* convert rows from perl arrays into colon-separated format
In SQL::Statement subclasses these responsibilities are assigned to two objects, a ::Statement object is responsible for opening the table, defining the column names and positions, and for creating new ::Table objects. A ::Table object is responsible for reading, converting, writing, and deleting data.
Download (0.085MB)
Added: 2006-06-13 License: Perl Artistic License Price:
1230 downloads
mssqldump 1.0
mssqldump.php is a PHP script that dumps a Microsoft SQL Server database into a SQL script. more>>
mssqldump.php is a PHP script that dumps a Microsoft SQL Server database into a SQL script. The project can also dump a table into CSV format.
<<less Download (0.003MB)
Added: 2006-12-06 License: GPL (GNU General Public License) Price:
620 downloads
Java embedded SQL(unix) 1.08
Subset of SQL for specifying non-procedural queries for Java objects more>> Subset of SQL for specifying non-procedural queries for Java objects, index access based on T-Tree, parallel excecution of requests
JSQL is subset of SQL languages, which can be used to select objects instances according to selection condition. JSQL can be used for implementing personal minidatabase, as tool for dynamic compilation and execution of user requests. JSQL uses notation more popular for object-oriented programming then for relational database. Table rows are considered as object instances and the table - as class of these objects. Unlike SQL, JSQL is oriented on work with objects instead of SQL tuples. So the result of each query execution is a set of objects of one class. The main differences of JSQL from standard SQL are:
There are no joins of several tables and nested subqueries. Query always returns set of objects from one table.
Standard C types are used for atomic table columns.
There are no NULL values, except null references. I am completely agree with C.J. Date critics of three-value logic and his proposal to use default values instead.
Arrays can be used as record components. Special exists quantor is provided for locating element in arrays.
User methods can be defined for table records (objects) as well as for record components.
References between objects are supported including automatic support of inverse references.
As far as query language is deeply integrated with Java language, case sensitive mode is used for language identifiers as well as for keywords.
No implicit conversion of integer and floating types is done to string representation. If such conversion is need, it should be done explicitly.<<less
Download (166KB)
Added: 2009-04-02 License: Freeware Price: Free
204 downloads
PApp::SQL 1.02
PApp::SQL is an absolutely easy yet fast and powerful sql access. more>>
PApp::SQL is an absolutely easy yet fast and powerful sql access.
SYNOPSIS
use PApp::SQL;
my $st = sql_exec $DBH, "select ... where a = ?", $a;
local $DBH = ;
my $st = sql_exec my($bind_a, $bind_b), "select a,b ...";
my $st = sql_insertid
sql_exec "insert into ... values (?, ?)", $v1, $v2;
my $a = sql_fetch "select a from ...";
sql_fetch my($a, $b), "select a,b ...";
sql_exists "table where name like a%"
or die "a* required but not existent";
my $db = new PApp::SQL::Database "", "DBI:mysql:test", "user", "pass";
local $PApp::SQL::DBH = $db->checked_dbh; # does ping
sql_exec $db->dbh, "select ...";
<<lessSYNOPSIS
use PApp::SQL;
my $st = sql_exec $DBH, "select ... where a = ?", $a;
local $DBH = ;
my $st = sql_exec my($bind_a, $bind_b), "select a,b ...";
my $st = sql_insertid
sql_exec "insert into ... values (?, ?)", $v1, $v2;
my $a = sql_fetch "select a from ...";
sql_fetch my($a, $b), "select a,b ...";
sql_exists "table where name like a%"
or die "a* required but not existent";
my $db = new PApp::SQL::Database "", "DBI:mysql:test", "user", "pass";
local $PApp::SQL::DBH = $db->checked_dbh; # does ping
sql_exec $db->dbh, "select ...";
Download (0.013MB)
Added: 2007-08-16 License: Perl Artistic License Price:
800 downloads
BITE SQL Reports 1.02a
BITE SQL Reports project consists of an advanced SQL reports for existing databases. more>>
BITE SQL Reports project consists of an advanced SQL reports for existing databases.
BITE is SQL reporting software that can be "plugged" into any existing database to add advanced reporting capabilities.
You can build reports and store them in the same database, view, print, save, and FTP these reports to pre-defined places, or distribute the "viewer" software so that others can run the reports that you build.
Enhancements:
- An initial Makefile has been added.
- gcc compile issues have been fixed.
<<lessBITE is SQL reporting software that can be "plugged" into any existing database to add advanced reporting capabilities.
You can build reports and store them in the same database, view, print, save, and FTP these reports to pre-defined places, or distribute the "viewer" software so that others can run the reports that you build.
Enhancements:
- An initial Makefile has been added.
- gcc compile issues have been fixed.
Download (1.9MB)
Added: 2007-01-19 License: LGPL (GNU Lesser General Public License) Price:
1009 downloads
Secleted [ 0 ] software to compare
Copyright Notice:
Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators is illegal and prevent future software development. The above implementations of sql search only lists software in full, demo and trial versions for free download. Download links are directly from our mirror sites or publisher sites, torrent files or links from rapidshare.com, yousendit.com or megaupload.com are not allowed