sqlMate for the OS/2- and eCS-Operating System

Imprint

sqlMate - a GUI-based local Front-End for the Administration of remote MySQL-Databases

Properties

Prerequisits

Download

Version 1.3 of Dec.23, 2005

sqlMate makes working with a remote MySQL-database much more easy. As an administrator you perform tasks such as:

	Create tables, modify and delete tables
	Display row-data, sometimes modify them
	Create indexes, modify and delete them
	Start queries
	and many more.
New in ver. 1.3:
	History-Function .

You can do all this with the well-known 'MySQL_Admin'-tool. This is a browser-based application, which is comfortable and powerful. But it is quite difficult to automate jobs or to perform tasks repeatedly.

This is the main-purpose of sqlMate. While with MySQL_Admin you don't need to know much about SQL-syntax this is quite different in sqlMate.

Whatever you want to do to your MySQL-database you must say it in pure SQL-syntax, e.g. CREATE TABLE with all column definitions and keys. In other words, you write a code-sequence of SQL-statements. What sqlMate does is send this code-sequence to the database-server over the internet-connection, which is automatically being established by sqlMate. After remote processing sqlMate receives the returned data, reformates them for easy reading and displays them in a listbox.

How to use it...

When the work is done, i.e. your intended tasks performed you can store your code-sequence as a 'Stored Query' and recall it later whenever you need it.

Auxiliary Edit:

This feature enables you to generate an SQL-statement for UPDATE or INSERT based upon a currently selected database-row (more....).

Look & Feel:

If somebody might want to have the several listboxes in different colors there is any freedom you like (more....).

Comparison:

If you prefer MySQL_Admin or rather sqlMate is just a matter of personal taste.

Most people would find MySQL_Admin more convenient. Others on the other hand like the total control over the database by unlimited use of SQL, which sqlMate gives them.

Anyway, it's up to you!

What you still need:

a connection to the internet
a locally installed MySQL-client. It needs not to be a complete installed mysql-database, but only the mySQL-programs 'mysql.exe' along with the DLLs (from. x:\mysql\dll). They must be present and indicated to by the config.sys (PATH / LIBPATH).

Before you download the program, please read and accept the following NoWarranty-Clause:

Usage of this program is totally at your own risk. Not the author nor the dirstributor of this program may be held responsible for any damages that may arise out of the usage of this program.
This program is freeware. There is no registration implemented, i.e. the program can be used without any functional limitations or restrictions in the version that is currently provided.

Installation:

Download 'sqlMate.zip' into a newly created directory, e.g. 'c:\sqlMate'
In that directory: enter 'unzip sqlMate'
enter install.

A re-boot is not required.

Install over an existing version:

Simply unzip the download-file 'sqlMate.zip' into your existing directory.

Download:

sqlMate.zip (110 kb)

Furthermore you need...

vrobj.zip (400 kb)
Vrobj.dll is a DLL which is used by many programs and most probably you already have it somewhere on your system (in the LIBPATH). If not or if the version that you have is older than 06-06-1995 then you must download it here and unzip it into (recommended) x:\os2\dll\.

Send an Email.

Detail-Features:

Auxiliary Edit:

Generate an SQL-Statement for UPDATE or INSERT from a certain database-row. Proceed as follows:

Edit an SELECT-Statement into the DDML-entryfield
click GO
You receive the SQL-output as a list (listbox bottom lefthand)
Doubleclick on a database-row; that row will be split into single columns and put as a list into the 'Single-Record'-Listbox
In the 'Single-Record'-listbox select a column for the WHERE-clause (optionally)
Invoke the context-menu (right mouse-click)
Select 'Generate SQL-Statement' -> 'Update'
The 'Auxiliary-Edit'-window opens where you can edit (if you like) the SQL-statement.
Invoke the context-menu: select COPY
Turn over to the main-SQL-Edit-window; invoke the context-menu: select PASTE

Determine your own colors:

Proceed as follows:

Open the OS/2-color-palette
To set the background-color: Drag a color into the listbox in question
To set the foreground-color (text): hold down CTRL-key and drag as above
Re-install orginal colors: Main-menu -> Settings -> Reset Color-Settings

History-Function:

Whenever a SQL-command is executed (by means of the 'Go'-button) the command is saved internally. To recall any SQL-command which has been executed before you simply click on the History-button and you can select from a list of already processed commands.
Note: The history-buffer is only valid during program-lifetime, i.e. after sqlMate has terminated the history vanishes also.

So the History-function does not mean that you don't have to save your SQL-command finally before exiting the program.