WEB MySQL vs. PostgreSQL

Discussion in 'OT Technology' started by daneeyah, Oct 19, 2007.

  1. daneeyah

    daneeyah Guest

    What are the major differences in terms of syntax between these two?

    :dunno:
     
  2. Nakon

    Nakon Guest

  3. RaginBajin

    RaginBajin Have you punched a donkey today?

    Joined:
    Dec 24, 2001
    Messages:
    8,740
    Likes Received:
    0
    Location:
    NoVA
    Take a look at the date on that article. That article is wayyyyy old.

    Mysql 5.1 which is in RC right now, has triggers, data partitioning as well as row level replication. It's really has developed into a major and competent data storage application.

    But really this is one of those Ford vs Chevy type of arguments. The syntax is pretty much the same with just a couple of differences but not much.
     
  4. Dnepr

    Dnepr Guest

    PostGRES is nice for GIS :drool:
     
  5. RaginBajin

    RaginBajin Have you punched a donkey today?

    Joined:
    Dec 24, 2001
    Messages:
    8,740
    Likes Received:
    0
    Location:
    NoVA
    Why is that?

    Side Note: What type of work do you do with GIS?
     
  6. Dnepr

    Dnepr Guest

    Well for one its very fast ( compared to ESRI stuff ) and its free.

    Hmn.. I just did a bit of research, I guess MySQL supports GIS extensions as well.

    PG makes it all so easy and fast though.

    I guess crap on a stick > ESRI.


    I do work with Bus routes, stops, etc.
     
  7. daneeyah

    daneeyah Guest

    Thanks everyone for your help :wavey:

    Do you guys mind giving me a quick example of how you would write something in postgressql and then the same statement in mysql?
    Any simple statement in which I can see the syntax difference.

    Thanks :)
     
  8. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    Years ago, MySQL was a "entry-level" website database solution mildly above Microsoft Access.

    However, now, MySQL is a competent mid-grade product.

    Not gonna compete with DB2 or Oracle at the high-end, but for most people, it's a great product.
     
  9. rtfm

    rtfm omgwtfbbq

    Joined:
    Oct 26, 2004
    Messages:
    5,043
    Likes Received:
    0
    Location:
    Canada
    I've always worked with MySQL just because it seems to be more widely supported and easier to use with PHP.
     
  10. RaginBajin

    RaginBajin Have you punched a donkey today?

    Joined:
    Dec 24, 2001
    Messages:
    8,740
    Likes Received:
    0
    Location:
    NoVA
    Basic CRUD is the same through out. It's going to be special functions that show up in each of the respective databases.. What exactly are you trying to do?
     

Share This Page