DbSchema 9.5.3

What's new in this version:

JDBC driver for CSV Files:
- Data analysts are often working with CSV files, using Excel or text editors
- DbSchema can handle now CSV files in a relational way, so you can visualize and manage multiple CSV files similar with a relational database
- To use CSV files, start a new model and using ‘CSV files’ as data source
- This will ask for the folder where the CSV files are saved, and load them in DbSchema as tables, with indexes and foreign keys
- Behind the scenes, the JDBC driver is loading the data to an H2 database

CSV JDBC Driver:
- This allows to interact with the CSV files as they would be a relational database. You can explore data in a relational way, write SQL queries and use the Visual Query Editor.
- To save back the data changes to CSV use the command ‘save csv to ‘

KeyStore tab to the Connection Dialog:
- In the connection dialog there is now a tab where you can load TLS keys into a keystore. There are two key stores: an authentication keystore and a trust store. These are passed over to Java as system variables
- java.net.sql.keyStore=<pathToStoreFile>
- java.net.sql.trustStore=<pathToStoreFile>
- The keystore files are saved to the ‘.DbSchema/connection/‘ folder in the user home.

Copy/Paste tables using SQL:
- Move or clone tables between different design models using the option Edit / Copy as SQL and Paste as SQL

Other Improvements:
- Feature: Export documentation always enable ‘Generate’ button. Until now was enabled only when a file was selected
- Feature: Oracle add FIRST_ROWS hint for browsing large tables
- Bug: Postgres sync issues for indexes with INCLUDE clause
- Bug: Postgres reverse engineer columns using domains as data type
- Bug: Postgres reverse engineer tables using inheritance
- Bug: Postgres reverse engineer column comments as table comments
- Bug: Oracle reverse engineer procedures, triggers and functions body text
- Bug: Postgres read-only connections do not import FKs
- Bug: MonetDB wrong class name in the JDBC Driver
- Bug: Multiple message on duplicate or invalid table or column names
- Bug: Oracle issues with reverse engineer tables with comments in Chinese. Upgrade the JDBC Driver.