Release Notes

08/24/2020

• CORE-997 Updated the data format for CSV data loads being sync'd across a cluster to take up less resources
• CORE-1018 Adds SQL functionality for  BETWEEN statements
• CORE-1032 Updates permissions to allow regular users (i.e. non-super users) to call the  get_job  operation
• CORE-1036 On create/drop table we auto create/drop the related transactions environments for the schema.table
• CORE-1042 Built raw functions to write to a tables transaction log for insert/update/delete operations
• CORE-1057 Implemented write transaction into lmdb create/update/delete functions
• CORE-1048 Adds  SEARCH wildcard handling for role permissions standards
• CORE-1059 Added config setting to disable transaction logging for an instance
• CORE-1076 Adds permissions filter to describe operations
• CORE-1043 Change clustering catchup to use the new transaction log
• CORE-1052 Removed word "master" from source
• CORE-1061 Added new operation called delete_transactions_before this will tail a transaction log for a specific schema / table
• CORE-1040 On HarperDB startup make sure all tables have a transaction environment
• CORE-1055 Added 2 new setting to change the server headersTimeout & keepAliveTimeout from the config file
• CORE-1044 Created new operation read_transaction_log which will allow a user to get transactions for a table by timestamp, username, or hash_value
• CORE-1043 Change clustering catchup to use the new transaction log
• CORE-1089 Added new attribute to system_information for table/transaction log data size in bytes & transaction log record count
• CORE-1101 Fix to store empty strings rather than considering them null & fix to be able to search on empty strings in SQL/NoSQL.
• CORE-1054 Updates permissions object to remove delete attribute permission and update table attribute permission key to attribute_permissions
• CORE-1092 Do not allow the __createdtime__ to be updated
• CORE-1085 Updates create schema/table & drop schema/table/attribute operations permissions to require super user role and adds integration tests to validate
• CORE-1071 Updates response messages and status codes from describe_schema and describe_table operations to provide standard language/status code when a schema item is not found
• CORE-1049 Updates response message for SQL update op with no matching rows
• CORE-1096 Added tracking of the origin in the transaction log. This origin object stores the node name, timestamp of the transaction from the originating node & the user.

2/26/2019

• Clustering connection direction appointment
• Foundations for threading/multi processing
• UUID autogen for hash attributes that were not provided 
• Added cluster status operation

Bug Fixes and Enhancements 

• More logging
• Clustering communication enhancements
• Clustering queue ordering by timestamps
• Cluster re connection enhancements
• Number of system core(s) detection
• Node LTS (10.15) compatibility
• Update/Alter users enhancements
• General performance enhancements
• Warning is logged if different versions of harperdb are connected via clustering
• Fixed need to restart after user creation/alteration
• Fixed SQL error that occurred on selecting from an empty table

11/2/2018

Fixes

HarperDB 1.2, Alby Release

Features

• Time to Live: Conserve the resources of your edge device by setting data on devices to live for a specific period of time.
• Geo: HarperDB has implemented turf.js into its SQL parser to enable geo based analytics.
• Jobs: CSV Data loads, Exports & Time to Live now all run as back ground jobs.
• Exports: Perform queries that export into JSON or CSV and save to disk or S3.

Fixes

• Fixed issue where CSV data loads incorrectly report number of records loaded.
• Added validation to stop BETWEEN operations in SQL.
• Updated logging to not include internal variables in the logs.
• Cleaned up add_role response to not include internal variables.
• Removed old and unused dependencies.
• Build out further unit tests and integration tests.
• Fixed https to handle certificates properly.
• Improved stability of clustering & replication.
• Corrected issue where Objects and Arrays were not casting properly in SQL SELECT response.
• Fixed issue where Blob text was not being returned from SQL SELECTs.
• Fixed error being returned when querying on table with no data, now correctly returns empty array.
• Improved performance in SQL when searching on exact values.
• Fixed error when ./harperdb stop is called.
• Fixed logging issue causing instability in installer.
• Fixed read_log operation to accept date time.
• Added permissions checking to export_to_s3.
• Added ability to run SQL on SELECT without a FROM.
• Fixed issue where updating a user’s password was not encrypting properly.
• Fixed user_guide.html to point to readme on git repo.
• Created option to have HarperDB run as a foreground process.
• Updated user_info to return the correct role for a user.
• Fixed issue where HarperDB would not stop if the database root was deleted.
• Corrected error message on insert if an invalid schema is provided.
• Added permissions checks for user & role operations.