3 ms·
Actually a lot of them do it's not hard to find some ticketing system or a call center management system that is written in JAVA or PHP and only works with mssq
by dogma1138 10y ago
Actually a lot of them do it's not hard to find some ticketing system or a call center management system that is written in JAVA or PHP and only works with mssql or oracle dbms.
The app stack is usually more platform agnostic than you think. Even if it's asp.net you most likely going to be able to run it or easily port it to .net core.
Basically having cross platform .net is pointless without having cross platform everything else especially MSSQL.
- tracker1 10y agoI was surprised how easy it was to get a couple asp.net apps running under docker dotnet-onbuild base containers... I think having SQL Server under linux/docker is a really nice option. Just being able to use it with ci/cd environments in linux is a pretty big thing. I've moved more away from the MS environments the past few years now, but have missed some of the things that MSSQL makes very easy, and by comparison PostgreSQL makes relatively hard. Of course you're paying for it. Having the option to run under Linux is really nice though imho.
- insulanian 10y ago> but have missed some of the things that MSSQL makes very easy, and by comparison PostgreSQL makes relatively hard. Could you give some examples?
- tracker1 10y agoNamely in the box replication and failover (like checkbox interaction via the GUI) compared to a hard to configure, or expensive to license add-on. IIRC geo indexing was easier in mssql, although much more configurable in pgsql. Not on pg, but linq to entities for .net is really nice, and the pg adapter (iirc) wasn't nearly as good. The node adapters for each are about equal though. Out of the box performance on mssql, and query performance in general was better last time I compared (admittedly about 2 years ago).