@Mimano, I can't think of any semantic importance. I am just curious if it would work and if not, why. If it did, would it be better than the norm and if not, why? @Wesley, at the back of my mind, I knew there was something I was overlooking, I just didn't know what. Your problems have shed more light. I will create the proposed structure in MySQL, load it up with some data and then run some benchmarks. Then maybe we can analyze the findings from there. On Thu, Feb 24, 2011 at 8:40 AM, wesley kirinya <kiriinya2000@yahoo.com>wrote:
That's a clever design. So here's my question:
Problem 1: Suppose you have 2 Objects, Object1 and Object2 with respective properties as Object1.ObjectProperties1, Object1.ObjectProperties2 and Object2.ObjectProperties1, Object2.ObjectProperties2 If you want to select values for Object1.ObjectPropertyTypes1 and Object2.ObjectPropertyTypes2 into 1 result set, then the query has to first resolve the respective IDs of the properties then query the values.
Problem 2: Any result from query has to contain the ObjectPropertyType so that the type is know and can be placed in the right class type in your code e.g. for dates, you might like to place that in a Date object, Float object etc (since these are stored as strings in the DB). There are 2 sub-problems here. 1 is that the ObjectPropertyType table has to be re-queried every time u run a query, and 2, existing libraries that might translate a DB value to int, float, etc will not understand your structure therefore will resolve the field values to strings and u have to cast them to the types you want.
Problem 3: You loose out on indexing features of the DB thus your DB will perform slower.
I bet there are other problems...
8~)
--- On *Thu, 2/24/11, skunkworks-request@lists.my.co.ke < skunkworks-request@lists.my.co.ke>* wrote:
From: skunkworks-request@lists.my.co.ke <skunkworks-request@lists.my.co.ke
Subject: Skunkworks Digest, Vol 12, Issue 326 To: skunkworks@lists.my.co.ke Date: Thursday, February 24, 2011, 7:07 AM
Send Skunkworks mailing list submissions to skunkworks@lists.my.co.ke<http://mc/compose?to=skunkworks@lists.my.co.ke>
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks or, via email, send a message with subject or body 'help' to skunkworks-request@lists.my.co.ke<http://mc/compose?to=skunkworks-request@lists.my.co.ke>
You can reach the person managing the list at skunkworks-owner@lists.my.co.ke<http://mc/compose?to=skunkworks-owner@lists.my.co.ke>
When replying, please edit your Subject line so it is more specific than "Re: Contents of Skunkworks digest..."
Today's Topics:
1. Re: Dont try make a complete CMS by yourself (Steve Obbayi) 2. Re: Forum ya opinions (Geoffrey Mimano) 3. Re: Forum ya opinions (Okechukwu) 4. Re: Dont try make a complete CMS by yourself (Frankline Chitwa) 5. Re: Wordpress releases Django, wait WTF? (Frankline Chitwa)
----------------------------------------------------------------------
Message: 1 Date: Thu, 24 Feb 2011 05:41:30 +0300 (EAT) From: Steve Obbayi <steve@sobbayi.com<http://mc/compose?to=steve@sobbayi.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke<http://mc/compose?to=skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Dont try make a complete CMS by yourself Message-ID: <15890304.401298515288968.JavaMail.SYSTEM@obbayi> Content-Type: text/plain; charset="utf-8"
I refuse to divulge the URLs so that you can hack them.
Are they that insecure, just kidding :)... maybe I can help
@Steve Obbayi, being a flash developer I am sure you will appreciate what I was trying to clone.
Actually I dont regard myself a Flash developer, my work doesnt require it, I mainly use it to tutor a bunch of people, the same goes for PHP, Java and a bunch of other languages. I actually code in C/C++ and Assembly (well, sue me) on a daily basis. Also Python.
@Humphrey thats a Nice App though
----- "Humphrey Ngoiya" <hngoiya@yahoo.co.uk<http://mc/compose?to=hngoiya@yahoo.co.uk>> wrote:
I refuse to divulge the URLs so that you can hack them. attached is my futile attempt at making the nokia calling for all innovators-Africa, ADOBE flash app category (source code is also included). If you want to attack my coding pedigree, go ahead.
@ Steve Obbayi , being a flash developer I am sure you will appreciate what I was trying to clone.