Categorized | News

MySQL/PHP Dynamic Duo Days Numbered?

Posted on 03 July 2003 by Demian Turner

Strange that none of the PHP sites are mentioning this, but now that the future of PHP working closely with MySQL is less bright than it was before MySQL’s recent licensing policy change, developers are starting to look for alternatives.

I didn’t even know that Postgres ran reliably well on windows without Cygwin until yesterday. And after seeing how easy it was to install I wish I’d tried it ages ago:

  • triggers
  • functions
  • PL/pgSQL
  • views
  • transactions
  • mmm …

I went straight to download pgMyAdmin after setting up but mysteriously this brother of phpMyAdmin seems to have disappeared from the web.

CORRECTION: name is everything, I should have tried remembering the name right: phpPgAdmin

Of course I would develop on linux if my damned laptop would run it! After trying somewhere around 9 of the latest distros I gave up, something with Packard Bell keyboard drivers that doesn’t go down well.

Unless something changes drastically it looks like a lot of us are going to be busy porting our apps to PostgreSQL.

Bookmark and Share

7 Comments For This Post

  1. essig Says:

    phpPgAdmin is available and still being actively developed at http://sourceforge.net/projects/phppgadmin/.

    In you’re running Linux, I recommend using Red Hat’s Postgres Administrator. Screenshots are available at http://sources.redhat.com/rhdb/tools.html#Administrator.
    It’s still beta and you have to install it from CVS. Once you have it installed, it works really well. See http://sources.redhat.com/rhdb/cvs.html.

    If you’re installing Postgres for the first time, you should remember to setup a cron to regularly VACUUM and ANALYZE you database. VACUUM reclaims disk space and ANALYZE improves performance by looking at the structure of your data. Don’t expect fast performance without running ANALYZE.

    George Essig

  2. demian Says:

    cool, thanks for the tips. was thinking of using up my Amazon gift certificates for this one 😉

  3. dougholt Says:

    Maybe I’m a newbie but I don’t get the rush away from MySQL. I read the new licensing agreement at http://www.mysql.com/products/licensing.html and didn’t see anything out of the ordinary.

    2. Free use for those who never copy, modify or distribute
    As long as you never distribute (internally or externally) the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL or other OSI approved license or not.

    (my italics added)
    Well I don’t “copy, modify or distribute” MySQL so what seems to be the problem?


    Watch This Interactive

    Multimedia & PHP/MySQL Development

  4. demian Says:

    The implications of the MySQL relicensing are worse than they first appear, this becomes apparent as you make your way through the thread I listed in the article, people like Rasmus Lerndorf have stepped out to comment.

    Rather than labour through the thread again let me quote from an interview of MySQL guru Zak Greant in this month\’s PHP Magazine:

    <snip>
    Derick Rethans: What about people selling PHP scripts which use MySQL, into which of the groups do they fall?

    ZG: If someone is distributing scripts under a closed license that uses MySQL, then they are creating a combined work that includes GPL-licensed software. They should purchase a proprietary license.

    If they are selling access to a site or service that uses proprietary code, but they are not distributing the application, then they are free to use GPL-licensed code.

    DR: Will this exception affect distribution only, or usage too?

    ZG: If you do not distribute, you will not breach the terms of the GPL. The exception is only needed for distributed code.

    </snip>

  5. dougholt Says:

    Well, I guess that put\’s a damper on distribution, but as long as I can develop propietary code for my clients and am not distributing the code in any way, my usage is still legal, which is what I\’m concerned about. At this time it is much more difficult to find affordable hosting with Postgres db available, and few applications already developed. But I\’m sure the community will quickly move over as soon as more hosting providers provide this option. Thanks for the prompt response.


    Watch This Interactive
    Multimedia & PHP/MySQL Development

  6. demian Says:

    Hi Doug

    Watch out for the *loose* description of distribution, it\’s very easy to fall into that cateogory. There are more descriptions if you have the patience to go through the thread I mentioned in the article.

    Reading the PEAR lists I can tell you many developers are moving away from MySQL so it must be serious. If you\’re using a db abstraction layer like PEAR::DB or ADOdb switching over won\’t be too bad. Regarding hosting, any linux root account comes with Postgres, and there are a lot of tools including webmin that make it very easy to manage.

    For hosting i use http://johncompanies.com/ which if you can get the open source special, works out at very cheap @ $45/mnth (see bottom of page). Split that between two people and you\’ve got a massive 40 GB transfer and all the luxury a root linux account provides 😉

  7. demian Says:

    there’s an interesting update to this saga at Sterling Hughes’ weblog:

    http://www.edwardbear.org/blog/archives/000217.html

Leave a Reply

Categories

Books

Demian Turner's currently-reading book recommendations, reviews, favorite quotes, book clubs, book trivia, book lists

Facebook