User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 374,021 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,789 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 16986 | Replies: 14
Reply
Join Date: Feb 2002
Posts: 175
Reputation: AlPhA is an unknown quantity at this point 
Rep Power: 7
Solved Threads: 1
AlPhA AlPhA is offline Offline
Junior Poster

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

  #1  
Feb 9th, 2002
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]
One day, we will die, when it comes...... i dunno, i'm not psychic!
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Feb 2002
Location: Long Island, NY
Posts: 1,134
Reputation: samaru is just really nice samaru is just really nice samaru is just really nice samaru is just really nice 
Rep Power: 12
Solved Threads: 2
Colleague
samaru's Avatar
samaru samaru is offline Offline
a.k.a inscissor

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

  #2  
Feb 9th, 2002
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
_.:: my websites ::._
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
Reply With Quote  
Join Date: Feb 2002
Posts: 175
Reputation: AlPhA is an unknown quantity at this point 
Rep Power: 7
Solved Threads: 1
AlPhA AlPhA is offline Offline
Junior Poster

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

  #3  
Feb 9th, 2002
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?
One day, we will die, when it comes...... i dunno, i'm not psychic!
Reply With Quote  
Join Date: Feb 2002
Location: Long Island, NY
Posts: 1,134
Reputation: samaru is just really nice samaru is just really nice samaru is just really nice samaru is just really nice 
Rep Power: 12
Solved Threads: 2
Colleague
samaru's Avatar
samaru samaru is offline Offline
a.k.a inscissor

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

  #4  
Feb 9th, 2002
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.
_.:: my websites ::._
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
Reply With Quote  
Join Date: Feb 2002
Posts: 2
Reputation: ffwd is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
ffwd ffwd is offline Offline
Newbie Poster

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

  #5  
Feb 10th, 2002
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 :
/join #betas on irc , the source for your betas
(XP | .net | officeXP | vs.net ...)
Reply With Quote  
Join Date: Feb 2002
Location: Long Island, NY
Posts: 1,134
Reputation: samaru is just really nice samaru is just really nice samaru is just really nice samaru is just really nice 
Rep Power: 12
Solved Threads: 2
Colleague
samaru's Avatar
samaru samaru is offline Offline
a.k.a inscissor

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

  #6  
Feb 10th, 2002
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.
_.:: my websites ::._
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
Reply With Quote  
Join Date: Feb 2002
Posts: 175
Reputation: AlPhA is an unknown quantity at this point 
Rep Power: 7
Solved Threads: 1
AlPhA AlPhA is offline Offline
Junior Poster

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

  #7  
Feb 11th, 2002
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.
One day, we will die, when it comes...... i dunno, i'm not psychic!
Reply With Quote  
Join Date: Feb 2002
Location: Long Island, NY
Posts: 1,134
Reputation: samaru is just really nice samaru is just really nice samaru is just really nice samaru is just really nice 
Rep Power: 12
Solved Threads: 2
Colleague
samaru's Avatar
samaru samaru is offline Offline
a.k.a inscissor

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

  #8  
Feb 11th, 2002
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.
_.:: my websites ::._
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
Reply With Quote  
Join Date: May 2002
Location: Tucson, AZ - formerly LI, NY
Posts: 613
Reputation: aeinstein is just really nice aeinstein is just really nice aeinstein is just really nice aeinstein is just really nice aeinstein is just really nice 
Rep Power: 12
Solved Threads: 8
Colleague
aeinstein's Avatar
aeinstein aeinstein is offline Offline
Team Member - aka kaynine

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

  #9  
Jun 11th, 2002
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......
"I do not feel obliged to believe that the same God who has endowed us with sense, reason, and intellect has intended us to forgo their use." - Galileo Galilei

"Science without religion is lame. Religion without science is blind." - Albert Einstein

"Good judgment comes from experience, experience comes from bad judgment." - author unknown

"Anyone who has never made a mistake has never tried anything new." - Albert Einstein

(why "aeinstein"?)

Peace Be with You
Reply With Quote  
Join Date: Feb 2002
Location: Long Island, NY
Posts: 1,134
Reputation: samaru is just really nice samaru is just really nice samaru is just really nice samaru is just really nice 
Rep Power: 12
Solved Threads: 2
Colleague
samaru's Avatar
samaru samaru is offline Offline
a.k.a inscissor

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

  #10  
Jun 11th, 2002
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.
_.:: my websites ::._
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb MS SQL Marketplace
Thread Tools Display Modes

Other Threads in the MS SQL Forum

All times are GMT -4. The time now is 11:19 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC