Microsoft SQL vs MySQL - GoFuckYourself.com

stevo · 10-21-2007, 08:17 PM

In college I learned the basics of Microsoft SQL. Built some small databases and websites with ASP.net / Microsoft Visual Web Developer / etc.

Is Microsoft SQL a waste of time? Should i now focus on learning MySQL? Seems like everything runs on MySQL, why is that? Does ASP.net go well with MySQL or should i learn PHP? Is it easy learning MySQL if you know Microsoft SQL?

I just want to practice designing some simple database dependent websites.

Bro Media - BANNED FOR LIFE · 10-21-2007, 08:26 PM

php/mysql is where its at, son

GrouchyAdmin · 10-21-2007, 08:33 PM

MySQL is crap, but it's free. PHP is crap, but it's free.

You'll find now this correlates throughout every industry, however. You can still do some pretty amazing things with crap.

XTNBruno · 10-21-2007, 08:34 PM

Mysql all the way....this is not even a question.. you'll find 100x more support for your things

Nails · 10-21-2007, 09:43 PM

Development cost in Php/mysql is far less then php/mysql. Also sites used to be more stable if they ran on unix. Not sure if that's really true since I think Amazon & Amazon both run windows now.

Bird · 10-21-2007, 09:47 PM

just like everything else we learned in school, It's worthless in the real world.

dozey · 10-21-2007, 10:09 PM

Quote:

Originally Posted by GrouchyAdmin

MySQL is crap, but it's free. PHP is crap, but it's free.

You'll find now this correlates throughout every industry, however. You can still do some pretty amazing things with crap.

Bingo.

Don't touch PHP / MySQL unless you want to jump on the whole Linux Apache Mysql bandwagon. Despite all the hype caused by free open source products and so forth, they tend to suck, particularly the aforementioned language.

Unless you want to spend your time wallowing in filth, stick to the commercial enterprise grade stuff. Mssql, Asp / .NET.

stevo · 10-21-2007, 10:24 PM

Allright, installed MYSQL. Seems easy enough. I have the time, might as well learn both!

As in MSSQL, is there a 'Enterprise Manager' for MYSQL? A visual interface would be nice. Having to do everything in command line is boring/tedious.

SuckOnThis · 10-21-2007, 10:25 PM

Quote:

Originally Posted by dozey

Bingo.

Don't touch PHP / MySQL unless you want to jump on the whole Linux Apache Mysql bandwagon. Despite all the hype caused by free open source products and so forth, they tend to suck, particularly the aforementioned language.

Really? I've been running Linux/MySQL servers since 1998 and they couldnt have been more stable and would completely outperform any NT setup. I had one server that had an uptime of almost 3 years, show me an NT server that could do that.

stevo · 10-21-2007, 10:29 PM

Anything wrong with using ASP.net and MySQL? Would rather go that route then learning php. ASP is simple with a Visual Basic background.

dozey · 10-21-2007, 10:33 PM

Quote:

Originally Posted by stevo

Anything wrong with using ASP.net and MySQL? Would rather go that route then learning php. ASP is simple with a Visual Basic background.

If you were so inclined, there is MySQL Connector .NET.

martinsc · 10-21-2007, 10:44 PM

for websites - yes, myhspq and php are the way to go.
For serious Data ware house - MS SQL is way more stable and better performing than mysql or oracle.

pudcat · 10-21-2007, 10:51 PM

install mysql-query-browser for gui

dozey · 10-21-2007, 10:56 PM

Quote:

Originally Posted by martinsc

for websites - yes, myhspq and php are the way to go.
For serious Data ware house - MS SQL is way more stable and better performing than mysql or oracle.

I disagree, using PHP, there is no concept of framework / struts... much time is wasted trying to achieve some very simple things due to this absence, not to mention plain shortfallings of the language.

Unless it is something dead simple, PHP / MySQL just don't cut it.

Sansa · 10-21-2007, 11:06 PM

Quote:

Originally Posted by stevo

Allright, installed MYSQL. Seems easy enough. I have the time, might as well learn both!

As in MSSQL, is there a 'Enterprise Manager' for MYSQL? A visual interface would be nice. Having to do everything in command line is boring/tedious.

EMS MySQL Manager is the most amazing tool for working with MySQL. The Lite version is free.

10-21-2007, 08:17 PM	#1
stevo Confirmed User Join Date: Aug 2002 Location: Orlando, Florida Posts: 2,051	Microsoft SQL vs MySQL In college I learned the basics of Microsoft SQL. Built some small databases and websites with ASP.net / Microsoft Visual Web Developer / etc. Is Microsoft SQL a waste of time? Should i now focus on learning MySQL? Seems like everything runs on MySQL, why is that? Does ASP.net go well with MySQL or should i learn PHP? Is it easy learning MySQL if you know Microsoft SQL? I just want to practice designing some simple database dependent websites.

10-21-2007, 08:33 PM	#3
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	MySQL is crap, but it's free. PHP is crap, but it's free. You'll find now this correlates throughout every industry, however. You can still do some pretty amazing things with crap. __________________ AIM: GrouchyGfy

10-21-2007, 08:34 PM	#4
XTNBruno Confirmed User Industry Role: Join Date: Apr 2007 Location: Montreal Posts: 188	Mysql all the way....this is not even a question.. you'll find 100x more support for your things __________________ Bruno O. - Was in adult business years ago

10-21-2007, 09:47 PM	#6
Bird Confirmed User Join Date: Jan 2005 Location: Stockton Posts: 4,365	just like everything else we learned in school, It's worthless in the real world. __________________ ICQ:268731675

10-21-2007, 10:44 PM	#12
martinsc Too lazy to set a custom title Industry Role: Join Date: Jun 2005 Location: 127.0.0.1 Posts: 27,047	for websites - yes, myhspq and php are the way to go. For serious Data ware house - MS SQL is way more stable and better performing than mysql or oracle. __________________ Make Money

10-21-2007, 08:26 PM	#2
Bro Media - BANNED FOR LIFE MOBILE PORN: IMOBILEPORN Join Date: Jan 2004 Location: Tinseltown NL Posts: 16,502	php/mysql is where its at, son

10-21-2007, 09:43 PM	#5
Nails Confirmed User Join Date: Jun 2007 Posts: 262	Development cost in Php/mysql is far less then php/mysql. Also sites used to be more stable if they ran on unix. Not sure if that's really true since I think Amazon & Amazon both run windows now.

10-21-2007, 10:24 PM	#8
stevo Confirmed User Join Date: Aug 2002 Location: Orlando, Florida Posts: 2,051	Allright, installed MYSQL. Seems easy enough. I have the time, might as well learn both! As in MSSQL, is there a 'Enterprise Manager' for MYSQL? A visual interface would be nice. Having to do everything in command line is boring/tedious.

10-21-2007, 10:29 PM	#10
stevo Confirmed User Join Date: Aug 2002 Location: Orlando, Florida Posts: 2,051	Anything wrong with using ASP.net and MySQL? Would rather go that route then learning php. ASP is simple with a Visual Basic background.

10-21-2007, 10:51 PM	#13
pudcat Confirmed User Join Date: Mar 2003 Posts: 1,169	install mysql-query-browser for gui __________________ SUBMIT YOUR BABE GALLERIES PROMOTE YOUR BLOG HERE always looking for hardlinks icq #207011694 Thunder-Ball.net, good for hardlink exchanges