Directory Lister 歷史版本列表 Page3

更新時間：2020-07-20
更新細節：

What's new in this version:

- Spatial presentation: tooltips rendering was fixed
- DB2: UI tools were converted into database tasks
- MySQL/MariaDB: database restore was fixed (binary data corruption)
- PostgreSQL: data type DDL was improved + comment edit support was added
- Oracle: problem with connect as SYSDBA was fixed

Exasol:
- Database error type discovery was added (proper handle of "connection lost" errors)
- Metadata read performance was improved

- Googlee Spanner: official driver configuration was added
- Simple view mode was fixed (redundant database objects were hidden)
- Proxy configuration UI was fixed
- MacOS installer was fixed (potential vulnerability was removed)
- Tasks management: error handing was improved (for deleted tables)
- We reverted to Eeclipse 2020-03 platform (it resolves a set of UI glitches on some platforms)
- A few minor UI and database-specific bugs were fixed

更新時間：2020-07-06
更新細節：

What's new in this version:

Data viewer:
- Now we refresh entire row after cell value update (handy if you have triggers)
- Generate SQL context menu was fixed
- Horizontal scroll with mouse wheel support was added
- Export data in source code (PHP arrays) format was added
- Bug with Ctrl+Backspace handler was fixed

SQL Editor:
- Query cancel handler was improved (problem with UI stuck was fixed)
- Now we show query information in the result tab tooltip
- Query parser was fixed (active query extraction for Ctrl+Enter action)
- Template variables (${word_selection} and ${line_selection}) support was fixed

Navigator:
- Icons for "Create object" actions were fixed
- Main menu File items were reordered
- Heading and trailing spaces trim was added to all edit dialogs/panels
- Session manager: problem with multiple windows was fixed
- SQL Server: Database tools (index rebuild, triggers disable) were redesigned
- Firebird: new table and table column creation was fixed
- PostgreSQL: Table partition DDL was fixed
- MySQL: CHECK constraints edit support was added

Oracle:
- Table statistics read was fixed
- Schema indexes folder was added
- Check constraints editor was added
- Trigger status icon was fixed
- Exasol: (thanks to @Sargul)
- Metadata read performance was improved
- Metadata search support was added
- Table references
- Index create DDL was fixed
- Table statistics read performance was improved
- Redshift: driver download was fixed
- SQreamDB driver was added
- YugabyteDB driver was added
- We upgraded Eclipse platform version to 2020-06. It affects dark theme and General preferences and fixes several minor bugs

更新時間：2020-06-22
更新細節：

What's new in this version:

Database navigator:
- Connection type highlighting was redesigned
- Simple view support was improved
- "Force object refresh on editor open" action was fixed
- Main toolbar UIX was improved (no disabled selectors)
- Database tools context menu was fixed

Table statistics:
- Rendering problems (redraw on scrolling) were fixed
- Performance problems were fixed
- SQL Server support was added

Data viewer:
- Wrong value extraction was fixed for expression aliases which conflict with table column names
- Dictionary values separator configuration was added
- Row coloring: support of gradient coloring for read-only columns was added
- Data formatter:
- Action "reset to default" was fixed in preferences
- Preference changes are immediately applied to open data editors

SQL editor:
- Results tab rename was fixed (now we save tab title between results refresh)
- Parser of multiple SQL queries on a single line was fixed
- Execution plan explain operation cancel was implemented
- Coloring of numbers in scientific notation was fixed
- Paste from source code: and characters handle was fixed (now we use proper line feeds)
- Stored procedures call generation was fixed
- Object editor: "reject changes" and command undo/redo command were fixed
- Data import: open target table on finish
- Data migration: DDL generation was improved (apply the same column data type when source and target databases use the same driver)
- Database tasks: PostgreSQL, MySQL and Oracle tools now can be saved as tasks
- SSH configurator: UI controls layout was fixed
- Database driver edit dialog was fixed (legacy driver option is disabled by default)

MySQL:
- User permission management was fixed (FLUSH PRIVILEGES is not needed for newer server versions)
- Unsigned INT and BIGINT data types support was added

Oracle:
- Numeric data type modifiers (scale/precision) rendering was fixed
- Materialized views read/create and delete was fixed (mviews were removed from table list)

PostgreSQL:
- Vacuum tool was improved (run in auto-commit mode)
- List of reserved keywords was updated
- Redshift: View with no schema binding support was added
- SQL Server: timestamp columns were marked as auto-generated
- Big number of minor UI and database-specific bugs were fixed

更新時間：2020-06-04
更新細節：

更新時間：2020-06-01
更新細節：

What's new in this version:

Database navigator:
- Statistics view (table sizes) was added
- Connection coloring was redesigned
- Connection host name tip was added

