Results 1 to 13 of 13

Thread: MySQL or SQL

  1. #1
    Registered User
    Join Date
    Jul 2010
    Posts
    11
    Thanks
    0
    Thanked
    0 times in 0 posts

    MySQL or SQL

    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

  2. #2
    PHP Geek Flash477's Avatar
    Join Date
    Dec 2008
    Location
    Devon
    Posts
    822
    Thanks
    51
    Thanked
    72 times in 65 posts

    Re: MySQL or SQL

    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.

  3. #3
    The late but legendary peterb - Onward and Upward peterb's Avatar
    Join Date
    Aug 2005
    Location
    Looking down & checking on swearing
    Posts
    19,378
    Thanks
    2,892
    Thanked
    3,403 times in 2,693 posts

    Re: MySQL or SQL

    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/
    (\__/)
    (='.'=)
    (")_(")

    Been helped or just 'Like' a post? Use the Thanks button!
    My broadband speed - 750 Meganibbles/minute

  4. #4
    HEXUS webmaster Steve's Avatar
    Join Date
    Nov 2003
    Posts
    14,283
    Thanks
    293
    Thanked
    841 times in 476 posts

    Re: MySQL or SQL

    MySQL will be fine, but the reality is for a simple site it's not going to matter which you choose.

  5. #5
    Moderator DavidM's Avatar
    Join Date
    Jan 2005
    Posts
    8,779
    Thanks
    802
    Thanked
    252 times in 234 posts

    Re: MySQL or SQL

    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!

  6. #6
    Senior Member
    Join Date
    Jun 2008
    Posts
    1,495
    Thanks
    2
    Thanked
    143 times in 119 posts
    • BobF64's system
      • Motherboard:
      • Asus P8Z77-V Pro
      • CPU:
      • Intel Core i7-3770K
      • Memory:
      • 16GB Corsair XMS3 PC3-12800
      • Storage:
      • Multiple HDD and SSD drives
      • Graphics card(s):
      • ASUS DUAL-GTX1060-06G
      • PSU:
      • 750W Silverstone Strider Gold Evolution
      • Case:
      • Silverstone Fortress FT02
      • Operating System:
      • Windows 10 x64 Pro
      • Monitor(s):
      • HP ZR24w

    Re: MySQL or SQL

    Quote Originally Posted by DavidM View Post
    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.

    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.

  7. #7
    Moderator DavidM's Avatar
    Join Date
    Jan 2005
    Posts
    8,779
    Thanks
    802
    Thanked
    252 times in 234 posts

    Re: MySQL or SQL

    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.

  8. #8
    Registered User
    Join Date
    Jul 2010
    Posts
    11
    Thanks
    0
    Thanked
    0 times in 0 posts

    Re: MySQL or SQL

    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

  9. #9
    Senior Member
    Join Date
    Dec 2005
    Location
    ::1
    Posts
    204
    Thanks
    4
    Thanked
    9 times in 8 posts
    • chinny's system
      • Motherboard:
      • Asus P5Q-EM
      • CPU:
      • Intel E6300
      • Memory:
      • 4Gb Corsair XMS2
      • Operating System:
      • Win7 x64

    Re: MySQL or SQL

    Quote Originally Posted by jeremyc View Post
    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.

    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.

  10. #10
    ɯʎɔɐɹsɐʌʍ mycarsavw's Avatar
    Join Date
    Feb 2007
    Posts
    4,945
    Thanks
    1,097
    Thanked
    653 times in 482 posts
    • mycarsavw's system
      • Motherboard:
      • P8H77-M Pro
      • CPU:
      • i5 3350P
      • Memory:
      • 16Gb
      • Storage:
      • Lots
      • Graphics card(s):
      • R9 285
      • PSU:
      • HX 620w
      • Case:
      • FD Define Mini
      • Operating System:
      • W10
      • Monitor(s):
      • BenQ G2420HDBL + GL2450HT
      • Internet:
      • Sky

    Re: MySQL or SQL

    Quote Originally Posted by jeremyc View Post
    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
    http://www.goarticles.com/cgi-bin/showa.cgi?C=3140479

    http://www.articlerich.com/Article/A...Hosting/919193
    |Kata: "Read title as 'fisting'. Not sure why I clicked. Relieved, really."|
    |TAKTAK: "It was so small that mine wouldn't fit into it"|

  11. #11
    Registered User
    Join Date
    Jul 2010
    Posts
    11
    Thanks
    0
    Thanked
    0 times in 0 posts

    Re: MySQL or SQL

    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

  12. #12
    ɯʎɔɐɹsɐʌʍ mycarsavw's Avatar
    Join Date
    Feb 2007
    Posts
    4,945
    Thanks
    1,097
    Thanked
    653 times in 482 posts
    • mycarsavw's system
      • Motherboard:
      • P8H77-M Pro
      • CPU:
      • i5 3350P
      • Memory:
      • 16Gb
      • Storage:
      • Lots
      • Graphics card(s):
      • R9 285
      • PSU:
      • HX 620w
      • Case:
      • FD Define Mini
      • Operating System:
      • W10
      • Monitor(s):
      • BenQ G2420HDBL + GL2450HT
      • Internet:
      • Sky

    Re: MySQL or SQL

    Quote Originally Posted by jeremyc View Post
    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.

    You're spamming, a mod has already picked up on it in your other nonsensical post - have a read of his reply.
    |Kata: "Read title as 'fisting'. Not sure why I clicked. Relieved, really."|
    |TAKTAK: "It was so small that mine wouldn't fit into it"|

  13. Received thanks from:

    peterb (03-08-2010)

  14. #13
    Registered User
    Join Date
    Jul 2010
    Posts
    11
    Thanks
    0
    Thanked
    0 times in 0 posts

    Re: MySQL or SQL

    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 View Post
    The post you wrote has two hosting links in it which happen to match your homepage link.

    You're spamming, a mod has already picked up on it in your other nonsensical post - have a read of his reply.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help connecting to a remote MySQL server...
    By chicken in forum Software
    Replies: 10
    Last Post: 27-11-2007, 11:52 AM
  2. Replies: 17
    Last Post: 15-07-2007, 03:59 PM
  3. MySQL extension for PHP 5.2.3 not working
    By Jerrythafast in forum Help! Quick Relief From Tech Headaches
    Replies: 18
    Last Post: 13-06-2007, 08:03 PM
  4. Moving website (inc. SQL) between two servers.
    By unrealrocks in forum Software
    Replies: 11
    Last Post: 31-01-2006, 10:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •