Releases: NTDLS/NTDLS.Katzebase.Server
Releases · NTDLS/NTDLS.Katzebase.Server
0.21.0
0.20.0
What Changed
- Aggregation when no group-by is present.
- Added count(*) shortcut,
- Added IsNumeric, IsDouble and IsString scaler functions.
- More drastic performance improvements to schema locking, also reduces deadlocks.
- Consolidated Server, Management, and SQL Server Migration tool into one installer.
New Contributors
Full Changelog: 0.19.0...0.20.0
0.19.0
- Fixed issue with scaler functions when optional parameters were not passed.
- Resolved issue with calculating mathematical expressions when in line with string concatenation.
- Added new "single" schema that is intended to mimic the Oracle "dual" function.
- Reimplemented insert of "ragged key/value" pairs. This is in addition to field/value insert style.
Full Changelog: 0.18.0...0.19.0
0.18.0
- Reimplemented "set".
- Massively improved insert performance.
- Greatly reduced schema lock contention.
- Resolved issues with case-sensitivity of schema aliases in where clause and joins.
- Greatly reduced duration and memory requirements for creating and rebuilding indexes.
Full Changelog: 0.17.0...0.18.0
0.17.0
- Reimplemented "select into".
- Reimplemented Sample, Analyze, List, Alter, Rebuild, Set, Kill, and Exec.
- Reimplemented system functions.
- Resolved issue with "select top" when offset is not specified.
- Client package update.
Full Changelog: 0.16.0...0.17.0
0.16.0
Changes
- Rewrote tokenizer.
- Rewrote entire query parser.
- Parsers are now separated into separate static classes for each query type.
- Parsers are now reusable, allowing for the condition parser, field parser and the like to be reused inside other query parser types.
- Functions are now fully recursive and are parsed in select fields, group by, order by, insert, update, select, where clause and join clauses.
- Update statements now allow for joins.
- Delete statements now allow for joins.
- Introduced "insert select from" statements.
- Temporarily removed support for procedures, they will need to be reimplemented.
- Major changes to the way that indexes are selected and used. Multiple values for a single index are now handled in one index lookup operation.
- Condition parser rewrite is now more robust and understandable.
- Introduction of new dapper like queries using classes as return objects.
- Introduction of parameterized queries prevents sql-injection attacks.
- Scaler and aggregate function parser rewrite allowing for reusability in various parts of queries.
- Added inline query string concatenation.
- Added query field type detection for inline math and string aggregation to coexist without "casting" which would be found in other RDBMSs.
- Added windowing functionality with TOP and OFFSET.
Remaining to-do:
- Reimplement "SELECT INTO".
- Reimplement stored procedures.
- More robust parser validation.
What's Changed
- Implementation of robust parser in PR #68
Full Changelog: 0.15.0...0.16.0
0.15.0
- Separated thread pools for indexing and lookup operations.
- Added full support for composite index seeks and scans.
- Vastly improved query optimizer.
- Added API to show query plan and order of operations, this is also available in the UI.
- Added finer granularity and additional categories to performance trace operations
- Performance counter refactoring.
- Removed element compression in favor of full page compression for better performance and space usage
- Greatly improved locking and concurrency. Much less contention and higher performance.
Full Changelog: 0.14.0...0.15.0
0.14.0
- Updated reliable messaging to allow async queries. Each connection can now handle more than one query at a time.
- Added configurable child thread pool queue depth.
- Updated delegate thread pooling to allows for consolidation of thread exceptions and process cancelation.
- Improved semaphore locking.
- Query explain, attached conditions to root schema, removed double optimize
- Cleaned up condition/indexing explanation.
- Cleaning up condition parser.
- Added condition inversion.
- Resolved selecting dynamic fields from specific schemas.
- Exception formatting.
- Added aggregate exception to one threaded call, need to do others.
- Condition parser improvements, thread exceptions, perf and refactoring.
- Added ShowVersion, faster string comparison, much faster like comparison
Full Changelog: 0.13.0...0.14.0
0.13.0
- Added: SystemProcedures and SystemAggregateFunctions
- Added serilog.
- Removed delayed document materialization.
- Removed stability lock conversion.
- Corrected index analytics for root node calculations.
- Fixed parser issue which was not tagging NULL as a constant.
- Resolved null equality issues.
- Resolved issue where constant values were not filled out on one-to-many relationships.
- Vastly improved exception reporting.
- Refactoring of expressions, sub-expressions and conditions.
Full Changelog: 0.12.0...0.13.0
0.12.0
- Major updates to dependency libraries.
- Lots of bug fixes.
- Lots of optimizations.
- Incredible amounts of refactoring.
Full Changelog: 0.10.0...0.12.0