Data viewer:
- Ref cursor panel viewer was added
- Columns sort settings save/load was added
- Data export in HTML format was fixed (styles)

SQL editor:
- Function call formatting was improved
- Table alias generation was fixed (for unicode/numeric table names)

PostgreSQL:
- Ref cursors refresh support was added
- Table and schema statistics was added
- Table comment and rules were added to DDL

Oracle:
- Metadata search was fixed
- Java source read was fixed
- ODBC driver download was fixed
- Exasol: metadata edit dialogs were redesigned
- Clickhouse: table statistics was added
- Firebird: view editor was fixed
- Plain HTTP driver repositories (Maven or direct links) were replaced or removed
- Big number of minor UI and database-specific bugs were fixed

更新時間：2020-05-18
更新細節：

What's new in this version:

Data viewer:
- Pin (aka "freeze") column feature was added
- Float (32bit) data type render was fixed (MySQL)
- Plaintext renderer was fixed (binary values representation)
- Filter value auto-complete was fixed (clipboard paste support)
- Issue with "order by table column + column alias" was fixed

SQL editor:
- Script close prompt was fixed
- Hyperlinks now contain procedure parameters
- Script selector panel positioning was fixed
- Execute in new tab: new tabs opening was fixed
- SQL format preferences page was improved
- SQL formatting was fixed (line feeds after brackets)
- SQL console title was fixed (source object name was added)
- Non-https Maven repositories and driver links were removed

PostgreSQL:
- Added parameters to the SQL execution plan explain (ANALYSE is optional)
- Database backup  was fixed on Linux/MacOS (proper table names quoting)
- Table DDL was fixed (show table comment)
- Sequence DDL was fixed (START parameter)
- Object dependencies now contain links on dependent/depending object
- Permission/role editors were fixed (roles are sorted by name now)
- SQL auto-completion fixed for older PG (<= 8.4)
- Oracle: unique key detection was fixed

DB2:
- FOR BIT DATA columns support was fixed (show value as binary)
- Native SQL dialect support was improved (BEGIN/END)
- SQLite: ROWID pseudo-column support was added (as unique key)
- Many other minor bug fixes and improvements

更新時間：2020-05-03
更新細節：

What's new in this version:

SQL editor:
- Format now formats active query by default
- Matching brackets highlighting was improved

Data viewer:
- Find/replace highlighting and scrolling was fixed
- Data filter save was fixed (problem with quoted column names)
- Auto-completion in data filter now can be disabled

- Object editor: refresh button in bottom toolbar was unified for all pages
- Dark theme support improved (connection type colors)
- New connection wizard was fixed (problem with quick driver selector)

Driver editor dialog was improved:
- Extra properties save was fixed
- Legacy drivers support was added

- Git extension packaging was fixed (older Eclipse versions support)
- Derby: new database create was fixed
- Firebird: system objects hide/show was fixed (determine system flag from fro meta table)

MySQL:
- Read-only connections support was fixed (SQL editors)
- Query execution plan explain was fixed

Oracle:
- Driver configuration was fixed (typo in Maven artifact name)
- Java classes source viewer was added
- Materialized view DDL read was fixed
- PL/SQL parser was fixed (CASE/WHEN/END)

PostgreSQL:
- search_path update was fixed
- Numeric values rendering was fixed

- Redshift: SOCKS proxy support was fixed
- SQL Server: table DDL generation was fixed (column type names)
- SQLite: foreign key metadata read was fixed (FKs with no name)
- Portuguese (BR) localization was added
- Many minor bug fixes and improvements

更新時間：2020-05-03
更新細節：

更新時間：2020-05-03
更新細節：

What's new in this version:

Directory Lister 2.41 (64-bit)
- Retrieving more properties from animated GIF files


Directory Lister 2.40 (64-bit)
- Improved progress window to better reflect current operation


Directory Lister 2.39 (64-bit)
- Added option to display disk letters and disk names in title summary
- Improved reading XML properties for FB2 files


Directory Lister 2.38 (64-bit)
- Added support for reading .7z and .cab archives
- Fixed displaying FOURCC for .mts and .m2ts files


Directory Lister 2.37 (64-bit)
- Added support for WebP files


Directory Lister 2.36 (64-bit)
- Added support for CorelDRAW (cdr) files (X4+)


Directory Lister 2.35 (64-bit)
- Network shares should be now displayed even if SMB1.0 is not installed
- Keywords for MP4 files are now displayed in proper column (and not in category)


Directory Lister 2.34 (64-bit)
- Added new column "Rating" for multimedia files


Directory Lister 2.33 (64-bit)
- Added support for webm format
- Retrieving more metadata from AVI files
- Dropped support for Windows XP
- Fix MP4 length fragmented files
- Fix sampling frequency for some MKV files


