HI
Which one is better ? As per you point of view ! I would Like to choose MySQL for my PHP based web site .
Regards
Jeremy
Printable View
HI
Which one is better ? As per you point of view ! I would Like to choose MySQL for my PHP based web site .
Regards
Jeremy
Some more details on what you are using them for would help.
If it is for a PHP site then I would go with MySQL, as it is much easier to work with and is cheaper.
SQL is an acronym for Structured Query Language - which as the name inplies is a language for querying databases. My SQL is an open source implementation of the SQL language and includes a number of database engines that it will work with. MySQL is quite powerful, integrates extremely well with php (what php was designed for) and with teh Apache open source webserver. For what its worth, the HEXUS forums run under MySQL, php and apache.
There are other databases (Oracle is probably the best know) that also use SQL, and there are commercial versions of SQL, such as Microsoft's SQL server which work with it. Acess can also be interrogated with SQUL.
If you want to stay open source, then the popular combinations are LAMP (Linix, Apache, MySQL, PHP) which while discrete applications can usually be downloaded pre-compiled and integrated for a particular linus distribution. Otherwise if you really want to customise the set up you can compile the source code to include/exclude the features you want/dont want. If you are using a windows platform, you can download a package called WAMP which includes the Apache, MySQL and PHP applications already integrated and with minimial configuration gives you a fully functions webserver ready for whatever CMS system you want to put on top of it.
http://www.wampserver.com/en/
http://www.mysql.com/downloads/mysql/
http://www.php.net/
http://www.apache.org/
MySQL will be fine, but the reality is for a simple site it's not going to matter which you choose.
May be worth a look into some sort of abstraction layer for your code, which will allow you to change the SQL server easier at a later date - or give the user a chocie of dbase servers to use.
Make sure it's a system thats fairly regularly updated however!
The "worst" problem Ive found is that not all SQL servers are the same.Quote:
Originally Posted by DavidM
Using ODBC, on Windows at least, you can in theory write once and use for various different databases underneath.
In theory only though.
Ive found that SQL, MySQL and, if insane, Access MDBs, all have various syntax differences.
Most of this occurs in table creation but some occurs when querying tables too.
Exactly my point. :)
I'm part of a project that has a lot of inherited code - written for use purely under Php & MySQL. Now this isn't a bad thing, but while enhancing the legacy code - it means we have to work out ways for programers who like to use raw SQL code (not always a good idea!) and getting it to work under an abstraction method.
Hi
As per my experience MySQL is more familiarized towards the selection display, update, and recording of data is really simple in this form but it is not strong when it comes to delete or insert data. But when I want to search all clients in database, the MySQL works really good for it.
Regards
Jeremy
I can second that - I know Postgres hasn't been mentioned yet but we've done some benchmarking with MySQL and Postgres. The benchmarks were carried out a few years apart on the latest stable builds for each DB platform available at the time. These were repeated on both Windows and Linux. MySQL won each time for selects - although the gap is closing now. For inserts and updates though Postgres came out on top both times. I might have the relative figures around somewhere if anyone's interested.Quote:
Originally Posted by jeremyc
As it happens we actually run most of our stuff on MS SQL.
It really depends what your going to be hosting it on and how hard you expect the box(es) to get hit as well. For out-the-box support though I would say MySQL is far more widely used with PHP than MS SQL.
http://www.goarticles.com/cgi-bin/showa.cgi?C=3140479Quote:
Originally Posted by jeremyc
http://www.articlerich.com/Article/A...Hosting/919193
HI
That was my post ! I am bit more curious about MySQL and SQL severs advantages. So that is the reason I am asking opinions.
Regards
Jeremy
The post you wrote has two hosting links in it which happen to match your homepage link.Quote:
Originally Posted by jeremyc
You're spamming, a mod has already picked up on it in your other nonsensical post - have a read of his reply.
Hi buddy !
But that is a article directory Okay, and they allow links in post. And, in this forum I never mentioned any links or company name in my post ! I just want to know what people thinks about this, because it is important for my knowledge. And if I break any guidelines of this forum then I would like to offer my apologies for this.
Regards
Jeremy
Quote:
Originally Posted by mycarsavw