[Phpmyadmin-devel] Column reordering

[Rouslan Placella]

On Sat, 2011-06-11 at 14:05 +0100, Rouslan Placella wrote:
> On Sat, 2011-06-11 at 10:58 +0700, Aris Feryanto wrote:
> > On 10 Jun 2011, at 20:31, Marc Delisle <marc at infomarc.info> wrote:
> > 
> > > Aris Feryanto a écrit :
> > >> 
> > >> ----- Original Message -----
> > >>> From: Marc Delisle <marc at infomarc.info>
> > >>> 
> > >>> Aris Feryanto a écrit :
> > >>>> Done in my git.
> > >>>>> I am also wondering how to "publicize" these two new features 
> > >>> (how to 
> > >>>>> make  more apparent that these are available).
> > >>> Aris,
> > >>> do you believe this feature is ready to be merged to the official tree?
> > >>> 
> > >> 
> > >> 
> > >> Hi Marc,
> > >> 
> > >> How about the way to publicize the features? Should we implement it first? There were several suggestions from Tyron and me regarding this.
> > > 
> > > Yes, please try to find something.
> > > 
> > 
> > I've updated my repo and it should be available in the demo soon. I add small popup balloon when we hover the column header. I also add some css code to prettify the column dragging. Please kindly check this.
> > 
> > P.S.: All my changes for column resize and reorder can be found under "colresize" branch in my git repo.
> 
> I found a small bug with the tooltip. See video here:
> http://www.placella.com/pma/colreorder_bug.avi
> 
> Rouslan

I also found another small issue that you might want to look into. The
pointer image that shows the user where the column that is being
reordered is about to be dropped is not loaded until it's class is
attached to the display element by jQuery. So this means that the
pointer does not appear instantly when you move a column for the first
time, but has to be downloaded first (about a second on my crappy
internet connection on the demo server). There are two ways (that I know
of) to fix this. You can attach the base64 encoded images inline with
the data URI scheme (both, directly in the stylesheet or through jQuery)
[1] or make a sprite from the two pointers that you have and load 1
transparent pixel from the sprite at page load (this will force the
whole sprite to load) [2].
Also those pointer images that you used could be smaller. Currently they
are saved in PNG format with an unnecessary comment that reads "Created
with GIMP", an sRGB profile which is pointless since you only have black
and transparent pixels and compression level 1. By removing the comment,
the sRGB profile and by using compression level 9 you can get each image
down from ~200bytes to ~100bytes. Or you could just save the images in
GIF format which would bring the size down from ~200bytes to ~60bytes
each. Hope this helps.

Rouslan

[1]: http://en.wikipedia.org/wiki/Data_URI_scheme
[2]: http://www.w3schools.com/css/css_image_sprites.asp