Thread: Postgress and MYSQL

Postgress and MYSQL

From
"Bob Powell"
Date:
To whom it may concern:

I find the recent articles in various trade publications a little
disturbing due to the lack of PostgrSQL mention.  I continue to see
articles about how IBM may be considering MYSQL for development an
open_source web database.

Why isn't PostgreSQL being considered or talked about by major industry
giants?  As a DBA I know that Postgres is far superior to MYSQL but if
the industry directs it's energies towards open-source database this
coming year I think somehow PostgreSQL needs to be represented better.


Bob Powell


Re: Postgress and MYSQL

From
"John Sidney-Woollett"
Date:
Bob Powell said:
> I continue to see articles about how IBM may be considering MYSQL for
> development an open_source web database.

Why would IBM use and promote postgres when it is much closer an offering
to DB2 than MySQL, and a much bigger commercial threat?

I'll bet that IBM will be planning on a nice migration path from the
open-source-web-db to DB2...

John Sidney-Woollett

Re: Postgress and MYSQL

From
Tom Lane
Date:
"Bob Powell" <Bob@hotchkiss.org> writes:
> I find the recent articles in various trade publications a little
> disturbing due to the lack of PostgrSQL mention.

You are seeing the effects of MySQL AB's large marketing budget;
they have the time and money to cause such articles to appear.
I'm not sure there is much we can do to counter this in the short run.
(I do wonder how quickly they are running through that $19 mil
investment though ...)

            regards, tom lane

Re: Postgress and MYSQL

From
merlyn@stonehenge.com (Randal L. Schwartz)
Date:
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

Tom> "Bob Powell" <Bob@hotchkiss.org> writes:
>> I find the recent articles in various trade publications a little
>> disturbing due to the lack of PostgrSQL mention.

Tom> You are seeing the effects of MySQL AB's large marketing budget;
Tom> they have the time and money to cause such articles to appear.
Tom> I'm not sure there is much we can do to counter this in the short run.
Tom> (I do wonder how quickly they are running through that $19 mil
Tom> investment though ...)

My new buzz-meme (pass it along)...

"You're still using MySQL... that's sooooo 90's!"

:-)

Seriously, the space occupied by MySQL has been encroached by SQLite
from the low end (if you just want SQL access to a data file,
including transactions) and PostgreSQL from the high end (when you
want a full-featured database).  I think they've completely overlapped
at this point (especially when I just discovered yesterday that you
can register Perl callbacks for user-defined functions and aggregates
in DBD::SQLite!), so MySQL really doesn't have much of a win at either
end.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!

Re: Postgress and MYSQL

From
"Marc G. Fournier"
Date:
On Tue, 13 Jan 2004, Tom Lane wrote:

> "Bob Powell" <Bob@hotchkiss.org> writes:
> > I find the recent articles in various trade publications a little
> > disturbing due to the lack of PostgrSQL mention.
>
> You are seeing the effects of MySQL AB's large marketing budget;
> they have the time and money to cause such articles to appear.
> I'm not sure there is much we can do to counter this in the short run.
> (I do wonder how quickly they are running through that $19 mil
> investment though ...)

Let's see if they can beat GB? *evil grin*


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: Postgress and MYSQL

From
"Joshua D. Drake"
Date:
>>(I do wonder how quickly they are running through that $19 mil
>>investment though ...)
>>
>>
>
>Let's see if they can beat GB? *evil grin*
>
>
>
I seriously doubt they will be a GB... MySQL is at least making money
(probably not profit though).
They have a huge, loyal following and presumably a decent size customer
base.

GB had none of this.

MySQL will probably be around a long, long time.

Sincerely,

Joshua D. Drake




>----
>Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
>Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


Re: Postgress and MYSQL

From
"James Hall"
Date:
I cannot answer your question directly, but I did come across this
mysql/postgresql article this morning...

http://story.news.yahoo.com/news?tmpl=story&ncid=1817&e=10&u=/zd/2004011
1/tc_zd/116115&sid=96120751

I'm sure it's already been posted to the list.

-jim


-----Original Message-----
From: Bob Powell [mailto:Bob@hotchkiss.org]
Sent: Tuesday, January 13, 2004 10:32 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Postgress and MYSQL


To whom it may concern:

I find the recent articles in various trade publications a little
disturbing due to the lack of PostgrSQL mention.  I continue to see
articles about how IBM may be considering MYSQL for development an
open_source web database.

Why isn't PostgreSQL being considered or talked about by major industry
giants?  As a DBA I know that Postgres is far superior to MYSQL but if
the industry directs it's energies towards open-source database this
coming year I think somehow PostgreSQL needs to be represented better.


Bob Powell


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly

Re: Postgress and MYSQL

From
Anton.Nikiforov@loteco.ru
Date:
Hello Bob!
Everybody knows that PostgreSQL is better than MySQL and supports more
features etc. But remember - the main issue of database systems now is
web that is being build mainly by students that do not even know what
database engines are made for. At least here (My second job is
Instructor in Unix/Linux/etc.) and i know that the main thing that is
required by students is Linux with apache and MySQL. And the strange
thing - students are always starting learning from Network
Administration or Linux in Enterprise course, but real administrators
who is working with systems for 10-15 years are starting from
Introduction into unix systems.
Here in Russia almost all web design companies using MySQL, on all
hosting systems owners asking to install MySQL for their users etc.
MySQL is everywhere.
So, who will work with PG? Only people registered here :)) Maybe a few
more. So it is normal that MySQL beats PG on the market.
I have Oracle, PostgreSQL servers, used to work with DB2 on AS/400 and
personaly i know that PG is better than MySQL. But who will tell it to
students who saw a computer twice and already think that they are
administrators? :))))
Please do not kill me for this post - i like PG and working with
PG and developing for PG, i was talking just about what happening
around. To make PG known there should be more and more products that
relay on PG. And this should be not Banking or other mission critical
projects. It should be a simple forums, picture bases i do not know
what but the things that should be installable for 3 minutes and
working for years. Otherwise if PG is positioning itself as a DB
system for huge and mission critical tasks - nobody here should think
about MySQL that was simple and will be simple when PG is being
installed for tasks where MySQL will never work and nobody will ever
think it will.

Regards,
Anton

BP> To whom it may concern:

BP> I find the recent articles in various trade publications a little
BP> disturbing due to the lack of PostgrSQL mention.  I continue to see
BP> articles about how IBM may be considering MYSQL for development an
BP> open_source web database.

BP> Why isn't PostgreSQL being considered or talked about by major industry
BP> giants?  As a DBA I know that Postgres is far superior to MYSQL but if
BP> the industry directs it's energies towards open-source database this
BP> coming year I think somehow PostgreSQL needs to be represented better.


BP> Bob Powell


BP> ---------------------------(end of broadcast)---------------------------
BP> TIP 3: if posting/reading through Usenet, please send an appropriate
BP>       subscribe-nomail command to majordomo@postgresql.org so that your
BP>       message can get through to the mailing list cleanly


Re: Postgress and MYSQL

From
Dustin Sallings
Date:
On Jan 14, 2004, at 0:08, Anton.Nikiforov@loteco.ru wrote:

> around. To make PG known there should be more and more products that
> relay on PG. And this should be not Banking or other mission critical
> projects. It should be a simple forums, picture bases i do not know

    This is very insightful.  mySQL is not popular in the enterprise
because it's known to solve big problems, but because it's known to
solve little ones.  It seems so wrong, but makes so much sense.

--
Dustin Sallings


Re: Postgress and MYSQL

From
Matt Davies
Date:
I have to agree. In my experience the average database user out there does not
need the entire functionality of something like Oracle. It is because of this
that I have used MySQL for many years now.

In this light (please accept my confession as to being a more prolific MySQL
user), I am becoming more converted to Postgress. I am very impressed with the
full features of PG, but I have noticed some things that will make PG more
useful out of the box.

1. Replication: Like it or not most people regard their data and access to their
data as 'invaluable'. If not, why are they storing it. Having a secondary
server (read slaves) on which you can perform backups, load balance RO traffic,
and eventually use as a failover has been one of the great selling points of
MySQL for my specific applications. I wish there were a Master-Master
replication scheme out there, but that is not the case.

2. Documentation: In delving deeper into the Postgress database I have tried to
find whatever I can to learn more. I have found an Oreilly book out there, but
the TOC reads almost the exact same as the online documentation. I ask myself -
have they lifted the documentation and are now trying to sell me it bound in
book form? MySQL did the same for a while, but it was the other books- problem
solving, examples, programming, etc.. that really helped MySQL adoption IMO.

MySQL marketing has done much to help the average database user out there feel
like they are getting a powerful and feature-rich database. The average user
out there is doing nothing more than address books and recipe books. They,
however, __THINK__ they are real DBA's because MySQL is happy to lead them to
believe that. Having them evangelize the database is like gold. There is no
barrier-to-entry (read cash!!!) to MySQL (or Postgress for that matter) that
requires business case analysis and hiring of trained professionals to run the
database.

I see a trend of "DBA's", "Network Admin's", "** Admins'"(fill in blank) out
there that lack a fundamental understanding of how a computer works and how you
make it work for you, not the other way around. I scoff at most training
centers that sit you in front of a terminal (maintained by them) and teach you
everything you need to know in 20 days for $1200. They lack the understanding
of how I/O works, CPU & caching, ... They know one thing, but they __THINK__
they are the master.

I have ranted about this for a point. It is not what the seasoned 20 year UNIX
veteran knows about a database/OS that really matters in terms of adoption - it
is what the general mass of people  __THINKS__ matters.  They are becoming ever
present in high levels of decision making functions. Perception is the key.

My $0.02.






Quoting Dustin Sallings <dustin@spy.net>:

>
> On Jan 14, 2004, at 0:08, Anton.Nikiforov@loteco.ru wrote:
>
> > around. To make PG known there should be more and more products that
> > relay on PG. And this should be not Banking or other mission critical
> > projects. It should be a simple forums, picture bases i do not know
>
>     This is very insightful.  mySQL is not popular in the enterprise
> because it's known to solve big problems, but because it's known to
> solve little ones.  It seems so wrong, but makes so much sense.
>
> --
> Dustin Sallings
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>




Re: Postgress and MYSQL

From
Peter Eisentraut
Date:
Matt Davies wrote:
> 2. Documentation: In delving deeper into the Postgress database I
> have tried to find whatever I can to learn more. I have found an
> Oreilly book out there, but the TOC reads almost the exact same as
> the online documentation. I ask myself - have they lifted the
> documentation and are now trying to sell me it bound in book form?
> MySQL did the same for a while, but it was the other books- problem
> solving, examples, programming, etc.. that really helped MySQL
> adoption IMO.

http://www.postgresql.org/users-lounge/books.html


Re: Postgress and MYSQL

From
"Joshua D. Drake"
Date:
>1. Replication: Like it or not most people regard their data and access to their
>data as 'invaluable'. If not, why are they storing it. Having a secondary
>server (read slaves) on which you can perform backups, load balance RO traffic,
>and eventually use as a failover has been one of the great selling points of
>MySQL for my specific applications. I wish there were a Master-Master
>replication scheme out there, but that is not the case.
>
>
>
Replication exists in multiple manners for PostgreSQL. There is Mammoth
replicator (our product),
ErServer (pgsql.com's product), dbmirror, Rserv, and pgCluster.

>2. Documentation: In delving deeper into the Postgress database I have tried to
>find whatever I can to learn more. I have found an Oreilly book out there, but
>the TOC reads almost the exact same as the online documentation. I ask myself -
>have they lifted the documentation and are now trying to sell me it bound in
>book form?
>
I am sorry but I am the co-author of that book and I can tell you the
only thing in that
book that reads like the documentation is the reference chapter and the
appendixes.
Not to mention that PostgreSQL.Org has some of the most complete
documentation
of any software out there.

There are also several books on PostgreSQL including the O'Reilly one,
the Addison
Wesley one, the Sams one... and I think even a PTR one.

>MySQL marketing has done much to help the average database user out there feel
>like they are getting a powerful and feature-rich database. The average user
>out there is doing nothing more than address books and recipe books. They,
>
>
MySQL has what 19 million in the bank?

>I have ranted about this for a point. It is not what the seasoned 20 year UNIX
>veteran knows about a database/OS that really matters in terms of adoption - it
>is what the general mass of people  __THINKS__ matters.  They are becoming ever
>present in high levels of decision making functions. Perception is the key.
>
>
>
This is very true. Perception is the key.

Sincerely,

Joshua D. Drake



>My $0.02.
>
>
>
>
>
>
>Quoting Dustin Sallings <dustin@spy.net>:
>
>
>
>>On Jan 14, 2004, at 0:08, Anton.Nikiforov@loteco.ru wrote:
>>
>>
>>
>>>around. To make PG known there should be more and more products that
>>>relay on PG. And this should be not Banking or other mission critical
>>>projects. It should be a simple forums, picture bases i do not know
>>>
>>>
>>    This is very insightful.  mySQL is not popular in the enterprise
>>because it's known to solve big problems, but because it's known to
>>solve little ones.  It seems so wrong, but makes so much sense.
>>
>>--
>>Dustin Sallings
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>>
>>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


Re: Postgress and MYSQL

From
Ben
Date:
On Wed, 14 Jan 2004, Joshua D. Drake wrote:

> Not to mention that PostgreSQL.Org has some of the most complete
> documentation
> of any software out there.

Yes, I don't understand why people seem to keep complaining about
Postgres' documentation - it is by far the best reference documentation
I've ever come across.

Maybe it's that there isn't much tutorial content in the documentation -
for somebody trying to learn how to do SQL in the first place, it's not
going to hold your hand and I could see how that will turn off newbies.



Re: Postgress and MYSQL

From
Dustin Sallings
Date:
On Jan 14, 2004, at 10:18, Matt Davies wrote:

> 1. Replication: Like it or not most people regard their data and
> access to their
> data as 'invaluable'. If not, why are they storing it. Having a
> secondary

    I'm not the only person who has used this same argument against mySQL
installs.  There is a huge understanding problem here.  Sure, so you're
replicating your data...that doesn't mean you're storing what you think
you're storing, or transactionally safe, or consistent, etc...

> server (read slaves) on which you can perform backups, load balance RO
> traffic,
> and eventually use as a failover has been one of the great selling
> points of
> MySQL for my specific applications. I wish there were a Master-Master
> replication scheme out there, but that is not the case.

    You don't need a replicate to perform a backup in general.  mySQL
imposed this requirement, but a replicate shouldn't be used that way.
Load balancing, perhaps...failover, maybe.

    In my experience with really good replication systems (sybase's rep
server), we didn't really use replication this way.  We had a replicate
going to a DSS system which was indexed and used differently, and we
had a replicate going to a ``warm'' standby which we would use for some
read-only queries.  Its original purpose was to use as a failover
system, but it was rarely used this way, even when there were
catastrophic database problems.  The reason is simple.  If something
broke the DB, it would be plain irresponsible to swap out the DB server
for another one that is (as far as we know) just as likely to break for
the same reason leaving us stranded.  Breaking replication required
rematerialization of the master after brining it back online, which was
an expensive process that left us without a spare for several hours.
So it was the DBAs' job to spend some time during any database failure
to determine the cause and solution.  Occasionally that meant swapping
to the other DB, but that process was never automated (well, no more
than being a script a DBA would run whenever he determined it
necessary).

--
Dustin Sallings


Re: Postgress and MYSQL

From
Matt Davies
Date:
Quoting "Joshua D. Drake" <jd@commandprompt.com>:

> >
> Replication exists in multiple manners for PostgreSQL. There is Mammoth
> replicator (our product),
> ErServer (pgsql.com's product), dbmirror, Rserv, and pgCluster.

What I meant was integrated replication. When adding more layers to the database
there is yet one more possible mechanism for failure at some point. I don't
know about you, but Murphy always bites me in the butt. In addition, I found
your product VERY interesting, but it kinda puts me off that it is starting at
$1000. PG is free, MySQL is not (for my purposes) and costs ~$500 with
everything in one tried and true package.



> >
> MySQL has what 19 million in the bank?

 I only point out what the userbase is feeling. I have never been attacked as an
idiot when using MySQL - I have always had helpful responses instead of "RTFM"
as I have seen and experienced here (and with qmail). To many people starting
the decision making process one looks at the type of support and how the group
makes you feel. You don't risk the company or project on potential hostility.

> >
> >
> This is very true. Perception is the key.
>

Again, I point out, PERCEPTION is the key. This can be done regardless of the
cash stash in the bank.

> Sincerely,
>
> Joshua D. Drake
>

Re: Postgress and MYSQL

From
Matt Davies
Date:
Quoting Ben <bench@silentmedia.com>:

> Yes, I don't understand why people seem to keep complaining about
> Postgres' documentation - it is by far the best reference documentation
> I've ever come across.
>
> Maybe it's that there isn't much tutorial content in the documentation -
> for somebody trying to learn how to do SQL in the first place, it's not
> going to hold your hand and I could see how that will turn off newbies.
>

I agree - it is very clear and complete. I do think that tutorials will help.
Tutorials being -
1. Basic SQL (one must understand that if you want your product to go forward
you have to teach some basic fundamentals - again no barrier to entry =
(usually) no formal training)

2. General Tutorials (see above)

3. Advanced Usage Tutorials (see above, again)


Acceptance of PG could be greatly accelerated by more:
1. small projects using PG as a backend (as stated in previous thread post)
2. documenation coming from multiple sources. Don't ask me to explain why, but
one seems to equate robustness, usability, etc... with the more titles one
sees. If you go to Barnes and Noble's and look there for DB books you see the
wall of red (Oracle books), black (M$oft), blue (MySQL). I simply point out
that perception being as it is - PG is not there. I am trying to learn more and
more about it to remedy my newcomer understanding of PG. Do not read this as if
I am a newbie to DB's; I am not ignorant.

I talk of perception - if you get PG into the hands of more newbies and make
them feel good you have a viral marketing strategy that costs you no $.  I fell
for it years ago with MySQL, but I have since learned. Now that I have Oracle
experience as a reference I see MySQL as lacking and trying to hoodwink me.
Most never make it out of the cloud.



Re: Postgress and MYSQL

From
"Chris Ochs"
Date:
A good clean replication system is not available for bsd platforms as far as
I can tell, which is the preferred OS of choice for many PG installations.
I am playing around with Erserver, but the download has to be updated from
cvs or it won't even compile (corrupted file in the distribution).  It
appears to me at first glance that it is not actively being worked on,
although it may indeed work (I haven't had a chance to fully configure/test
it yet on freebsd 5).

The Erserver I downloaded is free, although I was confused also because I
found that same page that said it was $1000.  I'm still not sure if the
erserver I downloaded is the only version, or if there is a commercial
version?

Chris





----- Original Message -----
From: "Matt Davies" <matt@mattdavies.net>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, January 14, 2004 11:12 AM
Subject: Re: [GENERAL] Postgress and MYSQL


> Quoting "Joshua D. Drake" <jd@commandprompt.com>:
>
> > >
> > Replication exists in multiple manners for PostgreSQL. There is Mammoth
> > replicator (our product),
> > ErServer (pgsql.com's product), dbmirror, Rserv, and pgCluster.
>
> What I meant was integrated replication. When adding more layers to the
database
> there is yet one more possible mechanism for failure at some point. I
don't
> know about you, but Murphy always bites me in the butt. In addition, I
found
> your product VERY interesting, but it kinda puts me off that it is
starting at
> $1000. PG is free, MySQL is not (for my purposes) and costs ~$500 with
> everything in one tried and true package.
>
>
>
> > >
> > MySQL has what 19 million in the bank?
>
>  I only point out what the userbase is feeling. I have never been attacked
as an
> idiot when using MySQL - I have always had helpful responses instead of
"RTFM"
> as I have seen and experienced here (and with qmail). To many people
starting
> the decision making process one looks at the type of support and how the
group
> makes you feel. You don't risk the company or project on potential
hostility.
>
> > >
> > >
> > This is very true. Perception is the key.
> >
>
> Again, I point out, PERCEPTION is the key. This can be done regardless of
the
> cash stash in the bank.
>
> > Sincerely,
> >
> > Joshua D. Drake
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>


Documentation search (Was: Postgress and MYSQL)

From
Martin Marques
Date:
Mensaje citado por Ben <bench@silentmedia.com>:

> On Wed, 14 Jan 2004, Joshua D. Drake wrote:
>
> > Not to mention that PostgreSQL.Org has some of the most complete
> > documentation
> > of any software out there.
>
> Yes, I don't understand why people seem to keep complaining about
> Postgres' documentation - it is by far the best reference documentation
> I've ever come across.

Not really. I just tried to look in the docs for the explicit for of a CAST
(really trying to find the link to send someone), and I just couldn't find it.
I know it's somewhere there, as I have read it before, but not even the search
engine installed in the interactive docs seem to find that doc.

Personally I think the docs are great (I learned a lot from them), but some
things are not that easy to find, even with a search engine. Compared to MySQL
online docs, PG's docs are heaven!!! :-)

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Martín Marqués          |   Programador, DBA
Centro de Telemática    |     Administrador
               Universidad Nacional
                    del Litoral
---------------------------------------------------------

Re: Postgress and MYSQL

From
"Joshua D. Drake"
Date:
>What I meant was integrated replication. When adding more layers to the database
>there is yet one more possible mechanism for failure at some point. I don't
>know about you, but Murphy always bites me in the butt. In addition, I found
>your product VERY interesting, but it kinda puts me off that it is starting at
>$1000. PG is free, MySQL is not (for my purposes) and costs ~$500 with
>everything in one tried and true package.
>
>
>
I am sorry but MySQL is anything but a tried a true package for any
serious database stuff.
Yes it is simple, but I don't consider any database that will allow you to:

divide by zero
truncate data
ignore data type constraints

worth even 500.00.

> only point out what the userbase is feeling. I have never been attacked as an
>idiot when using MySQL - I have always had helpful responses instead of "RTFM"
>
>
Well first, you should always RTFM but I have never seen anyone being
treated like
an idiot on these lists and we have some pretty dumb monkeys ask
questions some times.

Sincerely,

Joshua D. Drake


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


Re: Postgress and MYSQL

From
Terry Lee Tucker
Date:
We are in the process of porting a logistics application to Postgres from a
Progress Software database. We have about 75 employees and will be putting
Postgres to work in a real time business situation where there are lots of
transactions. Once we are successful in this endeavor, how can we get stories
like that out to people who would care to know? I know this is a small
business project, but will it help to advertise that the "little" guys are in
the trenches doing this kind of thing?

On Tuesday 13 January 2004 11:32 am, Bob Powell wrote:
> To whom it may concern:
>
> I find the recent articles in various trade publications a little
> disturbing due to the lack of PostgrSQL mention.  I continue to see
> articles about how IBM may be considering MYSQL for development an
> open_source web database.
>
> Why isn't PostgreSQL being considered or talked about by major industry
> giants?  As a DBA I know that Postgres is far superior to MYSQL but if
> the industry directs it's energies towards open-source database this
> coming year I think somehow PostgreSQL needs to be represented better.
>
>
> Bob Powell
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly

--
"Posterity -- you will never know how much it has cost my generation
 to preserve your freedom. I hope you will make good use of it."

 --John Quincy Adams

 Work: 1-336-372-6812
 Cell: 1-336-363-4719
email: terry@esc1.com

Re: Postgress and MYSQL

From
"Rick Gigger"
Date:
> On Wed, 14 Jan 2004, Joshua D. Drake wrote:
>
> > Not to mention that PostgreSQL.Org has some of the most complete
> > documentation
> > of any software out there.
>
> Yes, I don't understand why people seem to keep complaining about
> Postgres' documentation - it is by far the best reference documentation
> I've ever come across.
>
> Maybe it's that there isn't much tutorial content in the documentation -
> for somebody trying to learn how to do SQL in the first place, it's not
> going to hold your hand and I could see how that will turn off newbies.

I used to have that complaint until I got more aquainted with the docs.
When I used to use mysql I found that if I used search feature on their docs
I could find exactly what I was looking for almost immediately.  When I use
the postgres doc search feature I don't get the same experience.  It is
slow, sometimes doesn't work and rarely gives me what I am looking for.
Then I just started using google to search the docs and realized that just
looking at the TOC is usually good enough and that the postgres docs are
actually excellent.  My bad experience with search, as well as the good
experience with mysql search (do other people feel this way) however led me
initially to conclude that the postgres docs were not as good.


Re: Postgress and MYSQL

From
"Joshua D. Drake"
Date:
Terry Lee Tucker wrote:

>We are in the process of porting a logistics application to Postgres from a
>Progress Software database. We have about 75 employees and will be putting
>Postgres to work in a real time business situation where there are lots of
>transactions. Once we are successful in this endeavor, how can we get stories
>like that out to people who would care to know? I know this is a small
>business project, but will it help to advertise that the "little" guys are in
>the trenches doing this kind of thing?
>
>
>
Absolutely. If you have a case study you can point over to pgsql-advocacy.

Sincerely,

Joshua D. Drake



>On Tuesday 13 January 2004 11:32 am, Bob Powell wrote:
>
>
>>To whom it may concern:
>>
>>I find the recent articles in various trade publications a little
>>disturbing due to the lack of PostgrSQL mention.  I continue to see
>>articles about how IBM may be considering MYSQL for development an
>>open_source web database.
>>
>>Why isn't PostgreSQL being considered or talked about by major industry
>>giants?  As a DBA I know that Postgres is far superior to MYSQL but if
>>the industry directs it's energies towards open-source database this
>>coming year I think somehow PostgreSQL needs to be represented better.
>>
>>
>>Bob Powell
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 3: if posting/reading through Usenet, please send an appropriate
>>      subscribe-nomail command to majordomo@postgresql.org so that your
>>      message can get through to the mailing list cleanly
>>
>>
>
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


Re: Postgress and MYSQL

From
"Joshua D. Drake"
Date:
>I used to have that complaint until I got more aquainted with the docs.
>When I used to use mysql I found that if I used search feature on their docs
>I could find exactly what I was looking for almost immediately.  When I use
>the postgres doc search feature I don't get the same experience.  It is
>
>
Our doc search sucks. No question... there has been some work recently on it
but it doesn't seem to be that reliable. So you have us on that one.

Sincerely,

Joshua D. Drake



>slow, sometimes doesn't work and rarely gives me what I am looking for.
>Then I just started using google to search the docs and realized that just
>looking at the TOC is usually good enough and that the postgres docs are
>actually excellent.  My bad experience with search, as well as the good
>experience with mysql search (do other people feel this way) however led me
>initially to conclude that the postgres docs were not as good.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


Re: Postgress and MYSQL

From
Martin Marques
Date:
Mensaje citado por Matt Davies <matt@mattdavies.net>:

> Quoting "Joshua D. Drake" <jd@commandprompt.com>:
>
> > >
> > MySQL has what 19 million in the bank?
>
>  I only point out what the userbase is feeling. I have never been attacked as
> an
> idiot when using MySQL - I have always had helpful responses instead of
> "RTFM"
> as I have seen and experienced here (and with qmail). To many people
> starting
> the decision making process one looks at the type of support and how the
> group
> makes you feel. You don't risk the company or project on potential
> hostility.

Oh, please! I have never seen such a better community then this one (well, some
exceptions come to mind right now, but it's still within the best).

I have personally found GREAT replys from the developers (Tom Lane comes to
mind, saving me lots of time in some ocations), and users of this list.

Don't missunderstand me. Everyone (including me) some times makes responces in a
bit of a hard manner, but I think you have to see the whole picture, and not a
par of snapshots.

P.D.: BTW, RTFM is very good. You can learn alot from them. ;-)

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Martín Marqués          |   Programador, DBA
Centro de Telemática    |     Administrador
               Universidad Nacional
                    del Litoral
---------------------------------------------------------

Re: Postgress and MYSQL

From
"Rick Gigger"
Date:
> >I used to have that complaint until I got more aquainted with the docs.
> >When I used to use mysql I found that if I used search feature on their
docs
> >I could find exactly what I was looking for almost immediately.  When I
use
> >the postgres doc search feature I don't get the same experience.  It is
> >
> >
> Our doc search sucks. No question... there has been some work recently on
it
> but it doesn't seem to be that reliable. So you have us on that one.

Uh, I don't have one on you the mysql team does.  I haven't used mysql in
over a year and don't intend to again (at least not for any app I write
myself at leaset).  I assume that the mysql website is just using the mysql
full text search.  Having used the mysql full text search it does not
surprise me that the search on their website search is so good.  I always
asummed (read hoped) that the postgres full text search was just as good.  I
hope the bad website search is not a reflection of the quality of the full
text search in postgres.

Does anyone have any experience with postgers full text search?

Perhaps someone could get two birds with one stone and make a good full text
search engine for postgres (how hard could it be if mysql has such a good
one :-)  ) and use it to index the postgres docs.

Of course maybe mysql.com uses some other proprietery seach.


Re: Postgress and MYSQL

From
Martin Marques
Date:
Mensaje citado por "Joshua D. Drake" <jd@commandprompt.com>:

>
> >I used to have that complaint until I got more aquainted with the docs.
> >When I used to use mysql I found that if I used search feature on their
> docs
> >I could find exactly what I was looking for almost immediately.  When I use
> >the postgres doc search feature I don't get the same experience.  It is
> >
> >
> Our doc search sucks. No question... there has been some work recently on it
> but it doesn't seem to be that reliable. So you have us on that one.

I personally think that the search criterion is what's wrong here. The speed can
be fixed with optimization in the server.

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Martín Marqués          |   Programador, DBA
Centro de Telemática    |     Administrador
               Universidad Nacional
                    del Litoral
---------------------------------------------------------

Re: Postgress and MYSQL

From
"Joshua D. Drake"
Date:
>
>Does anyone have any experience with postgers full text search?
>
>
>
It works well but it is my understanding that our docs search doesn't
use PostgreSQL
and TSearch. It uses PostgreSQL monogo search or something like that.

J



>Perhaps someone could get two birds with one stone and make a good full text
>search engine for postgres (how hard could it be if mysql has such a good
>one :-)  ) and use it to index the postgres docs.
>
>Of course maybe mysql.com uses some other proprietery seach.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


Re: Postgress and MYSQL

From
Matt Davies
Date:
Quoting Martin Marques <martin@bugs.unl.edu.ar>:
> Oh, please! I have never seen such a better community then this one (well,
> some
> exceptions come to mind right now, but it's still within the best).
>
> I have personally found GREAT replys from the developers (Tom Lane comes to
> mind, saving me lots of time in some ocations), and users of this list.
>
> Don't missunderstand me. Everyone (including me) some times makes responces
> in a
> bit of a hard manner, but I think you have to see the whole picture, and not
> a
> par of snapshots.
>
> P.D.: BTW, RTFM is very good. You can learn alot from them. ;-)

This thread is getting long and out in never-never land. I have RTFM. In fact,
many times. As a matter of practice I subscribe long before I post. I RTFM, I
google, attempted to search the docs and lists, ...

My comments come from my experiences and others. Yes, Tom Lane has wonderful
advice and help.

I do not mean to call the PG baby ugly (as I fear some people have taken it), I
only mean to point out some areas (as others have in this thread) that could be
improved upon that would greatly enhance PG.

Imagine this: more users, more installations, more (selective) development
fingers. Not all users are rocket scientists, but the video game rule applies
to many: if I can't get it going in X (user preference) minutes then it isn't
worth the trouble. Should PG be limited to only those who are hard core DB
users? If so, I don't think PG will take off as fast.

OK, I am done.






Re: Postgress and MYSQL

From
"Rick Gigger"
Date:
> >Does anyone have any experience with postgers full text search?
> >
> It works well but it is my understanding that our docs search doesn't
> use PostgreSQL
> and TSearch. It uses PostgreSQL monogo search or something like that.

That's good to hear.  What is monogo and is it the problem here?  Why don't
it use TSearch if it is better?  Is it just a matter of someone taking the
time to set it up?


Re: Postgress and MYSQL

From
"Joshua D. Drake"
Date:
>That's good to hear.  What is monogo and is it the problem here?  Why don't
>it use TSearch if it is better?  Is it just a matter of someone taking the
>time to set it up?
>
>
It is a little more complicated than that. Monogo or whatever it is
called is more
like a web spider that uses postgresql. Thus we can search the entire
postgresql
website. Tsearch is more about text search within PostgreSQL so we would
have
to load the books etc... into the database. That is not as easy as it
sounds.

Also if you are looking for something very cool... check out www.pgsql.ru

Sincerely,

Joshua D. Drake

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


Re: Postgress and MYSQL

From
Jonathan Bartlett
Date:
> Imagine this: more users, more installations, more (selective) development
> fingers. Not all users are rocket scientists, but the video game rule applies
> to many: if I can't get it going in X (user preference) minutes then it isn't
> worth the trouble. Should PG be limited to only those who are hard core DB
> users? If so, I don't think PG will take off as fast.

We need a Postgres vs MySQL Mailing list :)

Honestly PG is easy to get up and running on several distributions.  On
RH, service postgres start willgive you a running Postgres (it will do an
initdb if needed).  Now just create a user and get going.

PG is only hard because people _think_ it's going to be hard.  Or because
it used to be hard.  However, it hasn't been hard for a long time.

I also don't think "how fast will this take off" is necesarily a good
design requirement.

Jon



Re: Postgress and MYSQL

From
Martin Marques
Date:
Mensaje citado por Rick Gigger <rick@alpinenetworking.com>:

> > >Does anyone have any experience with postgers full text search?
> > >
> > It works well but it is my understanding that our docs search doesn't
> > use PostgreSQL
> > and TSearch. It uses PostgreSQL monogo search or something like that.
>
> That's good to hear.  What is monogo and is it the problem here?  Why don't
> it use TSearch if it is better?  Is it just a matter of someone taking the
> time to set it up?

http://www.mnogosearch.com/

Aparently the problem is that this application is already written (I'm talking
about the presentation and buisness layers).

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Martín Marqués          |   Programador, DBA
Centro de Telemática    |     Administrador
               Universidad Nacional
                    del Litoral
---------------------------------------------------------

Re: Postgress and MYSQL

From
"Chris Ochs"
Date:
Personally I don't think it's installing/running the database server that
people have problems with.  I used postgresql about 5 years ago and am now
switching back to it from sapdb.  I have also used mysql and oracle.

The problems I have had with postgresql is the websites.  The website does
very little to make an impression on new users, or to showcase the features
that are available to someone that doesn't know anything about postgresql.
It's difficult to find information, and too much information is outdated
which makes you question everything else.  I still am not sure what
replication options are available because of all the conflicting information
that is posted on the various websites (gborg, pgsql.com, postgresql.org,
etc..).

Look I love postgresql, but reality is reality.  The database itself is
great, the documentation is pretty good, but a lot of the other things about
postgresql (like the website) need a lot of work.  Postgresql gives the
impression of being a second rate disorganized product if you were to just
go by the website alone.  Now of course that is not true, but perception
governs people's actions and behavior.  If people think postgresql is
difficult, guess what, for all intents and purposes it is.  If that
perception leads them to use mysql instead of postgresql, then at some point
you have to face the fact that it's the perceptions that are really
important, regardless of the facts.

Chris



>
> Honestly PG is easy to get up and running on several distributions.  On
> RH, service postgres start willgive you a running Postgres (it will do an
> initdb if needed).  Now just create a user and get going.
>
> PG is only hard because people _think_ it's going to be hard.  Or because
> it used to be hard.  However, it hasn't been hard for a long time.
>
>


Re: Postgress and MYSQL

From
"Keith C. Perry"
Date:
Quoting Rick Gigger <rick@alpinenetworking.com>:

> > On Wed, 14 Jan 2004, Joshua D. Drake wrote:
> >
> > > Not to mention that PostgreSQL.Org has some of the most complete
> > > documentation
> > > of any software out there.
> >
> > Yes, I don't understand why people seem to keep complaining about
> > Postgres' documentation - it is by far the best reference documentation
> > I've ever come across.
> >
> > Maybe it's that there isn't much tutorial content in the documentation -
> > for somebody trying to learn how to do SQL in the first place, it's not
> > going to hold your hand and I could see how that will turn off newbies.
>
> I used to have that complaint until I got more aquainted with the docs.
> When I used to use mysql I found that if I used search feature on their docs
> I could find exactly what I was looking for almost immediately.  When I use
> the postgres doc search feature I don't get the same experience.  It is
> slow, sometimes doesn't work and rarely gives me what I am looking for.
> Then I just started using google to search the docs and realized that just
> looking at the TOC is usually good enough and that the postgres docs are
> actually excellent.  My bad experience with search, as well as the good
> experience with mysql search (do other people feel this way) however led me
> initially to conclude that the postgres docs were not as good.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>

That is something we can't seem to get across the new folks who think that they
can come from MySQL and move to PostgreSQL.  I don't know why- I've heard people
say it because they are both open source, I heard (new) people say that they
should have to read the docs first, the reasons go on and on.  What I do know is:

1) Comparing MySQL to PostgreSQL is not a valid technical discussion  They're
   different products.

2) Assuming the way MySQL does is correct is also invalid.  What MySQL does for
   MySQL works for them.  Over time and with and open mind, I saw that even back
   in the 6.x days that PostgreSQL was going to be a more robust product
   and as such I had to not only learn PG but I also had to learn more about
   relational theory and SQL.  I was initially put off too (I remember all my
   engineering buddies and I cracking jokes about those "database people") but
   at the time, my DB experience was Dbase, Filemaker Pro and Foxpro.  I mean
   really...  *laff*

3) Not being able to "find" something in via search BEFORE even reading the
   documentation is somewhat backwards.  You have to at least get a feel for
   the docs before even know what to look for.  That is not to say that the
   search engine is not problematic but it is to say that I'm am more and more
   convinced that knowing how to search more important than what is being
   searched for.

4) As many people pointed out before, a product should not be technical
   education it should product education.  Some people take it as being rude
   we some on-list says use google or check <some other site>.  Granted
   being told "this is not hand holding" is definitely a slap in the face its
   been done to me and I'm sure there is a better way to put it but the
   reality is that PG docs are very good.  Get some paper and print
   they out double-sided- they're an excellent reference.  However, you have to
   understand the basics first and that simply does not belong on the PG
   site (save a link to some community recommendations).


BTW, I've asked this before but where are the 7.4 docs in PS or PDF format?  If
any one needs or wants them, I do have the 7.3.2-US books (admin, user,
programmer & reference) in PS with the duplexing code.  They all fit nicely in a
3" ring binder and will compliment any bookshelf  :)

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

Re: Postgress and MYSQL

From
"scott.marlowe"
Date:
On Wed, 14 Jan 2004, Rick Gigger wrote:

> Does anyone have any experience with postgers full text search?

I just put the docs on my apache server and hit them with htdig or
mnogosearch.


Re: Postgress and MYSQL

From
"Keith C. Perry"
Date:
Quoting "Joshua D. Drake" <jd@commandprompt.com>:

>
> >That's good to hear.  What is monogo and is it the problem here?  Why don't
> >it use TSearch if it is better?  Is it just a matter of someone taking the
> >time to set it up?
> >
> >
> It is a little more complicated than that. Monogo or whatever it is
> called is more
> like a web spider that uses postgresql. Thus we can search the entire
> postgresql
> website. Tsearch is more about text search within PostgreSQL so we would
> have
> to load the books etc... into the database. That is not as easy as it
> sounds.
>
> Also if you are looking for something very cool... check out www.pgsql.ru
>
> Sincerely,
>
> Joshua D. Drake
>
> --
> Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
> Postgresql support, programming shared hosting and dedicated hosting.
> +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
> Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

I thought Marc optimized the search last week when this same thread was being
discussed?

Marc?

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

Re: Postgress and MYSQL

From
"Joshua D. Drake"
Date:
>
>BTW, I've asked this before but where are the 7.4 docs in PS or PDF format?  If
>
>

They are being worked on ;)

>any one needs or wants them, I do have the 7.3.2-US books (admin, user,
>programmer & reference) in PS with the duplexing code.  They all fit nicely in a
>3" ring binder and will compliment any bookshelf  :)
>
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


Re: Postgress and MYSQL

From
"Joshua D. Drake"
Date:
>Look I love postgresql, but reality is reality.  The database itself is
>great, the documentation is pretty good, but a lot of the other things about
>postgresql (like the website) need a lot of work.  Postgresql gives the
>impression of being a second rate disorganized product if you were to just
>go by the website alone.
>
Isn't that true of just about any OSS project? Heck, Linux doesn't even
have a website ;).
MySQL is not an OSS project, it is an OSS product with a commercial
company backing
it. There is a big difference.

Sincerely,

Joshua D. Drake




> Now of course that is not true, but perception
>governs people's actions and behavior.  If people think postgresql is
>difficult, guess what, for all intents and purposes it is.  If that
>perception leads them to use mysql instead of postgresql, then at some point
>you have to face the fact that it's the perceptions that are really
>important, regardless of the facts.
>
>Chris
>
>
>
>
>
>>Honestly PG is easy to get up and running on several distributions.  On
>>RH, service postgres start willgive you a running Postgres (it will do an
>>initdb if needed).  Now just create a user and get going.
>>
>>PG is only hard because people _think_ it's going to be hard.  Or because
>>it used to be hard.  However, it hasn't been hard for a long time.
>>
>>
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


Re: Documentation search (Was: Postgress and MYSQL)

From
Peter Eisentraut
Date:
Martin Marques wrote:
> Not really. I just tried to look in the docs for the explicit for of
> a CAST (really trying to find the link to send someone), and I just
> couldn't find it. I know it's somewhere there, as I have read it
> before, but not even the search engine installed in the interactive
> docs seem to find that doc.

If you want to find something in the documentation, there's an index at
the end of it.  I realize now that there's no entry for CAST, which I
will fix.  But if you find more terms that you would like to see in the
index, write to pgsql-docs.


