SitePoint Sponsor

User Tag List

Results 1 to 18 of 18
  1. #1
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question PostgreSQL hosting and more ?

    Hola folks..

    just got a few questions here..

    1. does anybody have any good links to paid hosting (virtual hosting, not dedicated) which supports postgresql ?

    2. what other GUI's is there for PostgreSQL, other than PGADMIN ? and are they worthwhile looking into ?

    Cheers!!

  2. #2
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Use this search to find some hosts with PostgreSQL
    http://www.hostsearch.com/s_power_u.asp

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  3. #3
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Thanks n' Cheers!

    Thanks mate...

    will take a look at it once an opportunity comes along.

    Cheers

  4. #4
    SitePoint Wizard
    Join Date
    Nov 2000
    Location
    Chico, Ca
    Posts
    1,125
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Whats the difference between PostgreSQL and MySQL?

    Advantages and disadvanages?



    Thanks

    Chuck
    "Happiness doesn't find you, you find happiness" -- Unknown
    www.chuckknows.com

  5. #5
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation PostgreSQL vs. MySQL

    Hey,

    My main reason for using PostgreSQL instead of MySQL is the fact that PostgreSQL doesn't lock the table when performing an UPDATE as MySQL does.

    Also, second reason is that MySQL isn't relational. Queing on MySQL is also worse than on PostgreSQL

    Cheers..

    any other issues...let me know

  6. #6
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation Ooops

    Forgot...

    need i mention phpMyAdmin vs. PGADMIN ?

    sorry

  7. #7
    SitePoint Wizard
    Join Date
    Nov 2000
    Location
    Chico, Ca
    Posts
    1,125
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    So if this is true .. then why does everyone use MySql ?


    Chuck
    "Happiness doesn't find you, you find happiness" -- Unknown
    www.chuckknows.com

  8. #8
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    easy to answer

    everybody isn't using MySQL - a lot of people are using it..My thought is that those that use it doesn't care for it's disadvantages or are ignorant of them.

    Also, phpMyAdmin is webbased...can't get any easier to set up whereas PGADMIN is client sided - requires a lot more work to setup and configure IF you wanted to use it as the prefered gui/db admin as a host.

    PGADMIN unfortunately also has a few bugs in it (which you learn to live with or work around) - it's a compiled program written in VB (yeah don't ask me why) and sometimes freaks out a bit (i can't run PGADMIN II on this machine for some reason). but once up and running it's a hell of a lot better way to manage your system

  9. #9
    SitePoint Columnist Skunk's Avatar
    Join Date
    Jan 2001
    Location
    Lawrence, Kansas
    Posts
    2,066
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Probably because mySQL runs on both Windows and *nix, making it far easier for people with windows machines to play around with and develop for. The soul reason I haven't switched from mySQL to Postgres is that I don't have a Postgres development server (yet), whereas I can install mySQL on my windows desktop and play with it there.

  10. #10
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Yup!

    Yeah Skunk i agree totally...

    you're pointing out quite a favorable issue for MySQL...should have remembered.


  11. #11
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i think i would prefer MySQL. especially 4.0, 4.1. check these pages in the MySQL manual that explains some differences:

    www.mysql.com/doc/C/o/Compare_PostgreSQL.html
    http://www.mysql.com/doc/M/y/MySQL-P..._features.html
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR

  12. #12
    Hi there! Owen's Avatar
    Join Date
    Jan 2000
    Location
    CA
    Posts
    1,165
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Another reason is that MySQL is significantly faster than PostgreSQL. (According to PC World -- they say mySQL using InnoDB is nearly as fast as Oracle for most tasks.) This makes it attractive for ISPs (low CPU usage) which subsequenly determines what we need to use.

    Owen

  13. #13
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Talking newts

    Well, I have to admit that i'm not sitting at the server and timing each db extraction/insertion on it but on a user level I haven't noticed any significant speed difference between the two dbs...none..nada...

    and that's on both large and small jobs...but then again, i'm not sure i'll notice the extra pico second passing by while it inserts the data or something.

    as long as it's faster than MS Access then i'm happy

  14. #14
    Perl/Mason Guru Flawless_koder's Avatar
    Join Date
    Feb 2002
    Location
    Gatwick, UK
    Posts
    1,206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    As per usual dopples - i'll push you in the direction of the text based console for linux - psql.


    Flawless
    ---=| If you're going to buy a pet - get a Shetland Giraffe |=---

  15. #15
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Talking Awwwwww - Cute!!!

    geee, thanks Flawlie....that's very considerate of you

  16. #16
    SitePoint Member
    Join Date
    Jun 2001
    Location
    Montreal, CAN
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    For administration, I use phpPgAdmin... A phpMyAdmin port to Postgres....
    Quite useful.

    For the differences between the two... MySQL is faster than Postgres for single queries (personnaly tried that on my Sun SparcStation10). But when u need multi-threading db, Postgres quickly become faster. Postgres is the way to go when u have a lot of transactions to your db...

    ....gb

  17. #17
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by Ghost-B
    But when u need multi-threading db, Postgres quickly become faster.
    actually, MySQL is the multi-threaded one. Postgres is multi-process. (i knew what you meant, though. ) communicating between threads is much faster than between processes. this is part of the reason why MySQL is so fast. with multi-threading, though, the OS's thread library has to be good (Linux/Solaris).


    BTW, one of the things that sounds nasty about Postgres to me, as mentioned in the link i posted above, is the need to VACUUM the database a lot? that doesn't sound very good to me (especially for something like a forum system). you don't really have to do much maintenance with MySQL.

  18. #18
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    no problems yet

    BTW, one of the things that sounds nasty about Postgres to me, as mentioned in the link i posted above, is the need to VACUUM the database a lot? that doesn't sound very good to me (especially for something like a forum system). you don't really have to do much maintenance with MySQL.
    I've used postgresql for quite some time now (commercially only though) for both large and small projects and I have yet to find a need to vacuum the db at all. we do regular backups of it but haven't had to vacuum it at all.

    For any redundant data in the db we've written a small cron to take care of it when needed, though that's mainly happening on client request and not on a need-to-basis.

    ???????
    * Due to the last tax raise our prices has risen
    * - answers w/o thought $1 - answers w/ thought $3
    * - correct answers $10
    * - Dumb stares are still free


Bookmarks

Posting Permissions

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