[Phpmyadmin-devel] about choosing table layout for pmadb

[Mike Cochrane]

Hi,

Sorry I answered on the blog too - Michal's proposal has been clarified 
already.

In your NavigationBarIconic example you could consider bitwise stuff
0 - nothing
1 - option 1
2 - option 2
3 - option 1 and 2
4 - option 3
5 - option 1 and 3
etc

- Mike

On 5/06/2009 11:25, Marc Delisle wrote:
> Hi,
>
> Zeeshan is proposing a new table to store user preferences:
> http://zixan.info/2009/06/04/gsoc-week-two-progress/#comments
>
> Michal answers in the blog that this does not scale. When looking at
> Zeeshan's proposal, I had the same idea for a moment. However, after
> some researches, I am tempted to reject Michal's proposal.
>
> Michal's proposed solution (a table with key values) is also called the
> EAV (entity-attribute-value) model.
> http://en.wikipedia.org/wiki/Entity-attribute-value_model#Downsides
>
> This is advocated as a design flaw by some experts, see the comments here:
> http://www.devshed.com/showblog/22280/Database-Design-Using-KeyValue-Tables/
>
> http://decipherinfosys.wordpress.com/2007/01/29/name-value-pair-design/
>
> Marc
>
>
>
>
>
> ------------------------------------------------------------------------------
> OpenSolaris 2009.06 is a cutting edge operating system for enterprises
> looking to deploy the next generation of Solaris that includes the latest
> innovations from Sun and the OpenSource community. Download a copy and
> enjoy capabilities such as Networking, Storage and Virtualization.
> Go to: http://p.sf.net/sfu/opensolaris-get
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>