August 2012 - skunkworks - Skunkworks Site

Amazon
by toto mdogo 29 Aug '12

29 Aug '12

Morning everyone, Has anyone on the list bought items to Kenya via Amazon? How easy is the whole process? How long does it take &c? Thanks. -- t~0~t~0

4 4

MySQL Performance question
by Peter Karunyu 29 Aug '12

29 Aug '12

*Real life:* A questionnaire is grouped into several sections (e.g. personal details, contacts, education, work experience etc), each section then has multiple questions. *Current implementation:* I have 3 tables; questionnaires (columns: id, title, ...), sections (id, questionnaire_id, ...) and questions (id, section_id, ...). The columns questionnaire_id and section_id are indexed, and all "id" columns are primary keys, auto increment. *The need:* I need to get all questions that belong to a specific questionnaire. Lets assume the id of this questionnaire is 1. *Method 1:* 1. Run the query "SELECT id FROM sections WHERE questionnaire_id=1" 2. Do some PHP code to retrieve the ids and convert them into CSV format, e.g. 1, 2, 3 3. Run the query "SELECT id, title, ... FROM questions WHERE section_id IN (1,2,3)" *Method 2:* 1. Run the query "SELECT id, title, ... FROM questions WHERE section_id IN (SELECT id FROM sections WHERE questionnaire_id=1)" *Question:* Which is the better method in terms of speed and scalability?

1 0

Fwd: [YP_Ke] URGENT IT VACANCIES
by Odhiambo Washington 29 Aug '12

29 Aug '12

Maybe the myriad devs on this list are interested... ---------- Forwarded message ---------- From: maureen kinyanjui <hi2kireen(a)yahoo.com> Date: Tue, Aug 28, 2012 at 12:16 PM Subject: [YP_Ke] URGENT IT VACANCIES To: Young Professionals <youngprofessionals_ke(a)googlegroups.com>, progressive Kenyans <progressive-kenyans(a)googlegroups.com> Cc: wanakenya <wanakenya(a)googlegroups.com>, Giving it Straight < giving-it-straight(a)googlegroups.com> *PHP Developer*** Our client is looking for a PHP Developer to work in their Nairobi office. The successful candidate should enjoy working in a well-managed team environment; have the enthusiasm and ambition to complete projects to the highest standard and want to be part of an organization that has high quality values.**** *Skills required:* • Experience of object oriented programming / modular programming (essential) • Understanding of MVC design patterns and frameworks (essential);*** * • Front-end development including jQuery (desirable, not essential);* *** • Understanding of Ajax (desirable, not essential);**** • Experience of the full software development lifecycle: from requirements gathering and functional specification authoring, to development, testing and delivery (desirable, not essential);**** • Smarty templating (desirable, not essential)’**** • Commercial experience in Web Application development and / or software development (desirable, not essential);**** • Some knowledge of the Linux command line (desirable, not essential);**** • Good levels of communication, both written and verbal;**** • Enthusiasm and an interest in all things technology.**** *Education/Qualifications:* Candidates with all levels of experiences will be considered from graduate through to Senior Developer.**** *Salary:* Commensurate with experience**** Interested candidates to email their Cvs to Maureen.kinyanjui(a)hallmarkrecruitment.com We are also looking for a talented iPhone/iPad App Developer. You will assist us in creating a number of apps for our business products.**** ** ** - Experience with modern distributed software techniques, such as RESTful web services <http://nairobi.olx.co.ke/services-cat-191>**** - Database programming experience**** - Experience with source control**** - Experience developing iOS applications: Objective C, Cocoa, XCode and Interface Builder**** - Java experience**** - Experience with other server side languages such as PHP**** - Previously worked in an agile environment**** - Keen interest in mobile technology**** - Excellent communication skills**** - A portfolio of relevant work is highly regarded**** If you have the right skills and the sound of working with like-minded developers on exciting projects sounds good to you then email your resume and portfolio to us ASAP. maureen.kinyanjui(a)hallmarkrecruitment.com**** *Regards, Maureen* -- Hi All Here is a preview of our last League of Young Professionals Meeting... http://www.youtube.com/watch?v=BEEhBMvw9Ag&feature=youtu.be Join us on facebook http://www.facebook.com/LYP.Kenya for regular updates -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

1 0

sms system remarks
by Michelle Tongo 28 Aug '12

28 Aug '12

I am writing this to appreciate all those who updated and detailed me on their proposed sms system options. Thanks a lot for you reply and time. I appreciate it much. Now i leave it to the board to decide. So once anything is up, I will definitely keep you posted. Cheers -- *Regards,* *Michelle T.* *Cell: +254-734-695-532* * *

1 0

OSCON 2012 Proceedings
by Jason Mule 28 Aug '12

28 Aug '12

www.oscon.com/oscon2012/public/schedule/proceedings -- Kind regards Jason Mule

1 0

3G Firewall Woes - MNOs
by Odhiambo Washington 28 Aug '12

28 Aug '12

I understand that it is a Worldwide Standard that all IPs assigned to 3G connections are FIREWALLED. FIREWALLED to an extent that inasmuch as UserA and UserB both are on 3G with MNO1 they cannot access any services hosted by the other. This is the case with Safaricom. It also must be the case with Orange. It must also be the case with Airtel. It must also be the case with YU. No? I have a setup like this: 3G dongle < --- ROUTER ----< LAN <--- DVR The router is a TP-Link and the dongle is from Orange (MF192). Router IP (LAN) = 192.168.1.1 Router IP (WAN) = Dynamic (I have DDNS configured to help with name resolution) DVR IP (LAN) = 192.168.1.10 I have punched holes in the Router firewall to redirect/forward ports 8000 and 9000 to the DVR for purposes of accessing it using web and an android app. However, port scans to the WAN IP shows all ports are blocked! It would appear that the only way to get this to work would be to get Cable Broadband! Suppose there is no CB in one's area then technically you are damned. So it looks like as a rule, no one is allowed to run public services on 3G or does anyone know a provider who can give special considerations? Safaricom is NOT one such provider. I wonder if the others can. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

6 13

POS Machine Repair
by Richard Sinda 28 Aug '12

28 Aug '12

Does anyone on this list do repairs on POS machines? ...or knows people who know others who do this kind of repair? Sinda

4 4

postfix backup
by caroline mungai 28 Aug '12

28 Aug '12

Hi, Anyone who knows how to backup postfix kindly share. -- carol........ Make a habit of raising your standards so that you work towards them...........it will always keep you on your toes.

5 5

Access Kenya Core Network Problems
by Odhiambo Washington 28 Aug '12

28 Aug '12

It is now becoming the order of the day. Access Kenya has problems in their Core Network for 3 weeks in a row. I am just wondering what that means. Could it have been bad network planning? Please, John Gitau, I need an audit of Access Kenya's Core and Distribution Networks ASAP. Tell them I sent you, because I am paying for services which are becoming more and more difficult to get. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler.

10 13

4 inspiring tablets from Africa for Africa
by Rocky Mbithi 28 Aug '12

28 Aug '12

Hi Guys, Just came about this link: http://gearburn.com/2012/08/4-inspiring-tablets-from-africa-for-africa/ and was wondering whether this gadgets are in Kenya at all? And if available, where? Thanks. Kind regards, Rocky +254721708325

2 2