Re: [GENERAL] GUITools update
I haven't tried many of them, but I didn't like how they scribbled on my database. Hopefully now they are creating/using their own either database or at least schema for all their data. On 4/29/05, John DeSoi <[EMAIL PROTECTED]> wrote: > > On Apr 29, 2005, at 4:27 AM, Stephane Bortzmeyer wrote: > > > * Freeness of the code (which is much more important than price: > > switching tools is *hard* because of the lack of standards, so a small > > price at the beginning can lock you for a long time). > > It seems like this is a minimal issue with most PostgreSQL tools since > they are designed to work with a representation of the database. > Generally, SQL is the representation so there is no lock in. > > It might be useful to distinguish "freeness of code" (which does have > other advantages) from "proprietary binary data storage". Offhand I > can't think of any GUI tool which stores important data in a > proprietary format. > > > John DeSoi, Ph.D. > http://pgedit.com/ > Power Tools for PostgreSQL > > > ---(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 > ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] GUITools update
On Apr 29, 2005, at 4:27 AM, Stephane Bortzmeyer wrote: * Freeness of the code (which is much more important than price: switching tools is *hard* because of the lack of standards, so a small price at the beginning can lock you for a long time). It seems like this is a minimal issue with most PostgreSQL tools since they are designed to work with a representation of the database. Generally, SQL is the representation so there is no lock in. It might be useful to distinguish "freeness of code" (which does have other advantages) from "proprietary binary data storage". Offhand I can't think of any GUI tool which stores important data in a proprietary format. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(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
Re: [GENERAL] GUITools update
Hi, -- Brennan Stewart <[EMAIL PROTECTED]> wrote: > Before I analyze these tools, I would appreciate input from the community > on what sort of information is important for Postgresql users to know about > these design&administration tools. Sample list (just a few from my own) > operating system: These are my top questions: * Is it platform independent? And runs (for me) at least on Mac OS X and FreeBSD? * Has it a native GUI on all systems? * works with which Postgresql versions? * Is it simple for simple tasks: e.g. viewing a table and editing rows? * Is it Free Software? In the sense of liberty would be good. * Can it handle slow remote connections and SSL? * Is there a visual representation of the planer/explain? * Is there a visual representation of statistics? * Can I enter SQL-statements? Is there a keyboard controllable history? ... Ciao Alvar -- Alvar C.H. Freude -- http://alvar.a-blast.org/ http://odem.org/ http://www.assoziations-blaster.de/info/Hommingberger-Gepardenforelle.html http://www.assoziations-blaster.de/ pgpYBaNgLCahv.pgp Description: PGP signature
Re: [GENERAL] GUITools update
On Mon, Apr 18, 2005 at 04:26:56AM -0400, Brennan Stewart <[EMAIL PROTECTED]> wrote a message of 37 lines which said: > Sample list (just a few from my own) * Freeness of the code (which is much more important than price: switching tools is *hard* because of the lack of standards, so a small price at the beginning can lock you for a long time). * Ability to work nicely with people who edit text files: the tool should be able to *read* text files and to write them properly (i.e. without deleting the comments or introducing gratuitous presentation changes, which would confuse the version control system). ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] GUITools update
I am starting work on a comparison of all the Postgresql design & administration tools. The problem: Many Postgresql-compatible administration/design tools exist, but we lack a full comparison and review of each. This impedes migration and slows down the development process (time spent researching tools instead of doing DB work). Devs & hackers would have an easier time if they could read over a guide, and know from the start which tool will meet their own requirements. So, I want to remedy that problem. Before I analyze these tools, I would appreciate input from the community on what sort of information is important for Postgresql users to know about these design&administration tools. Sample list (just a few from my own) operating system: OSS SQL Syntax checking price User permissions management visual relationship modeling I prepared a list of things myself, but was worried about incompleteness. If you send back an email with the criteria that you find important, it would be much appreciated. regards, Brennan age on #postgresql irc.freenode.net ---(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