Free perform sql queries software for linux

SQLitepp is a C/C++/Python wrapper to sqlite library for database management. It implements an object oriented way to manipulate the database in every supported language.

SQLitepp supports selfupdatable queries and a straight SQL code query system without using strange things for querying the database, letting you manipulate it directly in SQL but also exposing simple object oriented methods to manipulate the result of the queries and updating them.

Python EXAMPLE:

db = SQLDatabase("database.db")
q = db.query("Tablename", "SELECT Name,Id FROM %t")
if len(q):
tuple1 = q[0]
tuple1["Name"] = "Foobar"
tuple1.commit()
del db

C++ EXAMPLE:

SQLDatabase db("database.db");
SQLQuery *q = db.query("Tablename", "SELECT Name,Id FROM %t");
if(q->numberOfTuples()) {
SQLRow *tuple1 = q->getRow(0);
tuple1->set("Name", "Foobar");
tuple1->commit();
}
delete q;

C EXAMPLE:

void *db = new_SQLDatabase("database.db");
void *q = SQLDatabase_query(db, "Tablename", "SELECT Name,Id FROM %t");
if(SQLQuery_numberOfTuples(q)) {
void *tuple1 = SQLQuery_getRow(q, 0);
SQLRow_set(tuple1, "Name", "Foobar");
SQLRow_commit(tuple1);
}
delete_SQLQuery(q);
delete_SQLDatabase(db);

PgWorksheet is a simple GUI frontend to PostgreSQL for executing SQL queries and psql commands without using the psql command line tool.

PgWorksheet allow you to execute SQL queries and psql commands against a PostgreSQL database with a GUI. The UI have been designed to be extremly simple and easy to use.

JDBC SQL Profiler is a quickly hacked tool to do statistics on SELECT queries in order to know where it is most efficient to create indexes.

This small tool, released under an Apache-based license connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns and can generate SQL index creation files.

Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect database problems efficiently.

This tool can be very useful when you have a big volume of queries that you need to analyze not one by one (meaning that the specific time isnt that much of interest), but rather when you want to know what "group" of queries is taking a lot of time, such as queries on the same tables and columns but with different query values. The integrated SQL parser (built with ANTLR) is used to analyze the incoming SELECT queries.

The Swing GUI was based on Apaches Log4J Chainsaw, but all the bugs are mine. Also contributors are welcome to test, make new suggestions, give their opinion and submit patches.

Perlbug::Interface::Web is a web interface to perlbug database.

SYNOPSIS

my $o_web = Perlbug::Interface::Web->new;

print $o_web->top;

print $o_web->request(help);

print $o_web->links;

METHODS

new

Create new Perlbug::Interface::Web object.
my $web = Perlbug::Interface::Web->new;

setup

Setup Perlbug::Interface::Web
$o_web->setup($cgi);

check_user

Access authentication via http, we just prime ourselves with data from the db as well.

menus

Return menu of system, designed for vertical format. Wraps logo, title and links

print $o_web->menus();

logo

Return logo of system with href=hard_wired_url

print $o_web->logo();

get_title

Return title of current page

print $o_web->get_title();

summary

Return summary of open/closed bugs

print $o_web->summary();

links

Return links of system, with adminfaq inserted if appropriate, configured links and object search forms.

print $o_web->links();

index

Display the index results here...

get_request

Return the req value for this request

my $req = $self->get_request;

set_command

Set the command type for the rest of the process, based on the input and operation

my $cmd = $o_web->set_command($req);

commands

Return command menu buttons for request given

print $o_web->commands($req);

switch

Return appropriate method call for request(else index), using internal CGI object

my $method = $o_web->switch([$req]); # set $method=($call|index)

start

Return appropriate start header data for web request, includes start table.

print $o_web->start();

form

Return form with appropriate name and target etc.

print $o_web->form(menus);

top

Return consistent top of page.

print $o_web->top($req, $cmd);

request

Handle all web requests (internal print)

$o_web->request($call);

target2file

Return appropriate dir/file.ext for given target string

my $filename = $o_base->target2file(header);

# -> /home/richard/web/header.html

finish

Return appropriate finishing html
Varies with framed, includes table finish

print $o_web->finish($req);

overview

Wrapper for doo method

graph

Display pie or mixed graph for groups of bugs etc., mixed to come.

date

Wrapper for search by date access

create

Wrapper for object creation

$o_web->create($obj, %data);

object_handler

Wrapper for object access: no ids = search form

$o_web->object_handler($me_thod, $oid); # o_cgi comes from the heavens

hist

History mechanism for bugs and users.

Move formatting to Formatter::history !!!

headers

Headers for all objects (message, note, ...) by id

$o_web->headers(patch, $id);

bidmid

Wrapper for bugid and messageid access

spec

Returns specifications for the Perlbug system.

$dynamic =~ s/ />/g;
$dynamic =~ s/b(http:.+?perlbug.cgi)b/$1/gi;
$dynamic =~ s/b([ |&.t;]+@.+?.(?:com|org|net|edu))b/$1/gi;

webhelp

Web based help for perlbug.

print $web->webhelp;

mailhelp

Web based mail help for perlbug.

print $web->mailhelp;

delete

Wrapper for delete access

sql

Open field sql query processor

todo

To do list, may be appended to

adminfaq

adminFAQ

web_query

Form bugid search web query results

# results - dont map to query() unless Base::query modified

search

Construct search form

with chosen params as defaults...

update

For all application objects, wraps to object_handler

$o_web->update(); # args ignored here for passing purposes

current_buttons

Get and set array of relevant buttons by context key

my @buttons = $o_web->current_buttons(search update reset, scalar(@uids), [$colspan]);

case

Handle case sensitivity from web search form.

format_query

Produce SQL query for bug search from cgi query.

Can be optimised somewhat ...

my $query = $web->format_query;

wildcard

Convert * into % for sqlquery

my $string = $self->wildcard(5.*);

tenify

Create range of links to split (by tens or more) bugids from web query result.

$self->tenify(@_bids, bug, 7); # in chunks of 7

htmlSQL is a PHP class to query the web by an SQL like language. htmlSQL is a experimental PHP class which allows you to access HTML values by an SQL like syntax.

This means that you dont have to write complex functions (regular expressions) to extract specific values.

How to use

Just include the "snoopy.class.php" and the "htmlsql.class.php" files into your PHP scripts and look at the examples (examples/) to get an idea of how to use the htmlSQL class. It should be very simple.

Background & Idea

I had this idea while extracting some data from a website. As I realized that the algorithms and functions to extract links and other tags are often the same - I had the idea to combine all functions to an universal usable class. While drinking a coffee and thinking on that problem, I thought it would be cool to access HTML elements by using SQL. So I started creating this class...

Warning!

The eval() function is used for the WHERE statement. Make sure that all user data is checked and filtered against malicious PHP code. Never trust user input!

phpMysqlConnection provides a PHP class for handling MySQL database connections.
phpMysqlConnection is an interface class to be used with the PHP programming language to help projects connect to a MySQL database server and perform queries.
The methods of this class prevent the programmer from having to memorize all the different steps needed to connect to the database, perform a query, and retrieve results.
Enhancements:
- A function to return XML-formatted data record sets from queries has been added.