Re: Postgress and MYSQL

From
"Chris Ochs"
Date:
Yes I didn't really want to get into that at the moment, but that is THE
main difference....

That said, there are number of OSS projects that have very nice websites,
and it wouldn't be that much work to clean up the postgresql site a bit.
I'm not talking about a ton of new content, just a simple, clean layout for
the front page that's easier to use.  I might even do a template myself and
send it to the list if I can get the time.

Chris

> >
> Isn't that true of just about any OSS project? Heck, Linux doesn't even
> have a website ;).
> MySQL is not an OSS project, it is an OSS product with a commercial
> company backing
> it. There is a big difference.
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>
> > Now of course that is not true, but perception
> >governs people's actions and behavior.  If people think postgresql is
> >difficult, guess what, for all intents and purposes it is.  If that
> >perception leads them to use mysql instead of postgresql, then at some
point
> >you have to face the fact that it's the perceptions that are really
> >important, regardless of the facts.
> >
> >Chris
> >
> >
> >
> >
> >
> >>Honestly PG is easy to get up and running on several distributions.  On
> >>RH, service postgres start willgive you a running Postgres (it will do
an
> >>initdb if needed).  Now just create a user and get going.
> >>
> >>PG is only hard because people _think_ it's going to be hard.  Or
because
> >>it used to be hard.  However, it hasn't been hard for a long time.
> >>
> >>
> >>
> >>
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 5: Have you checked our extensive FAQ?
> >
> >               http://www.postgresql.org/docs/faqs/FAQ.html
> >
> >
>
>
> --
> Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
> Postgresql support, programming shared hosting and dedicated hosting.
> +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
> Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
>
>


Re: Postgress and MYSQL

From
"Joshua D. Drake"
Date:
>I'm not talking about a ton of new content, just a simple, clean layout for
>the front page that's easier to use.  I might even do a template myself and
>send it to the list if I can get the time.
>
>
>
Well before you do that, you might want to look at pgsql-advocacy and
pgsql-www. There
are some arguments going on right now about that very subject :)

Sincerely,


Joshua D. Drake



>Chris
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


Re: Postgress and MYSQL

From
"Chris Ochs"
Date:
I will, and glad to hear it is being worked on.

Chris

>
> >I'm not talking about a ton of new content, just a simple, clean layout
for
> >the front page that's easier to use.  I might even do a template myself
and
> >send it to the list if I can get the time.
> >
> >
> >
> Well before you do that, you might want to look at pgsql-advocacy and
> pgsql-www. There
> are some arguments going on right now about that very subject :)
>
> Sincerely,
>
>
> Joshua D. Drake
>
>
>
> >Chris
> >
> >
>
>
> --
> Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
> Postgresql support, programming shared hosting and dedicated hosting.
> +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
> Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>


Re: Documentation search (Was: Postgress and MYSQL)

From
Martin Marques
Date:
Mensaje citado por Peter Eisentraut <peter_e@gmx.net>:

> Martin Marques wrote:
> > Not really. I just tried to look in the docs for the explicit for of
> > a CAST (really trying to find the link to send someone), and I just
> > couldn't find it. I know it's somewhere there, as I have read it
> > before, but not even the search engine installed in the interactive
> > docs seem to find that doc.
>
> If you want to find something in the documentation, there's an index at
> the end of it.  I realize now that there's no entry for CAST, which I
> will fix.  But if you find more terms that you would like to see in the
> index, write to pgsql-docs.

Well, this is something very interesting. I didn't know about pgsql-docs (maybe
it's because I go into the "lists" section in www.postgresql.org not looking at
the lists available, but looking for actual help on a certain list).

I will do so in the future. Thanks alot.

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Martín Marqués          |   Programador, DBA
Centro de Telemática    |     Administrador
               Universidad Nacional
                    del Litoral
---------------------------------------------------------

Re: Postgress and MYSQL

From
Martin Marques
Date:
Mensaje citado por "Keith C. Perry" <netadmin@vcsn.com>:

>
> 3) Not being able to "find" something in via search BEFORE even reading the
>    documentation is somewhat backwards.  You have to at least get a feel for
>    the docs before even know what to look for.  That is not to say that the
>    search engine is not problematic but it is to say that I'm am more and
> more
>    convinced that knowing how to search more important than what is being
>    searched for.

I am totally against this kind of believes.
Personally, I think that one of the most important caracteristics a book should
have is a VERY GOOD INDEX. This makes the searching easier.
I can remember starting with Informix, about 4 years ago, and I can say that
even not being excelent manuals the index really helped me and made me save
lots of time when trying to find a determinated information.

> BTW, I've asked this before but where are the 7.4 docs in PS or PDF format?
> If
> any one needs or wants them, I do have the 7.3.2-US books (admin, user,
> programmer & reference) in PS with the duplexing code.  They all fit nicely
> in a
> 3" ring binder and will compliment any bookshelf  :)

I had the 7.1 printed. Read most of it when my wife was in the hospital having
my daughter, and I had to stay there 2 days. :-)

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Martín Marqués          |   Programador, DBA
Centro de Telemática    |     Administrador
               Universidad Nacional
                    del Litoral
---------------------------------------------------------

Re: Postgress and MYSQL

From
Alvaro Herrera
Date:
On Wed, Jan 14, 2004 at 09:29:32PM -0300, Martin Marques wrote:
> Mensaje citado por "Keith C. Perry" <netadmin@vcsn.com>:
>
> >
> > 3) Not being able to "find" something in via search BEFORE even reading the
> >    documentation is somewhat backwards.  You have to at least get a feel for
> >    the docs before even know what to look for.  That is not to say that the
> >    search engine is not problematic but it is to say that I'm am more and
> > more
> >    convinced that knowing how to search more important than what is being
> >    searched for.
>
> I am totally against this kind of believes.
> Personally, I think that one of the most important caracteristics a book should
> have is a VERY GOOD INDEX. This makes the searching easier.

But the PG docs _have_ good indexes!  (Much better than other docs for
open source projects I have seen.)  I for one have always found what I
was looking for.  Searching in a full text engine is a different matter
and I agree it is lousy (maybe that's the reason I don't use it
anymore).


> I had the 7.1 printed. Read most of it when my wife was in the hospital having
> my daughter, and I had to stay there 2 days. :-)

Go figure.  Maybe I'll start thinking about children so I can have a
spare time to read documentation ... or maybe not ;-)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"I think my standards have lowered enough that now I think 'good design'
is when the page doesn't irritate the living f*ck out of me." (JWZ)

Re: Postgress and MYSQL

From
Martin Marques
Date:
Mensaje citado por Alvaro Herrera <alvherre@dcc.uchile.cl>:

> On Wed, Jan 14, 2004 at 09:29:32PM -0300, Martin Marques wrote:
> >
> > I am totally against this kind of believes.
> > Personally, I think that one of the most important caracteristics a book
> should
> > have is a VERY GOOD INDEX. This makes the searching easier.
>
> But the PG docs _have_ good indexes!  (Much better than other docs for
> open source projects I have seen.)  I for one have always found what I
> was looking for.  Searching in a full text engine is a different matter
> and I agree it is lousy (maybe that's the reason I don't use it
> anymore).

CAST wasn't there. :-)
Any way, as I stated before, I find PG docs to be very good. But I know that they
can be even better, so that is what I'm aiming at.

> > I had the 7.1 printed. Read most of it when my wife was in the hospital having
> > my daughter, and I had to stay there 2 days. :-)
>
> Go figure.  Maybe I'll start thinking about children so I can have a
> spare time to read documentation ... or maybe not ;-)

No Alvaro! I had does two days to read. Since then I have had lots of less time for
relaxing with a book. :-)

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Martín Marqués          |   Programador, DBA
Centro de Telemática    |     Administrador
               Universidad Nacional
                    del Litoral
---------------------------------------------------------

Re: Postgress and MYSQL

From
Bret Busby
Date:
On Wed, 14 Jan 2004, Matt Davies wrote:

>
> Acceptance of PG could be greatly accelerated by more:
> 1. small projects using PG as a backend (as stated in previous thread post)
> 2. documenation coming from multiple sources. Don't ask me to explain why, but
> one seems to equate robustness, usability, etc... with the more titles one
> sees. If you go to Barnes and Noble's and look there for DB books you see the
> wall of red (Oracle books), black (M$oft), blue (MySQL). I simply point out
> that perception being as it is - PG is not there. I am trying to learn more and
> more about it to remedy my newcomer understanding of PG. Do not read this as if
> I am a newbie to DB's; I am not ignorant.
>

I have just gone to www.barnesandnoble.com , and, searched on
postgresql, and got 13 results - including the famous and
previously mentioned "Teach Yourself PostgreSQL in 21 Days", by Chris
Smith, published in December 2002!

:)

--
Bret Busby
Armadale
West Australia
..............

"So once you do know what the question actually is,
 you'll know what the answer means."
- Deep Thought,
  Chapter 28 of
  "The Hitchhiker's Guide to the Galaxy:
  A Trilogy In Four Parts",
  written by Douglas Adams,
  published by Pan Books, 1992
....................................................


Re: Postgress and MYSQL

From
"Chris Travers"
Date:
From: "Keith C. Perry" <netadmin@vcsn.com>

> 3) Not being able to "find" something in via search BEFORE even reading
the
>    documentation is somewhat backwards.  You have to at least get a feel
for
>    the docs before even know what to look for.  That is not to say that
the
>    search engine is not problematic but it is to say that I'm am more and
more
>    convinced that knowing how to search more important than what is being
>    searched for.

Well put, and I like the other posts about the usefullness of a really good
index.  However, I think that there is an attitude that MySQL docs are
better for beginners because the search really takes the place of the index.
However, IMO, this masks a more subtle issue, see below.
>
> 4) As many people pointed out before, a product should not be technical
>    education it should product education.  Some people take it as being
rude
>    we some on-list says use google or check <some other site>.  Granted
>    being told "this is not hand holding" is definitely a slap in the face
its
>    been done to me and I'm sure there is a better way to put it but the
>    reality is that PG docs are very good.  Get some paper and print
>    they out double-sided- they're an excellent reference.  However, you
have to
>    understand the basics first and that simply does not belong on the PG
>    site (save a link to some community recommendations).
>
I agree to a point, in that the PostgreSQL product documentation is product
education, not general database education.  However, the "community
recommended links" approach has a number of difficiencies that I don't think
have been discussed much:

1:  Community maintained lists of links seems the easy way to go until those
links become broken or change and need to be removed due to inaccurate
content.  It may be easier over the long term to maintain our own technical
education database that we have control over.

