Re: [Phpmyadmin-devel] Remember the last way user sorted tables
Hi Piotr, On 24 Mei 2011, at 18:12, Piotr Przybylski <piotr.prz@gmail.com> wrote:
2011/5/24 Aris Feryanto <aris_feryanto@yahoo.com>:
Hi all, I've pushed the implementation of feature "Remember the last way user sorted tables" when browsing tables. You may try it at the demo server [0]. Current implementation only remember the sorting in the session variable. So, when you logout and login again, the sorting will be refreshed. In order to keep it persistent across session, I will add a new table in phpMyAdmin database and store the sorting and maybe other "browsing"-related data in there later.
If you store all data in memory, I think you can use pma_userconfig table for that, just add a new text column for serialized data.
Thank you for your suggestion. I think I will need to store the serialized data per user and per table. But, this is just my current thought. If later, it only needs to be stored per user, then I'll use pma_userconfig table. :) -- Aris Feryanto
2011/5/24 Aris Feryanto <aris_feryanto@yahoo.com>:
Hi Piotr, On 24 Mei 2011, at 18:12, Piotr Przybylski <piotr.prz@gmail.com> wrote:
2011/5/24 Aris Feryanto <aris_feryanto@yahoo.com>:
Hi all, I've pushed the implementation of feature "Remember the last way user sorted tables" when browsing tables. You may try it at the demo server [0]. Current implementation only remember the sorting in the session variable. So, when you logout and login again, the sorting will be refreshed. In order to keep it persistent across session, I will add a new table in phpMyAdmin database and store the sorting and maybe other "browsing"-related data in there later.
If you store all data in memory, I think you can use pma_userconfig table for that, just add a new text column for serialized data.
Thank you for your suggestion. I think I will need to store the serialized data per user and per table. But, this is just my current thought. If later, it only needs to be stored per user, then I'll use pma_userconfig table. :)
Remember that when storing data per table you will have to set some upper limit, or you may have data in which half of the tables don't exist. Limiting eg. to 100 takes care of dealing with removed tables - after some time you will just "forget" about them (they get pushed out of saved table list). -- Piotr Przybylski
participants (2)
-
Aris Feryanto -
Piotr Przybylski