SQL Server vs MYSQL vs MSQL (i'm stopping now)

[AlPhA]

So...
what is better, SQL, MYSQL, MSQL, POSTRESQL, and etc for a fast database that must be used in conjunction with asp and php.

For now, i'm looking for the easiest database to be used in conjunction with ASP. Any suggestions?

[flash]http://www.geocities.com/cyberpitstop/footer.swf[/flash]

[samaru]

There's no doubt that if you use ASP, you want to go for SQL Server 7/2000. Contains a hell of a lot of features, including Triggers/Stored Procedures/and Text Indexing. SQL Server 2000 now can be used along side XML. It has a good learning curve, and the interface makes it a lot easier to grasp all the RDBMS concepts.

MySQL can't handle Stored Procedures or triggers yet, and it functions along the command line (like Oracle). (Although there are some GUIs out there for it.) MySQL is a good place to start though for PHP. It's free and reliable for personal apps. It's all pretty easy to use. From what I hear, PostgreSQL is only available on Unix/Linux types of machines, but there's a way around it using Cygwin.

If you want to start with an EASY database, I suggest using Access with ASP, unless you can afford SQL Server 2000 or Oracle 8i/9i. If you have any other questions, ask away.

Cheers

[AlPhA]

I'm using access now, it's madd ghetto. Slow as shit!

Also... say i have an asp page and it searches through an access database, would i just have to change the databaseconnection line (and maybe the sql string) to migrate to SQL server?

[samaru]

Depends. The transmission goes through ODBC, if you have it set that way, so syntax will be the same - unless of course you decide to change your table names or use features that are only part of SQL Server/Access.

[ffwd]

Hi!
Someone here sayd that if you can afford yourself, you can use SQL SERVER 7/2000.
well, it's realy doesnt metter, because most of web application developers doesnt realy host the sites, they just build it and use a web-hosting company that hosts their sites.

Most of these web-hosts uses Linux as there OS, so it's realy a question of what your hosting copmany uses, if it uses Linux/UNIX it will probably use mySQL otherwise with will be SQL Server, so my point is if your gonna target your Application to a specific Database Program (this case using ASP) target it to the Database your hosts use.

If you ask me ill write all my web application in JSP, using JDBC, but that's my choice.

Hope I could help, if you want you can email me ::)

[samaru]

That depends. A lot of web developing companies have their own servers, unless those companies are non-web related, and they choose another organization to host their site remotely. (This is usually the case for small business or starting business.)The best way I think is if you just go for an an application service provider that supports whatever you want. The only drawback is that you will not be in full control of the server, and you might need some additional tech support to see how they function, depending on the complexity of your application.

[AlPhA]

I don't care about the price, and about the hosting, i wanna do it at home. I want to learn how to setup and maintain web hosts and stuff like that.

[samaru]

If you don't care about the price, go to SQL Server 2000 on Windows 2000 Advanced Server. If you do decide to go cheap, go for MySQL on WinNT/Linux.

[aeinstein]

hmmmmmpppffffffffffff!!!!!!! i was just searching for webhosting co's that offered Oracle as the db - man, i couldnt find *ANYTHING* under a Franklin month!!!! whats up with THAT!!!! >:( i might have to go the MySQL route instead, but i think i'd b *VERY* unhappy w/that choice. my aim is to gain SQL skills within a bonifide (ie, corporate) db environ, e-commerce oriented yet affordable thru a hosting co. @ a hundred bucks (or more!) a month i might as well look into setting up my own direct-access webserver...... :(

[samaru]

I'm not surprise you didn't find any. Web hosting companies use MySQL because it's cheap. Oracle is usually available for corporate development, which means you're going to shell out more cash for a corporate web hosting company. If you want to gain "bonified" skills with a corporate db, I say go with SQL Server 2000 which is more common in web hosting companies than Oracle.

[aeinstein]

yeah, i'm not 2 happy w/that thought, but i agree - i try to avoid MS prods 4 the most part. i figure if i'm going 2 work @ becoming proficient at a prog, and its oriented towards a particular platform then i should learn the platform as well 2 make sure i can ferret out prog & OS issues. means i need to delve into Win2K land b4 i go the SQL route. unless, of course, BG decides to port it to Linux! 8)

[samaru]

Well, you don't have to be a Win2K Guru to be good. As long as you got a good SQL and relational db foundation, you're good to go with any database.

This is a really good SQL Server 2000 book. I have it and it'll get you up and running fast.

http://www.amazon.com/exec/obidos/ASIN/1861005237/ref=pd_sr_ec_ir_b/102-1094467-5582532

Here's a list of my reviews from Amazon.com on some of the books I've read.

http://www.amazon.com/exec/obidos/tg/cm/member-reviews/-/A2HEEBN9QJWP00/1/ref=cm_mp_rv/102-1094467-5582532

Check out my review of "Data Structures Via C++: Objects by Evolution."

[aeinstein]

just read all 14 reviews - i VERY much like ur style. seems to be honest (after all, i'm really NOT a mind reader) and definitely to the point! just about tripled my to-buy book list w/just 2 pages of surfing :D

[samaru]

I love controversial reviews. They always crack me up! ;)
Check this review out - it's on Jakob Nielsen's "Web Usability," which is a very popular book in the web community. I have to say that I disagree with a lot of his ideas. If you read this book, most of his statistics are pulled out of thin air... he uses words such as "Experts say that..." and "From my experience...."

http://www.amazon.com/exec/obidos/tg/stores/detail/-/books/156205810X/customer-reviews/4/ref=cm_rev_next/102-1094467-5582532?show=-submittime

This is the guy that shot down Flash and said it was a waste. He wrote a segment on his site. It's kind of humorous that just recently he had seconds thoughts AFTER he had a meeting with Macromedia, you can see the segment update on the botton of the page... (can someone say payoff?)

The link to that Flash segment:
http://www.useit.com/alertbox/20001029.html

I would respect/follow his ideas MORE if he was a graphic designer which he is not and he even admits on his site that he isn't. How can you criticize usebility if you're not a graphic designer and all pages deal with graphic design?

I agree more with the article Julie Meloni wrote for Webmonkey. She has her own thoughts on Jakob. Check it out.

http://hotwired.lycos.com/webmonkey/01/26/index1a.html?tw=commentary

[mikeSQL]

I don't care about the price, and about the hosting, i wanna do it at home. I want to learn how to setup and maintain web hosts and stuff like that.

LOL, I hear ya, Im a PHP Man myself and I run my server and sites from home using Cold Fusion, MSSQL and MySQL. Great for all I should say. But I personlaly think MySQL is better if your a Hard Scripter. If your 1 esy street like Microsoft, then go with ASP using ASP.NET. These, yes can be ran from your desktop srvers even if you wanted too. But again, these are my opinions.