Which kind of SQL database do you use?

Discussion in 'PHP/MySql' started by chococheese, May 10, 2010.

Remove these ads by signing in
Remove these ads by signing in
  1. chococheese New Member

    Member Since:
    May 4, 2010
    Message Count:
    234
    Likes Received:
    13
    Occupation:
    Network Administrator
    Location:
    VA, USA
    Which kinds of SQL databases do you use/have you used? Most people use MySQL because its simple to use, free, widely compatible, and included with most hosting accounts. Other common alternatives to MySQL are PostgreSQL, MSSQL, Oracle, Firebird, and SQLite. I mainly use MySQL for my projects because of its availability and ease of use. At work, I run an MSSQL server. As most of you know, its a Microsoft commercial product. I do like MSSQL because of the amount of tools you have at your fingertips when administrating a MSSQL server. You also generally have direct physical access to your database server so you can perform your backups very frequently and quickly.
    Back onto the topic of MySQL, for those who don't know, you can actually download and install it on your own computer. This is useful if you want to create a testing environment that you can use before putting your content up live on the internet. You could also utilize MySQL on your local system if you really want to use your own PC as a web server.
    I will get discuss that subject a bit more at a later time, but in the meantime, what database software do you use? Have you ever branched out and tried other database software?
  2. Adam H Administrator

    Member Since:
    Jan 7, 2008
    Message Count:
    2,807
    Likes Received:
    162
    Occupation:
    Web Developer
    Location:
    Norfolk Uk
    I must admit im not really one that has played around with hosting in's and outs so ive stuck with MySQL ever since i started in the game. At first i found MySQL hard enough to grasp so moving to something else would be like a mild heart attack for me lol . What benefits or what reasons would there be to use another database other than MySQL ? Is there anything specific ?
  3. chococheese New Member

    Member Since:
    May 4, 2010
    Message Count:
    234
    Likes Received:
    13
    Occupation:
    Network Administrator
    Location:
    VA, USA
    PostgreSQL has some additional features not included in MySQL. I believe Postgre supports subqueries while MySQL doesn't. I think there are some other differences between the features but I am not all that familiar with those differences. The main thing I hear about MySQL is that many of it's new features have been around in Postgre for much longer (stability). I'm sure its not a deal breaker to most people but some database admins find these features vital. MySQL was designed with speed in mind while Postgre was designed with advanced features in mind. Because of that, I often hear from people that MySQL runs faster than Postgre. MSSQL offers probably some of the most advanced tools for managing triggers and procedures. I generally notice though that MSSQL is slower than MYISAM tables in MySQL since it was designed to be lightweight and fast. Another thing to consider is compatibility. Pretty much all forum software supports MySQL but most don't support the other databases. vBulletin only supports MySQL. IPB only supports MySQL and MSSQL but charges an extra $75 for the MSSQL driver. On the other hand, phpBB supports MySQL, PostgreSQL, MSSQL, Firebird, SQLite, and Oracle.
    1 people like this.
  4. jaikanth12 Member

    Member Since:
    Jan 9, 2010
    Message Count:
    490
    Likes Received:
    9
    i use MYSQL data base to perform operations The main thing I hear about MySQL is that many of it's new features have been around in Postgre for much longer (stability) i found MySQL hard enough to grasp so moving to something else would be very much ugly as this is the best database.
  5. jphilipson New Member

    Member Since:
    May 8, 2010
    Message Count:
    46
    Likes Received:
    1
    When it comes to performance, MySQL will trump Postgres every time.
  6. chococheese New Member

    Member Since:
    May 4, 2010
    Message Count:
    234
    Likes Received:
    13
    Occupation:
    Network Administrator
    Location:
    VA, USA
    That seems to be the general consensus. And it really shows in the way how MySQL is the most popular database available. Supposedly Postgre has gotten quicker than it used to be, but if you truly want a fast, lightweight and easy to use database, MySQL appears to be the most prevalent choice.
  7. jphilipson New Member

    Member Since:
    May 8, 2010
    Message Count:
    46
    Likes Received:
    1

    Also, only one of them is a true RDMS, guess which one? Can't find the link to the article I read a while back, but MySQL crushed MSSQL and other big DB engines in performance tests, and was only a tiny bit slower than Oracle.
  8. chococheese New Member

    Member Since:
    May 4, 2010
    Message Count:
    234
    Likes Received:
    13
    Occupation:
    Network Administrator
    Location:
    VA, USA
    Have you ever used Oracle? It is pretty much the only one of those systems I haven't used at some point in time yet but I heard its very solid.
  9. jphilipson New Member

    Member Since:
    May 8, 2010
    Message Count:
    46
    Likes Received:
    1
    I haven't used Oracle, just see it mentioned in the comparisons.
  10. chococheese New Member

    Member Since:
    May 4, 2010
    Message Count:
    234
    Likes Received:
    13
    Occupation:
    Network Administrator
    Location:
    VA, USA
    Ah ok. I might give it a try one of these days to get a first hand look at how it compares to the rest.
  11. vBDiscussions New Member

    Member Since:
    Jan 20, 2010
    Message Count:
    75
    Likes Received:
    2
    Different types of SQL db's? i've only used the most common one, MySQL.
  12. mahesh2010 New Member

    Member Since:
    Jun 15, 2010
    Message Count:
    119
    Likes Received:
    0
    Location:
    USA
    My sql is a best backend process for any projects...because it not only serves for microsoft products but also it supports with other technologies one of them is php which is widely used now...because it is faster than other technologies...combined with this both php and mysql a better and best projects can be done .....for more best projects and other cms technologies ...check out by just clicking below the message....
  13. PradeepKr New Member

    Member Since:
    Aug 16, 2010
    Message Count:
    22
    Likes Received:
    0
    I have worked with MySQL till now and now want to write a code which can run on MySQL as well as Oracle.
    Is it possible? If yes what things I need to care about. Any tutorials?
  14. SeoKungFu Active Member

    Member Since:
    Jul 10, 2009
    Message Count:
    604
    Likes Received:
    77
    Occupation:
    SEO Ninja
    Yes, in the past working for some banks and telecoms. Actually Oracle fits mainly for high-load, high-demand, high-end corporative environment with its robustness and high scale reliability. And there is no reason - cost and resource-wise - to use it for a web project, unless you'll be running next Facebook or PayPal.
    As you said PostgreSQL has the needed enhancements ( subqueries, triggers, stored procedures and the like ) while fitting in the price/resource mid-niche ( free/lightweight ).
  15. misterromeo New Member

    Member Since:
    Sep 13, 2010
    Message Count:
    16
    Likes Received:
    0
    I'm using Mysql. I know only about mysql. Don;t know others
  16. paullopez Member

    Member Since:
    Nov 5, 2010
    Message Count:
    316
    Likes Received:
    6
    Occupation:
    Sales & Marketing
    Location:
    Newark, DE, US
    Re:

    Hi

    I am using MySQL and if I wan to select alternative I would like to opt PostgreSQL. According to my knowledge, MySQL is believed to be faster than PostgreSQL, but developers seem to prefer PostgreSQL when it comes to variety of features, since MySQL is seen as basic, and well suitable for novice like me :) The person who use Oracle also tend to prefer PostgreSQL.

    Actually both have an astonishing range of features that increase data integrity, functionality, and performance. However MySQL is slightly popular between different open source web development packages and that the reason my vote goes to MySQL. However, PostgreSQL has more popularity in experienced developers Community, specially those who willing to work with Oracle and SQLServer experience.

Share This Page