473,889 Members | 1,327 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Is my MySQL Gaining ?

Dear all,

Their was a huge rore about MySQL recently for something in java functions
now theirs one more

http://www.mysql.com/doc/en/News-5.0.x.html

Does this concern anyone.

What I think is PostgreSQL would have less USP's (Uniqe Selling Points
though we dont sell) now.

What do you think yes we PostgreSQL users need some introspection.

Regards,
Vishal Kashyap.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05
175 11574
Bruno Wolff III <br***@wolff.to > writes:
I still don't see that there needs to be a lot more added to the postgres
update command documentation. The main thing missing is links to the
syntax definitions for things like from list, condition and expression.


This is in part because before 7.4, those things were in separate
"books" and so you couldn't easily make a cross-reference to them.
Now that we build the docs as one big book, cross-references are easy.
It's just a matter of someone taking the time to go through and add
them. Do I hear a volunteer?

BTW, I'd not be in favor of separating out the Tutorial into a separate
document again, precisely because we would lose the ability for it to
easily cross-reference the main docs.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #141
On Tue, Dec 30, 2003 at 12:20:03 -0500,
Tom Lane <tg*@sss.pgh.pa .us> wrote:
Bruno Wolff III <br***@wolff.to > writes:
I still don't see that there needs to be a lot more added to the postgres
update command documentation. The main thing missing is links to the
syntax definitions for things like from list, condition and expression.


This is in part because before 7.4, those things were in separate
"books" and so you couldn't easily make a cross-reference to them.
Now that we build the docs as one big book, cross-references are easy.
It's just a matter of someone taking the time to go through and add
them. Do I hear a volunteer?


I will do this for the UPDATE command to get some feedback and assuming
that goes well, I am willing to go through the commands section of the
manual looking for other appropiate cross references.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 12 '05 #142
Hello

I had queried about the issue before and tried to
google for solution. But still I am not able to find
windows version of libpq.

I installed postgresql ( not from source though )
using cygwin. It installed the header files needed for
pg development. It even installed libpq.a but not
libpq.lib ( is libpq.a windows compliant ). Where can
I get precompiled copy of latest libpq.lib.

Also this may be off list....I downloaded the source
of pgAdmin III ( to know live examples of working PG C
API ). The project needs some libs called ssleay.lib
etc. Are these pg specific or for what? Cant seem to
compile it.

I am using WinXP Pro with VC++ 6.0.

Regards
Karam

_______________ _______________ ____
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #143
Quoting DeJuan Jackson <dj******@speed fc.com>:
B. van Ouwerkerk wrote:
IMO there's no valid reason for MySQL bashing. I'm not going to defend
either one because that kind of discussion leads to nowhere.


How about pure entertainment? Or maybe because we don't have anything
better to do on a Friday night because the one girl this year who
actually said she would go out with us has stood us up? But were not
bitter at all at that slut and she uses MySQL I just no it, I bet she's
using it right now and laughing... LAUGHING at me...

See it can be very therapeutic :)

LOL- yea, that was actually!
Seriously though- another sub-text of this thread **is** defending how MySQL
documentation is "better" than PostgreSQL's. Of course many have responded with
various opinions as to why it is not "better".

I personally don't see much weight in the arguement because comparisons by
nature are subjective. There's everyone from the person whose has just heard
what SQL stands for to the person that can receit the specifications. Couple
that with the fact that MySQL just isn't on the same level yet to be making the
comparison and what you have is a bit of a mess.

I'm not sure how this "mess" gets cleaned up but like Tom indicated earlier in
this thread, this is open source so if you want something done that is not so
high up on the list, you're probably going to have to do it yourself or at least
in a smaller group.

It seems for the MySQL folks (which I was for a very short time) I would say
that a study of SQL itself might be warranted. It just really is not
appropriate to duplicate the basics for which there is a tremendous amount of
information online already You should not have a problem finding something that
you like.

