Thread: [Squirrel-sql-develop] Squirrel SQL Client 1.1 alpha 1 is finally released
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Colin B. <col...@bi...> - 2001-11-13 11:33:55
|
The first alpha of Squirrel SQL Client 1.1 has finally been released. You can get it from http://squirrel-sql.sourceforge.net/alpha/. The installation file is an installer created by the Izpack Java installer, just execute it from Java with the -jar option. The document plugins.html within the docs directory of the distribution is the beginnings of a programming guide to Squirrel. How much of the plugin API is still to be written? Most of it. I'm going to be driven by what you want as to what I implement next. Areas missing that I am going to be addressing (in no particular order): 1. Data model for the SQL output. 2. Access to the objects tree for adding to both object types and objects. 3. A popup menu for the objects tree. 4. Allowing plugins to save/restore state to/from the SquirrelPreferences object. 5. The ability to add tabs to the session window. 6. Allow the user to specify shortcut and accelerator keys for menu items. This will get around the current problem of multiple plugins using the same accelerator keys. 7. Allow the user to specify actions to be added to toolbars. 8. To make 6 and 7 work Actions need to be specified through XML config files. Probably add actions to menus just through config files without requiring Java code as it does at the moment. 9. Access to the SQL script before it is executed. 10. Tell me what else you want!!! There are a number of plugins shipped with the distribution which are mainly the beginnings of some plugins that I would like to see in Squirrel. These are: Database Information -------------------- internal name: dbinfo Description: Extend Squirrel by defining XML config files for various databases. E.G. the method by which you retrieve the source for a stored procedure is different between different databases but it is normally a piece of SQL. Therefore you could have an XML file to specify this. E.G. Status: 2% complete. I've done almost nothing on this. Saved Queries ------------- internal name: favs Description: Allow the saving of queries in a manner similar to Favourites/Bookmarks in a browser. Status: 5% complete. Look and Feel ------------- internal name: laf Description: Allows the user to select the current look and feel. Status: 75% complete. This is basically a wrapper around the existing Squirrel functionality. Still to implement is the specifying of default fonts for various controls. SQL Scripts ----------- internal name: sqlscript Description: This is a wrapper around some code supplied by Johan Compagner which allows the saving/restoring of SQL scripts to/from text files. Status 50% complete (maybe). Still to do is integrate Johans code for generating structure/data scripts for tables. ========================================= The Database Information and Saved Queries plugins are looking for somebody to take them over. Just send a message to this list if you'd like to take responsibility for them. I'm hoping that Johan will take over the SQL Script plugin <hint/>. These are a few ideas for other plugins that I think would be useful: 1. Table creation wizard. 2. Visual Query builder. 3. SQL results export utility (CSV, XML, text, HTML etc.) 4. Data maintenance. Spreadsheet or generating a maintenance panel on the fly for a selected row. If theres a plugin that you'd like to develop just send a message to the list giving a quick description of the plugin and the internal name you'd like to use. At some stage I'll put up a register of used internal names on the web site. Those of you who haven't sent me your SourceForge user names please do so so that I can add you to the project. Theres no urgency on this as I still haven't got CVS up yet. The next task! Col |