Question Hosting Cos and Mysql & Postgresql

Kenneth wrote:

 > I don't understand, both databases are free, easy to compile and install so
 > why is it that hosting compnaies, by and large, do not also offer PostgreSql
 > along with Mysql.

MySQL has a reputation for being faster and lighter. However, it also
doesn't support very complex queries (yet), so you can often achieve in
PostgreSQL in one query what might take several in MySQL.

I'm guessing that one of the main reason so many hosting companies offer
MySQL is that phpMyAdmin is so much better than phpPgAdmin.

Personally I run both here -- PostgreSQL for my own use and MySQL for
testing things that are going to be hosted elsewhere. At work, I use
PostgreSQL exclusively.

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ <a style='text-decoration: underline;' href="http://tobyinkster.co.uk/contact" target="_blank">http://tobyinkster.co.uk/contact</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Question Hosting Cos and Mysql & Postgresql 

On 2004-09-08, Toby Inkster <usenet200409.DeleteThis@tobyinkster.co.uk> wrote:
 > Kenneth wrote:
 >
  >> I don't understand, both databases are free, easy to compile and install so
  >> why is it that hosting compnaies, by and large, do not also offer PostgreSql
  >> along with Mysql.
 >
 > MySQL has a reputation for being faster and lighter. However, it also
 > doesn't support very complex queries (yet), so you can often achieve in
 > PostgreSQL in one query what might take several in MySQL.

One reason why we wanted to use Postgresql. I think, overall, Postgresql
will prove faster.

 >
 > I'm guessing that one of the main reason so many hosting companies offer
 > MySQL is that phpMyAdmin is so much better than phpPgAdmin.

IMHO, not a very good reason, however, I don't run a hosting service.

 > Personally I run both here -- PostgreSQL for my own use and MySQL for
 > testing things that are going to be hosted elsewhere. At work, I use
 > PostgreSQL exclusively.

Will finish installing Postgresql this weekend on the development computer,
hopefully, I'll get better times than I'm currently getting with MySQL.

ken<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Question Hosting Cos and Mysql & Postgresql 

On 2004-09-08, Matthias Gutfeldt <say-no-to-spam DeleteThis @gmx.net> wrote:
 > Kenneth wrote:
  >> I don't understand, both databases are free, easy to compile and install so
  >> why is it that hosting compnaies, by and large, do not also offer PostgreSql
  >> along with Mysql.
  >>
  >> Is there problem with Postgresql?
 >
 > Not at all. MySQL is just more popular, perhaps due to better marketing.
 >
 > Here's an interesting article that compares the two DBs:
 ><http://www.databasejournal.com/features/mysql/article.php/3288951>
 >
 > Compare the feature sets of both DB's and choose what's right for the
 > job at hand - one time it might be MySQL, next time it might be
 > PostgreSQL. Who cares what you use as long as the job gets done.
 >
 >
 > Matthias
 >

Thanks for the links, some info there I didn't realize.

Again, thanks.

ken<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Question Hosting Cos and Mysql & Postgresql 

"Kenneth" <Kenneth.TakeThisOut@nowhere.special> wrote in message
news:slrncjtddl.oh7.Kenneth@localhost.localdomain...
 > I don't understand, both databases are free, easy to compile and install
so
 > why is it that hosting compnaies, by and large, do not also offer
PostgreSql
 > along with Mysql.
 >
 > Is there problem with Postgresql?
 >
Nope - But - most hosting cos clients are -generally- more cognisant with
web design than they are with programme use, particularly of the nix
variety. Therefore MySql is the obvious choice, simple to use, not too
complex and relatively easier to admin.

Also, and this is likely more relevant to most hosts, MySql and PhP are
excellent stable mates. they work extremely well together<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Question Hosting Cos and Mysql & Postgresql 