I learned PG by studying SQL and finding some examples/tutorials online and at
first trying them in mSQL, MySQL (which was difficult because it wasn't very
standard) and later in PostgreSQL. Once I understood SQL and actually played
around with some products I found having a reference (like PG's docs) to be my
bible. Those of you who are new to the product don't realize have far the docs
have come from the 6.x days nor does it really matter to you when you need a
question answered at 2am. Thats the rub!. If you have grown with one culture,
you really can't come to another one and expect to be at the same point. In a
sense you have to start over but with your mind open to a new way of doing things.

This is very similar to how people dissatified with M$ come over to Linux or the
Mac world. They are very anxious to do away with the old and get on with the
new. The problem is that they forget there is a learning curve- easier or hard.
Lets face it, a lot of people don't like to "learn" so if something new is not
"easy" to do in the long run it won't go far. Just look how new products are
marketed on TV. Not to say that that is the right way to do things- just to say
that it is done. This is always going to be a the balancing act for good
products- marketability vs. functionality

I apologize now if this seems like a dig at MySQL users- it truely is not but I
do get the sense that the issue with PG is really more an issue with
understanding SQL and RDBMS' in general.
--
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 12 '05 #144
On Tue, 2003-12-30 at 17:20, Tom Lane wrote:
Now that we build the docs as one big book, cross-references are easy.
It's just a matter of someone taking the time to go through and add
them. Do I hear a volunteer?


I'll have a go at it. Gradually...

--
Oliver Elphick Ol************@ lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
=============== =============== ==========
"Give to him that asketh thee, and from him that would
borrow of thee turn not away."
Matthew 5:42
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #145
I want to use one subject line to discuss many different
topics on this mailing list. Which subject should I use?
Is there a prize for longest thread on this list?

- MySQL has Java support in alpha
- MySQL has documentation that newbies like
- MySQL features are alpha and 2 years away
- PostgreSQL already has MySQLs proposed features
- PostgreSQL stored procedures rock
- Can we have nested transactions, please?
- We like everything about MySQL (docs, website, 3rd party tools)
except the database
- PostgreSQL is more robust and mature
- MySQL developers are doing a 180 turn from their "you don't need
that" stance
- PostgreSQL needs volunteers for documentation enhancements
- Somebody on the list missed a date with a MySQL girlfriend
- Elephants never forget and can step on dolphins
- ...

Oh nevermind, I'll just use 'Is my MySQL Gaining?' for a subject.
Yeah, that works.

----------
Dante

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #146
On Wednesday 31 December 2003 05:23, Oliver Elphick wrote:
On Tue, 2003-12-30 at 17:20, Tom Lane wrote:
Now that we build the docs as one big book, cross-references are easy.
It's just a matter of someone taking the time to go through and add
them. Do I hear a volunteer?


I'll have a go at it. Gradually...


I'm with Oliver - I'll be happy to put my name down for doing a few sections
in the docs.. just name them

rgds,

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

Nov 12 '05 #147
D. Dante Lorenso wrote:
I want to use one subject line to discuss many different
topics on this mailing list. Which subject should I use?
Is there a prize for longest thread on this list?

- MySQL has Java support in alpha
- MySQL has documentation that newbies like
- MySQL features are alpha and 2 years away
- PostgreSQL already has MySQLs proposed features
- PostgreSQL stored procedures rock
- Can we have nested transactions, please?
- We like everything about MySQL (docs, website, 3rd party tools)
except the database
- PostgreSQL is more robust and mature
- MySQL developers are doing a 180 turn from their "you don't need
that" stance
- PostgreSQL needs volunteers for documentation enhancements
- Somebody on the list missed a date with a MySQL girlfriend
- Elephants never forget and can step on dolphins
- ...

Oh nevermind, I'll just use 'Is my MySQL Gaining?' for a subject.
Yeah, that works.


I think that sums the thread up nicely. :-)

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #148
On Fri, Dec 26, 2003 at 10:02:25AM -0500, Jan Wieck wrote:
It seems to concern MySQL now at least. They have changed their minds on
many enterprise features that PostgreSQL has for years. The strategy of
misguiding people like "you don't need foreign keys", "you don't need
stored procedures", "yadda yadda triggers", "blah blah views" didn't
work forever. So they have to add or propose those features one by one.


Anyone have a copy of their older docs where they argued that row level
locking was bad and that you should only do table level locking? :)
--
Jim C. Nasby, Database Consultant ji*@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #149
On Tuesday 30 December 2003 06:50, B. van Ouwerkerk wrote:
I don't know that particular book myself but the book MySQL written by Paul
DuBois took me much less then 21 days :-) I have yet to find a simular book
about PostgreSQL..


uh... I would have to think that Korry Douglas's book titled "PostgreSQL " from
the same publisher must be somewhat similar.

http://www.amazon.com/exec/obidos/AS...846574-6863256

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

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

Nov 12 '05 #150

This thread has been closed and replies have been disabled. Please start a new discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.