What's new in DbEdit 1.0.1

SQL Editor / Instant SQL View
Major changes have been applied to the Core that enables the SQL editor to analyze SQL syntax while typing and annotate errors in text or overview ruler. This feature is very nice but unfortunately the SQL dialects out there are fairly different. Configuration of datatypes and functions that areAnnotations considered by the analyzer will follow in a future release, for now you can only disable analyzation if you do not like the syntax error annotations.




Completion with aliasCompletion has also been improved / bugfixed to support you with the full SQL dialect that is built in the code as well as any kind of database element (schemas, tables, columns, constraints, indizes). It can also handle table name aliases.



Another nice addition are query templates that you can freely configure using the SQL editor preference page. CompletionThey work nearly the same as you know it from the Java editor. In addition, backstep positions that you define are recognized by the completion so that a select statement template as you see it in the screenshot can be used to first choose a table or view to select from and then choose the appropriate columns from these tables or views.



Inserting TODOs within a comment leads to adding them as tasks to the Task view in a way as known from the Java editor. You cannot configure the tag words and this will not be implemented because IMO one tag word is enough.



Last but not least are Comment/Uncomment actions that you can use as usual when you select a block of text and hit Ctrl+Shift+/ or Ctrl+Shift+\.

Connection Configuration
Many asked for an automatic support when choosing their server URLs. Now there is URL template base preconfigured with a number of well known URLs for specific vendors. This default base is adaptively customized as you enter new URLs. If a connection is successfully established using such a new URL, DbEdit converts this into a template and adds it to the base. Next time you create a new connection config from scratch (the code watches for a blank URL text field in the dialog), DbEdit presents all URL templates for this kind of drivers in a list if you change the selection of the driver combo box.

Tables View
For connections the explicitly choose a catalog in the URL, e.g. jdbc:postgresql://host:port/testdb all catalogs were displayed in the past which has been changed. If you want switch back to the old style you can choose Show all Catalogs from the view menu.


© Copyright Uwe Voigt 2002, 2003, All Rights Reserved.