2: You DO have a problem that PostgreSQL as a product assumes more general
knowledge than MySQL.  The docs tend to assume you know stuff, and it would
be nice to have community maintained references on these general topics,
perhaps on techdocs, perhaps elsewhere.

3:  MySQL is a database engine which seems to make sense UNTIL you are
technically educated.  Competing with MySQL may mean being able to
articulate why ACID complience is important, for example.  Or why the
database should abort the operation/transaction rather than truncate your
data in a NUMERIC column.

So what is the alternative?  I am working on some documentation but my work
is slowed by my laptop being in the shop.  Perhaps we could have a technical
education category in Techdocs?

Best Wishes,
Chris Travers


Mailing list? was Postgress and MYSQL

From
"Chris Travers"
Date:
From: "Jonathan Bartlett" <johnnyb@eskimo.com>
> We need a Postgres vs MySQL Mailing list :)

you are going to laugh but I don't think that this is such a bad idea,
provided that it is not limited to Postgres vs MySQL.  Advocacy is good and
all, but they are more interested in promoting PostgreSQL than discussing
competitive issues.  In fact, the general list seems to be dedicated to only
2 things:
support of all types and
PostgreSQL vs MySQL.

I would suggest that we consider forming a pgsql-competitive email list for
discussing PostgreSQL and how it compares with other database managers.  We
could then send out documents, etc. to other lists (general, advocacy, etc.)
for more general consideration.

We could then look at comparisons regarding Oracle, MySQL, MS SQL, etc.
without cluttering this list or the Advocacy list with material that tends
to be... voluminous but disorganized.

The list could also serve as a place for consultants to go if they want
competitive information relating to other products.

Best Wishes,
Chris Travers


Re: Postgress and MYSQL

From
"Uwe C. Schroeder"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 14 January 2004 10:18 pm, Chris Travers wrote:
> From: "Keith C. Perry" <netadmin@vcsn.com>
>
> > 3) Not being able to "find" something in via search BEFORE even reading
>
> the
>
> >    documentation is somewhat backwards.  You have to at least get a feel
>
> for
>
> >    the docs before even know what to look for.  That is not to say that
>
> the
>
> >    search engine is not problematic but it is to say that I'm am more and
>
> more
>
> >    convinced that knowing how to search more important than what is being
> >    searched for.
>
> Well put, and I like the other posts about the usefullness of a really good
> index.  However, I think that there is an attitude that MySQL docs are
> better for beginners because the search really takes the place of the
> index. However, IMO, this masks a more subtle issue, see below.
>
> > 4) As many people pointed out before, a product should not be technical
> >    education it should product education.  Some people take it as being
>
> rude
>
> >    we some on-list says use google or check <some other site>.  Granted
> >    being told "this is not hand holding" is definitely a slap in the face
>
> its
>
> >    been done to me and I'm sure there is a better way to put it but the
> >    reality is that PG docs are very good.  Get some paper and print
> >    they out double-sided- they're an excellent reference.  However, you
>
> have to
>
> >    understand the basics first and that simply does not belong on the PG
> >    site (save a link to some community recommendations).
>
> I agree to a point, in that the PostgreSQL product documentation is product
> education, not general database education.  However, the "community
> recommended links" approach has a number of difficiencies that I don't
> think have been discussed much:
>
> 1:  Community maintained lists of links seems the easy way to go until
> those links become broken or change and need to be removed due to
> inaccurate content.  It may be easier over the long term to maintain our
> own technical education database that we have control over.
>
> 2: You DO have a problem that PostgreSQL as a product assumes more general
> knowledge than MySQL.  The docs tend to assume you know stuff, and it would
> be nice to have community maintained references on these general topics,
> perhaps on techdocs, perhaps elsewhere.
>
> 3:  MySQL is a database engine which seems to make sense UNTIL you are
> technically educated.  Competing with MySQL may mean being able to
> articulate why ACID complience is important, for example.  Or why the
> database should abort the operation/transaction rather than truncate your
> data in a NUMERIC column.
>
> So what is the alternative?  I am working on some documentation but my work
> is slowed by my laptop being in the shop.  Perhaps we could have a
> technical education category in Techdocs?
>
> Best Wishes,
> Chris Travers

Basically it's a question of what product to compare postgresql with. If you
target the DB2 / Oracle / Sybase corner I don't think a lot of those admins
have a problem getting used to postgresql.
But looking around on the net and in paper publications makes it obvious that
postgresql is mostly compared to mysql - both being "open source" (well, to
some degree :-)) )
Coming from the classic DB systems around I found it much easier to use
postgresql than to use mysql - things like transactions always were a given
fact for me, so I was utterly surprised not being able to set an isolation
level in mysql.
Having the usual comparison in mind I agree with Chris that at least a link
collection to sources that educate the "average ms-access user" about basic
database concepts might prove very useful - even if people won't read it, but
at least it's much easier to point them to the right place instead of
repeating the same things over and over again.

My $0.01 <- only one cent here - need the other one for another email :-)


    UC

- --
Open Source Solutions 4U, LLC    2570 Fleetwood Drive
Phone:  +1 650 872 2425        San Bruno, CA 94066
Cell:   +1 650 302 2405        United States
Fax:    +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFABkmFjqGXBvRToM4RApSBAJ9+fKmSg9y+9O3r94PzHv2kKP/hkwCgwplv
HRVWOPFHQ6WBqUHEjq1CLlc=
=LVQX
-----END PGP SIGNATURE-----


Re: Postgress and MYSQL

From
"Keith C. Perry"
Date:
Quoting "Joshua D. Drake" <jd@commandprompt.com>:

>
> >Look I love postgresql, but reality is reality.  The database itself is
> >great, the documentation is pretty good, but a lot of the other things
> about
> >postgresql (like the website) need a lot of work.  Postgresql gives the
> >impression of being a second rate disorganized product if you were to just
> >go by the website alone.
> >
> Isn't that true of just about any OSS project? Heck, Linux doesn't even
> have a website ;).
> MySQL is not an OSS project, it is an OSS product with a commercial
> company backing
> it. There is a big difference.
>
> Sincerely,
>
> Joshua D. Drake

You're kidding me...

linux.org
linux.com   (ewwww, way to cluttered these days)
linuxhq.org
linuxhq.com (looks like their undergoing a facelift)


I seem to remember someone saying that PG is supposed to be leaning towards
being more like a "kernel" so I would like one day the site might become
conceptually like linux.org in the sense that they point you toward the various
distributions of Linux.

Comments?

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

Re: Postgress and MYSQL

From
Oleg Bartunov
Date:
On Wed, 14 Jan 2004, Rick Gigger wrote:

> > >Does anyone have any experience with postgers full text search?
> > >
> > It works well but it is my understanding that our docs search doesn't
> > use PostgreSQL
> > and TSearch. It uses PostgreSQL monogo search or something like that.
>
> That's good to hear.  What is monogo and is it the problem here?  Why don't
> it use TSearch if it is better?  Is it just a matter of someone taking the
> time to set it up?
>

I don't understand also, why not use tsearch2 for searching postgresql
documentation. All docs contains about 10-20 K unique words !
Searching arhives is another story and we're working on it on www.pgsql.ru
btw, have you seen it ?

>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

    Regards,
        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Re: Postgress and MYSQL

From
Oleg Bartunov
Date:
On Wed, 14 Jan 2004, Joshua D. Drake wrote:

>
> >That's good to hear.  What is monogo and is it the problem here?  Why don't
> >it use TSearch if it is better?  Is it just a matter of someone taking the
> >time to set it up?
> >
> >
> It is a little more complicated than that. Monogo or whatever it is
> called is more
> like a web spider that uses postgresql. Thus we can search the entire
> postgresql
> website. Tsearch is more about text search within PostgreSQL so we would
> have
> to load the books etc... into the database. That is not as easy as it
> sounds.

Then use OpenFTS if you prefer to store documents outside of database.
I don't see any problem to develop separate search on official postgres
documentations.

>
> Also if you are looking for something very cool... check out www.pgsql.ru
>
> Sincerely,
>
> Joshua D. Drake
>
>

    Regards,
        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Re: Mailing list? was Postgress and MYSQL

From
"Marc G. Fournier"
Date:
why not use pgsql-chat, which isn't being used at all right now ... ?

On Thu, 15 Jan 2004, Chris Travers wrote:

> From: "Jonathan Bartlett" <johnnyb@eskimo.com>
> > We need a Postgres vs MySQL Mailing list :)
>
> you are going to laugh but I don't think that this is such a bad idea,
> provided that it is not limited to Postgres vs MySQL.  Advocacy is good and
> all, but they are more interested in promoting PostgreSQL than discussing
> competitive issues.  In fact, the general list seems to be dedicated to only
> 2 things:
> support of all types and
> PostgreSQL vs MySQL.
>
> I would suggest that we consider forming a pgsql-competitive email list for
> discussing PostgreSQL and how it compares with other database managers.  We
> could then send out documents, etc. to other lists (general, advocacy, etc.)
> for more general consideration.
>
> We could then look at comparisons regarding Oracle, MySQL, MS SQL, etc.
> without cluttering this list or the Advocacy list with material that tends
> to be... voluminous but disorganized.
>
> The list could also serve as a place for consultants to go if they want
> competitive information relating to other products.
>
> Best Wishes,
> Chris Travers
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: Postgress and MYSQL

From
"Joshua D. Drake"
Date:
>You're kidding me...
>
>
>
No I am not... You missed the point, there is no official Linux website.
Linux.org is ran by one guy,
linux.com is run by VA (I actually used to have poet@linux.com), I own
Linuxdoc.org and Linuxdoc.com...
The closest you get to a "linux" website is kernel.org.
Sincerely,

Joshua D. Drake

>linux.org
>linux.com   (ewwww, way to cluttered these days)
>linuxhq.org
>linuxhq.com (looks like their undergoing a facelift)
>
>
>I seem to remember someone saying that PG is supposed to be leaning towards
>being more like a "kernel" so I would like one day the site might become
>conceptually like linux.org in the sense that they point you toward the various
>distributions of Linux.
>
>Comments?
>
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL


Re: Mailing list? was Postgress and MYSQL

From
Francois Suter
Date:
> why not use pgsql-chat, which isn't being used at all right now ... ?
>>
>> I would suggest that we consider forming a pgsql-competitive email
>> list for

Whatever, but using another mailing is definitely an excellent idea. I
actually stopped reading -general recently because it got bogged down
in yet another PostgreSQL vs MySQL debate. And the same happens to
advocacy too, although less frequently.