On 2004-09-08, Bill Logan <kiwienzed.DeleteThis@clear.net.nz> wrote:
 >
 > "Kenneth" <Kenneth.DeleteThis@nowhere.special> wrote in message
 > news:slrncjtddl.oh7.Kenneth@localhost.localdomain...
  >> I don't understand, both databases are free, easy to compile and install
 > so
  >> why is it that hosting compnaies, by and large, do not also offer
 > PostgreSql
  >> along with Mysql.
  >>
  >> Is there problem with Postgresql?
  >>
 > Nope - But - most hosting cos clients are -generally- more cognisant with
 > web design than they are with programme use, particularly of the nix
 > variety. Therefore MySql is the obvious choice, simple to use, not too
 > complex and relatively easier to admin.

Seriously, Postgresql is more difficult to admin? I wasn't aware of that
issue. However, I did find a hosting service that offers both Mysql and
Postgresql.

Thanks for the info.

ken<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Question Hosting Cos and Mysql & Postgresql 

Kenneth wrote:

 > Seriously, Postgresql is more difficult to admin?

Personally I find it easier. Probably because I've been using it longer,
but there are some things that just seem a lot more sensible admin-wise:

* Very easy wizards to create and drop users and databases:
  - /usr/bin/createuser
  - /usr/bin/createdb
  - /usr/bin/dropuser
  - /usr/bin/dropdb

* It authenticates users based on their system login, so they don't have
to use any password when connecting to their own databases.

* The psql command line interface is very user-friendly (as command-line
FTP interfaces go) has good a help function.

* pg_dumpall is a very easy method of backing up and restoring your entire
database.

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ <a style='text-decoration: underline;' href="http://tobyinkster.co.uk/contact" target="_blank">http://tobyinkster.co.uk/contact</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Question Hosting Cos and Mysql & Postgresql 

On 2004-09-08, Toby Inkster <usenet200409.TakeThisOut@tobyinkster.co.uk> wrote:
 > Kenneth wrote:
 >
  >> Seriously, Postgresql is more difficult to admin?
 >
 > Personally I find it easier. Probably because I've been using it longer,
 > but there are some things that just seem a lot more sensible admin-wise:
 >
 > * Very easy wizards to create and drop users and databases:
  > - /usr/bin/createuser
  > - /usr/bin/createdb
  > - /usr/bin/dropuser
  > - /usr/bin/dropdb
 >
 > * It authenticates users based on their system login, so they don't have
 > to use any password when connecting to their own databases.
 >
 > * The psql command line interface is very user-friendly (as command-line
 > FTP interfaces go) has good a help function.
 >
 > * pg_dumpall is a very easy method of backing up and restoring your entire
 > database.
 >

Thanks for the additional info. I've been going over the manual, off and
on, thoughout the day. I really don't see any special problems.

I'm looking forward to giving the DB a good test drive over the weekend.

Again, Thanks

ken<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Question Hosting Cos and Mysql & Postgresql 

"Toby Inkster" <usenet200409 DeleteThis @tobyinkster.co.uk> wrote in message
news:pan.2004.09.08.20.20.12.50922@tobyinkster.co.uk...
 > Kenneth wrote:
 >
  > > Seriously, Postgresql is more difficult to admin?
 >
 > Personally I find it easier. Probably because I've been using it longer,
 > but there are some things that just seem a lot more sensible admin-wise:
 >
 > * Very easy wizards to create and drop users and databases:
 > - /usr/bin/createuser
 > - /usr/bin/createdb
 > - /usr/bin/dropuser
 > - /usr/bin/dropdb
 >
 > * It authenticates users based on their system login, so they don't have
 > to use any password when connecting to their own databases.
 >
 > * The psql command line interface is very user-friendly (as command-line
 > FTP interfaces go) has good a help function.
 >
 > * pg_dumpall is a very easy method of backing up and restoring your
entire
 > database.
 >
