Find the answer to your Linux question:

View Poll Results: best database

Voters
9. You may not vote on this poll
  • MySQL

    4 44.44%
  • PostgreSQL

    2 22.22%
  • Others(cant think of any more)

    3 33.33%
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11
what do you think is the best database server software. i have heard good things about both. but have only really messed with postgres. and i was wondering which one ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Engineer big_k105's Avatar
    Join Date
    May 2003
    Location
    Fargo, ND
    Posts
    901

    what do you think is the best database server software.


    what do you think is the best database server software. i have heard good things about both. but have only really messed with postgres. and i was wondering which one i should use to mess with.
    BIG K aka Kyle
    Programming Forums
    www.kylekonline.com
    Please don\'t PM me for help-- ask in the forums instead!

  2. #2
    Linux Guru
    Join Date
    Apr 2003
    Location
    London, UK
    Posts
    3,284
    Oracle is well respected in heavy duty business applications, but MySQL & PostgreSQL can perform as well, both have there good and bad points.

    MySQL generally scores highly on speed and flexability, while PostgreSQL has a more developed SQL langauge, event triggers and referential integrity which can be enforced on the database server itself.

    I think it's like all things, work out what you are going to do and what it needs BEFORE you commit to a technology/platform to build it on.

    This site run's on MySQL and i have no complaints, it serves it's purpose, which at the end of the day is the target.

    Jason

  3. #3
    Linux Engineer big_k105's Avatar
    Join Date
    May 2003
    Location
    Fargo, ND
    Posts
    901
    does MySql come with slackware and if so what do you all have to do to get it set up and running.

    edit: well i guess i know its on there cause i located it but how would i go about setting it up.
    BIG K aka Kyle
    Programming Forums
    www.kylekonline.com
    Please don\'t PM me for help-- ask in the forums instead!

  4. #4
    Linux Guru
    Join Date
    Apr 2003
    Location
    London, UK
    Posts
    3,284
    1) forget what is on the slackware CD' its already out of date.
    2) Download 4.1 binaries from http://www.mysql.com/downloads/mysql-4.1.html
    3) setup instructions here: http://www.mysql.com/doc/en/Installing.html

    Jason

  5. #5
    Linux Engineer big_k105's Avatar
    Join Date
    May 2003
    Location
    Fargo, ND
    Posts
    901
    how many files do i download jst the standard or do i have to get max and debug aswell

    edit: i guess debug is only an option when you download the source but im not that into linux quite yet. but what other files should id get
    BIG K aka Kyle
    Programming Forums
    www.kylekonline.com
    Please don\'t PM me for help-- ask in the forums instead!

  6. #6
    Linux Guru
    Join Date
    Apr 2003
    Location
    London, UK
    Posts
    3,284
    just the standard should do.

    Basically they have been compiled differently (you are downloading pre-compiled binaries, not source code unlike most other apps). The standard version is ok for most common use. the "large"/"big" version has been compiled especially to handle a very high load, ie, super-duper busy websites, and the debug im not too sure about, but i would guess it is for testing or problem solving.

    Jason

  7. #7
    Linux Engineer big_k105's Avatar
    Join Date
    May 2003
    Location
    Fargo, ND
    Posts
    901
    J, how did you install MySQL like did you go with the RPM or the tar.gz im jst curious to which way you did it since im using slackware. or for anyone else that has installed mysql on slack.
    BIG K aka Kyle
    Programming Forums
    www.kylekonline.com
    Please don\'t PM me for help-- ask in the forums instead!

  8. #8
    Linux Guru
    Join Date
    Apr 2003
    Location
    London, UK
    Posts
    3,284
    I used the .tar.gz

  9. #9
    Just Joined!
    Join Date
    Apr 2003
    Location
    Australia & England
    Posts
    75
    I use Oracle at work at the moment, but I really like Sybase ASE.
    If you want a free one, don't know, I haven't used Postgres, and only played around with MySQL, but MySQL seems easy to install, setup and run.

  10. #10
    Linux Engineer big_k105's Avatar
    Join Date
    May 2003
    Location
    Fargo, ND
    Posts
    901
    well i got MySQL all installed and working now i jst need to read alittle more about it and i can start using it. this is awsome
    BIG K aka Kyle
    Programming Forums
    www.kylekonline.com
    Please don\'t PM me for help-- ask in the forums instead!

Page 1 of 2 1 2 LastLast

Posting Permissions

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