From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Thom Brown <thombrown(at)gmail(dot)com> |
Cc: | Luis Ochoa <ziul1979(at)gmail(dot)com>, pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: Looking for table design interface advice for pgAdmin Database Designer |
Date: | 2010-07-14 21:46:57 |
Message-ID: | 4C3E3051.8090104@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Le 14/07/2010 17:56, Thom Brown a écrit :
> On 14 July 2010 16:38, Luis Ochoa <ziul1979(at)gmail(dot)com> wrote:
>> Hi, I'm just working right now at Database Designer for pgAdmin with the
>> GSoC, and I want to create a table user interface that will be simple, easy
>> to use, and more keyboardless possible, right now my proposal is with two
>> designs that you can see at this image:
>>
>> http://a.imageshack.us/img707/8048/tableinterface.png
>>
>>
>> Symbols explanation:
>>
>> + Add a Column or index
>>
>> - Remove a Column or index, you click this simbol and then click the
>> column (Table should show in a very clear way that it's in delete mode, for
>> example by change in some way their border and writing below table in clear
>> red letters : TABLE IN DELETE COLUMN MODE or something like that), then user
>> confirm if delete or not column.
>>
>> I-
>> -| Create Join Symbol, allow you to create a join relatioship between
>> two tables by dragging from this table (Fk source) to destination table, or
>> just click (just dragging is implemented right now) this symbol and then
>> click destination table and the join is created.
>>
>> X Remove table
>>
>> _ Hide all except table title
>>
>> ^ and v Hide and show below part of table.
>>
>> * Not Null Column
>> o Null Column
>>
>> F Foreign Key
>>
>> U Unique Key
>>
>> Key Image (primary Key)
>>
>>
>> Notes (Some are ideas, some are implemented yet):
>>
>> - You can change column name just by double click at column, there you can
>> put your custom datatype by typing name : datatype or after you type just
>> name without ":" you can do right click and select datatype from popup menu
>>
>> - You can add and remove columns, and create joins using a popup right click
>> menu too on a table.
>>
>> Current state of designer can be follow by twitter:
>> Here is a little youtube video: http://is.gd/dnqA4
>>
>> All ideas are welcome, and main idea of this post is to ask before code and
>> lost less time and effort possible
>>
>> Thanks in advance.
>>
>> Regards, Luis.
>>
>
> Thanks for working on this.
>
> I'm wondering if it might be better if there wasn't a type selected
> automatically for a column so that the user doesn't accidently leave
> it and forget to change it.
>
Yeah, I also think so. And there's a good chance people won't be happy
with our default choice for the datatype. So, it's better not to have one.
> Also, could the data types line up so it's easier to read? I know
> it's still under development, but clickable elements should probably
> be bigger and clearer to reduce the chance of clicking on the wrong
> thing. And anything the user has to squint at to see (like the F for
> foreign key and U for unique constraint) would be a problem.
>
> And tooltips for everything? Many of those icons could be seen as cryptic.
>
> Regarding the joins, will there be a clear indicator as to which
> column is linking to which?
>
> Would tables be renamable?
>
+1 for the four comments.
> And what's your Twitter handle? I don't see it above. :)
>
> Keep up the good work.
>
+1 :)
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | pgAdmin Trac | 2010-07-14 23:26:40 | [pgAdmin III] #213: Crash when entering text in Table grid |
Previous Message | Guillaume Lelarge | 2010-07-14 21:42:20 | Re: Looking for table design interface advice for pgAdmin Database Designer |