couple of web hosting questions (plz help)

[ukemike]

Hi i got a couple of questions about web hosting. I would like your opinion on.

First of all a database question.

1) Is SQL Oracle specific?
Or can it be used on Access and FoxPro

2) In school they taught us that using oracle is good for when many people use it, and that Access is not good if there is more than like 10 people connected to it. Well, when i look at some sites (cuz im looking for web hosting company), they say that they have Access to use. How does this work??? Is this only for less than 10 people to be able to access your database at a time or what?.

3) What is the different between SQL and MySQL???


Ok any answers/opinions on those answers i would really appreciate.
Thank you
Mike

[Khalid Ali]

Q1.
No SQL is not Oracle specific.
And yes it can be used with any other database,however,some databases might have some prpriterty commands.such as MS Access does have few,but overall a simple sql statement is true for any other database

Q2.
Webhosting companies may not use Oracle becuase its very expansive.

Q3.
SQL is programming language where as MySQL is a RelationalDBMS

The best part with MySQL is that its pretty good and fee...

[PeOfEo]

It also depends on what languages the server is running. If you are on a ms platform you are going to be using sql server, not mysql or oracle.

[Khalid Ali]

Originally posted by PeOfEo
If you are on a ms platform you are going to be using sql server, not mysql or oracle.

Thas not true,All company's where they care for the data,and where the data is too important,regardless of what OS they are using they all use Oracle Databases.Of course small company's who can not afford Oracle they could use any other DBMS including MS one's

[ukemike]

So if i want to know SQL your pretty good with all the databases around right???

thanx
mike

[ukemike]

I thought that Access was not good with more than 10 users. Our teacher taught us that its not good at all as s server database.

[Khalid Ali]

Yes if you are very good at SQL,you typically ok for all the databases(except for the MS one's,since they have some rather drastic proprietary syntax),but a typical SQL statement should work for most of the database programs.

Access database from Office 2000 onwards is not too bad at all.But whats stopping you from using MySQL?..just curious

[Ribeyed]

hi,


I thought that Access was not good with more than 10 users. Our teacher taught us that its not good at all as s server database.


Your teacher is corerct with Access only handling 10 users maximum at any one time, but remember this is concurrent users. All 10 users have to be accessing Access concurrently for it to cause problems/ fall over.

[PeOfEo]

Originally posted by Khalid Ali
Thas not true,All company's where they care for the data,and where the data is too important,regardless of what OS they are using they all use Oracle Databases.Of course small company's who can not afford Oracle they could use any other DBMS including MS one's I meant that if you are on a ms platform you are going to be using asp or asp.net for your server side language and those go hand in hand with sql server. You may use oracle but saying the sql server is cheaper, I dont know, oracle may be expencive but sql server is pretty pricy its self (somewhere over $1,000) Also sql server is a pretty darned good data base. What is the advantage to using oracle, security?