Free sql uniform software for linux

SQL Uniform is a database client with a graphical user interface (GUI). The project is a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert), and import.
It supports any kind of database and database servers to which there is an ODBC or JDBC standard driver. It has been tested on the following databases: Access, Adabas D, DaffodilDB, dBASE, Excel, HSQL, IBM DB2, Interbase (Firebird), JDataStore, Linter (Relex), McKOI, Mimer, MSSQL, MySQL, Openlink Virtuoso, Oracle, Paradox, Pervasive (Btrive), Pointbase, PostgreSQL, Quadcap QED, Solid, SQLITE, Sybase, ThinkSQL, and Yard.
Enhancements:
- The data browse, SQL query, table design, administration, export, and SQL import windows are also parts of freeware mode.

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.

SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux.
Main features:
SQL Relay is ideal for:
- speeding up database-driven web-based applications
- enhancing the scalability of database-driven web-based applications
- distributing access to replicated databases
- throttling database access
- accessing databases from unsupported platforms
- migrating applications from one database to another
SQL Relay supports the following database backends:
- Oracle
- MySQL
- mSQL
- PostgreSQL
- Sybase
- MS SQL Server
- IBM DB2
- Interbase
- Sybase
- SQLite
- ODBC
- MS Access
The SQL Relay client APIs support advanced database operations such as bind variables, multi-row fetches, client-side result set caching and suspended transactions. SQL Relay has native client APIs for the following languages:
- C
- C++
- Perl
- Python
- PHP
- Ruby
- Java
- TCL
- Zope
SQL Relay provides drivers for the following database abstraction layers:
- Perl DBD
- Python DB
- Ruby DBD
- PHP Pear DB
An application coded using another databases native client API may be able to use SQL Relay without modification. SQL Relay provides drop-in replacement libraries for:
- MySQL
- PostgreSQL
SQL Relay also features:
- command line clients
- a GUI configuration tool
- extensive documentation
Enhancements:
- Several contributed patches were applied.
- Oracle stability was improved.
- Support for Oracle OS-authentication was added.
- The maxlisteners option was added.
- Support for Sybase stored procedures which return result sets was added.
- A Zope empty-result set bug was fixed.
- Support for Mac OS X, Solaris, and Cygwin was improved.

sql++ is an easily configurable, feature-rich, portable command-line SQL tool. It can be used with many different databases and in place of other commandline tools such as MySQLs mysql-client, Microsoft SQL, PostgreSQLs psql, and Oracles sqlplus.

sql++ project has features such as multiple connections, multi-database interfacing, subselects for all databases, regardless of whether the database has native subselects or not, and much more.

SQL-Ledger Accounting project is a double entry accounting system. Accounting data is stored in a SQL Server, for the display any text or GUI browser can be used. The entire system is linked through a chart of accounts. Each item in inventory is linked to income, expense, inventory and tax accounts. When items are sold and purchased the accounts are automatically updated.
With the assembly feature you can build manufactured goods from parts, services, labor units and assemblies. When the assembly is sold all the accounts linked to the individual parts, services, labor units and assemblies are updated and stock levels adjusted accordingly.
Invoices, Packing List, Income Statement, Balance Sheet, Sales, Work and Purchase Order, Statements, Receipts and Checks are generated from templates and can be changed to suit your needs. Templates are provided in html, tex and text format. The tex templates are processed with latex to produce postscript and PDF documents. Documents can be sent to a printer, file or fax, displayed with a PDF viewer or sent by email.
The translation mechanism for items and foreign language templates can be set for each customer/vendor so it is possible to generate invoices in a foreign language without knowledge of a foreign language. This translation facility can also be used to generate different forms for a group of customers/vendors.
DWS Systems Inc. is the developer of SQL-Ledger and provides ongoing support and customizations. SQL-Ledger is licensed under the GPL license, and is free software.
SQL-Ledger can be used on any UNIX, Mac OS X and Windows computer.
SQL-Ledger is written in Perl, developed on FreeBSD and Linux with Galeon, Konqueror, Netscape, Lynx, Links, W3M, Voyager, Explorer to render the display, Apache, thttpd, boa to communicate between the server and the browser, and PostgreSQL, Oracle, or DB2 to store accounting data.
Languages:
- English
- Arabic (Egypt)
- Bahasa Indonesia
- Brazilian Portuguese
- Catalan
- Chinese (Simplified)
- Chinese (Traditional)
- Czech
- Danish
- Dutch
- Estonian
- Finnish
- French
- German
- Greek
- Hungarian
- Icelandic
- Italian
- Latvian
- Lithuanian
- Norwegian
- Polish
- Portuguese
- Russian
- Spanish
- Swedish
- Turkish
- Ukrainian
Main features:
- Accounts Receivable
- Accounts Payable
- General Ledger
- Inventory Control
- Billing / Invoicing
- Time Cards
- Recurring Invoices
- POS
- Check Printing
- Purchase / Sales Orders
- Customizable Taxes
- Multi-user
- Multi-company
- Audit Control
- Foreign Currency
- Internationalization
- Access Control
- SQL server backend
- Customizable Templates
- Customers
- Vendors
- Assemblies (BOM, kits)
- Chart of Accounts
- Customizable Reports
- Financial Statements
- Administration Module
- Backup to file/email
- Application Interface
- Use on Handheld

DL/SQL is declarative, turing-complete programming language based on top of SQL database. The main idea is to store both program and data in one SQL table and make all the computations in it.

The current version of interpreter written in PHP contains quasi-lazy evaluation and simple caching.

The syntax was inspired by LISP and bash. Sounds strange? For example,

(* (+ 2 4 (#FACT 4)) 3)


means (2 + 4 + fact(4)) * 3 where fact is user-defined function for factorial.

As youve probably noticed, DL/SQL has got prefix (polish) notation with compulsory bracketing. That means, in front any name of function there must be opening bracket and after last parameter of a function there must be closing bracket. With this rule its really easy to implement variable-length argument lists.

For real deployment its necessary to change the core according to your needs - some special constructions are always necessary. Fortunatelly the core is flexible and easily extendable. Right now DL/SQL uses MySQL as its backend. Therere only several calls to DB, changing them is work for few minutes so porting DL/SQL to lets say PostgreSQL is piece of cake.

Therere only two API calls:

rpn_init()

clears all the cached values (actually sets the counted bit to false).

rpn_eval($expression)

evaluates entered DL/SQL expression. For using DL/SQL interpreter its necessary to include file rpnparser.phtml in your project. For easy implementation I also advise you to include file include/setup.phtml which contains all the necassary stuff for connecting to database and setting the directories. Without this file, youll have to do all the things yourself!

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.

SQL::Tidy is a Perl module to tidy up SQL statements.

SYNOPSYS

use SQL::Tidy;
my $tidy = SQL::Tidy->new;
print $tidy->tidy("select xyz from abc");

SQL::Tidy will (hopefully) make your SQL statement look prettier.

METHODS

new

Constructor. It can take a bunch of options (see OPTIONS below).

tidy

Takes an SQL statement (a string) and returns a tidied up version of the same.

add_keywords(qw(keyword1 keyword2))

Add keywords to those already in the instance.

OPTIONS

The options can be either passed to the constructor or be changed later as method calls on the tidy object:

# One way
$tidy = SQL::Tidy->new(width => 75);

# Another way
$tidy->width(75);

indent

Specifies the indent string. The default is two spaces, .

keywords

An array reference to override the default list of keywords.

margin

Start each new line with this string. The default it an empty string.

width

Page width. The default is 75 characters.