SQL Server 2000 And MySQL

[Morgoth]

I am confused with a little bit of this. Is MySQL and a SQL server 2000 that I have been hearing about the same thing or not?

Can I use BOTH to store information using ASP and PHP?
Which is better, what's the differance?

Anyone have a site I cna look at?

Thank you.

[oracleguy]

MySQL and msSQL Server 2000 do basically the same thing, yes. They are from to diffrent companies, and the cost is very diffrent. And you can use either to store info from PHP or ASP.

MySQL (www.mysql.com) is a free product. Used commonly with Apache because msSQL is not compatible with Linux. The system requirements are not too high for it either. It is a quite versital product and free is always good. I know PC Magazine did a comparison between several database server solutions sometime in the last year. Maybe you can find the article on their website. (www.pcmag.com)

MsSQL (http://www.microsoft.com/sql/default.asp) is not a free product. It can be very expensive, especially if it is for web use because then there is a diffrent licensing type that isn't cheap. However MsSQL offers things like publishing to other servers and such. The system requirements, especially RAM, can be quite high if you have real time data being feed into them. I know from personal experience. I do not know how well MySQL works with handling massive real time data. Even though, Microsoft claims that you only need a 166MHz CPU, that like other MS system requirements is unrealistic. You can barely get Windows 2000 Server run on that. Muchless a high end database product. You'd probably want at least dual P2 450's and a couple gigs of RAM for optimum performance.

Both databases use SQL (structured query language) to run queries on them.

Hope that helps.

[raf]

what oracleguy said +
MySQL and PHP have a sort of tight relation. If you use PHP, then MySQL will probably your db-format of choice. PHP has a lot of MySQL functions that make it a lot easier to work with this database, and that provide extra info for errorhandeling and about the tables and variables. Stuff you don't have with, let's say MsAccess.

I think that the combination PHP-MySQL-Apache is probably the best choice to build app's with industrial strenght (or almost) on a shoestring budget.
Also, an experienced programmer will code faster using PHP than using ASP

But of coarse, there are more developersjobs that require knowledge of the commercial versions (Oracle, MsServer2000, ASP, IIS, ...
(Personally, i'm rewriting some ASP-Access-stuff in a PHP-MySQL versions, because MySQL is certainly way better for app's that require multiple user acces to a database. In stead of learning asp.net, i'm at the moment sticking with asp for the smal stuff + take PHP for the apps that require something more.)

[Morgoth]

I don't know the big statistics and everyone has opinons with what is better, PHP and ASP.
I only started to learn ASP because I have a basic knowledge in VB at that time. I would love to be able to use both lanugages fluently, but that takes time, and that would mean I would have to take up some C++ aswell.

But as for databases, I hear MS Access is very much not good for many users at a time, and I might use MySQL, the problem is, it's very complicated in some areas, and if there was anyway I could create an MySQL database the same way I create an mysql database, with all the tables and such, I WOULD LOVE TO SEE IT!
A complete (almost) copy of Ms Access but for MySQL servers, yummy.

The best think for me to do, I guess is keep using Ms access and learning more ASP until I receive a problem, and am forced to switch to MySQL.
I know it would be better to use MySQL now, to prevent any problems, but I just can't do it that way. I can't!

Is there a linux version of MySQL at all?

[allida77]

Access is really not meant for a large number of users. If you want a trial copy of MS SQL 2000 server then go here:
http://www.microsoft.com/sql/evaluation/trial/default.asp

I hope you have cable or dsl because the download is huge.

MS SQL is very easy to use and install.

Links ( my google skills are weak this morning only found one):
http://www.pcmag.com/article2/0,4149,7279,00.asp

[raf]

Morgoth,

I'm seriously thinking about writing a web-interface for MySql databasemanagement, as sort of a test-application on your webserver. I'll let you know when it's done. (could take some weeks before i find the time)

Meanwhile, there are already a lott of MySQL client softwaretools you can use.

look hear for what my spider came up with:
http://search.megaspider.com/XP.html?MySQL+client

or one of them that looks interesting:
http://www1.overture.com/d/sr?xargs=02u3hs9yoaRSuWGFOUWpqYXFYDpAAC1YsS8kqLUnNs01OLEzILUlNKi1OLEIu51hkZWjpaOJm6mbo4m5o5Qrgz7EtWz E7Py7Qrzk1MySvNyFEErQWZhHZlb6BwAo8cRExqZkiqbgGtuBg5GTubWroauqi7AAHzhZ4y

[Morgoth]

Hum. I guess soon, I will switch to an SQL server. And I guess it'll be MySQL, because it's easy fast, and FREE.

But I will need a DB client to do manual editing.

[oracleguy]

You could also use PHPMyAdmin, thats what I use for managing my MySQL databases.

Raf, why do you think that you can program faster in PHP than ASP? I'm not trying to start a flame war over which one's better, its just impossible to ever come to such a conclusion. There is no way to measure the speed of the two.

[Morgoth]

oracleguy, that's what I am using at the moment.


Raf, why do you think that you can program faster in PHP than ASP?

I am not sure, but maybe it is an opinion about himself. Frankly, I can script ASP better and faster then PHP.

[raf]

oracleguy,
i bought a great assesmenttool for it. it's called a watch ;)
seriously, the code is more powerfull and has far more build in functions. This results in fewer codelines to write yourself. especially when editing files, creating immages, working with db and stuff like that.

writing functions yourself is something else. it's slower, but less limited then doing it in asp.

also, the fact that it's open source, it's also expanding quicker (more people adding new functionsa nd setting them free)

and it's not only my opinion. most book on PHP say the same:D