Can I go with MySQL database ?

Posted on 2012-08-30
Last Modified: 2012-08-30
I have a old website (daily news, blogs, tamil stories portal) running in linux , php, postgresql database. now we're finding difficult to maintain the db changes as well as server maintenance, also to do coding with php.  because we use mostly MySQL now a days.

Hosting  person also suggesting to go with MySQL db instead of Postgresql db.  Initially , I've done simple php coding with postgresql stuff on the old site.

Now, I am planning to do with CodeIgniter and Mysql.

Can I go with postgresql db or change to mysql db?

Will mysql support large data storing as like Postgresql?

Will support Unicode function as like Postgresql ?

Please suggest.
Question by:Loganathan Natarajan
    LVL 107

    Accepted Solution

    The short answer is "Yes" to all the questions.  Make your test cases carefully.  In my experience, you can do everything with MySQL that you can do with PostGreSQL, and more.  For example, PHPMyAdmin is much better than the PostGreSQL counterpart.

    So my counsel is "Go for it!"
    LVL 49

    Assisted Solution

    by:Julian Hansen
    There are many out there who would argue that PostGres is a better database engine than MySQL specifically for more data intensive opperations.

    MySQL has a bigger support community and is more widely supported by various hosting providers.

    MySQL should support everything you need but it is difficult to say without knowing more about your application which one is more suited to your particular requirements.

    Both products have matured over the past few years and each have their pros and cons. Which one to choose would be based on your specific environment, your application, and your expectations.

    My advice is define criteria you need from your application (performance, functionality, scalability) and then measure those against each of the databases.

    There is plenty of supporting info out there to fill in any gaps you may have on specific comparison between the two.
    LVL 36

    Author Comment

    by:Loganathan Natarajan
    Exactly, I too thinking. Thank you very much Ray!!!!  .. Let me wait others comments too please.
    LVL 42

    Assisted Solution

    by:Chris Stanyon
    Because of the way CodeIgniter handles databases, your code will work for either. If you want to switch from one to the other, you simply change one line in your config file (dbdriver). You won't need to change your code :)

    Makes testing the two side-by-side really simple.
    LVL 36

    Author Closing Comment

    by:Loganathan Natarajan
    I've decided to go with MySQL.
    LVL 107

    Expert Comment

    by:Ray Paseur
    Thanks for the points and best of luck with the project.  I think MySQL still has a few years left (and I hope I am right). Warm regards, ~Ray
    LVL 36

    Author Comment

    by:Loganathan Natarajan
    Thanks Ray, This is the portal, I am going to automate.

    It is my region language and it was built in year of 2001.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
    Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit ( and similar technologies have enjoyed wide adoption, making it possib…
    Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now