SQLWeb Worksheet 3000 / News: Recent posts

This time, if you're in 'Table' mode, and you do a supported query, you can double-click and 'edit' cells on-the-fly. It's a nice feature if you have say 10 rows of something to update .. saved time from having to run 10 separate update queries. Note that it depends on the driver what type of queries are supported (IE, for Oracle 'select *' is not supported). Also, changed the way you can increase the size of the 'Query' window ... you can now use the mousewheel to increase/decrease the query window size (rather than the 'jumpy' onMouseOver way that I was using before).

Change Log:
- made Query Builder feature more powerful by automatically having it help you join tables based upon foreign keys.
- added to Query Builder the ability to alias column names.
- added to Query Builder the ability to specify certain where clause values.
- changed main query textarea to auto 'grow' when your mouse is over-top ... so when you are typing your query, you have much more to work with and then when you are not typing you can move your mouse away and see more of the results area.

I have finally got around to adding some more features and released a Beta 7 version:
- code is much more Object-oriented now and switching between Worksheet and Table view does not create a whole new connection to the DB (you still lose your results though since they are stored differently)
- worksheet mode is up to 100x faster now since I optimized all the string lengthening code (faster than table mode now)
- added export for both the current query as an sql file and for the worksheet results as a txt file.
- fixed Hot-keys so that Mozilla users can actually use Ctrl-Enter as well to execute a query
- added new Query Builder to let you visually create your queries (a little slow in Oracle with the free driver but if you have your own faster driver it should be plenty fast - ie, JTDs driver for SQL Server is plenty fast). Requires latest browers (IE 6+, Firefox 2+, etc).

Added a beta 6 version today with a features I've added over the past year:

- fixed CSV download for Tomcat
- cleaned up user's guide
- streamlines new connection to remove redundant step
- fixed textareas to attempt to maximize to the size of the browser window.

NOTE: I had to stick the WAR file into a zip file because Sourceforge didn't want an 'unversioned' file name for the release.

Re-arranged the app a little and started an 'edit' feature to create/modify/drop tables .... it's VERY beta at this point but I'd like any feedback before I spend much more time on it. At that point I'll update CVS and start adding support for more databases.

My bad, one of you caught me on the fact that I only test this sucker on Resin. Well I downloaded Tomcat 4 and played around and now version .4 should work with Tomcat with no problems. Resin is still better. :)

Some people have asked why they can't get the app to 'run'. These releases are web applications, meant to run under something like Tomcat, Resin, or any JSP/Servlet engine using the 'war' file capability. In the future we hope to make a Swing version of the app available, but for now .... it's designed as a web application ONLY. Thanks.

Anyone using the beta SQL Server driver should be aware that the non-beta release is available at http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/MSDN-FILES/027/001/779/msdncompositedoc.xml This version is probably more stable but ONLY supports SQL Server 2000. I release my WAR file with the beta version for 2 reasons: 1) it's beta so I don't have to worry about any MS licensing issues (we all know how understanding MS is of Open Source software) and 2) it still works with SQL Server 7.0 Either way, I still recommend FreeTDS (if you can use it) or the Inet Sprinta drivers (if you can afford it) for better performance.

I updated my projects web page at http://sqlweb3000.sourceforge.net/ The main addition is that I now have screenshots.

Fixed a typo that reversed the the url and driver for MySQL ... should be fine now. Also added SABDP, Firebird, Interbase, and PostgreSQL (untested) support. In anyone wants to test these for me, that would be great?! :)

I added a relatively simple (for a developer) dbtype.ini file so adding new database types should be as easy as modifying a few lines in the file and dropping a driver JAR file in the lib directory.

Though the app is over 2 years old, this is my first open-source release on Sourceforge.net