Then again this means that whoever moderates -general (is that you
Marc?) would have to move PostgreSQL vs MySQL threads to the other
mailing list whenever they crop up, otherwise any benefits will be
lost.

Cheers.

---------------
Francois

Home page: http://www.monpetitcoin.com/

"Would Descartes have programmed in Pascal?" - Umberto Eco


Re: Mailing list? was Postgress and MYSQL

From
Csaba Nagy
Date:
Hi all,

I have the impression that these "Postgres vs MySQL vs XXX" stuff is
regularly started up by newcomers to this list. So wherever you will
decide to move it, it will still pop up here - the new-comers will know
nothing about being elsewhere, except it is called something very-very
suggestive, like "postgres-mysql-compare".
Even then, it will pop up here too, and it carries the risk of heated
answers even from long term subscribers. Could this be really moderated
?
If there is to be a new list, please name it very-very suggestively,
otherwise it has no point.

Cheers,
Csaba.


On Thu, 2004-01-15 at 16:14, Marc G. Fournier wrote:
> why not use pgsql-chat, which isn't being used at all right now ... ?
>
> On Thu, 15 Jan 2004, Chris Travers wrote:
>
> > From: "Jonathan Bartlett" <johnnyb@eskimo.com>
> > > We need a Postgres vs MySQL Mailing list :)
> >
> > you are going to laugh but I don't think that this is such a bad idea,
> > provided that it is not limited to Postgres vs MySQL.  Advocacy is good and
> > all, but they are more interested in promoting PostgreSQL than discussing
> > competitive issues.  In fact, the general list seems to be dedicated to only
> > 2 things:
> > support of all types and
> > PostgreSQL vs MySQL.
> >
> > I would suggest that we consider forming a pgsql-competitive email list for
> > discussing PostgreSQL and how it compares with other database managers.  We
> > could then send out documents, etc. to other lists (general, advocacy, etc.)
> > for more general consideration.
> >
> > We could then look at comparisons regarding Oracle, MySQL, MS SQL, etc.
> > without cluttering this list or the Advocacy list with material that tends
> > to be... voluminous but disorganized.
> >
> > The list could also serve as a place for consultants to go if they want
> > competitive information relating to other products.
> >
> > Best Wishes,
> > Chris Travers
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings
> >
>
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


Re: Postgress and MYSQL

From
"Keith C. Perry"
Date:
Quoting "Joshua D. Drake" <jd@commandprompt.com>:

>
> >You're kidding me...
> >
> >
> >
> No I am not... You missed the point, there is no official Linux website.
> Linux.org is ran by one guy,
> linux.com is run by VA (I actually used to have poet@linux.com), I own
> Linuxdoc.org and Linuxdoc.com...
> The closest you get to a "linux" website is kernel.org.
> Sincerely,
>
> Joshua D. Drake

Then the word "official" is ambiguous and perhaps not even applicable.  If a
site is NOT run by Linus is it not official?  Due to how Linux is structured is
hard to say what is "official" (if you believe that concept applies).  That is
one of the things MS is expliot about Linux and OSS in general.

> >linux.org
> >linux.com   (ewwww, way to cluttered these days)
> >linuxhq.org
> >linuxhq.com (looks like their undergoing a facelift)
> >
> >
> >I seem to remember someone saying that PG is supposed to be leaning towards
> >being more like a "kernel" so I would like one day the site might become
> >conceptually like linux.org in the sense that they point you toward the
> various
> >distributions of Linux.
> >
> >Comments?
> >
> >
> >
>
>
> --
> Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
> Postgresql support, programming shared hosting and dedicated hosting.
> +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
> PostgreSQL Replicator -- production quality replication for PostgreSQL
>


--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

Re: Mailing list? was Postgress and MYSQL

From
Tom Lane
Date:
Csaba Nagy <nagy@ecircle-ag.com> writes:
> On Thu, 2004-01-15 at 16:14, Marc G. Fournier wrote:
>> why not use pgsql-chat, which isn't being used at all right now ... ?

> I have the impression that these "Postgres vs MySQL vs XXX" stuff is
> regularly started up by newcomers to this list. So wherever you will
> decide to move it, it will still pop up here - the new-comers will know
> nothing about being elsewhere, except it is called something very-very
> suggestive, like "postgres-mysql-compare".
> Even then, it will pop up here too, and it carries the risk of heated
> answers even from long term subscribers. Could this be really moderated
> ?
> If there is to be a new list, please name it very-very suggestively,
> otherwise it has no point.

I think this analysis is dead-on.  Pointing to pgsql-chat won't
accomplish anything.

            regards, tom lane

Re: Mailing list? was Postgress and MYSQL

From
"Marc G. Fournier"
Date:
On Thu, 15 Jan 2004, Francois Suter wrote:

> > why not use pgsql-chat, which isn't being used at all right now ... ?
> >>
> >> I would suggest that we consider forming a pgsql-competitive email
> >> list for
>
> Whatever, but using another mailing is definitely an excellent idea. I
> actually stopped reading -general recently because it got bogged down
> in yet another PostgreSQL vs MySQL debate. And the same happens to
> advocacy too, although less frequently.
>
> Then again this means that whoever moderates -general (is that you
> Marc?) would have to move PostgreSQL vs MySQL threads to the other
> mailing list whenever they crop up, otherwise any benefits will be
> lost.

actually, nobody "moderates" any of the lists, except for pgsql-www, and
that is only for subscribers ...

What it means is that those that are on this list, if they see a tangent
tread popping up, need to learn to respond to the correct list, CC'ng in
the original poster, so that subsequent responses go to the other list ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: Mailing list? was Postgress and MYSQL

From
"Marc G. Fournier"
Date:
On Thu, 15 Jan 2004, Tom Lane wrote:

> Csaba Nagy <nagy@ecircle-ag.com> writes:
> > On Thu, 2004-01-15 at 16:14, Marc G. Fournier wrote:
> >> why not use pgsql-chat, which isn't being used at all right now ... ?
>
> > I have the impression that these "Postgres vs MySQL vs XXX" stuff is
> > regularly started up by newcomers to this list. So wherever you will
> > decide to move it, it will still pop up here - the new-comers will know
> > nothing about being elsewhere, except it is called something very-very
> > suggestive, like "postgres-mysql-compare".
> > Even then, it will pop up here too, and it carries the risk of heated
> > answers even from long term subscribers. Could this be really moderated
> > ?
> > If there is to be a new list, please name it very-very suggestively,
> > otherwise it has no point.
>
> I think this analysis is dead-on.  Pointing to pgsql-chat won't
> accomplish anything.

No, but if ppl change the CC to pgsql-general to pgsql-chat, so that there
responses went to that list and didn't go to -general, ppl would slowly
learn ...

Even if the Postgress and MYSQL thread was originally sent to -general, if
everyone that responded ot it changed pgsql-general -> pgsql-chat, then
the onoly thing that would have touched the -general list would have been
that original message ...

Its a matter of how much energy ppl are willing to expend on keeping the
lists more pure, that's all ...

again, as long as you CC in the person that started it originally, so that
they know that the topic has shifted to a different list ...


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: Postgress and MYSQL

From
Date:
I am currently evaluating all open source databases and possibly my fresh
opinion will be of interest.

I went over documentation and setup of Firebird, MySQL and PostgreSql and
here is "perception"(to get better understanding one has to run thing for
quite a while):

As for "user friendly" image:  Firebird and MySQL are ok, PostgreSQL's web
site really has some glitches. Example, a search on everything more then 1-2
words never completes, i.e. one immeadiately notices SQL datbase runing
behind the scene... :-(

As for SQL features, Firebird and PostgreSQL are close - both have a
"triplet": stored procedures, triggers, views.
MySQL however has plans for all that in the next version.

As for speed: MySQL claims supremacy, at least that's in the benchmarks which
innoDB and mysql sites provide.

As for architecture then multi-versioning is implemented the same way for
both Firebird and PostgreSQL and both have some troubles when collecting
garbage. innoDB of MySQL doesn't even hide they implemented things "like
Oracle"(i.e. rollback segments): this model is good for garbage collection
but can  potentially terminate long running queries with kind of "ora-01555
snapshot to old" error. Personally I prefer rollback segments solution as old
versions are reclaimed behind the scene while "snapshot to old" error can be
delt with.
Otherwise Firebird seems to have plans for WAL and shared SQL buffer.


Therefor if all goes like planned then both internals(in terms of features
like WAL, shared SQL buffers and so on) and SQL features of all databases
will be extremely similar with some differences in multi-versioning handling.
MySQL may(just may) claim a better speed, Firebird and postgreSql will have
more standard("clean") SQL.

Here is this year's "database of the year" poll
http://www.linuxquestions.org/questions/showthread.php?s=&threadid=116360






Re: PostgreSQL and MYSQL

From
Christopher Browne
Date:
netadmin@vcsn.com ("Keith C. Perry") writes:
> Quoting "Joshua D. Drake" <jd@commandprompt.com>:
>> >Look I love postgresql, but reality is reality.  The database itself is
>> >great, the documentation is pretty good, but a lot of the other things
>> about
>> >postgresql (like the website) need a lot of work.  Postgresql gives the
>> >impression of being a second rate disorganized product if you were to just
>> >go by the website alone.
>> >
>> Isn't that true of just about any OSS project? Heck, Linux doesn't even
>> have a website ;).
>> MySQL is not an OSS project, it is an OSS product with a commercial
>> company backing it. There is a big difference.
>>
>> Sincerely,
>>
>> Joshua D. Drake
>
> You're kidding me...
>
> linux.org
> linux.com   (ewwww, way to cluttered these days)
> linuxhq.org
> linuxhq.com (looks like their undergoing a facelift)

 for i in linux.com linux.org linux.info linuxhq.org linuxhq.com; do
> echo $i
> whois $i | grep -i -4 Registrant
> done | more_filtering

linux.com

Registrant:
 VA Software Corporation (OSDN)
 47071 Bayside Parkway
 Fremont, CA 94538
 US

linux.org

Registrant ID:22275688-NSI
Registrant Name:Linux Online, Inc
Registrant Organization:Linux Online, Inc
Registrant Street1:59 E. River St, #2
Registrant City:Ogdensburg
Registrant State/Province:NY
Registrant Postal Code:13669
Registrant Country:US
Registrant Email:mmclagan@INVLOGIC.COM

linux.info
Trademark Number:4346339
Sponsoring Registrar:R110-LRMS
Status:ACTIVE
Status:OK
Registrant ID:C20726-LRMS
Registrant Name:Tokio Matsumoto
Registrant Organization:Bijou Co.ltd.
Registrant Street1:17-2 harumi-cho
Registrant City:kasugai
Registrant State/Province:Aichi
Registrant Postal Code:4860837
Registrant Country:JP
Registrant Phone:+81.0568568208
Registrant FAX:+81.0568568208
Registrant Email:cupfarm@kctv.ne.jp

