(If not a full version of MS Express then SQL local DB...)
Please just Microsoft native RDBMS with NinjaTrader not some other offering such as MySQL from UNIX :-(... heres why:
1. Native driver compatibility 1000000% assured - Use MS developers for MS dekstop technologies and mobile/ UWA/ Core -even improve the platform development with a proper RDBMS!
2. Allow new and experienced TSQL deverlopers to take the platform to another universe - natively working with WPF etc - orders/executions - reports/technicals all easy stuff - all
3. Allow side by side instances of MS SQL all flavours to talke nativelt and link via views/ queries via instances as 1 database - so we dont have to suck data out into another - allow realtime querys not snapshot pulls
4. Future proof it with full compatibility to even UWA and Core and use the Microsoft Developer/Software Architecture Guidelines
5. NinjaTrader - is Microsoft .net, it moved on the order of Microsoft's architectural plans and road map to WPF and that is a mixed bag - but without doubt its a light year ahead of NT7 - so now we need to move since NT8 to SQL local DB -this is where the future is... not in different technology not part of .NET and MS familly...so lets do the right thing and move to an up to date MS SQL RDBMS - SQL Local DB for this exact kind of application.., the dev community is waiting for the correct choice to be made.
if the next choice for NinjaTrader DB is MYSQL
Compatibility likely still run into drive issues and support later whereby people have different installs of MYSql and various, there is a golden chance now to add in something that will be a game changer and we will see addons never thought of before -with TSQL supported natively in the internal db. MySQL is not native... or as powerful - in fact it's a rather dated weak technology - its used in windows for PHP running on IIS hosting Wordpress usually - it should never ever be used in windows .net .... its not even related...
NT7/NT8 legacy
NT7 - 10000% - Compact SQL - was a neccessary alternative to MS SQL Express in 2006 to 2012 or so due to installation issues and support overhead single instance and mutli use and stuff - it got jammed up it was nightmare and needed special privileges under install that would have thrown a curve ball - but this was done away with since then with MS SQL Local Db...with intrinsic unfailing driver support in .NET - so why NT8 ignored the chance to use that we dont know but ok lets do the right the thing for the NT dev community internally and externally...
SQL Express improved and could be use in full or if not only a partial install - SQL Local DB was brought around to work out the box and very easily and simply and natively... and will allow you to take WPF as it goes into Core and beyond and UMA and still be supported it works.... create any classic desktop project in windows it will use that... any asp.net it will use it... - unless you override the connection string etc...to MS Express or MS SQL etc
We can use side by side instances and use 1 query to join the NinjaTrader DB and get valuable data executions/orders/instruments even positions and do amazing things with it...
Non Technical/ Technical
If i cant appeal to the normal user who has no knowledge of the talk above hopefully the dev community will take interest in this matter and signal support for this common sense furture improvement. There surely must be a load of TSQL fans who know exactly what i mean - natively working with WPF etc - orders/executions - reports/technical all easy stuff -your trade performance report can be done in SQL statement - with some CTEs for example the rendered out to WPF - but with additional power and capability far beyond your data layer on that etc
Even more than MS Local DB - For for NT Ideally for me it would be a full version of MS SQL Express - so i could simply attach it to proper MS SQL Instance ok so fair enough 90% of people never heard of that. i could use Quantmod and various AI technologies and file system tables against linear tick with horizontal and vertical partitioning and caching and all sort of stuff a pure c# indicator developer has little idea of ;-)
>>>>Please vote for this if you want the very best platform and apps for NinjaTrader next versions!!! it will open the door to amazingness !!! or close it and go ahead with average joe technology and miss out on a new univers of power and creativity and developer productivity
There is no excuse - the code is already done or we dont know of that...change it!!! - This must be MS LOCAL DB!!!! this is the industry standard and most powerful option for .NET at an entry level...flavour!!!
sorry for my spelling ;-)
regards
Tom
Comment