SqlFun is a Java program/applet (sort of a generic SQL client) that allows you to experiment with SQL
statements [hopefully] without having to install a SQL server or database program.
All you need is Java and Windows ODBC (or any other database server that supports JDBC).
SqlFun is compiled with Java 1.3; so you will need the
Java Runtime Environment (JRE 1.2) --
free from Sun Microsystems -- in order to run it.
It is recommended that you run SqlFun as an application.
However, SqlFun can be run as an applet (using Java Plug-in -- part of the Java Runtime Environment) as well.
The only thing is that you may encounter
Security Violation Error when you try to connection to data source via
sun.jdbc.odbc.JdbcOdbcDriver.
(However, other JDBC driver, like Sybase, may work.)
Follow this link to try to run SqlFun as an applet.
(If the plug-in is not installed, one will be downloaded form Sun Microsystems.)
Can connect to any SQL server that support JDBC standard.
Support user predefined SQL statement templates that prompt user for values.
Support copy of SQL query result to system clipboard for paste to applications like MS Excel.
Support multiple work spaces.
Can save/load session.
Runnable as Java Applet.
Switchable "look and feel".
Small in size.
SqlFun is Free!
What's new in SqlFun:
Starting from version 1.3, startup parameters can be passed to SqlFun.
Starting from version 1.3, SqlFun can read in commonly reused SQL statements and SQL statement templates from a
configuration file ("SQL statement providers" file). By selecting a menu item, SQL statement will be automatically
inserted. In the case of SQL statement template, a dialog will pop up to prompt user for the "prompt values" in the
SQL statement template.
Starting from version 1.3.2, batch of SQL statements can be executed with
the menu item Edit|Exec Batch.
Starting from version 2.0, SqlFun can save/load session to/from a text file (SqlFun Session file). This will provide
an easy way to restore the "work spaces" of any previous session.
Moreover, instead of the complete "work space" TEXT buffer, selection of the TEXT buffer can be treated as the SQL
statement to execute. This will allowed quick switch to execute different SQL statements. What you have to do is to type
all SQL statements in the TEXT buffer, and select the one you want to execute. Of couse, all you typed can be saved
for later reload.
Also, starting from version 2.0, SqlFun allows you to copy the query result to the system clipboard.
The copied result can be pasted to spreadsheet like MS Excel.
Starting from version 2.1, you can double click on any "result grid" cell to browse the content of the cell in a bigger
text box. This should be helpful if any result field is, say, a memo field.
Starting from version 2.153, undo/redo and basic syntax highlight features are added to SqlFun.
Moreover, column orders and sizes are now remembered so that next time the "same" SQL query is executed,
the layout of the result table will stay the same.
Please refer to the documentation in the package for more details.
Download: SqlFun.zip (66 K).
After you downloaded the ZIP file, you should UNZIP it into a directory using tools like WinZIP.
In the directory, the file sqlfun.jar is the JAR file of SqlFun.
You can simply double-click on the JAR file, from Windows Explorer, to have it started.
However, here is the common way to run a Java (JRE 1.2) application from DOS Prompt:
SqlFun is a FREEWARE.
You can use it and distribute it free of charge.
Should you be interested in bundling SqlFun with your product,
you are encouraged to notify the author.
Moreover, you should not turn SqlFun into your own production.
The author shall retain the rights to the source and the binary of the program.
This freeware does not come with any warranty or support of any kind.
The author is not responsible for any damage caused due to the use of this program.
Bug reports, comments and suggestions are welcome.
