Nuts
Ask HN: Would you consider running SQL Server on Linux?
31–40 of 90 posts
Re: Ask HN: Would you consider running SQL Server on Linux?
#32"Would you?" Of course.
"Will you?" Of course not.
Re: Ask HN: Would you consider running SQL Server on Linux?
#33No, almost certainly not. Why would I use MSSQL in the first place, when I could just use PostgreSQL? The main reason I could see to use MSSQL would be "you're in a Windows shop already", and if that isn't the case, I don't see much reason for it.
I would have said the same thing if I had never used MSSQL.
PG just doesn't have the same quality SQL-dialect or tools as MSSQL though. Some very basic facilities are missing from PG like snapshot and transaction logs, batched triggers and being able to return multiple resultsets from a single trip to the database server.
Even the free tools for SQL Server are better than anything you can get for PG and there's nothing like SQL Server Data Tools.
Re: Ask HN: Would you consider running SQL Server on Linux?
#34I actually have been running SQL Server for linux for the past few months. In a docker container, no less. This is entirely for testing a part of our application that needs to connect to legacy mssql servers. The server is spun up, databases are created programmatically, tests are run, and then the container is destroyed. As for running this in production, ahahaha no.
so is your apprehension because of sql server on linux, or because of docker, or because of the combination of the two? this post is snarky but lacks real information.
Re: Ask HN: Would you consider running SQL Server on Linux?
#35Probably not.
We use SQL Server for our product running on AWS and we tested it with the Linux edition and it works fine.
But what’s the advantage of moving it over to Linux. It’s anyway sitting on a dedicated box and Windows Server hosting charges are only marginally more expensive than Linux on AWS(depending on the AZ you use).
So it’s cool and works well but there’s no compelling reason for us to move to it yet. At least not one that I could see
Re: Ask HN: Would you consider running SQL Server on Linux?
#36I would consider using it because: 1. I work in a backwards enterprise shop where "no one ever got fired for choosing Microsoft" and it would be easier (read as "possible) to get IT here to support it than Postgres. (That said, they do support Mongo internally but won't admit that to software teams) 2. It's much cheaper than Oracle, which is the other "enterprise" database where it's easier to get an install done 3.…
Can you elaborate on point 3? If the argument is ideological, I get it. I'm more interested in the technical argument.
There is another argument for or against adoption of Oracle and that is a basic business argument. Oracle is expensive and their virtualization costs are well above Microsoft.
Re: Ask HN: Would you consider running SQL Server on Linux?
#37I would consider using it because: 1. I work in a backwards enterprise shop where "no one ever got fired for choosing Microsoft" and it would be easier (read as "possible) to get IT here to support it than Postgres. (That said, they do support Mongo internally but won't admit that to software teams) 2. It's much cheaper than Oracle, which is the other "enterprise" database where it's easier to get an install done 3.…
Can you elaborate on point 3? If the argument is ideological, I get it. I'm more interested in the technical argument.
Not the OP, but licensing comes to mind. MSSQL licensing and Windows Server licensing are a pain, especially in virtualized environments. But Oracle? The word predatory - complete with claws and fangs - comes to mind.
Re: Ask HN: Would you consider running SQL Server on Linux?
#38Related question. Where can i run and host a SQL db for free? Or for cheap. It's for a hobby project.
For a hobby project, you can probably use whatever is running the rest of your project. Sqlite in particular is lightweight.
If you need hosting, I've heard good things about Digital Ocean, Vultr, and Linode. You'd have to install the database yourself though.
Re: Ask HN: Would you consider running SQL Server on Linux?
#39Related question. Where can i run and host a SQL db for free? Or for cheap. It's for a hobby project.
Depends on the hobby. You can run one on your desktop, or if you are using a web host they most likely include database as part of the plan.
Re: Ask HN: Would you consider running SQL Server on Linux?
#40No, almost certainly not. Why would I use MSSQL in the first place, when I could just use PostgreSQL? The main reason I could see to use MSSQL would be "you're in a Windows shop already", and if that isn't the case, I don't see much reason for it.
I would have said the same thing if I had never used MSSQL. PG just doesn't have the same quality SQL-dialect or tools as MSSQL though. Some very basic facilities are missing from PG like snapshot and transaction logs, batched triggers and being able to return multiple resultsets from a single trip to the database server. Even the free tools for SQL Server are better than anything you can get for PG and there's nothi…
How is the JSON integration and geometry primitives? I had no idea it was competitive with postgres.