Free sql query language software for linux

SQL::Routine::Language is a Perl module for what language or grammar SQL::Routine speaks.

SQL::Routine contains SQL schemas and queries, represented as a tree of atomic tokens; it is structurally like an abstract syntax tree or an XML DOM, but one that only accepts, respectively, a specific source language or XML schema. See SQL::Routine for more details.

The modules API and code make it look like a generic tree, composed of related Nodes. The restrictions for which attributes each Node can have, and its relationship to others, is defined by data (though for efficiency, that data is also contained in the same module and cant be changed at runtime).

As an analogy, the module has an API like a generic XML DOM, but it can enforce a specific XML Schema (the data). The context in which it is used is like a generic database interface. The API basically has an "execute" function, to which a SQL string is given, within that, there is a huge amount of flexibility of what the SQL string can say, but it must conform to a specific grammar.

This document, SQL::Routine::Language, is meant to say what all the types of Nodes are, and what attributes and relationships are allowed for each. It is meant to say what grammar for SQL::Routines language is, or what schema it accepts.

The type of information this document would provide is functionally similar to the SQL design documents, or vendor-specific ones.

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.

The Mozilla Afrikaans Language Pack provides translations of the Mozilla suites Web browser, email program, and editor into Afrikaans.

All functions, errors, menus, and buttons are translated into Afrikaans.

SQL::Amazon::UserGuide is a Perl module with user Guide for DBD/SQL::Amazon.

SYNOPSIS

#
# create the parser, passing in the current Amazon metadata
#
my $parser = SQL::Amazon::Parser->new(%attrs);

#
# parse a SQL statement, returning a SQL::Amazon::Statement
#
my $stmt = $parser->parse($sql_stmt)
or die "Parse failed: " . $parser->errstr;
#
# evaluate the parse tree, using an evaluation object
# for driver specific evaluation
# returns either a scalar rowcount for write operations,
# or a SQL::Amazon::Table object for SELECT
# or undef on error
#
my $results = $stmt->execute($params)
or die "Evaluation failed: " . $stmt->errstr;

SQL::Amazon provides the various components required by DBD::Amazon http://www.presicient.com/dbdamzn to query the Amazon E-Commerce Service 4.0 aka ECS using SQL.

Be advised this is ALPHA release software.

The suite includes the following components:

SQL::Amazon::Parser

provides SQL parsing and query plan generation. Implemented as a subclass of SQL::Parser, part of the SQL::Statement bundle.

SQL::Amazon::Statement

provides SQL query plan execution. Implemented as a subclass of SQL::Statement.

SQL::Amazon::Functions

provides SQL::Amazon-specific predicate functions, including MATCHES ANY, MATCHES ALL, MATCHES TEXT, POWER_SEARCH, IN, and NOT IN.

SQL::Amazon::ReqFactory

provides a factory class for generating SQL::Amazon::Request::Request objects based on the predicates in a querys WHERE clause.

SQL::Amazon::Spool

provides a temporary storage object for intermediate results extracted from the base table cache objects. Acts as a SQL::Eval::Table object for SQL::Statement processing.

SQL::Amazon::StorageEngine

provides a global storage engine for managing data caching and retrieval.

SQL::Amazon::Request::Request

provides a base class for all ECS request objects, including numerous default method implementations for building and sending requests, and processing the responses into the base table cache objects.

SQL::Amazon::Request::ItemLookup

a subclass of SQL::Amazon::Request::Request for the ItemLookup request; also acts as a base class for the ItemSearch request.

SQL::Amazon::Request::ItemSearch

a subclass of SQL::Amazon::Request::ItemLookup for the ItemSearch request

SQL::Amazon::Tables::Table

provides a base class for table cache objects, including methods for data type conversion, keyed lookup, and cache management.

SQL::Amazon::Tables::< tablename >

provides table-specific implementations of the Table base class.

Be::Query is a Perl module to do a query for a given filesystem.

SYNOPSIS

use Be::Query;
@files = Be::Query::Query($filesystem, $query);

do a Query for a given filesystem

USAGE

@files = Be::Query::Query("/boot", "name=lib*.so");

$filesystem is a path anywhere in the target filesystem; $query is a query construction, of the form attribute op value [connector attribute op value]

Such as (name = fido) || (size >= 500)

Alinous-Core HTML-SQL language serverIDE is a very easy tool for creating WebDB application. We can create it with almost only SQL & HTML. Java , PHP and other languages are not necessary.

If you know SQL & HTML, you can create it with them and the Alinous-Core. The Alinous-Core is very simple tool, but it has enough functions. It has almost all features we use on WebDB development. For example, form data validation, Basic authentication, RSS, File upload and SMTP.

In addition to those, Alinous-Core supports GUI debugger, so we can develop with watching how it works.