Sql Statement

JoSQL (Java Objects SQL) provides SQL capabilities for querying, ordering and grouping of collections of Java objects (POJOs). It allows a SQL statement to be applied to the collection of objects and the matching set returned, ordered and grouped. Platforms: Windows, Mac, Linux

DBIx::PDlib is a Perl with DBI SQL abstraction and convenience methods. SYNOPSIS use DBIx::PDlib; my $db = DBIx::PDlib->connect({ driver => mydriver, host => myhost.com, dbname => mydb, user => myuser, password => mypassword, }); my ($name) = $db->select(name,table1,"id = 10"); my... Platforms: *nix

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a... Platforms: Windows, Mac, *nix, Python, BSD Solaris

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,... Platforms: *nix

SQLView provides a user friendly interface for browsing a SQL database and modifying SQL tables using a Web browser. This is strictly an application to give users access to view and modify their SQL tables. PHP SQLView is not a tool to help database administrators (other than perhaps getting... Platforms: *nix

Pangolin is an automatic SQL injection penetration testing (Pen-testing) tool for Website manager or IT Security analyst. Its goal is to detect and take advantage of SQL injection vulnerabilities on web applications. Once it detects one or more SQL injections on the target host, the user can... Platforms: Windows

EQB allows users to extract important information such as customer data, sales and virtually any other types of records. The solution does not require any extensive knowledge of SQL syntax and the inner workings of the databases, but it is also very useful for those learning SQL syntax, since you... Platforms: Windows

OleDBCmd allows you to execute SQL commands against an OleDB Database, eg a Microsoft Access database, an Excel spreadsheet, etc. This can be a powerful adjunct to LGX Report (see www.freereporting.com) as it allows database creation to be scripted rather than manually creating a database with... Platforms: Windows

MySqueaks is the short name for My Simplified Quality Expressions (SQX), a simple PHP class that generates SQL statements. This facilitates an easier understanding of the different parts and conditions of a SQL statement, making it more user-friendly for beginner programmers. The use of the... Platforms: Windows, Mac, *nix, PHP, BSD Solaris

sql_Generator class is meant to make it easier to generate SQL queries for inserting or updating records in a database table.Just specify the required fields, and then call the class functions to retrieve the SQL statement to perform an insert or update query. Platforms: PHP

SQLTools is a light weighted and robust tool for database development. It includes a text editor, an sql console and a couple of sql utilities. You can use it for dial-up connection and it will work as fast as SQLPlus. It is small and not required an installation so SQLTools will help you... Platforms: Windows

ODBCView is a free SQL query tool to view and export data from any OBDC compliant database. Connect to an ODBC data source and enter a SQL statement to execute. The data is then displayed on a read-only grid or it can be exported to a external CSV or HTML report file. Any valid SQL statements can... Platforms: Windows

GsqlR2 is a GTK2 interface for Oracle application devlopment / testing. Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, tracing facility, and SQL*Plus-style command scripting. For SQL statement... Platforms: *nix

GTKO is a GTK+ 2 Oracle development tool. Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, tracing facility, and SQL*Plus-style command scripting. For SQL statement analysis and tuning there is a... Platforms: *nix

GTK Oracle is a GTK+ 2 interface to Oracle that aids in Oracle application development and testing. Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting. For SQL... Platforms: *nix

DBD::ODBC Perl module contains a ODBC Driver for DBI. SYNOPSIS use DBI; $dbh = DBI->connect(dbi:ODBC:DSN, user, password); Private DBD::ODBC Attributes odbc_more_results (applies to statement handle only!) Use this attribute to determine if there are more result sets available. SQL... Platforms: *nix

TbsSQL is a PHP class for SQL abstraction. TbsSQLs goal of this tool is to reduce the code when working with SQL through PHP. The TbsSQL is available for the following databases: - MySQL - MySQLi - SQL-Server (via Ms-Odbc) - PostgreSQL (version 7.2 or higher) Example: $id = 29; $name =... Platforms: *nix

PipisCrew.QueryAnalyzerPlus is an easy-to-use application designed to help you manipulate dbase servers. You can connect to Access mdb files / SQL Server / SQLCe sdf files / SQLite db files. Once connected your can type and run SQL statements, when tables loaded into treeview there are various... Platforms: Windows, XP, 2003, Windows Vista, XPX64, 2008, 7, 7x64, 2008x64, 2008R2, 832-bit, 864-bit

FlexTracer is powerful, easy-to-use SQL tracer for Oracle, MS SQL, MySQL, Interbase/Firebird, Advantage Server, ODBC, SQLite, ADO, BDE. You don't need to have administrator privileges on your database server! File and registry operations are supported as well. FlexTracer dumps all executed SQL... Platforms: Windows, XP, Windows Vista, 7

LightProfiler – application for performance analysis of the Oracle databases. It generates detailed resource profile for extended SQL trace files (10046 event), containing information about consuming of response time (by events, by cursors, etc.), data files usage, error analysis (SQL, PL/SQL)... Platforms: Windows, Linux, Unix