@David, I'll contact you offlist in a short while.

@James, regarding the Blob/Filesytem issue, it is as debatable as the Apple vs. Adobe Flash debate. Most of the open source apps I have interacted with tend to prefer storing files on the filesystem. Regarding the BWC CMS, let us do some experiments first and see how they come out :-)


On Thu, Feb 24, 2011 at 10:45 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:

@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

To subscribe or unsubscribe via the World Wide Web, visitor, via email, send a message with subject or body 'help' to
    skunkworks-request@lists.my.co.ke

You can reach the person managing the list at
    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>
To: Skunkworks Mailing List <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> 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.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.my.co.ke/pipermail/skunkworks/attachments/20110224/1df59867/attachment-0001.htm>

------------------------------

Message: 2
Date: Thu, 24 Feb 2011 07:20:55 +0300
From: Geoffrey Mimano <soyfactor@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Forum ya opinions
Message-ID:
    <AANLkTiktc8uD-qxc89wL-Zc9RFQthafL8xVvhyyBh-FB@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

hehe.. Nice one

On 24 February 2011 03:19, Steve Muchai <smuchai@gmail.com> wrote:

> On Wed, Feb 23, 2011 at 9:05 PM, Geoffrey Mimano <soyfactor@gmail.com>
> wrote:
> > When will this forum change from a forum of opinions? kila mtu ako na
> > opinion yake on everything!! bah! always giving sugestions on what others
>
> That's your opinion.
>
> > should do..  Sick of this bana..
>
> Then unsubscribe.
>
> BR,

> S
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke




--
Mimano G. Muthondu,
Software Developer
skype : gmimano
Mobile : +254 723 615 206
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.my.co.ke/pipermail/skunkworks/attachments/20110224/6102a89b/attachment-0001.htm>

------------------------------

Message: 3
Date: Thu, 24 Feb 2011 07:28:11 +0300
From: Okechukwu <okechukwu@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Forum ya opinions
Message-ID:
    <AANLkTi=RjNQ2DG1WsKDErY1Q654mAq+udx+H+geCajtX@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Every one has a right to my opinion ~ Anon

./Ok3ch

On Thu, Feb 24, 2011 at 7:20 AM, Geoffrey Mimano <soyfactor@gmail.com> wrote:
> hehe.. Nice one
>
> On 24 February 2011 03:19, Steve Muchai <smuchai@gmail.com> wrote:
>>
>> On Wed, Feb 23, 2011 at 9:05 PM, Geoffrey Mimano <soyfactor@gmail.com>
>> wrote:
>> > When will this forum change from a forum of opinions? kila mtu ako na
>> > opinion yake on everything!! bah! always giving sugestions on what
>> > others
>>
>> That's your opinion.
>>
>> > should do.. ?Sick of this bana..
>>
>> Then unsubscribe.
>>
>> BR,

>> S
>> _______________________________________________
>> Skunkworks mailing list
>> Skunkworks@lists.my.co.ke
>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
>> ------------
>> Skunkworks Rules
>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
>> ------------
>> Other services @ http://my.co.ke
>
>
> --
> Mimano G. Muthondu,
> Software Developer
> skype : gmimano
> Mobile : +254 723 615 206
>
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke
>


------------------------------

Message: 4
Date: Thu, 24 Feb 2011 07:41:44 +0300
From: Frankline Chitwa <frank.chitwa@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Dont try make a complete CMS by yourself
Message-ID:
    <AANLkTing5BjEG4igcZf2wLMAKiyN3Veka=Bqu4Eu3McU@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hmmm, Ok, now this simply looks like lets make a cms because we were dared
to by Humphrey. In actual fact, I really support Humphreys stand. Give me a
minute to explain.

If you will be developing CMSes for every new website contract you receive,
this is an overkill. If you take months to develop a CMS which is used by
few websites, it is an overkill, If you make a CMS because somebody dared
you to and you didin't look at the future, it is an over kill, If you are
doing this for non-commercial purposes, it is an overkill CMS OOOO CMS OOO
CMS OOOO

Ok, I was just paying my respects to former Ikolomani MP, Mr. Bonny Khalwale
anyways, back to the topic

You make a CMS, you take weeks -> months to develop it (depending on
complexity), This CMS is very unmodular, hackercentric (serious hacks to
make some things work) and It is used by 1 - 20 websites (5 of them yours).
And worst of all, since it is non commercial, NOBODY will do updates on that
thing (lets tell the truth here).

In the end, you will make a CMS that anybody uses at their own risk, not a
product with solid support and background.

On the other hand, maybe am just raising some issues worth looking at. If
you can cover these bases then I believe you have a product. Cheers


On Thu, Feb 24, 2011 at 5:41 AM, Steve Obbayi <steve@sobbayi.com> wrote:

> > 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> 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.

> >
> >
>
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke
>



--
www.golavish.com - The travel and leisure
www.raccuddasys.com - code Development issues
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://orion.my.co.ke/pipermail/skunkworks/attachments/20110224/a18c9e9f/attachment-0001.htm>

------------------------------

Message: 5
Date: Thu, 24 Feb 2011 07:55:46 +0300
From: Frankline Chitwa <frank.chitwa@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Wordpress releases Django, wait WTF?
Message-ID:
    <AANLkTikmGSUdJ5EuN8ot1EN5VL7ndwQTzo-hHL3AcLN6@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Those rather imaginative chaps have decided to name it Reinhardt.
Apparently, it was named after a mucisian Django Reinhardt and the first
name seemed snazzy enough for 2 :-).

On Wed, Feb 23, 2011 at 6:41 PM, Paul Kevin <paultitude@gmail.com> wrote:

> In the end, its wordpress
>
> On Wed, Feb 23, 2011 at 6:39 PM, Dennis Kioko <dmbuvi@gmail.com> wrote:
>
>> As Kenyans continue to build their own CMS, Worpress has released version
>> 3.1 and named it Django. The world meanwhile has decided to remain calm and
>> not get confused by the naming. Wordpress has not confirmed whether a
>> future release will be codenamed "Joomla" or "Drupal"
>>
>> --
>> with Regards:
>>
>> The Chinese are known to be entrepreneurs, and coupled with some
>> imagination, are now playing the role of nature in food and beverage
>> production.
>> http://gramware.blogspot.com/2011/01/chinese-way-to-become-imaginative.html

>>
>>
>> _______________________________________________
>> Skunkworks mailing list
>> Skunkworks@lists.my.co.ke
>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
>> ------------
>> Skunkworks Rules
>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
>> ------------
>> Other services @ http://my.co.ke
>>
>
>
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke
>



--
www.golavish.com - The travel and leisure
www.raccuddasys.com - code Development issues
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.my.co.ke/pipermail/skunkworks/attachments/20110224/9d433fc0/attachment.htm>

------------------------------


_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://orion.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en

------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

End of Skunkworks Digest, Vol 12, Issue 326
*******************************************


_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke