Browse-mode Improvements – Week 13

This week I added handling for datetime-related data in grid editing and also fixed some bugs in grid editing. I think the grid editing feature is now complete and also the other features that I initially proposed to do in the context of GSoC 2011. All the new features have been merge to the official master repository and may be tested in here.

Things done this week:

• Added datetime picker in grid editing for datetime-related data type
• Replaced js/jquery/timepicker.js by Martin Milesich with timepicker by Trent Richardson, as suggested by Martin himself
• More handling for HTML entities escaping
• Fix some bugs in grid editing feature

I’m really curious to see the new features from me and other GSoC-ers tested by other phpMyAdmin devs & users and also to hear any feedback from them.

 

Browse-mode Improvements – Week 12

This week, I finished “grid editing” feature and restructured code in makegrid.js file. These changes were already merged into the official master branch and can be tested in the demo page of phpMyAdmin.

Things done this week:

• Finish grid editing feature
  I added grid editing hint when hovering “Edit” link in table’s rows, alert when user edit some field in non-unique table (i.e., table with no primary key), fix some bugs.
• Remove inline edit feature
• Restructure code in makegrid.js
• Add configuration for maximum number of records stored in pma_table_uiprefs
  I added code in Table.class.php to check the number of records and delete older records in pma_table_uiprefs when saving/updating a record in the table.

Things to do next week:

• More bug fixing, documentation and code cleaning
• Improve grid editing: add more specific editor for certain data type (e.g., datetimepicker for DATETIME data type)

With the end of 12th week of GSoC 2011, I and other GSoC-ers are approaching the end of official coding time. For me, all the planned things are done, except for one thing: edit only selected field (see Project Detail section in my proposal). I think this feature won’t be needed anymore, since we can combine “show/hide column” and “grid editing” feature to achieve this. Hopefully there is nothing else missing from my project in the context of GSoC 2011.

Although the GSoC 2011 will end soon and I have already graduated from my college (which for me means: time to go to work), it doesn’t mean that I will stop my contribution for phpMyAdmin. I will still hang around in the mailing list and put my contributions for phpMyAdmin.

 

Browse-mode Improvements – Week 11

This week I was working in grid editing feature. I spent a lot of time in writing code to update the where_clause for links in Actions column. It’s in a good progress and hopefully can be done in this week.

Things done this week:

• Fixed grid editing feature to update where_clause in Actions column (currently works for a table which do not have “update on changes” field)
• Added configuration to show/hide hint
• Fixed bug in “recent tables” feature (previously failed on table name or db name containing ‘.’ character)

Things to do next week:

• Fix more bug when updating where_clause for grid editing feature
• Remove inline edit feature

 

Browse-mode Improvements – Week 10

Grid editing get a lot of improvements this week. After some discussion in the mailing list with my mentor, we agree on removing the edit mode and use “click to edit” instead. I also found the user experience is better than before. In this week, not all the planned “to do”s were completed. I will try to finish those things next week.

Things done this week:

• Removed “edit mode” and use “click to edit”
• Added grid editing support for SET, ENUM, and TEXT data type
• Added a configuration to save all edited fields at once
• Fixed some bugs in grid editing that also appears in inline edit

Things to do next week:

• Fix more bugs in grid edit
• add configuration to turn on/off hint (as suggested by Tyron)
• refactor code in js/makegrid.js, to make it cleaner and easier to read

 

Browse-mode Improvements – Week 9

This week I finished basic grid editing feature. Currently, it can be used to edit most of the fields that can be edited in inline edit. Below is the screenshot of current grid editing feature:

Things done this week:

• investigating some edit-in-place jQuery plugin, like Jeditable and Inline Text Edit
• add basic grid editing feature (demo can be tested in http://demo.phpmyadmin.net/gsoc-aris)

Things to do next week:

• Grid-edit related things:
• add support for fields like ENUM, SET, and TEXT
• improve user control by adding options to save all edited data at once or every time a field is edited
• look into data with transformation
• Others:
• add configuration to turn on/off hint (as suggested by Tyron)
• refactor code in js/makegrid.js, to make it cleaner and easier to read

 

Browse-mode Improvements – Week 8

The eighth week was uneventful for me. I was focusing on “grid” editing, but cannot finish it. I just had my graduation day on this Saturday and there was a lot of small things to do before that. But, after this, I got nothing else to do and can focus only for GSoC.

What I’ve done this week:

• Remove js support for vertical mode display.
• Replace hint tooltip with qTip for more reusable code.
• Some progress on grid editing.

Plans for next week:

• Add different kind of editing mode (text, integer, datetime) for grid editing
• Do a usability test for grid editing mode

 

Browse-mode Improvements – Week 7

Seventh week of my GSoC 2011 was not as smooth as planned. My body was not so well and I didn’t progress a lot. I will have to catch up things in the next week.

Things done this week:

• Fix some bugs in show/hide column feature.
• Remove some js support for vertical mode.
• Add a grid editing feature (not pushed to my repo yet)

My plans for next week:

• Finish js code removal for vertical mode.
• Continue to implement grid editing feature.

 

Browse-mode Improvements – Week 6

During sixth week, I finished the “show/hide column” feature and implemented some small features.

What I’ve done this week:

• Move the “Show all columns” button to the bottom (and top if the list is quite big) of column visibility list.
• Add shift+click ability while clicking on a table’s rows.
• Make the table navigation more compact. In the new table navigation, display direction is not shown by default. It is configurable under Settings -> Main frame -> Browse mode -> Show display direction.

Things to do next week:

• Look for existing code and see how it can be used in “grid editing” mode.
• Start implementing next feature: grid editing.

 

Browse-mode Improvements – Week 5

My focus for the fifth week of GSoC was about implementing “show/hide column” feature. I also did some bug fixes in some recent features.

Here is the list of what I did:

• Added new feature “show/hide column”. While browsing a table, now we can hide a column by clicking a drop-down arrow in the left or right header of the table. Clicking it will show up a checkbox list, where user can toggle column visibility. I also add a “hide” button to allow a user to hide column directly. But, it seems that sometimes it is annoying, especially for small column, so I’ll remove it.
• Added support for recently used tables without javascript. But, since this feature relies on the javascript to do refreshing of the navigation panel in correct time, “recently used tables” without javascript won’t always give a user the correct order of recently used tables.
• Fixed bug: recently used tables and UI preferences (such as column order) doesn’t honor current server (in case a user have more than one server to manage).

My plans for next week:

• Finishing the “show/hide column” feature.
• Finding a way to better “integrate” the table navigation with the table content.
• Implement shift + click to select some rows while browsing.

 

Browse-mode Improvements – Week 4

This week, I have been focusing on improving and fixing bugs for “column reordering” feature. My progress is not as much as expected, because I had to deliver my final year project’s presentation in last Thursday. The presentation went smooth and I am now considered as graduated (yay..!), but with some revision. Hopefully my revision will be approved soon and I can fully concentrate on GSoC. Thanks to my mentor, Marc, for giving me permission to have three days for preparations and things to do after the presentation.

What I did this week:

• Some optimization (preloading, compressing) of the column pointer arrow for column reordering.
• Merged “Drag to reorder”, “Click to sort”, and “Click to mark” hint. These messages will be shown, only for javascript enabled browsers.
• Improved performance and fixed bugs with column reordering.

Things to do next week:

• Add checking for “Server” in recently used tables and some existing features, like tracking.
• Better support for recently used tables for browser without javascript.
• Continue the “show/hide column” feature.