Directory Lister 2.32 (64-bit)
- Retrieve more MP3 properties when using MediaInfo
- Retrieve more WAV properties (Album, Track)
- Prevent updating Last Access Time while reading files


Directory Lister 2.31 (64-bit)
- Fix updating columns listed on some options
- Fix configuration migration from v2.25
- Fix reading AC3 properties from some MPEG files


Directory Lister 2.30 (64-bit)
- Added support for reading meta data from html files
- Added /c command line option to override configuration
- Fix endless loop while parsing broken mkv files


Directory Lister 2.29 (64-bit)
- Added option to display free bytes and total disk size in title summary
- Fix writing multimedia length column to database output


Directory Lister 2.28 (64-bit)
- Added "Vertical resolution" option and renamed current "Resolution" into "Horizontal resolution"
- Added option to count total multimedia length for folders
- Added "Body serial" and "Lens serial" columns
- Resolutions are now extracted from PNG images
- Recognize Unicode comments in JPEG files
- Merged Multimedia -> Comments, Title with respective Document options
- Merged Multimedia -> Date taken with Document -> Doc created option. (Now renamed to "Doc created / Date taken")
- Moved several descriptive metadata to Document page and left only technical metadata on Multimedia page
- Fix newline character in text output
- Fix slash being added to CSV header when Path is checked


Directory Lister 2.27 (64-bit)
- Recognize lower case keys in FLAC metadata
- Display single slash if displayed path is empty
- Fixed not displaying time in date columns for Excel output
- Fix displaying date values in older Excel editions (2010, 2007)


Directory Lister 2.26 (64-bit)
- Fix displaying number as separate column when column names is not displayed
- Fix displaying path as separate column in Excel output


Directory Lister 2.25 (64-bit)
- Added "Lock table header" option to HTML output
- Added options to calculate SHA-3 256 and 512 bits hashes
- Added options to have separate "Path", "Extension" and "Number" columns for all outputs and removed "Path, Name and Extension together" option for CSV
- Option to split path into parts now works for all outputs
- Added option to end path with slash
- Added support for SQLite database output via ODBC
- Custom header can now be included in CSV output
- Added option to automatically save configuration on exit
- All columns are now visible in "Column order" list box for CSV and database outputs
- Updated HTML output template to HTML5 standard
- ! < and > are now not added to folder names, only to subfolders


Directory Lister 2.24 (64-bit)
- Added option to include folder id columns in database output
- Fix total number of files and total size when folder filter is applied


Directory Lister 2.23 (64-bit)
- Added support for ICO and CUR files
- Added option to use MediaInfo library to retrieve metadata
- Added support for OGG files
- More properties are retrieved from WAV files
- Retrieving Subtitle property from MP3, MP4 and ASF files into Subject column
- Fixed bits per pixel value for RGBA PNG images
- Fixed use of TAB as a separator in CSV output which resulted in merged columns


Directory Lister 2.22 (64-bit)
- Added Microsoft Excel as an output option
- Zip archives are now also shown in the left tree when 'Treat archives as directories' option is selected
- Added support for ZIP64 archives
- Fix displaying VBR for directory rows in CSV


Directory Lister 2.21 (64-bit)
- Fixed database output to SQL Server when date columns were selected.


Directory Lister 2.20 (64-bit)
- Date fields can now show dates since year 1601 and not only since 1970
- Fixed slow report generation for "Draw directories tree" option
- Fixed reading dates from xml properties (Office, ebooks, pdf) for some files

更新時間：2020-04-19
更新細節：

What's new in this version:

Data viewer:
- Problem with unreachable last row/column was fixed
- "Open With" action now uses configuration from last data export
- Find/replace issues were fixed (scroll to found cell)
- Bug in reference panel was fixed (multiple value selection)
- Filter value auto-completion was fixed (popup close)
- Virtual unique keys management was improved

- SQL editor: multiline code templates apply was fixed
- Number of bugs were fixed in the Simple navigator view
- Transaction management was improved (redundant transaction commit confirmations were removed)
- GIS viewer: many new (and cool) tiles were added
- Active catalog/schema selector UI was improved
- Connection edit dialog was fixed (error during page switch)

Oracle:
- Connection settings (SID/Service) save was fixed
- Session terminate was fixed (for non-RAC databases)

Exasol:
- Foreign key creation was fixed
- View DDL extraction was fixed (auto-format was disabled)

- HANA: unique key creation was fixed
- Firebird: procedure metadata refresh was fixed
- Problems with remote RDP connections (app crash) were fixed
- Japanese localization was significantly improved
- We have migrated to Eclipse platform 2020-03
- Many other minor bug fixes and improvements