MS Local DB for NinjaTrader - vote for this for the best next version

[MicroTrends]

NinjaTrader next version DB.


(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

[MicroTrends]

Links

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-2017

SQL Server 2017 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications.

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

[MicroTrends]

>>>i wrote that bit quickly -ideally the full version of MS Express if not then SQL Local DB should be sufficient and if we can use that for NinjaTrader it will be amazing and will be 1000 times better than SQL Compact Edition... that is a fact

[NinjaTrader_Kate]

Hello MicroTrends,

Thank you for your post.

I have submitted this request to our developers for consideration and it may be tracked under SFT-4117. While not every request will make it into future versions of the platform, our developers do take each into consideration.

Please let us know if we may be of further assistance to you.

[MicroTrends]

Hello MicroTrends,

Thank you for your post.

I have submitted this request to our developers for consideration and it may be tracked under SFT-4117. While not every request will make it into future versions of the platform, our developers do take each into consideration.

Please let us know if we may be of further assistance to you.

We live in Hope - MYSql will do - as 2nd place it will be a lot better than current for sure X 10000000% -but it will miss a whole universe of capability with the MS SQL flavour... and the only acceptable argument was rollout and support headaches - cured by lcoal db... :-) The work around is we suck data out of MYSQL into the real deal TSQL technology side by side - clunky but works.

NOTE: for SQL if the dev's thought it was contention locking MYSQL was better at that is resolved in 2008 by this in TSQL before each SQL Select:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

So whatever avenue is traversed we can look forwards to a 10000000% X more reliable platform as far as application data is concerned :-)


Final question: Where can we view these tracked items - tracked under SFT-4117?

thank for your time

best


Tom

[NinjaTrader_Kate]

Hello MicroTrends,

Thank you for your reply.

There is no publicly viewable tracking system for feature requests as they are considered and handled internally. However, you may inquire here on the forums or by writing directly into platform support about the status of a feature request. However, be aware we don't get updates on these very regularly as the platform gets updated every few months on average.

Please let us know if we may be of further assistance to you.