Everybody! This is important. In a few days, these forums will be moving over to using the totally sweet Discourse platform. To ensure this migration happens smoothly with no loss of content, these forums are currently in a read-only mode. I do apologize for the inconvenience.

There is never a good time to turn the forums off for an extended period of time, but I promise the new forums will be a billion times better. I'm pretty sure of it.

See you all on the other side in a few days, and if you have any (non-technical) questions, please e-mail me at kirupa@kirupa.com. For technical questions, try to find a tutorial that corresponds to what you are looking for and post in the comments section of that page.

Cheers,
Kirupa

Results 1 to 11 of 11

Thread: PostgreSQL Vs. MySQL

  1. #1

    PostgreSQL Vs. MySQL

    Ok, so I want to know all the differences, I have both but am unsure about PostgreSQL, I have always used MySQL and when I tried PostgreSQL it was different, like in MySQL its database = top level then tables under it, but in PostgreSQL there were databases tables and schemes with tables in them.

    I feel like a n00b again

  2. #2
    just to expand a little, after exploring the phpmyadmin equivalent I have a few questions; how do I auto-increment values? What is the equivalent of Varchar?

  3. #3
    i don't know much about postgresql. my understanding is that postgresql has stability issues that generally mysql does not have. wikipedia has a nice comparison of RDBMS that might help: http://en.wikipedia.org/wiki/Compari...gement_systems

  4. #4
    well from the wiki comparison it seems PostgreSQL is better, the reason I started looking at Postgre is because I am learning django and it recommends Postgre above MySQL and so I want to be able to just use one instead of switching around.

  5. #5
    Yeah, I've tried to use PGSQL before, but have found it harder to install than MySQL. Funny you mention this all, because I was just reinstalling Django today, and trying to install PGSQL, but didn't succeed. Was wondering the same thing.

    I guess I'll give it another shot.


    K-Emmys-06: Best Footer; and K-Emmys-06: Most Active Member

  6. #6
    well, postgresql was designed first to have a lot of features. mysql was designed first to be fast. so they started at opposite ends of the spectrum and are moving towards being pretty similar in functionality and speed.

    i've always stuck with mysql for web work b/c i think there are more available resources. also, my opinion has always been that if it's good enough for Yahoo!, it's good enough for me.

  7. #7
    Yahoo! doesn't use Oracle? Hmm...


    K-Emmys-06: Best Footer; and K-Emmys-06: Most Active Member

  8. #8

  9. #9
    Ha, wow. That's neat.


    K-Emmys-06: Best Footer; and K-Emmys-06: Most Active Member

  10. #10
    @Nokrev, I managed to install it pretty easy, what went wrong?

    I guess ill just stick to MySQL, I have both anyway

  11. #11
    I couldn't figure out how to execute the client. Figured it out.


    K-Emmys-06: Best Footer; and K-Emmys-06: Most Active Member

Thread Information

Users Browsing this Thread

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

Posting Permissions

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

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012