Postgres Sql Query

MySQL cache class can be used to cache MySQL query results in session variables. MySQL cache script used in PHP, it is a professional PHP cache script.It can perform a given SELECT SQL query and store the result in a session variable.Next time the same query is executed it can retrieve the...

PHP Oracle Grid aims to display Oracle query results in an HTML table. It can execute a given SQL query and then generate an HTML table in which the query results displayed. The presentation of the table rows is configurable using CSS styles. Headers, odd and even rows can use different CSS...

This class can be used to connect and query Microsoft Access databases from PHP. It takes the path of a Microsoft Access database file and computes suitable a DSN string to establish a connection to the database using ODBC extension on Windows.It can also execute a given SQL query on a connected...


Platforms: PHP

True MySQL class can connect to a specified MySQL host, execute SQL queries and retrieve the results into arrays or objects.Key Features of True MySQL class:- Seek SQL query result sets- Get the number of affected rows and the identifier of the last record inserted by a query- Retrieve the names...


Platforms: PHP

MySQL Paging is a simple class that can return a MySQL database query results for spliting into multiple pages given the maximum number of result rows to present on each page.Usage :- Create a class object with 3 arguments: MySQL SQL query, limit of records per page, MySQL connection handle-...


Platforms: PHP

The query results can be retrieved into arrays with MySQL access class.Key Features of MySQL access class:- Connect to a given MySQL database server host- Execute SQL queries- Execute queries that return the number of rows that a given SQL query would return- List the database tables


Platforms: PHP

Tabela script can be used to show MySQL query results in an HTML table. It can build an SQL query from a list of table fields and executes it.The script creates an HTML table to display the database query results. It also displays links to browse results split in multiple pages, showing up to a...


Platforms: PHP

DbProxy can be used to execute MySQL queries from SQL templates defined in XML files.The script can parse a given XML file that contains definitions of SQL query templates. DbProxy can execute given MySQL queries eventually replacing template parameters with given values.


Platforms: PHP

PhpReportsMSSQL can generate report HTML pages from given SQL database queries. It supports either MySQL and Microsoft SQL server databases.PhpReportsMSSQL takes as parameters the database type, the database access arguments, an SQL query strings, the title of the report page, number of records...


Platforms: PHP

ApexSQL Refactor is a free SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code and database tables with ease. It can format and refactor code directly in SSMS or VS, qualify objects, expand wildcards, encapsulate SQL, locate and highlight unused...


Platforms: Windows 7, Windows Server, Windows

Qvu Data Service is a wysiwyg report design, ad-hoc query and api data service design tool that allows users to create and save query designs in a user-friendly, web-based UI. Qvu Data Service provides REST API endpoints for users and applications to execute saved query documents and return...


Platforms: Windows, Mac, *nix, Windows 8, Windows 7, Windows Server, iOS, Android, ,iPhone,iPad

Cache Monitor is the SQL development tool designed for InterSystems database Cache. It supports developers with features, like: advanced SQL Query Editor with foreign key join suggestion,Cache-SQL Syntax highlighting,SQL Code completion,SQL History buffer for executed SQL commands,SQL Code...


Platforms: Windows

DBIx::DBStag::Cookbook is a Perl module for building and querying databases from XML. SYNOPSIS stag-autoddl.pl stag-storenode.pl selectall_xml.pl This will give an outline of how to build a normalised relational database from XML source data, set up SQL templates, issue relational queries...


Platforms: *nix

DBIx::SQLCrosstab Perl module creates a server-side cross tabulation from a database. SYNOPSIS use DBIx::SQLCrosstab; my $dbh=DBI->connect("dbi:driver:database" "user","password", {RaiseError=>1}) or die "error in connection $DBI::errstrn"; my $params = { dbh => $dbh, op => [ [SUM,...


Platforms: *nix

DBIx::XMLServer is a Perl module to serve data as XML in response to HTTP requests. SYNOPSIS use XML::LibXML; use DBIx::XMLServer; my $xml_server = new DBIx::XMLServer($dbh, "template.xml"); my $doc = $xml_server->process($QUERY_STRING); die "Error: $doc" unless ref $doc; print...


Platforms: *nix

Template::Plugin::JavaSQL is a Perl module to help generate Java from database schemas. SYNOPSES Within an XML file processed by the Java plugin: < sql: query="select foo as f, bar as b from some_table" > or < sql: table="some_table" > Via a template such as: [% USE Java %] [% Use...


Platforms: *nix

Entrance project is a MySQL client. Entrance also provides tools for exchanging data with other applications, like spreadsheets, and tools for exploring data using an innovative technique called "data painting". Shown below is the Entrance main window, with a single MySQL table displayed. On...


Platforms: *nix

Azuki Framework project is a Java application framework designed to resolve various problems in the software development lifecycle. These goals are achieved by splitting the software conception into two main stages: creation of independent components and definition of component dependencies...


Platforms: *nix

dotConnect Express for PostgreSQL is a free of charge data provider built over ADO.NET architecture and a development framework with number of innovative technologies. It offers basic functionality for developing database-related applications and web sites. It introduces new approaches for...


Platforms: Windows

WP MySQL Console (WPMC) is a web based MySQL command shell. WPMC aims to be a web shell has same functionalites of real MySQL Shell. Integrating of WPMC to any web application such as WP is very easy because dont need any firewall construction. Its completly http based. I ported WPMC from...


Platforms: Windows, *nix, Other