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 are![]() ![]() Another nice addition are query templates that you can freely configure using the SQL editor preference page. ![]() 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. |
|