What other development options do we have for soemthing that is GUI and
portable to all platforms that postgresql runs on? Java? wxWindows? Qt?
Gtk? I would think that Gtk is probably the most portable, and it has
bindings to many languages, but we would probalby want to use C.
TOra uses
I wasn't really comparing to MySQL here. I meant, in relationship
to MS Access. Start it up and it just works.
Yeah, a point-and-drool installation wizard for postgres under windows
would be great. I think, from looking at PGAdminII, that we've already
got great admin tools; it seems just
Two points to this discussion.
I hate to admit this, but to some people, a Windows version is important.
Yesterday I learned that one product developed here will have a MySQL
implementation because marketing wants a free implementation.
The biggest advantage seems to be that it's working on
Yeah, a point-and-drool installation wizard for postgres under windows
would be great. I think, from looking at PGAdminII, that we've already
got great admin tools; it seems just as good as SQL Server Enterprise
Manager to me.
Once we have a proper Win32 native version, the guy in our
Julian Mehnle wrote:
Yeah, it does *not* exhibit the faulty CRLF-LF conversion behavior.
Is this a custom build of the ODBC driver done by you? Will the
official driver be fixed soon?
I would commit the fix to cvs this week.
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/
I have started a java admin tool on sourceforge just 2 weeks ago
actually, www.sf.net/jpgadmin
Dave
On Wed, 2002-06-26 at 02:51, Christopher Kings-Lynne wrote:
What other development options do we have for soemthing that is GUI and
portable to all platforms that postgresql runs on? Java?
Hi, my name is Emil, I am a software engineer at NEC, Japan. This is not in
any way related to my work, but I am that interested in cygwin that I
installed it on my own PC and right now I am enjoying it. Your work is a
good one really, I appreciate what you guys are doing.
I am just wondering,
Marc G. Fournier [EMAIL PROTECTED] writes:
On Tue, 25 Jun 2002, Tom Lane wrote:
It also occurs to me that discussing this on -hackers, which is a
technically focused list, is itself somewhat wrongheaded. The best
list we have for it at the moment is -general, but I wonder whether we
This mail was sent to pgadmin-hackers list by Mark Radulovich
[EMAIL PROTECTED]. It is quite interesting:
*
I've been following these mailing lists for over two years, and I guess now
is the time to chime in. I
Jonah H. Harris wrote:
Who originally did the TPC-C benchmarks? Is the source available for them?
Great Bridge once ran some sort of (what they thought it would be) TPC-C
benchmark. They used the proprietary Benchmark Factory software for
doing so.
While working there I had some time to
Curt Sampson [EMAIL PROTECTED] writes:
Note that your proposal of using mmap to replace sysv shared memory
relies on the behaviour I've described too.
True, but I was not envisioning mapping an actual file --- at least
on HPUX, the only way to generate an arbitrary-sized shared memory
region
-Original Message-
From: Greg Sabino Mullane [mailto:[EMAIL PROTECTED]]
Sent: 25 June 2002 20:04
To: [EMAIL PROTECTED]
Subject: [HACKERS] Postgres idea list
12. Offer something fun: a naming contest for the elephant (I know,
I know),
Isn't the elephant called Slonik? I
-Original Message-
From: Josh Berkus [mailto:[EMAIL PROTECTED]]
Sent: 26 June 2002 01:51
To: [EMAIL PROTECTED]
Cc: Rod Taylor
Subject: Re: [HACKERS] Postgres idea list
Folks,
What would be a win is an SQL like interface to editing pg_hba.conf
and postgresql.conf.
Hackers,
as some of you figured already, Katie Ward and I are working fulltime on
PostgreSQL and are actually doing a native Win32 port. This port is not
based on CygWIN, Apache or any other compatibility library but uses 100%
native Windows functionality only.
We already have it far enough to
On Wed, Jun 26, 2002 at 12:22:54PM +0900, Emilio Uy III wrote:
I am just wondering, because I have installed PostgreSQL on my Cygwin
(Windows NT) and this is my first time to attempt a dive into the database
realm. I am not sure of this, but there should be a way to access a database
Hi Tom,
Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
snip
You mean a list like ... oh, I don't know ...
[EMAIL PROTECTED]? :)
You know, I seemed to remember that we had such a list, but I looked at
http://archives.postgresql.org/
and saw no archive for it, so I figured
I have been reviewing Rod Taylor's pg_depend patch, which among other
things adds SQL-compliant DROP RESTRICT/CASCADE syntax and prevents
you from dropping things that other things depend on, as in ye olde
novice error of dropping a function used by a trigger.
As submitted, the patch gives
I guess the website is really good. The only thing I'd do is to add a
section listing the core features of PostgreSQL - I think this could be
an important point.
In my opinion MySQL is not a competitor and we should not benchmark
PostgreSQL and compare it with MySQL. Those features which are
Tom Lane wrote:
Curt Sampson [EMAIL PROTECTED] writes:
Note that your proposal of using mmap to replace sysv shared memory
relies on the behaviour I've described too.
True, but I was not envisioning mapping an actual file --- at least
on HPUX, the only way to generate an arbitrary-sized
what is gborg ? :)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Marc G. Fournier
Sent: Wednesday, June 26, 2002 11:21 AM
To: Dave Cramer
Cc: [EMAIL PROTECTED]
Subject: Re: [HACKERS] Democracy and organisation : let's make a
revolution
Justin Clift wrote:
Hi Jonah,
Was just looking around your company website, and it mentions a product
called Nextgres which looks interesting :
http://www.nightstarcorporation.com/?op=products
How do you guys implement the PostgreSQL SQL parser as well as the
Interbase and Oracle
I find myself repeatedly arguing for partial solutions, and having to
struggle with other developers who feel these solutions are hacks.
Let me explain why I like these hacks.
When we have a feature that users want, often we can't get it
implemented promptly in a clean way. It can take several
Tom Lane wrote:
Also, would it be a good idea to make it *recursively* report all
the indirect as well as direct dependencies? The output might get
a little bulky, but if you really want to know what DROP CASCADE
will get you into, seems like that is the only way to know.
To work
Daves,
Would you consider java as a platform independant language? I have
started a project on sf.net called jpgadmin, but I see the duplication
of effort as a waste of time.
Java has its drawbacks, but a JPgAdmin tool would significantly encourage
Postgres-OpenOffice.org integration.
--
Tom Lane wrote:
DROP TYPE widget RESTRICT; -- fail
NOTICE: operator % depends on type widget
NOTICE: operator % depends on type widget
NOTICE: operator =% depends on type widget
ERROR: Cannot drop type widget because other objects depend on it
Use DROP ... CASCADE to drop the
Dave,
What do you see as the drawbacks with java, and how can they be
circumvented?
1. Java is not Open Source. It's an open standard, but not OS.
2. I understand that there are some serious limitations to the current
Postgres JDBC drivers. I have not used them, so I'm reporting rumor,
-Original Message-
From: Josh Berkus [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 26, 2002 9:18 AM
To: Curt Sampson; [EMAIL PROTECTED]
Subject: Re: [HACKERS] Democracy and organisation : let's make a
Curt,
You do point out some good areas in which PostgreSQL needs to
Dave,
1) There is an open source implementation of java
Really? I thought Sun had a patent.
2) The jdbc driver is much better than it was recently we have made lots
of improvements, and it won't affect jpgadmin anyway. I actually think
writing the admin tool in java will make the driver
I think that the people on this list tend to make a mistake.
They try to pick apart the competition by focusing on their weak points.
From a growth standpoint, I think it is a much better idea to focus on
their strong points. Look at the things each competitor can do best.
Try to think of ways
-Original Message-
From: Jan Wieck [mailto:[EMAIL PROTECTED]]
Sent: 26 June 2002 15:45
To: HACKERS
Subject: [HACKERS] (A) native Windows port
As for project coordination, I am willing to setup and
maintain a page similar to the (horribly outdated) ones that
I did for
On Wed, 26 Jun 2002, Dave Page wrote:
-Original Message-
From: Greg Sabino Mullane [mailto:[EMAIL PROTECTED]]
Sent: 25 June 2002 20:04
To: [EMAIL PROTECTED]
Subject: [HACKERS] Postgres idea list
12. Offer something fun: a naming contest for the elephant (I know,
I
-Original Message-
From: Dave Cramer [mailto:[EMAIL PROTECTED]]
Sent: 26 June 2002 19:01
To: Dave Page
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Rod Taylor
Subject: Re: [HACKERS] Postgres idea list
Dave,
Would you consider java as a platform independant language? I
have
Dann,
Totally false:
http://www.microsoft.com/sql/evaluation/compare/benchmarks.asp
The microsoft benchmarks aren't worth the screen space they take up. I don't
consider these evidence. I'm basing this on real experience of working
with real production databases, not some idealized
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
Sent: 26 June 2002 19:21
To: PostgreSQL-development
Subject: [HACKERS] Why I like partial solutions
If we want to grow PostgreSQL, we need to meet users needs,
even if that requires stomaching some hack
Tom Lane writes:
IIRC, a function is only considered to be a cast function if it matches
by name *and schema* with the target type. So if you, for example,
make a function public.int4(something), it'll never be considered a
cast function for pg_catalog.int4. I had some doubts about that
On Wed, 26 Jun 2002 11:35:07 PDT, the world broke into rejoicing as
Josh Berkus [EMAIL PROTECTED] said:
What do you see as the drawbacks with java, and how can they be
circumvented?
1. Java is not Open Source. It's an open standard, but not OS.
The problem is not with the language; it
On Tue, 25 Jun 2002, Marc G. Fournier wrote:
Well hidden, but so far 86 have found it and subscribed to it *grin*
It's on the subscription form.
[snip]
Vince, we can get -advocacy listed on the web site? There has been no
traffic over there until now, but there are ppl subscribed to it
On Wed, 2002-06-26 at 13:50, Josh Berkus wrote:
BTW, does anyone on this list know about Command Prompt, Inc.'s tools? There
seems to be a lot of duplicte development going on in the commercial space.
I know for my PERSONAL stuff, commercial tools ($$) mean I don't even
bother. I have
Jan Wieck wrote:
As for project coordination, I am willing to setup and maintain a page
similar to the (horribly outdated) ones that I did for Toast and RI.
Summarizing project status, pointing to resources, instructions, maybe a
roadmap, TODO, you name it.
Great. Please see roadmap in
Followup set to -advocacy
On Wed, Jun 26, 2002 at 12:01:18PM -0700, Dann Corbit wrote:
Customer support is also a big issue comparing free database systems
with commercial ones. I know that there are a couple groups that do
this, but that genre of businesses do not have a good track record
Joe Conway [EMAIL PROTECTED] writes:
It would be nice if the recursive dependency checking function was
available as an end user function too, so you could analyze dependencies
before even trying to drop something, or even just to understand a
database schema you've inherited from someone
Bruce Momjian [EMAIL PROTECTED] writes:
So, when we review patches, we shouldn't be turning up our noses at
imperfect solutions if the solution meets needs of our users.
I think our standards have gone up over the years, and properly so.
The fact that we put in hacks some years ago doesn't
On Wed, 2002-06-26 at 22:30, Tom Lane wrote:
Joe Conway [EMAIL PROTECTED] writes:
It would be nice if the recursive dependency checking function was
available as an end user function too, so you could analyze dependencies
before even trying to drop something, or even just to understand a
Vince, we can get -advocacy listed on the web site? There has been no
traffic over there until now, but there are ppl subscribed to it ...
all done.
Any chance of getting a pgsql-patches link on archives.postgresql.org?
I know the archives are created (I use them) but there is no
Peter Eisentraut [EMAIL PROTECTED] writes:
Perhaps it wouldn't be such a terrible idea after all to store the casting
paths separately, such as in a system table pg_cast (from, to, func,
implicit). This would implement the SQL99 spec fairly exactly.
Well, maybe. One question is how that
On 27 Jun 2002, Rod Taylor wrote:
Vince, we can get -advocacy listed on the web site? There has been no
traffic over there until now, but there are ppl subscribed to it ...
all done.
Any chance of getting a pgsql-patches link on archives.postgresql.org?
I know the archives are
Rod Taylor wrote:
David Kaplan reminded me that there is another UI issue to be
considered: when we *are* doing a DROP CASCADE, should the dropped
dependent objects be reported somehow? As it stands, Rod's patch emits
elog(NOTICE) messages in this case, but I am wondering whether that
Dann,
From a growth standpoint, I think it is a much better idea to focus on
their strong points. Look at the things each competitor can do best.
Try to think of ways to get the same functionality from PostgreSQL. If
it is impossible [or currently infeasible] to meet the functionality,
Rod Taylor [EMAIL PROTECTED] writes:
Any chance of getting a pgsql-patches link on archives.postgresql.org?
I know the archives are created (I use them) but there is no obvious
link.
Secondly, could the links that do exist be ordered alphabetically?
I'm for that too. Every time I go to
will do it tonight :)
On Wed, 26 Jun 2002, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
Any chance of getting a pgsql-patches link on archives.postgresql.org?
I know the archives are created (I use them) but there is no obvious
link.
Secondly, could the links that do exist be
-patches added ... I've gotta redo that page, as it was just a
'quick-n-dirty' when I did it ...
On 27 Jun 2002, Rod Taylor wrote:
Vince, we can get -advocacy listed on the web site? There has been no
traffic over there until now, but there are ppl subscribed to it ...
all done.
On Wed, 26 Jun 2002, Josh Berkus wrote:
As a professional MS SQL Server 7.0 manager
Well, I wouldn't call myself a professional at managing SQL Server, but
I did do about two years of work on an application (database design,
programming and day-to-day running of the production system) that
On Wed, 26 Jun 2002, Tom Lane wrote:
Curt Sampson [EMAIL PROTECTED] writes:
Note that your proposal of using mmap to replace sysv shared memory
relies on the behaviour I've described too.
True, but I was not envisioning mapping an actual file --- at least
on HPUX, the only way to
Hi everyone,
This is Jonah's explanation of what Nextgres is, as his response didn't
make it to the list (some kind of software or network problem).
:-)
Regards and best wishes,
Justin Clift
Original Message
Subject: Re: [HACKERS] Nextgres?
Date: Wed, 26 Jun 2002 12:18:57
DROP TYPE widget RESTRICT; -- fail
NOTICE: operator % depends on type widget
NOTICE: operator % depends on type widget
NOTICE: operator =% depends on type widget
ERROR: Cannot drop type widget because other objects depend on it
Use DROP ... CASCADE to drop the dependent objects too
On Wed, 26 Jun 2002, Dann Corbit wrote:
I have worked as an MS SQL Server DBA (also database designer and
programmer along with just about anything else that could be done with
it) and am aware of the difficulties associated with SQL Server. It's a
very good product.
Yeah, I agree. Maybe
On Wed, 26 Jun 2002, Josh Berkus wrote:
Depends on your level of write activity, and the size of the records.
Clustered indexes work nicely for some tables. Not for others.
Well, I'm sure everyone would agree with that. The point is that
SQL Server gives you the option, posgres doesn't.
cjs
http://archives.postgresql.org/ ... better?
On Wed, 26 Jun 2002, Marc G. Fournier wrote:
will do it tonight :)
On Wed, 26 Jun 2002, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
Any chance of getting a pgsql-patches link on archives.postgresql.org?
I know the archives are
Marc G. Fournier [EMAIL PROTECTED] writes:
http://archives.postgresql.org/ ... better?
Yup, although I'd suggest making the classification line up with
the one on the main website --- docs and cygwin are listed as
developer lists there.
Also, someone suggested listing the by-month indexes
I am a student doing my graduation in India. I want to know what are the
other OODBMS features ( other than inheritance ) available
in PostGreSQL. It would be great if you can help me out with some
information regarding this.
Thanks,
Nishkala
--
Being yourself in the world which is
60 matches
Mail list logo