Downloads

Users who intend to write code in QueryStorm should use the Full version. The full version includes the runtime.

Users who will use the solutions built on QueryStorm but will not themselves write code should use the Runtime version.

Version History

2.5.7923.20438
·
Sep 10 '21
·
current
- Fixing the problem with the default workbook data context that prevented its use (the workaround was creating an explicit data context)
- When using [BindTable] the binder can now detect the table name based on the property type, if it is a table wrapper class (but not if it is Tabular)
- SQL preprocessor now forbids illegal combinations of declarations (e.g. can only use {@tbl} in a handler but not in a function or query) and gives better error information
- Fix encoding issue with .cs files that are created via a code fixer (e.g. extract class into its own file)
- Adding a "netstandard.dll" reference into the default config file as many current NuGet packages rely on it
- Support for configuring SSL in Postgres connection strings
Runtime Installer
MD5: 4E3CFB52D4DC3E0DA5F16A85F3327D4A
Size : 4.38 MB
Full Installer
MD5: ED1C5F50178FA3D36AFC1BAEC051EB70
Size : 29.66 MB
2.5.7914.20852
·
Sep 1 '21
- Hotfix: existing projects that used SQLite fail to load with the new 2.5 version. This hotfix fixes this (check release notes for details)
- Syntax highlighting for the new C# 9 "with" keyword
- Displaying compilation warnings even if build succeeeds


Full Installer
MD5: 68E71EF6C6BAEE177736035DB6D9A883
Size : 29.84 MB
Runtime Installer
MD5: A58F32C645BC1C3C2F09C22292C41C3F
Size : 4.38 MB
2.5.7913.28115
·
Aug 31 '21
- Upgrading from C#7 to C#9 (support for records, nullable reference types, async streams!)
- Upgrading from SQLite 3.15.2 to 3.36.0 (support for window functions!)
- Easy Excel function results caching
- Several
Runtime Installer
MD5: BEA0F5ABD3FEF2D698E3A819E0164CF4
Size : 4.38 MB
Full Installer
MD5: 64A91E942750A428791D696B72D5267F
Size : 29.84 MB
2.3.7891.32861
·
Aug 10 '21
- Trusted documents (runtime security feature for workbook apps)
- Easier context menus in apps
- Easier settings in apps
- Various bugfixes and improvements
Runtime Installer
MD5: F50CF3FF4C3E86937436DD00907F5DA9
Size : 4.3 MB
Full Installer
MD5: E2E90ECA0F7436ACA8F7FC464E8B3566
Size : 27.93 MB
2.3.7824.17314
·
Jun 3 '21
Summary
=======
This version is a collection of bug fixes. There are no breaking changes in this version.

Fixes
=======
- fixed compilation of projects with references to local system dlls
- minor fixes to ribbon class template
- fixed publishing packages with native dlls
- prevent creating multiple projects in a workbook, as this scenario is not yet supported
- better handling for project load errors
- better handling for async function crashes
- fix a focus issue with the undocked QueryStorm window where all text input would go to Excel
- fix for project deletion issues (add error logging, allow deleting projects with readonly files/folders)
- fixed minor ui issues in the undocked ribbon
Full Installer
MD5: 23570F6640D79B0F08D4A1D05A8B9E7D
Size : 27.75 MB
Runtime Installer
MD5: C5AAFA37E589E26FA5C5718FE9DE5668
Size : 4.3 MB
2.3.7822.26514
·
Jun 1 '21
Apps
======
- Added support for defining ribbons in apps

SQL preprocessor
======
- async functions
- functions that include headers in results
- async event handlers
- queries (for use from .NET code)

Data contexts
======
- complete overhaul of data contexts: switched to C# script for defining data context
- added support for CSV data contexts

Fixes
======
- fixed Excel process crash on exit in certain situations
- fixed Excel process crash on disable runtime Excel Addin
- fixed problem with nesting user defined Excel functions
- fixed activation issue for SQL Pro licenses
- fixed deadlocks in certain situations
- fixed some data handling issues in SQLite
- fixed dozens of IDE issues (logging, code editing, UI glitches)
- fixed handling of special values in user defined functions (error values, missing values)
- fixed installer issue for versions of Excel installed from the windows store
- reorganized confusing connection dialog

Breaking changes
==============
- SQL preprocessor syntax change for commands (event handlers): instead of e.g. {handles eventName} now it's {handler (eventName)}
- new apps will not work on the runtime from previous versions due to a change in the API of the runtime. This change was needed to allow apps to register their own ribbons.
- in projects, data context files will need to be recreated, because the new data context approach has changed
Runtime Installer
MD5: 33A8E2432B314836DEF98FDB07EFFE0B
Size : 4.3 MB
Full Installer
MD5: 713B3128CF0A650A081C3E2F351E4E09
Size : 27.74 MB
2.2.7760.18802
·
Mar 31 '21
Version 2 is here!
Full Installer
MD5: AC042517B43F704BED0EF7984E163902
Size : 27.61 MB
Runtime Installer
MD5: 285A281AB51AA13BB20A267AAD7B1134
Size : 4.27 MB

Get Started!

Read the documentation to
learn how to use QueryStorm.

Contact sales

Contact us for any licensing
or sales related questions.