11/2/2018
Features
Upgrade: Upgrade to newest version via command line.
SQL Support: Added IS NULL
for SQL parser.
Added attribute validation to search operations.
Fixes
Fixed SELECT
calculations, i.e. SELECT
2+2.
Fixed select OR not returning expected results.
No longer allowing reserved words for schema and table names.
Corrected process interruptions from improper SQL statements.
Improved message handling between spawned processes that replace killed processes.
Enhanced error handling for updates to tables that do not exist.
Fixed error handling for NoSQL responses when get_attributes
is provided with invalid attributes.
Fixed issue with new columns not being updated properly in update statements.
Now validating roles, tables and attributes when creating or updating roles.
Fixed an issue where in some cases undefined
was being returned after dropping a role
2/26/2019
Features
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
7/10/2018
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 SELECT
s.
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.
Did you know our release names are dedicated to employee pups? For our first release, Alby was our pup.
Here is a bit about Alby:
Hi, I am Alby. My mom is Kaylan Stock, Director of Marketing at HarperDB. I am a 9-year-old Great Dane mix who loves sun bathing, going for swims, and wreaking havoc on the local squirrels. My favorite snack is whatever you are eating, and I love a good butt scratch!
4/18/2018
Features
Users & Roles:
Limit/Assign access to all HarperDB operations
Limit/Assign access to schemas, tables & attributes
Limit/Assign access to specific SQL operations (INSERT
, UPDATE
, DELETE
, SELECT
)
Enhanced SQL parser
Added extensive ANSI SQL Support.
Added Array function, which allows for converting relational data into Object/Hierarchical data
Distinct_Array
Function: allows for removing duplicates in the Array function.
Enhanced SQL Validation: Improved validation around structure of SQL, validating the schema, etc..
10x performance improvement on SQL statements.
Export Function: can now call a NoSQL/SQL search and have it export to CSV or JSON.
Added upgrade function to CLI
Added ability to perform bulk update from CSV
Created landing page for HarperDB.
Added CORS support to HarperDB
Fixes
Fixed memory leak in CSV bulk loads
Corrected error when attempting to perform a SQL DELETE
Added further validation to NoSQL UPDATE
to validate schema & table exist
Fixed install issue occurring when part of the install path does not exist, the install would silently fail.
Fixed issues with replicated data when one of the replicas is down
Removed logging of initial user’s credentials during install
Can now use reserved words as aliases in SQL
Removed user(s) password in results when calling list_users
Corrected forwarding of operations to other nodes in a cluster
Corrected lag in schema meta-data passing to other nodes in a cluster
Drop table & schema now move the table & schema or table to the trash folder under the Database folder for later permanent deletion.
Bulk inserts no longer halt the entire operation if n records already exist, instead the return includes the hashes of records that have been skipped.
Added ability to accept EULA from command line
Corrected search_by_value
not searching on the correct attribute
Added ability to increase the timeout of a request by adding SERVER_TIMEOUT_MS
to config/settings.js
Add error handling resulting from SQL calculations.
Standardized error responses as JSON.
Corrected internal process generation to not allow more processes than machine has cores.