>Are you considering columnstore compression to reduce footprint size of tables by a factor of 8-10x, and increase query performance by 10x or better?
I don't know. What is it? I have a database engine design I invented in 2004 called Journey, which has something similar to what you describe, but I don't know what "columnstore compression" is by name.
>Are you considering self-service reporting tools as part of the VFP platform?
I have made several enhancements to VFP in my Visual FreePro design. You can look through them:
http://www.visual-freepro.org/wiki/index.php/VXB%2B%2BHere's a page on reporting features:
http://www.visual-freepro.org/wiki/index.php/Enhanced_Reporting_and_Print_Preview>Are you considering query store features, so that we can monitor execution plans of previously executed queries?
I have something similar to this. It is not just for queries, but for anything (including reports). It allows you to save previously computed data for later use. It's not limited to queries. It's limited to diskspace. :-)
>Are you considering change data capture in the core VFP database engine?
Yes. A journaling engine is an absolute must in my opinion. It should be automatic and searchable. This actually goes along with another concept I have called
Anchor, where you "drop anchor" at a particular point and time in your data set, allowing for diffs between versions, to compare this snapshot with that snapshot, etc.
I have many designs along these lines.
>Are you considering row-level user security?
No. I've never considered that. It could be added. Right now I have table-access security. A second layer could be applied, and that layer could be handled in users or groups, to rows or columns.
The entire design with the full version of Visual FreePro is along the lines of a .NET engine. It is its own VM, and it operates with about 80% compatibility with VFP9, and has about 20% new features and does some things differently.
VJr, on the other hand, is a literal follow-on to VFP9 supporting nearly everything, plus many extensions.
