Posted by Dark_Adder on January 21, 2009 at 7:59am
I'm trying to create a dashboard module with the Jquery UI. It's based on the iGoogle dashboard.
And I'm very near in finishing the base of it.
Just a bit of info about the module:
- As admin you can choose what blocks you make available for the dashboard + give a info about the block.
- Every user can then add the blocks he wants on his dashboard (with an ajax-call)
- there are 3 columns on the dashboard
- Blocks on the dashboard can be dragged around (position is autosaved with ajax) or deleted (ajax call)
- The content of the blocks can be hidden (also autsaved with ajax)
Now the question.
The position of the blocks on the dashboard is saved in a sql table. I'm curently saving the blocks in a string per column.
Something like this.
Col_0: (3v1, 5v1, 9v0)
Col_1: (1v1, 6v0, 10v1)
Col_2: (2v0, 8v1)
user: 1
where a block value is %v% (the first % is the block id and the second % is for the visibility)
So it's one row/user.
Is this the way to go (perfomance wise), or should I use one row per block with the column, the user and the visibility in it (wich creates a whole lot of rows)?
Comments
Hi, great thinking of a
Hi,
great thinking of a module.
May be you could integrate it with panels2 module, so igoogle dashboard comes into panels scope?
Or may be the mysite module is better. That will work with panels2 in D6.
My humble opinion is: integration of modules to make the best possible modules is the way forward I think!
Greetings,
Martijn
www.trekking-world.com
I didn't find that mysite
I didn't find that mysite module before and it looks interesting indeed. The problem is that the module is almost ready.
Another problem is the different layout's u can choose in those modules. It would require a different javascript file per layout and a different save and load system per layout.
But I'll check it out if its possible to extend those modules with my module.
Hi,Mysite for D6 is not
Hi,
Mysite for D6 is not ready I think, the roadmap is to integrate it panels wise, and not with its own GUI, I heard. So your participation is most welcome I presume!
Greetings,
Martijn