August 2013 - skunkworks - Skunkworks Site

Dell Server Hard disks needed
by Wagah Hayanga 01 Aug '13

01 Aug '13

Dell Power Edge R910 Server hard disks - best pricing please and availability should be ASAP. Type: 600GB SAS 10k 2.5" - 4 pieces Needed 146GB SAS 10K 2.5" - 2 Pieces Needed Also advice me on what would happen if i get HDD of various data speeds of say 7.2k and 10k or even 15k on one server - I intend to deploy RAID on the server. -- *Wagah Hayanga* "...indeed, the forest did change but the monkeys in it remained the same" - PLO.

2 1

PHP/MySQL: Is there a better way to count distinct values in a column
by Peter Karunyu 01 Aug '13

01 Aug '13

I have a table with 10 columns, and about 20,000 rows. I want to get the count of the distinct values in 5 of the columns, so normally, I would probably write 5 queries thus: SELECT column_a, count(column_a) FROM my_table GROUP BY column_a; SELECT column_b, count(column_b) FROM my_table GROUP BY column_b; SELECT column_c, count(column_c) FROM my_table GROUP BY column_c; SELECT column_d, count(column_d) FROM my_table GROUP BY column_d; SELECT column_e, count(column_e) FROM my_table GROUP BY column_e; My question is, is there a way I can do this in a more generic/future proof way? Maybe a stored procedure which I just pass the table name to? Or some PHP function which I just give the name of the table to? Ultimate goal is to write just one query to get the above data.

2 1

Re: [Skunkworks] Task Tracker: What is the best way to handle it
by mutinda benjamin 01 Aug '13

01 Aug '13

You may also wish to explore the capabilities and goodies that come with the following open source tools: 1. Dot project (http://www.dotproject.net/) 2. Xplanner (http://xplanner-plus.sourceforge.net/) Benjamin Mutinda Tech Savvy, Cell: 0729- 639 136 * * On Wed, Jul 31, 2013 at 7:19 PM, <skunkworks-request(a)lists.my.co.ke> wrote: > Send skunkworks mailing list submissions to > skunkworks(a)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(a)lists.my.co.ke > > You can reach the person managing the list at > skunkworks-owner(a)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: Task Tracker: What is the best way to handle it > (Joseph Wayodi) > 2. Re: bulk sms gateway providers (John Karanja) > 3. Looking for T shirt Printer (chris bacon) > 4. Dell Server Hard disks needed (Wagah Hayanga) > 5. Re: Task Tracker: What is the best way to handle it > (Pauline Kitheka) > 6. Consultant who can configure Call Center wanted (Peter Muchemi) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 31 Jul 2013 16:42:45 +0300 > From: Joseph Wayodi <jwayodi(a)gmail.com> > To: Skunkworks Mailing List <skunkworks(a)lists.my.co.ke> > Subject: Re: [Skunkworks] Task Tracker: What is the best way to handle > it > Message-ID: > <CAOXm+p_FoXX= > y4NokkVNMTxU8XsJi36MgMgL+nWYdLoQrA5W-A(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > On 31 July 2013 16:36, Eva Kimathi <evakimathi(a)gmail.com> wrote: > > thanks all > > > > Eventually, I think a commercial solution will be the way to go, > definitely. > > I appreciate the time you took in helping me. I'll post an update. > > > > Currently testing > > - Trac > > - ProjectPier > > - redmine > > - chilliProject > > > > You might also want to look at Apache Bloodhound [1] [2]. It adds > multiple projects support, among other features, to Trac. > > [1] <https://bloodhound.apache.org/> > [2] <https://en.wikipedia.org/wiki/Apache_Bloodhound> > > > ------------------------------ > > Message: 2 > Date: Wed, 31 Jul 2013 16:54:56 +0300 > From: John Karanja <mauxdatabase(a)gmail.com> > To: Skunkworks Mailing List <skunkworks(a)lists.my.co.ke> > Subject: Re: [Skunkworks] bulk sms gateway providers > Message-ID: > <CAKj0ww= > yce9NqZ8fMNK9M3AvqPp+gObtvs-kb_DfsQWyzrRhag(a)mail.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > Hi Peter, > > Also try us at http://Whive.org we specialize in social media innovations > for up starts including bulk sms services and gateways. > > Cheers, > > John > > > On Wed, Jul 31, 2013 at 4:18 PM, Ruth Were <nafuna(a)gmail.com> wrote: > > > contact bechesa(a)siltechsystems.com > > > > > > On Tue, Jul 30, 2013 at 4:31 PM, Mark Ojuok <markojuokicon(a)gmail.com > >wrote: > > > >> Contact michael.kabugi(a)gmail.com > >> Rgds > >> Mark > >> > >> On Tue, Jul 30, 2013 at 4:20 PM, Peter Muchemi <pmuchemi(a)gmail.com > >wrote: > >> > >>> Hi, > >>> > >>> Am looking for a bulk sms gateway providers. > >>> > >>> This is to facilitate the creation of an interface to some of our > >>> software products so that sms' can be sent to clients, leads and other > >>> parties. > >>> > >>> We will then sell the service as an additional revenue stream. > >>> > >>> Any links will be appreciated. > >>> > >>> Regards > >>> > >>> -- > >>> Peter Muchemi > >>> Software Developer > >>> Electra Software Ltd > >>> http://www.software.co.ke > >>> +254 722 320986 > >>> > >>> > >>> > >>> _______________________________________________ > >>> skunkworks mailing list > >>> skunkworks(a)lists.my.co.ke > >>> ------------ > >>> List info, subscribe/unsubscribe > >>> 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(a)lists.my.co.ke > >> ------------ > >> List info, subscribe/unsubscribe > >> 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(a)lists.my.co.ke > > ------------ > > List info, subscribe/unsubscribe > > 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 > > >

1 0

Android to PC client :Contacts sync
by Joram Mwinamo 01 Aug '13

01 Aug '13

Anyone know a good system that links an android phone to a PC and can sync contacts that are on outlook?

3 2

Looking for a core i3, 500gb nd 2gb ram PC.
by Hillary Rugut 01 Aug '13

01 Aug '13

Hi guys, Where can I get a new PC with the above specs @ a fair price? -- Regards, Rugut Hillary +254723023964 Do not Forsake the time to know yourself.

2 1

Task Tracker: What is the best way to handle it
by Eva Kimathi 01 Aug '13

01 Aug '13

Hello all, I hope you are doing great, especially in this weather. In an environment with a large group of employees and various tasks assigned by different managers to the employees, what would be the best way/tool to gauge progress per task? -- __________________________________________________________________________ Out of clutter, find simplicity. From discord, find harmony. In the middle of difficulty, lies opportunity ~Albert Einstein Eva Kimathi

12 17