Release Notes for Beta Version .9

Revision 133 (Released: )

Numerous UI fixes for formatting on 4K screens

Revision 132 (Released: April 2, 2025)

Added ability to delete markers on the markers tab.
Speed optimizations.
Changed hashing algorithm for tags. BREAKS BACKWARD COMPATABILITY!
Can now create dictionaries with any data type.
Can attach a dictionary to a column in the column definition. All table inserts must match a value in the dictionary.
Added ability to specify a reject table. Rejected rows are added to this table instead.

Revision 131 (Released: January 16, 2025)

Display the expiration date in the About dialog.
Update properties dialog for DB tables.

Revision 130 (Released: November 26, 2023)

Display some additional 'not implemented' messages for unfinished features.

Revision 129 (Released: July 26, 2023)

Fixed bug when creating indexes where too many progress updates flooded the Qt message queue.

Revision 128 (Released: April 24, 2023)

Added ability to add values to an existing dictionary in addition to creating a new one.
Fixed bug when creating indexes using a dictionary that did not respect the case sensitivity setting.
Fixed bug where sorting values in an index caused selection problems.
Fixed crash where multiple threads were trying to sort the same value set when creating an index.

Revision 127 (Released: April 14, 2023)

Fixed bug when CSV file contains a mismatched quote.
Added ability to create a DB table definition from a csv file (or clipboard) where the delimiter is not a comma.
Added threading support when creating a test DB table.
Fixed memory leak when creating DB table using random generated values (a test table).
Improved the progress bar messages, tracking and dismissal for various tasks.
Added error correction code for fixing problems with DB tables.

Revision 126 (Released: March 21, 2023)

Fixed problem where creating a new drop zone on the 'Create' tab did not enable file timestamps.
Added the document subtype to the kinds of File Didgets that can be indexed.
Optimized the index mapping Didget to handle millions of indexed files quickly.
Added word count to the mapping information for each Didget indexed.

Revision 125 (Released: March 15, 2023)

Fixed problem with value selection after a 'Select All' operation.
Dynamically show the SQL as changes are made in the Create Query Dialog for a DB table.
Added a version number to mappings for Indexing so that Didgets that change can be re-indexed.

Revision 124 (Released: March 8, 2023)

Replaced the 'Show as Json...' option on database results with 'View as...' to also view in other formats.
Fixed bug when viewing or exporting selected cells in CSV format (needed extra commas for missing columns).
Improved performance when creating pivot tables on large relational tables.
Fixed bug when viewing indexes for Didgets that contain multiple selected values.

Revision 123 (Released: Jan 9, 2023 )

Added the file system tag ImportDT to record when a file was imported from a file system into a Didget.
Added a calendar button to the filter on the Tags tab for use when the data type is DATETIME.
Added a dictionary search button to the filter on the Tags tab.
Restore file CreateDT, AccessDT, and ModifyDT timestamps when exporting a Didget to a file (if those tags have values).

Revision 122 (Released: December 15, 2022)

Added ability to get a summary of selected Didgets on Query tab for properties when holding shift key.
Fixed problem with matching RegEx strings when doing database queries. Now does a search instead of a match.
Allow cancel when dropping many files that are unknown on the definitions window on the databases tab.
Enhanced Indexing tab.

Revision 121:

Fixed problem with creating and checking a FOLDER pod.
When creating a pod, give the user an option of pre-populating it with data in the Config/ folder.
Warn user when the Config/ folder is not found.
Show the specified limit in the tooltip for any queries on the Query Tab.
Fixed problem showing tooltips for menu items.

Revision 120:

Added more display of timings for filters, pivot tables, and other DB queries.
Added keyboard shortcuts for navigating between tabs.
Fixed performance problem when creating pivot table and calculating sum in another column.

Revision 119:

Added ability to create a DB table definition from a Json Lines file containing data.
Fixed issue where enter key did not trigger the OK button in the Create DB Table dialog.

Revision 118:

Fixed bug on Dictionaries tab where updates to a dictionary were not flushed to disk immediately and value count was stale.
Updated tracking to measure how long DB queries take and display it even when the performance tracking checkbox is unchecked.
Added Dictionaries to the Create Index dialog so the user can create an index for only words that match or don't match dictionary values.
Fixed problem in importing a Json file with a dateTime string to a column defined as of type DATETIME.

Revision 117:

