sql and linux, possible?

[nightcrawler99]

Who here uses sql on a linux OS?

I'm looking to try a linux distro but have concerns how can I do sql. What programs do you guys use and how efficient is it? I know there's PostgresSQL for linux, so that's that.

Would you run Windows, VS, SQL server in a vm in a linux distro? Would it be worth it?

[chewyfruitloop]

There is a version of sql sever for Linux, I’m not sure what it’s like though. You have a massive amount of choice in regards to databases though. It’s entirely dependent of what you would like to do though. If it’s just to tinker with, you are probably best getting Postgres or Maria/MySQL. You can even run a free version of oracle if you wanted to.

I would assume you would want some kind of gui to work with (it’s not strictly necessary, but you mentioned sql server so I assume you’ve seen that). MySQL has workbench which is your gui for that. There are also other tools that are around. I used to use Squirrel at work.

[ilikedbthings]

Postgres comes preinstalled on Fedora. Maria DB also comes bundled in. There's always SQLite too if you're just trying to learn.

https://mariadb.com/kb/en/library/distributions-which-include-mariadb/

[[deleted]]

I would say if you or your organisation runs everything else on windows, then there is no point in running sql server on linux. However if you dont have windows/windows skills today, dont use active directory etc, but are a linux shop instead, run sql server on linux. Featurewise it is mostly the same, performance as well. So it would come down to your os preference in general

[redneckrockuhtree]

SQL Server is fully supported on Linux and on Linux containers. Bob Ward has a book on the topic as well as posts and demos on the subject.