Going dark!

Android SDK on MACOsx

When trying to install the Android SDK on a MacOSX you can run the android command from the sdk directory/tools.

To run the command type bash android under the tools directory.

Using LEFT JOINS and Hellfire the MySQL performance guide

I occasionally play WOW (World of Warcraft) and as a “Lock” I know that I shouldn’t use hellfire in any instance (bg or not), is a waste of energy and give’s no result.

With MySQL LEFT JOINS is no different. Off course there will be cases where you will be required to use a LEFT JOIN (and in most of these, normalizing the tables would work), but if you can avoid it, the performance gain on the queries is considerable. There are options for not using left joins, but here are a couple:

1. INNER JOINS (should be your first and mostly only option)

2. INNER JOINS …

I’m no MySQL master, but I have received a good article today that give’s a bunch of MySQL optimization tips. Check it out:

http://www.informit.com/articles/article.aspx?p=377652

This article is dedicated to all my friends and co-workers that play with me on WOW and annoy the hell out me when I use a LEFT JOIN

Rasmus Lerdorf in Florida

Spreading the word

The South Florida PHP Users Group has a very special speaker coming to South Florida in December. The creator of PHP will actually be in South Florida to talk about “PHP in 2011″. This is a FREE event, and anyone interested in the web can benefit from what this guy has to say. The event will be held at Nova Southeastern University on Wednesday, December 14th at 7:00 pm.

Rasmus Lerdorf is known for having gotten the PHP project off the ground in 1995 and has contributed to a number of other open source projects over the years. He spent 7 years at Yahoo and has since worked for and consulted with various startups. He was born in Greenland, grew up in Denmark and Canada and has a Systems Design engineering degree from the University of Waterloo.

Follow this link for more details and to rsvp: http://www.meetup.com/South-Florida-PHP-Users-Group/events/40433602/
OpenPros – Open Source Staffing
PHP | LAMP | LINUX | RoR | CMS | Python | Perl
www.openpros.net | info@openpros.net

If you would like to stop receiving any and all email communications from OpenPros, LLC, click here to unsubscribe.

Powered by CATS (www.catsone.com)

3 cool tools for Chrome

All of them a must have:

• https://chrome.google.com/webstore/detail/gbammbheopgpmaagmckhpjbfgdfkpadb - XML Tree
• https://chrome.google.com/webstore/detail/bcjindcccaagfpapjjmafapmmgkkhgoa - Json formatter
• https://chrome.google.com/webstore/detail/epmaefhielclhlnmjofcdapbeepkmggh - Code highlight

JQuery 1.7

Jquery 1.7  was released today and among all the features there are a couple that can be highlighted:

• HTML5 support for IE 6 through 8
• isNumeric function – an alias for NAN from javascript, but the code will look more readable

Anyway, there is a bunch more of it. Worth a read: JQuery 1.7 release

Steve Jobs

I have to confess that I have been reluctant in writing about Steve Jobs. He have just passed away and how could I write about a man with so great brilliance and that brought to the tech world the innovation word.

For many he was more than an idol, for me he was the inventor of WAD (works as designed). Even knowing that this little flaw on the launch of iPhone 4 was probably a heavy weight for such a perfectionism man, it showed that he had at least some humor within.

Today’s morning the world knew that a the former CEO of Apple has passed away; Today’s morning I learned that I would not be able anymore to see one of the persons that I have looked for giving a speech on a tech conference.

Today we have lost not only a man, but also a bit of creativity, perfectionism and innovation. Hopefully the space that now has been created can be filled by more creativity, perfectionism and innovation.

Farewell Steve Jobs.

Whitepaper on SSL

Nice whitepaper: https://www.sslpoll.com/symc6579/Assets/Q1_2011_WP_Bestpractice.pdf

PHP Frameworks

Today I heard an interesting podcast from the guys of PHPSP and during the whole podcast they brought 2 interesting points:

1. Every developer should participate on a PHP Open Source project so he can not only learn new techniques but also improve his techniques
2. Zend Framework is definitely not for beginners.

Talking about frameworks is hard and there are a lot to consider and there is even a lot more that can be overlooked, therefore there are a few things that must be considered:

• MVC
• it can jumpstart a project and seriously: time is money
• performance is important and even if the you can’t achieve with the framework, you can achieve it with hardware
• when choosing a framework, consider age, documentation and online collaboration
• frameworks are supposed to be a “lego board” where you build things on, in another words, a place where you don’t need to re-invent the wheel

Don’t forget to consider looking into other frameworks. There is always something new, something that you can use on a given project or even use the concept on a new one.

Have fun.

CSS and JS bootstrap

Everybody knows that creating a CSS and JS from the scratch is a pain in the neck and making them UI friendly is even more annoying. A couple of weeks ago I came across this project that make’s any developer life a bit better.

http://twitter.github.com/bootstrap/

I has a bootstrap file for CSS and the default JQuery plugins necessary for UI. It is definetly a great resource and can speed up the development of the the UI of the site a ton more.

Give it a check.