Hi,
My name is Yashodha, from Sri Lanka, and i'm a first year undergraduate
student in the Sri Lanka Institute of Information Technology.
I've gone through the idea list and found myself interested in the project
idea:
Refactoring: Designer/schema integration.
after going through, I have some questions to be clarified:
1). The designer tab can be used to model the database structure (can be
viewed after some configuration changes and running database scripts). And
also under the operations tab, there is "Edit or export relational schema"
facility. So one of the outcomes of this project is to bring these two into
one page with direct exporting facilities from the same page?
2). To use the designer(GUI), there are several parameters in the
"config.inc.php" file to be changed and also some tables need to be
created. So is the idea to reduce this setup overhead?
Regards,
Yashodha.
Hi,
I have submitted my GSOC 2014 proposal for "User Interface Enhancements".
Please have a look at it.
Looking forward to your reply.
Regards,
Chirayu Chiripal
Hi
I am Smita Kumari, first year Mtech student at IIIT Hyderabad, India. This
year I wish to apply for GSoC with phpMyAdmin. I have done some
contribution to PMA, I don't know if that is sufficient for evaluation or
not. Basically I am interested in "Interface Improvements" and "Structure
tools" idea from our idea list.
It would be nice if you can suggest me some bug or feature request which I
should try to fix and which can help you while evaluating my work for the
above mentioned projects.
Also I wanted to work on few more features as part of my GSoC project or
otherwise which I really think should be there in phpMyAdmin and will help
users, that includes:
*1. Making indexes for bookmarked sql query. *
I believe, people use bookmarking to save their favourite query or the
query they are are gonna execute frequently. Assuming most of the naive
mysql users be non technical and they don't know what is indexing, they
don't know they can execute their queries 100 times faster on their huge
tables which most of the enterprise users will be having. I know in
PMA,users can make indexes but I doubt that they would know on what columns
they should make index that will serve their purpose.
So I was thinking, shouldn't we make indexes for the queries they have
bookmarked on our own or may be we can prompt user and ask if you wanna
make index for this query, since it'll speed up execution time/performance.
Please share your opinions, Will love to have some input on this .
*2. TRANSACTION support on innodb and ndb*
As we know innodb and ndb support transactions, which is a very useful
sometimes, specially when you are doing some changes directly on the
server, and you don't want to apply just partial changes or can say you
have a unit of work that is either sensitive to outside changes or needs
the ability to rollback every change, if an error occurs or you are not
sure if things will go right may be because if someone else doing some
conflicting changes on same db/table or any unexpected reasons.
So I think it would be nice if we have some way to let user say something
like "start a transaction" on GUI and then he does all the changes he wants
like insert/update/delete, after he is done he can choose to either
rollback or commit to all changes made meanwhile based on if things went
right or wrong. So we can implement something that let users to use
transactions within PMA without writing explicitly transaction queries in
SQL box.
Please give your input on these.
Thanks and Regards
- Smita Kumari
> On Sat, 15 Mar 2014, Sastry aditya wrote:
>
> >Hi all,
>
> >This is the farthest I got
> >http://adityasastry.in/multicolumn.jpg (Screenshot functionality is not
> >working in Ubuntu for some reason, so I
> >had to manually take a photo from my phone of the screen and upload it).
>
> >As you can see the arrows are not pointing in the correct direction also
> >the url's attached to those arrows don't work yet.
>
> Maybe those arrows are in correct direction. Check this here:
> http://stackoverflow.com/a/338202
> (Pardon me if my posting style is incorrect).
>
>
I agree with the post on stackoverflow. It's strange the first time, but we
should see the "arrow" not like an arrow, but like small and large values.
Maybe, it would be even clearer to use this kind of icon:
http://i.stack.imgur.com/EQUFt.png
Hugues.
The way I see it, this patch should be done by today evening or tommorow
evening at max so I guess I will add those icons and show you sir. But I
guess we are better of choosing a lighter color icons than those and also
they are too Bulky for our narrow table headers maybe.
http://tablesorter.com/docs/ Look at this. May be if we could take the
existing arrows and make them darker they will look better don't you think
?
To get a broader opinion on this matter I posted a question in the
stackoverflow, user experience forum
http://ux.stackexchange.com/questions/54098/what-are-standard-visual-cues-t…
> On Sat, 15 Mar 2014, Sastry aditya wrote:
>
> >Hi all,
>
> >This is the farthest I got
> >http://adityasastry.in/multicolumn.jpg (Screenshot functionality is not
> >working in Ubuntu for some reason, so I
> >had to manually take a photo from my phone of the screen and upload it).
>
> >As you can see the arrows are not pointing in the correct direction also
> >the url's attached to those arrows don't work yet.
>
> Maybe those arrows are in correct direction. Check this here:
> http://stackoverflow.com/a/338202
> (Pardon me if my posting style is incorrect).
>
>
I agree with the post on stackoverflow. It's strange the first time, but we
should see the "arrow" not like an arrow, but like small and large values.
Maybe, it would be even clearer to use this kind of
icon:http://i.stack.imgur.com/EQUFt.png
Hugues.
On Sat, 15 Mar 2014, Sastry aditya wrote:
>Hi all,
>This is the farthest I got
>http://adityasastry.in/multicolumn.jpg (Screenshot functionality is not
>working in Ubuntu for some reason, so I
>had to manually take a photo from my phone of the screen and upload it).
>As you can see the arrows are not pointing in the correct direction also
>the url's attached to those arrows don't work yet.
Maybe those arrows are in correct direction. Check this
here:http://stackoverflow.com/a/338202
(Pardon me if my posting style is incorrect).
--
Chirayu Chiripal
@huges The GIF involved could be changed but what Chirayu chiripal is
talking about is the direction that the arrows were pointing to, even when
I made this post I was concerned with the direction not the look of the
icon, you know cause the look is a trivial thing. Anyways I got the problem
sorted out now.
@chirayu chiripal Dude the direction of the arrows was incorrect I got it
right now
Look at this photo you will agree too.
http://adityasastry.in/multicolumn2.jpg (You have to zoom in to see the
direction of the arrows )
Regards,
Aditya