Re: [HACKERS] What can we learn from MySQL?

2004-04-27 Thread Karel Zak
On Mon, Apr 26, 2004 at 04:41:35PM -0400, Bruce Momjian wrote: Jean-Michel POURE wrote: [ PGP not available, raw data follows ] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My question is, What can we learn from MySQL? I don't know there is anything, but I think it makes sense to

Re: [HACKERS] What can we learn from MySQL?

2004-04-26 Thread Jim C. Nasby
I'm certain you guys could do a far better installer than the one Oracle has, which is very, very fragile. There's all kinds of wonkiness to try and get it to work on a non-supported linux distro (gentoo in my case), and from talking to people who've dealt with it on redhat it's no better. Also,

Re: [HACKERS] What can we learn from MySQL?

2004-04-26 Thread Bruce Momjian
Jean-Michel POURE wrote: [ PGP not available, raw data follows ] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My question is, What can we learn from MySQL?  I don't know there is anything, but I think it makes sense to ask the question. Dear Bruce, Taking the example of pgAdmin III,

Re: [HACKERS] What can we learn from MySQL?

2004-04-26 Thread Jean-Michel POURE
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My question is, What can we learn from MySQL?  I don't know there is anything, but I think it makes sense to ask the question. Dear Bruce, Taking the example of pgAdmin III, which reached nearly one million hits in December

Re: [HACKERS] What can we learn from MySQL?

2004-04-24 Thread Bruno Wolff III
On Fri, Apr 23, 2004 at 16:36:57 -0400, [EMAIL PROTECTED] wrote: Ease of use is VERY important, but few suggestions that address this are ever really accepted. Yes, focusing on the functionality is the primary concern, but how you set it up and deploy it is VERY important. You guys need to

Re: [HACKERS] What can we learn from MySQL?

