RSS

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.

 
Leave a comment

Posted by on August 22, 2011 in GSoC 2011

 

Tags: ,

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.

 
Leave a comment

Posted by on August 15, 2011 in GSoC 2011

 

Tags: ,

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
 
Leave a comment

Posted by on August 8, 2011 in GSoC 2011

 

Tags: ,

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
 
2 Comments

Posted by on August 1, 2011 in GSoC 2011

 

Tags: ,

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:

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
 
Leave a comment

Posted by on July 24, 2011 in GSoC 2011

 

Tags: ,

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
 
Leave a comment

Posted by on July 18, 2011 in GSoC 2011

 

Tags: ,

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.
 
Leave a comment

Posted by on July 11, 2011 in GSoC 2011

 

Tags: ,