19 May
2014
19 May
'14
8:37 a.m.
Hi,
I have started working on Central List of Columns. I had to clarify few
things so writing here.
Central columns list will be stored per database, right ?
But while using all columns will be available to use from all databases to
users ?
Where do we keep "manage central columns list" tab ? I'm thinking Settings
menu tab will be a good place may be ?
This is what I have done till now:
1. config.inc.php - > added line $cfg['Servers'][$i]['central_columns']
=
'pma__central_columns';
how to commit config changes ? as its in git-ignore
2. examples/create_table.sql -> added the Table structure for table
`pma__central_columns`
3. In General settings block on landing page -> added "Manage central list
of columns link" that goes to
prefs_central_columns.php?token=XXXXXXXXXXXXXXXXXXXx
[1.png] As this is a new feature, users wont be knowing anything like that
exist so keeping a link at landing page that points to it should be good.
4. In the settings menu tab added another submenu "manage Central Columns
List" where user can choose columns to add to the list and delete from the
list.[2.png, 3.png]
For adding the columns, we'll give users a dropdown of all databases and
for selected database, checkboxes with columns name/definition to add to
central list.
let me know if any concerns?
Thanks and Regards
- Smita
19 May
19 May
9 a.m.
New subject: [Phpmyadmin-devel] GSOC'14 Structure tools project clarifications
Smita a écrit :
Hi,
I have started working on Central List of Columns. I had to clarify few
things so writing here.
Central columns list will be stored per database, right ?
Yes.
But while using all columns will be available to use
from all databases to
users ?
I believe that in general, it will be better to only show the central
list for the current db. There might be some cases where it's useful to
show a column list for more that one db or to give a choice of db, but
the UI would be too complex IMO.
Where do we keep "manage central columns list" tab ? I'm thinking Settings
menu tab will be a good place may be ?
I suggest to put this link on the db
Structure page, next to "Data
dictionary".
This is what I have done till now:
1. config.inc.php - > added line
$cfg['Servers'][$i]['central_columns'] =
'pma__central_columns';
how to commit config changes ? as its in git-ignore
No, your commit should go to
config.sample.php and
libraries/config.default.php.
2. examples/create_table.sql -> added the Table structure for table
`pma__central_columns`
Correct.
3. In General settings block on landing page -> added "Manage central list
of columns link" that goes to
prefs_central_columns.php?token=XXXXXXXXXXXXXXXXXXXx
[1.png] As this is a new feature, users wont be knowing anything like that
exist so keeping a link at landing page that points to it should be good.
See my
suggestion above. I thing that putting a link on the landing page
is too prominent.
4. In the settings menu tab added another submenu "manage Central Columns
List" where user can choose columns to add to the list and delete from the
list.[2.png, 3.png]
See my suggestion above.
For adding the columns, we'll give users a dropdown of all databases and
for selected database, checkboxes with columns name/definition to add to
central list.
let me know if any concerns?
Thanks and Regards
- Smita
--
Marc Delisle (phpMyAdmin)
1:07 p.m.
New subject: [Phpmyadmin-devel] GSOC'14 Structure tools project clarifications
On Mon, May 19, 2014 at 5:30 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Places where users can have options to add/delete columns to central list:
1. on db_structure page,
with selected(table): sync unique columns to central list
: delete its columns from central list
2. A link "manage central columns list" on db_structure page next to "Data
Dictionary", on click of that a new page opens within PMA that let user to
add one or more columns at a time from tables in selected database and give
option to remove the already added columns.
3. on tbl_structure page,
with selected (columns): add to central columns list
: delete from central columns list
Will these be fine ?
Smita a écrit :
yeah, agree. We'll see if we can make it simpler when we works on that.
Hi,
I have started working on Central List of Columns. I had to clarify few
things so writing here.
Central columns list will be stored per database, right ?
Yes.
But while using all columns will be available to
use from all databases
to
users ?
I believe that in general, it will
be better to only show the central
list for the current db. There might be some cases where it's useful to
show a column list for more that one db or to give a choice of db, but
the UI would be too complex IMO.
Where do we keep "manage central columns list" tab ? I'm thinking
Settings
menu tab will be a good place may be ?
I
suggest to put this link on the db Structure page, next to "Data
dictionary".
This is what I have done till now:
1. config.inc.php - > added line
$cfg['Servers'][$i]['central_columns'] =
'pma__central_columns';
how to commit config changes ? as its in git-ignore
No, your commit should go to
config.sample.php and
libraries/config.default.php.
2. examples/create_table.sql -> added the Table structure for table
`pma__central_columns`
Correct.
3. In General settings block on landing page -> added "Manage central
list
of columns link" that goes to
prefs_central_columns.php?token=XXXXXXXXXXXXXXXXXXXx
[1.png] As this is a new feature, users wont be knowing anything like
that
exist so keeping a link at landing page that
points to it should be good.
See my suggestion above. I thing that putting a link
on the landing page
is too prominent.
4. In the settings menu tab added another submenu "manage Central Columns
List" where user can choose columns to add to the list and delete from
the
list.[2.png, 3.png]
See my suggestion
above.
For adding the columns, we'll give users a dropdown of all databases and
for selected database, checkboxes with columns name/definition to add to
central list.
let me know if any concerns?
Thanks and Regards
- Smita
--
Marc Delisle (phpMyAdmin)
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform
available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
2:01 p.m.
New subject: [Phpmyadmin-devel] GSOC'14 Structure tools project clarifications
Smita a écrit :
On Mon, May 19, 2014 at 5:30 PM, Marc Delisle
<marc(a)infomarc.info> wrote:
Places where users can have options to add/delete columns to central list:
1. on db_structure page,
with selected(table): sync unique columns to central list
: delete its columns from central list
OK
Smita a écrit :
yeah, agree. We'll see if we can make it simpler when we works on that.
Hi,
I have started working on Central List of Columns. I had to clarify few
things so writing here.
Central columns list will be stored per database, right ?
Yes.
But while using all columns will be available to
use from all databases
to
users ?
I believe that in general, it will
be better to only show the central
list for the current db. There might be some cases where it's useful to
show a column list for more that one db or to give a choice of db, but
the UI would be too complex IMO.
Where do
we keep "manage central columns list" tab ? I'm thinking
Settings
menu tab will be a good place may be ?
I
suggest to put this link on the db Structure page, next to "Data
dictionary".
2. A link "manage central columns list" on
db_structure page next to "Data
Dictionary", on click of that a new page opens within PMA that let user to
add one or more columns at a time from tables in selected database and give
option to remove the already added columns.
OK
3. on tbl_structure page,
with selected (columns): add to central columns list
: delete from central columns list
Will these be fine ?
Yes
> This is what I have done till now:
>> 1. config.inc.php - > added line
$cfg['Servers'][$i]['central_columns'] =
>> 'pma__central_columns';
>> how to commit config changes ? as its in git-ignore
> No, your commit should go to config.sample.php and
> libraries/config.default.php.
>
>> 2. examples/create_table.sql -> added the Table structure for table
>> `pma__central_columns`
> Correct.
>
>> 3. In General settings block on landing page -> added "Manage central
> list
>> of columns link" that goes to
>> prefs_central_columns.php?token=XXXXXXXXXXXXXXXXXXXx
>> [1.png] As this is a new feature, users wont be knowing anything like
> that
>> exist so keeping a link at landing page that points to it should be good.
> See my suggestion above. I thing that putting a link on the landing page
> is too prominent.
>> 4. In the settings menu tab added another submenu "manage Central Columns
>> List" where user can choose columns to add to the list and delete from
> the
>> list.[2.png, 3.png]
> See my suggestion above.
>
>> For adding the columns, we'll give users a dropdown of all databases and
>> for selected database, checkboxes with columns name/definition to add to
>> central list.
>>
>> let me know if any concerns?
>>
>> Thanks and Regards
>> - Smita
>
> --
> Marc Delisle (phpMyAdmin)
--
Marc Delisle (phpMyAdmin)
3764
days inactive
3764
days old
3 comments
2 participants
participants (2)
-
Marc Delisle -
Smita