2004-04-24 Thread Jordan Henderson
I think that when considering install, it is very important, if not critical, that we all understand who is doing the install. Certainly if it is a person much like us, meaning people on the hackers/development list, we can all handle more terse installs. Personally, I like the freedom of

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread David Garamond
Bruce Momjian wrote: My question is, What can we learn from MySQL? I don't know there is anything, but I think it makes sense to ask the question. MySQL was my first introduction to SQL databases (I had dabbled with Clipper and Foxpro years earlier, but only for a couple of months and had

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Shachar Shemesh
Bruce Momjian wrote: Here is a blog about a recent MySQL conference with title, Why MySQL Grew So Fast: http://www.oreillynet.com/pub/wlg/4715 and a a Slashdot discussion about it: http://developers.slashdot.org/article.pl?sid=04/04/20/2229212mode=nestedtid=137tid=185tid=187tid=198 My

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Fabien COELHO
My question is, What can we learn from MySQL? I don't know there is anything, but I think it makes sense to ask the question. Questions I have are: o Are we focused enough on ease-of-use issues? There are two issues here : ease-of-use for admin and basic users. I recognize my

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Karel Zak
On Fri, Apr 23, 2004 at 01:05:21PM +0700, David Garamond wrote: So in my opinion, as long as the general awareness about RDBMS (on what tasks/responsibilities it should do, what features it generally has to have, etc) is low, people will be looking at MySQL as good enough and will not be

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Dennis Bjorklund
On Fri, 23 Apr 2004, Shachar Shemesh wrote: When I ask about non-standard complience of Pg (turning unquoted identifiers to lowercase instead of uppercase, violating the SQL standard, and requring an expensive rewrite of clients), and I get the answer uppercase is ugly, I think something

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Hans-Jürgen Schönig
Karel Zak wrote: On Fri, Apr 23, 2004 at 01:05:21PM +0700, David Garamond wrote: So in my opinion, as long as the general awareness about RDBMS (on what tasks/responsibilities it should do, what features it generally has to have, etc) is low, people will be looking at MySQL as good enough and

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Tom Lane
Dennis Bjorklund [EMAIL PROTECTED] writes: On Fri, 23 Apr 2004, Shachar Shemesh wrote: When I ask about non-standard complience of Pg (turning unquoted identifiers to lowercase instead of uppercase, violating the SQL standard, and requring an expensive rewrite of clients), and I get the

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Matthew T. O'Connor
There are two issues here : ease-of-use for admin and basic users. On for former point, admin ease-of-use, A little story a few month ago. I succeeded in advising production people here to switch some applications from a mysql database, which was working perfectly, to a postgres database. A

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Fabien COELHO
Dear Matthew, My goal is to have pg_autovacuum integrated into the backend for 7.5. I know about that, and that would be a good thing. I don't know if it will default to being turned on or off, I'm sure that will be a discussion, but if it is defaulted to on, then this whole problem of

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Thomas Swan
Bruce Momjian wrote: My question is, What can we learn from MySQL? I don't know there is anything, but I think it makes sense to ask the question. MySQL became popular at my university when the students discovered they could install it on their personal computers. Just the exposure for

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Matthew T. O'Connor
My goal is to have pg_autovacuum integrated into the backend for 7.5. I know about that, and that would be a good thing. I hope so! I don't know if it will default to being turned on or off, I'm sure that will be a discussion, but if it is defaulted to on, then this whole problem of having

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Bruce Momjian
Matthew T. O'Connor wrote: I think it's premature to have this conversation. I need to get something done / working before we dicuss optimal configuration. That said, I also agree that if it's good enough, it should be on by default. Good luck;-) Thanks, I'll need it Matthew

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Dave Cramer
Does the current implementation of pg_autovacuum have a way of setting windows where it is allowed to vacuum? Many large 24/7 will only allow vacuumming at certain times of the day. Dave On Fri, 2004-04-23 at 08:58, Matthew T. O'Connor wrote: There are two issues here : ease-of-use for admin

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread D'Arcy J.M. Cain
On Fri, 23 Apr 2004 11:07:20 -0400 Dave Cramer [EMAIL PROTECTED] wrote: Does the current implementation of pg_autovacuum have a way of setting windows where it is allowed to vacuum? Many large 24/7 will only allow vacuumming at certain times of the day. It seems to me that the point of

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Matthew T. O'Connor
Does the current implementation of pg_autovacuum have a way of setting windows where it is allowed to vacuum? Many large 24/7 will only allow vacuumming at certain times of the day. No the current implementation doesn't, but such a feature is in the works (planned anyway). What I was

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Matthew T. O'Connor
On Fri, 23 Apr 2004 11:07:20 -0400 Dave Cramer [EMAIL PROTECTED] wrote: Does the current implementation of pg_autovacuum have a way of setting windows where it is allowed to vacuum? Many large 24/7 will only allow vacuumming at certain times of the day. It seems to me that the point of

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Bruce Momjian
D'Arcy J.M. Cain wrote: On Fri, 23 Apr 2004 11:07:20 -0400 Dave Cramer [EMAIL PROTECTED] wrote: Does the current implementation of pg_autovacuum have a way of setting windows where it is allowed to vacuum? Many large 24/7 will only allow vacuumming at certain times of the day. It seems

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread D'Arcy J.M. Cain
On Fri, 23 Apr 2004 13:08:30 -0400 (EDT) Bruce Momjian [EMAIL PROTECTED] wrote: D'Arcy J.M. Cain wrote: It seems to me that the point of pg_autovacuum would be to run 24/7 so that there is never big hit on the system. Perhaps it could be designed to throttle itself based on current system

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread J. Andrew Rogers
On Thu, 2004-04-22 at 21:09, Bruce Momjian wrote: Questions I have are: o Are we marketing ourselves properly? It is perhaps less a matter of marketing and more a matter of word-of-mouth mind share. I don't see much evidence of effective direct marketing, but I've noticed a huge growth

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Merlin Moncure
J. Andrew Rogers wrote: No. The greatest strength of Postgres, marketing-wise, are technical and is what drives its growth today. I think most of the ease-of-use issues are in the packaging of the larger Postgres product and mid-level developer documentation, both of which seem to be

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread pgsql
I have been thinking about this subject for a LONG time, and I hope I have something to contribute. My question is, What can we learn from MySQL? I don't know there is anything, but I think it makes sense to ask the question. Questions I have are: o Are we marketing ourselves

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Alvar Freude
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, - -- Bruce Momjian [EMAIL PROTECTED] wrote: o Are we marketing ourselves properly? while talking about MySQL, there is the myth, that MySQL is fast; and that because MyISAM has no transactions, that it is faster. That is in most cases

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Alvar Freude
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, - -- [EMAIL PROTECTED] wrote: I would say this is a clear 'NO!' When ever I read about open-source being used anywhere, I always read MySQL. They are *very* good at this. yes! Some days ago, there was a news in the Heise Newsticker (most