linuxhq.org
Last Updated On:19-Nov-2003 19:30:36 UTC
Expiration Date:16-Dec-2005 05:00:00 UTC
Sponsoring Registrar:R91-LROR
Status:OK
Registrant ID:GODA-01869555
Registrant Name:Taylor Kimball
Registrant Street1:5701 Lindero Canyon Road
Registrant City:Westlake
Registrant State/Province:California
Registrant Postal Code:91364
Registrant Country:US
Registrant Phone:+1.8186180510
Registrant Email:taylorzanti@yahoo.com

linuxhq.com

Registrant:
Linux Headquarters, Inc (LINUXHQ-DOM)
   59 E. River St, #2
   Ogdensburg, NY 13669
   US

Not a single one of these sites belongs to anyone with any official
standing vis-a-vis Linux.

Actually, if there _is_ an "official" Linux site, it is kernel.org:

$ whois kernel.org | filtering

Domain ID:D169413-LROR
Domain Name:KERNEL.ORG
Created On:07-Mar-1997 05:00:00 UTC
Last Updated On:12-Jan-2004 05:33:05 UTC
Expiration Date:08-Mar-2009 05:00:00 UTC
Sponsoring Registrar:R42-LROR
Status:OK
Registrant ID:0-698778-Gandi
Registrant Name:Transmeta Corporation
Registrant Organization:Transmeta Corporation
Registrant Street1:Attn: H. Peter Anvin
Registrant Street2:3990 Freedom Circle
Registrant City:Santa Clara
Registrant State/Province:California
Registrant Postal Code:95054
Registrant Country:US
Registrant Email:hostmaster@kernel.org

Peter Anvin, unlike all the other registrants of domains you
mentioned, is, in fact, a Linux developer.

>> MySQL is not an OSS project, it is an OSS product with a commercial
>> company backing it. There is a big difference.

I would reword that a bit...

  MySQL(tm) is not an OSS project.  It is a commercial product whose
  owners permit access to an "OSS" version of it.

Furthermore, "MySQL" is not one thing, but rather _three_ things, all
of which are tightly held by one entity:

  1.  It is a trademark.  You can't use it except with permission of 3.

  2.  That trademark is used to describe a set of products mostly having
      to do with databases.

  3.  It is the name of a company, MySQL AB, that are the owners of 1
      and 2.

Indeed, pointing back at #2, I would suggest that MOST of the
discussion has been overly loose in usage of the proprietary
trademarks.  The vendor (#3) expects people describing the product in
public to properly reference the fact that it is a registered
trademark, via use of "(tm)".
--
let name="cbbrowne" and tld="libertyrms.info" in String.concat "@" [name;tld];;
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 646 3304 x124 (land)

Re: Postgress and MYSQL

From
Christopher Browne
Date:
jd@commandprompt.com ("Joshua D. Drake") writes:
>>BTW, I've asked this before but where are the 7.4 docs in PS or PDF format?  If
>>
>
> They are being worked on ;)
>
>>any one needs or wants them, I do have the 7.3.2-US books (admin, user,
>>programmer & reference) in PS with the duplexing code.  They all fit nicely in a
>>3" ring binder and will compliment any bookshelf  :)

Quick question that popped up when chatting with a friend that's
considering using PG...

The PDF documentation set didn't seem to have _valid_ links from
indices/table-of-contents to the 'destinations.'  I don't recall
offhand; might this be that he grabbed something a bit old-and-broken?
Or have there been troubles with this with the DocBook tools?
--
let name="cbbrowne" and tld="libertyrms.info" in String.concat "@" [name;tld];;
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 646 3304 x124 (land)

Re: Postgress and MYSQL

From
"ezra epstein"
Date:
""Bob Powell"" <Bob@hotchkiss.org> wrote in message
news:s003d760.005@grpwise.hotchkiss.org...
> To whom it may concern:
>
> I find the recent articles in various trade publications a little
> disturbing due to the lack of PostgrSQL mention.  I continue to see
> articles about how IBM may be considering MYSQL for development an
> open_source web database.
>
> Why isn't PostgreSQL being considered or talked about by major industry
> giants?  As a DBA I know that Postgres is far superior to MYSQL but if
> the industry directs it's energies towards open-source database this
> coming year I think somehow PostgreSQL needs to be represented better.
>

Hear, hear!

Almost all the replies are about technical superiority.  But, as we have all
seen dozens of times over, marketing trumps technology in the marketplace.

So the only "fix" is to find vocal, clear and market-savvy evangelist(s) for
Postgres.  Doesn't even need to be technically savvy (probably helps if the
person isn't).

== Ezra Epostein.



Re: Postgress and MYSQL

From
Christopher Browne
Date:
After a long battle with technology, Bob@hotchkiss.org ("Bob Powell"), an earthling, wrote:
> To whom it may concern:
>
> I find the recent articles in various trade publications a little
> disturbing due to the lack of PostgrSQL mention.  I continue to see
> articles about how IBM may be considering MYSQL for development an
> open_source web database.
>
> Why isn't PostgreSQL being considered or talked about by major industry
> giants?  As a DBA I know that Postgres is far superior to MYSQL but if
> the industry directs it's energies towards open-source database this
> coming year I think somehow PostgreSQL needs to be represented better.

For IBM, in particular, it would be hugely counterproductive to point
people to something that might take away from the sales of their own
products.  After all, they bought Informix and Universe, and developed
DB/2.  There's presumably some money in the latter.

Furthermore, there's presumably some money in getting people to adopt
a product that has rudimentary support for what they need, and then,
when scalability proves troublesome, migrate them to DB/2.

Mind you, as the recent changes to the licensing and marketing of
MySQL AB get better known, it is also possible that IBM would
(correctly) perceive them as competition (irrespective of technical
merits), and either demand money for promoting the product, or cease
promoting it.
--
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://cbbrowne.com/info/nonrdbms.html
"very few people approach me in real life and insist on proving they
are drooling idiots."  -- Erik Naggum, comp.lang.lisp

Re: Postgress and MYSQL

From
Andrew Sullivan
Date:
On Wed, Jan 14, 2004 at 11:40:04AM -0800, Chris Ochs wrote:

> I am playing around with Erserver, but the download has to be updated from
> cvs or it won't even compile (corrupted file in the distribution).  It

Fixing this has been on my TODO list for several weeks now, but it
keeps failing to make it to the top.  (Fortunately, at work vacations
are more or less all done, and we've hired another person, so I may
actually have some time soon to do something about this.)

> appears to me at first glance that it is not actively being worked on,

It certainly is.  There's a mailing list where you can follow
development.

> The Erserver I downloaded is free, although I was confused also because I
> found that same page that said it was $1000.  I'm still not sure if the
> erserver I downloaded is the only version, or if there is a commercial
> version?

There's a commercial version as well.  It shares some of, but not all
of, the code.

A

--
Andrew Sullivan
It never occurred to them that, if everyone had to think outside the box,
maybe it was the box that needed fixing.
        --Malcom Gladwell

Re: Postgress and MYSQL

From
Steve Atkins
Date:
On Wed, Jan 14, 2004 at 12:37:55PM -0800, Joshua D. Drake wrote:
> >I used to have that complaint until I got more aquainted with the docs.
> >When I used to use mysql I found that if I used search feature on their
> >docs
> >I could find exactly what I was looking for almost immediately.  When I use
> >the postgres doc search feature I don't get the same experience.  It is
> >
> >
> Our doc search sucks. No question... there has been some work recently on it
> but it doesn't seem to be that reliable. So you have us on that one.

Would there be any interest in a standalone, non web-based, version of
the docs, with a built-in search engine? Similar to, say, MSDN or Qt
documentation.

Cheers,
  Steve


erServer (was: Re: Postgress and MYSQL)

From
Devrim GUNDUZ
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Mon, 19 Jan 2004, Andrew Sullivan wrote:

> On Wed, Jan 14, 2004 at 11:40:04AM -0800, Chris Ochs wrote:
>
> > I am playing around with Erserver, but the download has to be updated from
> > cvs or it won't even compile (corrupted file in the distribution).  It
>
> Fixing this has been on my TODO list for several weeks now, but it
> keeps failing to make it to the top.  (Fortunately, at work vacations
> are more or less all done, and we've hired another person, so I may
> actually have some time soon to do something about this.)

In fact we would announce it next week, but I and Nicolai Tufar patched
eRServer current CVS version last week, since it fails to configure
and compile on most systems.

Here is the url for the patches and patched versions:

http://www.tdmsoft.com/PostgreSQL/download/

We'll submit the patches to gborg next week.

Regards,
- --
Devrim GUNDUZ
devrim@gunduz.org                devrim.gunduz@linux.org.tr
            http://www.TDMSoft.com
            http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFADNXftl86P3SPfQ4RAjR2AKCtVMoDCIWh5aAnJKKlw/R+8em1VACfZCWR
FZWueuj306ZVey/ihfI6scQ=
=r+O5
-----END PGP SIGNATURE-----


Re: erServer (was: Re: Postgress and MYSQL)

From
Andrew Sullivan
Date:
On Tue, Jan 20, 2004 at 09:16:45AM +0200, Devrim GUNDUZ wrote:
> In fact we would announce it next week, but I and Nicolai Tufar patched
> eRServer current CVS version last week, since it fails to configure
> and compile on most systems.

Bug reports are welcome.  I look forward to the patches.

A

--
Andrew Sullivan

Re: Mailing list? was Postgress and MYSQL

From
Bruce Momjian
Date:
Tom Lane wrote:
> Csaba Nagy <nagy@ecircle-ag.com> writes:
> > On Thu, 2004-01-15 at 16:14, Marc G. Fournier wrote:
> >> why not use pgsql-chat, which isn't being used at all right now ... ?
>
> > I have the impression that these "Postgres vs MySQL vs XXX" stuff is
> > regularly started up by newcomers to this list. So wherever you will
> > decide to move it, it will still pop up here - the new-comers will know
> > nothing about being elsewhere, except it is called something very-very
> > suggestive, like "postgres-mysql-compare".
> > Even then, it will pop up here too, and it carries the risk of heated
> > answers even from long term subscribers. Could this be really moderated
> > ?
> > If there is to be a new list, please name it very-very suggestively,
> > otherwise it has no point.
>
> I think this analysis is dead-on.  Pointing to pgsql-chat won't
> accomplish anything.

I always felt advocacy was the right place for database comparisons
directed to increasing market share.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073