Sorry Toby, I was refering to ease of admin for a novice or person not too
familier with DBs. Even then mainly because MySql is less -complex?'
(although some would say lower functionality - but I dont want to go there
<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Question Hosting Cos and Mysql & Postgresql 

Bill Logan wrote:

 >
 > "Toby Inkster" <usenet200409.TakeThisOut@tobyinkster.co.uk> wrote in message
 > news:pan.2004.09.08.20.20.12.50922@tobyinkster.co.uk...
  >> Kenneth wrote:
  >>
   >> > Seriously, Postgresql is more difficult to admin?
  >>
  >> Personally I find it easier. Probably because I've been using it
  >> longer, but there are some things that just seem a lot more sensible
  >> admin-wise:
  >>
  >> * Very easy wizards to create and drop users and databases:
  >> - /usr/bin/createuser
  >> - /usr/bin/createdb
  >> - /usr/bin/dropuser
  >> - /usr/bin/dropdb
  >>
  >> * It authenticates users based on their system login, so they don't
  >> have to use any password when connecting to their own databases.
  >>
  >> * The psql command line interface is very user-friendly (as
  >> command-line FTP interfaces go) has good a help function.
  >>
  >> * pg_dumpall is a very easy method of backing up and restoring your
 > entire
  >> database.
  >>
 > Sorry Toby, I was refering to ease of admin for a novice or person not
 > too familier with DBs. Even then mainly because MySql is less
 > -complex?' (although some would say lower functionality - but I dont
 > want to go there
 >

Why not? Is it controversial?

FWIW, I agree with you about Postgres/MySql

--
William Tasso - read 'em, else the puppy gets it:
<a style='text-decoration: underline;' href="http://www.aww-faq.org/" target="_blank">http://www.aww-faq.org/</a>
<a style='text-decoration: underline;' href="http://www.catb.org/~esr/faqs/smart-questions.html" target="_blank">http://www.catb.org/~esr/faqs/smart-questions.html</a>
<a style='text-decoration: underline;' href="http://groups.google.com/groups?as_ugroup=alt.www.webmaster" target="_blank">http://groups.google.com/groups?as_ugroup=alt.www.webmaster</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Question Hosting Cos and Mysql & Postgresql 

"William Tasso" <SpamBlocked.DeleteThis@tbdata.com> wrote in message
news:Xns955F62236466WilliamTasso@130.133.1.4...
 > Bill Logan wrote:
 >
  > >
  > > "Toby Inkster" <usenet200409.DeleteThis@tobyinkster.co.uk> wrote in message
  > > news:pan.2004.09.08.20.20.12.50922@tobyinkster.co.uk...
   > >> Kenneth wrote:
   > >>
   > >> > Seriously, Postgresql is more difficult to admin?
   > >>
   > >> Personally I find it easier. Probably because I've been using it
   > >> longer, but there are some things that just seem a lot more sensible
   > >> admin-wise:
   > >>
   > >> * Very easy wizards to create and drop users and databases:
   > >> - /usr/bin/createuser
   > >> - /usr/bin/createdb
   > >> - /usr/bin/dropuser
   > >> - /usr/bin/dropdb
   > >>
   > >> * It authenticates users based on their system login, so they don't
   > >> have to use any password when connecting to their own databases.
   > >>
   > >> * The psql command line interface is very user-friendly (as
   > >> command-line FTP interfaces go) has good a help function.
   > >>
   > >> * pg_dumpall is a very easy method of backing up and restoring your
  > > entire
   > >> database.
   > >>
  > > Sorry Toby, I was refering to ease of admin for a novice or person not
  > > too familier with DBs. Even then mainly because MySql is less
  > > -complex?' (although some would say lower functionality - but I dont
  > > want to go there
  > >
 >
 > Why not? Is it controversial?
Nah, just too busy to get tied into a merry - go - round

 > FWIW, I agree with you about Postgres/MySql

Personally I am a fan of MySql, mainly because it works well with PhP and
is simple to work with. I dont have to spend too much time 'thinking'.
Also, it is reasonably well behaved and nothing we do requires more
functionality, speed or complexity than we can get with MySql.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Question Hosting Cos and Mysql & Postgresql