DbSchema 9.4.3

What's new in this version:

- Feature: Store database connections in a separate file ‘ ~ /.DbSchema/connections/connections.xml’, configurable in Model / Settings. Passwords are stored encrypted in ‘ ~ /.DbSchema/connections/passwords.xml’.
- Feature: New function evaluate(…) can be used in CREATE TABLE statement, to dynamically evaluate parameters. Sample CREATE TABLE ${table} ( ${body} ) ${createPartitionEnding} ${createClusterEnding} ${createSortEnding} ${createIndex1Ending} ${evaluete(options)} Where options can be someText${System.getProperty(“test”)}
- Feature: Support for DuckDB
Feature:
- Export dialog add combo for the file selection
- Add Model /Settings parameter to define a custom location to store the DbSchema settings. This allows to share the settings in a team via GIT.
- Logical Design table and column options conversion to physical using regular expressions
- Upgrade SqlServer JDBC Driver
- Faster Snowflake reverse engineer View columns
- Allow executing SQL insert statements with more than 1000 rows.
- Make the time limit to trigger auto-refresh after running ALTER TABLE statements configurable
- Implement DbSchema Test in Tools / Automation Scripts
- Automation Scripts can be executed directly in the Tools / Automation Scripts dialog
- Improve Data Explorer insert components

Fixed:
- SqlServer issue in reverse engineer with Foreign keys using columns with spaces or dots.
- Exception in Grid Editor
- Issue in Logical Design Naming Conversion
- Temporary issue with printing the data types
- SQL Editor open multiple files from one editor menu is using the wrong files.
- Default value conversion dialog not working.
- SQL Editor auto-completion include SELECT, UPDATE statements.
- Postgres reverse engineer User Defined Types created in another schema
- SQL Editor caret move left-right go to the next line
- Postgres reverse engineer varchar[] and timestamp(precision)