Fixed bug where multi-level cells did not calculate for all values when running formulas.
Fixed bug when creating test DB tables with specific keys.
Added scrollable area to the Create DB Query dialog for the filter area.
Added scrollable area to the Insert Table Rows dialog for when a DB table has a lot of columns.
Added 'Check All' and 'Uncheck All' options to the Insert Table Rows dialog.
Fixed bug when parsing clipboard data that has separator inbedded within quotes.

Revision 116:

Close the reject file when importing data into a database table.
Fixed a memory leak.

Revision 115:

Fixed bug where duplicate formats were separated in the 'Show Formats' dialog.
Fixed application crash when importing multiple files to separate tables.
Removed extra quotes in CSV values.

Revision 114:

Added transformations for numbers. (Add, subtract, multiply, divide).
Fixed problem with DB Table Query not having the correct table name.
Added ability to search for Sets based on set type (e.g. folders, databases, Photo Album, etc.).
Notify user when something in the ./Config/Queries/*.Json files is not valid.

Revision 113:

Throttled thread that loads CSV lines from disk when the DB insert threads can't keep up.
Added ability to insert rows into an existing table that has DATETIME columns in it using a calendar.
Fixed bug when search button pressed when updating values in a column.
Added calendar popup when updating DATETIME values in a column.

Revision 112:

Fixed bug caused by following SymLinks to Directories when importing files.

Revision 111:

Added a Calendar popup when filtering on DATETIME values so the user can pick a Date and/or Time to compare.
Added ability to use DATETIME values in a DB Query 'WHERE' clause.
Fixed a bug when trying to filter on CURRENCY values.

Revision 110:

Added ability to import data into the DATETIME columns using an import datetime format. User can now specify the format for any given column.
Added ability to export data (Show as Json, Export to File, and Copy to Clipboard) for DATETIME columns that will use the specified display format.
Added ability to convert data in DATETIME columns to STRING columns and have the string values reflect the specified display format.

Revision 109:

Added ability to set the default DATETIME format at the browser level, at the ResultSet level, or individual columns in a table.
Added ability to set the default number format at the browser level, at the ResultSet level, or individual columns in a table.
Added other data types when creating a DB Table Definition for testing using random column types.
Added feature to create any DB Table filled with random data, random NULL cells, and random cells with multiple values.

Revision 108:

Fixed round error problem with the CURRENCY data type.
Added LATITUDE, LONGITUDE, and ALTITUDE data types for Geo coordinates.
Created the .position.Latitude, .position.Longitude, and .position.Altitude tags so they can be attached to photos or other Didgets.
Added CURRENCY, LATITUDE, LONGITUDE, and ALTITUDE conversions to the 'Transform->Convert' options.

Revision 107:

Fixed bug when updating values which might corrupt other values.
Fixed bug when an existing pod was loaded with a different size than it was created with.
Added some additional 'Transform->Convert' options. Can now convert between DOUBLE, FLOAT, INTEGER, STRING, and DATETIME types.

Revision 106:

Added ability to fix some errors encountered when doing a 'Check Integrity' operation against a database table.

Revision 105:

Fixed bug when transforming column with multiple layers
Fixed bug when exporting DB data (overwriting an existing file) and it did not write the header properly
Minor GUI changes for fitting windows on smaller screen sizes.
Minor GUI changes for some other dialogs.

Revision 104:

Fixed bug when filtering a column with a DOUBLE data type
Added a 'Stack Values' option for database columns. When a CSV file tries to implement arrays (e.g. Club1,[John, Bill, Sam],...), this lets you stack up the values in the array to form a 3D table.
Added the transformation 'TrimSingle' which lets you remove a single character at the beginning and at the end of a string (e.g. remove brackets in the example above).
Minor GUI changes for some other dialogs.

Revision 103:

Changed how DB queries are saved as a template. Now it just adds a tag to queries that are templates.
Made some more dialogs smaller for use on laptops or screens with fewer pixels.
Fixed bug when deleting result sets that did not clear the current result window.

Revision 102:

Suggest 'Run as Administrator' when the user does not have file permissions in the root directory.
Made some dialogs smaller for use on laptops or screens with fewer pixels.
Changed the 'Transform Table' operation when a database table is selected and the 'Transform data...' option is used.
Minor GUI changes for some other dialogs.

Revision 101:

Added the .fileSystem tag definitions for CreateDT, AccessDT, and ModifyDT. (original file date and time stamps)
Let users enable the new tags on a Drop Zone to automatically create the tags for each File Didget when importing a file.
Show date and time stamps in ISO8601 format.
Minor GUI changes for some tabs and dialogs.

Revision 100:

Initial Revision made available 2022-03-13