Announcement

Collapse
No announcement yet.

MySQL vs. Postgresql

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Inhanse
    replied
    Hmmm.... This article is rather interesting, but not so far I found rather interestng articled about MySQL here too: http://phpforms.net/tutorial/tutorial.html

    Leave a comment:


  • MattR
    replied
    Sybase ASE documentation is here:
    http://manuals.sybase.com/onlinebook...ew;pt=asg1200e

    Leave a comment:


  • fastforward
    replied
    The documentation for Oracle can be viewed on-line at http://technet.oracle.com . You have to register, but it's free. You can also access their trial download area with the same login.

    I'm starting to get problems with mysql on my boards now. It crashes once a month. The worst part is the length of time it takes to repair the tables. I'm guessing it will only get worse as the tables get bigger. I'd go to innodb, but I need to buy a bigger hard drive first. I couldn't believe how much extra space innodb needs .

    Leave a comment:


  • Wayne Luke
    replied
    Hmmm. The complete documentation for Oracle comes on several CD's... 10 if I recall correctly.

    However you can get the gist of it from their reference CD which is only 492 megabytes. Don't think you can download it though.

    Anyway, I have personal experience with Oracle, Sybase and Ms-SQL Server.

    The query syntax for Sybase and MS-SQL Server are pretty much the same. However Oracle's is completely different.

    Leave a comment:


  • chrispadfield
    replied
    www.dbforums.com is the place to start your search.

    Leave a comment:


  • Woody
    replied
    I don't know of a site that does off hand. You could go to the home page for each database and scan the docs.

    Leave a comment:


  • Billy
    replied
    Is there any site that shows the differences in query syntax between the major RDBMS's(pgSQL,msSQL,mySQL,oracle,sybase).

    Leave a comment:


  • Chris Schreiber
    replied
    Originally posted by Sinecure
    I have been doing a lot of comparing and contrasting for which one is better.
    Same here.... technically speaking, I am convinced PostgreSQL is better... however there have been some severe limitations and speed issues in the past, but with each new release they seem to be getting much better. For most sites with less traffic, MySQL seems to be a better choice most of the time.

    Leave a comment:


  • Sinecure
    replied
    Well I am hoping that perhaps there will be versions in the future for postgreSQL. I have been doing a lot of comparing and contrasting for which one is better.
    vB guys always do whats right

    Leave a comment:


  • etones
    replied
    newer versions of postgre wipe the floor with the ailing MySQL... its a fact

    Leave a comment:


  • JamesUS
    replied
    I'm good at MS SQL (and have a license as well ). I'm not a developer though.

    Leave a comment:


  • Kaizen
    replied

    Leave a comment:


  • Chris Schreiber
    replied
    Originally posted by Kaizen
    Is there anyone on vbulletin (developers) that knows how to use these alternative databases ?
    There sure are

    Leave a comment:


  • Kaizen
    replied
    Is there anyone on vbulletin (developers) that knows how to use these alternative databases ?

    Leave a comment:


  • George L
    replied
    Originally posted by Lynn
    But look at another article written a little more recently by the same author:

    http://www.phpbuilder.com/columns/tim20001112.php3

    I see the tide turning toward PostGreSQL every where I look/read, and therefore I think it should be a high priority for vBulletin developer's to make vBulletin support PostGreSQL.
    wow bringing back a thread that's over 1 yrs old

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X