4 ms·
> Ship 2.0 is two parts, a hybrid Cocoa/ObjC/CoreData/JavaScript/React application that runs on your Mac, and a C#/MSSQL/Orleans server that runs in Azure. Oh,
by koolba 10y ago
> Ship 2.0 is two parts, a hybrid Cocoa/ObjC/CoreData/JavaScript/React application that runs on your Mac, and a C#/MSSQL/Orleans server that runs in Azure. Oh, and a little bit of glue written in Python running on AWS lambda. Yes, it's truly an unholy alliance.
What compels someone to write a net new application (from scratch with no legacy DB) that uses MSSQL?
In my book it's in front of only DB2 and Oracle on the "Will not use unless you're already using it, migration is impossible, and you're going to have to seriously pay me to deal with this" list.
- kogir 10y agoWe can agree to disagree, but the tooling has definitely saved me enough time to be worth it. That and realistically, no matter the DB chosen, you either use DB specific features or leave performance (often substantial) on the table.
- koolba 10y ago> We can agree to disagree, but the tooling has definitely saved me enough time to be worth it. What specifically are you referring to (regarding tooling)? Do you mean running it on Azure as a managed service that auto scales, programming tools/frameworks like LINQ, or client side GUI tools? From an automation perspective not having a decent CLI for MSSQL to facilitate scripting makes it a pain from day one.
- kogir 10y agoSSMS is pretty great, especially for digging into query plans and deadlock graphs. Same for SQL Server Profiler. We use Database projects in Visual Studio, so all our schema, stored procedures, and other scripts are in version control. We can compile them (additional validation) into dacpac packages, and script updates and deployment to local instances and Azure with sqlpackage and sqlcmd.
- shortstuffsushi 10y agoThe one real downside here is that you're tying your users to Windows. If you had a more "pluggable" db layer, they could use the platform of their choice. That said, the code is in C# as well (and not .NET core, from what I saw), so they're pretty tied to Windows anyway, which is awkward since this is a macOS app.
- nohant 10y agoYou mean back-end developers right? Because users are not tied to Windows, as they do not need to install the server side of the app...
- shortstuffsushi 10y agoYes, I meant the backend. Apparently I misread the part where this is a SaaS product, I thought you could host the backend.
- joshuahornby 10y agoCare to expand what makes MYSQL so bad?
- kjbflsudfb 10y agoOP mentions MSSQL (Microsoft SQL Server), not MySQL.
- koolba 10y agoMSSQL = Microsoft SQL Server : https://en.wikipedia.org/wiki/Microsoft_SQL_Server https://en.wikipedia.org/wiki/Microsoft_SQL_Server MySQL = https://en.wikipedia.org/wiki/MySQL https://en.wikipedia.org/wiki/MySQL