My closing presentation at the dedicated MySQL track at ODTUG Kaleidoscope 2010 discussed various techniques and best practices for improving the ROI of developer resources using MySQL. Included in the sections on Design, Security, Development, Testing, Implementation, Instrumentation and Support were also a number of horror stories of not what to do, combined with practical examples of improving productivity.
Increasing MySQL Productivity
View more presentations from Ronald Bradford.

I have introduced some new people to MySQL recently and had to back track the years to figure out how I learned what I learned about MySQL indexes.  A quick way to get up to speed about MySQL indexes is these three podcasts by Sheeri Cabral.OurSQL Episode 13: The Nitty Gritty of IndexesOurSQL Episode 17: Hashing it outOurSQL Episode 18: De-myth-tifying IndexesThose three episodes do a good job of explaining how indexes work so that you have a better understanding of how MySQL indexes find your data.

EllisLab is pleased to release CodeIgniter version 1.7.2 for ready download.  What’s new?  Among other changes:

• Compatible with PHP 5.3.0
• Added a new Cart Class.
• Improvements to the Form helper
• Added is_php() to Common functions to facilitate PHP version comparisons
• Modified show_error() to allow sending of HTTP server response codes, and all internal uses now send proper status codes.
• Numerous bug fixes

Version 1.7.2 has been baking in the subversion for quite some time, and has been compatible with PHP 5.3.0 since late July, but many users understandably haven’t been running from the in-development version.  While I’d have liked to have had time to add a few more “big ticket” items to this release, making it 1.8, time is a cruel mistress.  Many of our users develop on Macs, and OS X Snow Leopard ships with PHP 5.3.0, so we felt is was more important to push out this stable maintenance release instead of waiting for an even later date – it’s been almost seven months since a refresh, afterall.  But there are still a few good surprises, and welcome changes.  Enjoy!

EllisLab is blessed with two of the greatest communities that can be found anywhere on the internet in ExpressionEngine and more recently CodeIgniter.  Despite being a relative newcomer to the scene, the people attracted to CodeIgniter are among the smartest, most talented and down-to-earth developers around today.  From time to time we want to highlight some of these talented people, and we’ve asked them to lend their voice to ours.  Have your voice.  I hope you enjoy what they have to say as much as I did.

This week, our Community Voice author is Bruce Alderson, known on the forums as madmaxx, who has written a wonderful guide on how he uses subversion with CodeIgniter.  Bruce is an elder web monkey and systems programmer.  He totally digs the craft of building software, making cool stuff, and causing people to laugh so hard liquids are forced from their nose.  He’s currently the Chief Monkey at Discovery Software and author of the not-at-all famous robotpony.ca.  (Go read the one about shaving your yak)

After working with CodeIgniter for a few months (and WordPress for a few years), I?ve settled on a way to set up web projects that works well for development, deployment, and source control. Note that this style of layout only works on systems like Mac and Linux that have useful symlinks.

First, the folder layout

The layout favours a vhost setup, and splits your code and resources out of the CodeIgniter sources. Splitting your stuff from the CodeIgniter stuff lets you link your Subversion repository to theirs, so that you can keep it in sync with their development.

How it’s done

1. Set up your source tree (not including the symlinks or CodeIgniter source) and add to your Subversion repo.
2. Add a svn link to CodeIgniter’s repo (via svn propedit svn:externals, with public http://dev.ellislab.com/svn/CodeIgniter/tags/v1.6.2/) and run a svn update to grab the framework.  See the Subversion docs for details.
3. Copy the CI application folder to the site root (as app), remove the .svn folders, symlink to application, and add it to your local svn repo.
4. Symlink the other site-extras to the public webserver root, and configure your local machine (and public webserver) to point to this root for the domain’s virtual host setup.
5. Alternatively, you can modify the $application_path to point to ../public/app/ (I’m not sure which is better yet).  See the CodeIgniter docs on apps for more details.

You now have a CodeIgnitor project ready for development. You can keep up-to-date with CodeIgniter updates, deploy easily, and get at your code without wading through extra levels of hierarchy.

Discuss this article

pIn the last post I’ve shown how to create keyrings using python and mentioned a slightly difference from the seahorse password storing process. Well, it happens that, when we start to dig this difference isn’t so small. Using seahorse every keyring item is created with the Update if Exists flag as False, so you can create identical keyring items. This is not a safe approach and can result in an inconsistent keyring. But as we use the Update if Exists flag set as True, something uRead More…

a href=”http://www.diegocarrion.com/2010/05/27/ruby-annotations/”Learn/a how to create Ruby annotations like this:
brclass User
br??admin_only
br??def update;
br??…
br??end
brenddiv class=”feedflare”
a href=”http://feeds.feedburner.com/~ff/Rubyflow?a=Z8NsviJusyk:lPQhEIRhYxY:3H-1DwQop_U”img src=”http://feeds.feedburner.com/~ff/Rubyflow?i=Z8NsviJusyk:lPQhEIRhYxY:3H-1DwQop_U” border=”0″/img/a
/divimg src=”http://feeds.feedburner.com/~r/Rubyflow/~4/Z8NsviJusyk” height=”1″ width=”1″/

My old post on
compiling PHP for Mac OS 10.5 (Leopard) continues to top my most-viewed page
statistics. Sadly, that article is old and doesn’t apply very well to Snow
Leopard (10.6).

I’ve been meaning to post instructions on how to compile PHP for Snow
Leopard since last summer when I picked up the DVD, but hadn’t found the
time or opportunity to build PHP from a completely fresh start, until a few
weeks ago.

This time, I took notes on how to reliably compile PHP and Apache from
scratch on this system.

1. Download and install href="http://developer.apple.com/technologies/xcode.html">Xcode.
   You’re on your own for the details of this one, but frankly, if you can’t
   figure it out, you’ll find the next steps too difficult. Think of it as
   a prerequisite.

2. Create a working directory. I use ~/src,
   but you can use whatever you like.

   
   $ mkdir ~/src
   $ cd ~/src
     

3. Install href="http://github.com/mxcl/homebrew">Homebrew. Homebrew is
   a truly great software packager for OS X. Think Macports, but not as ugly;
   Fink, but not as broken (and not as binary). Designed for Mac. It’s Ruby,
   but we don’t have to hold that against them. (-:

   
   $ curl http://gist.github.com/raw/323731/572b315c4f7ee78244de70e7ad703c8ae324da7a/install_homebrew.rb > install_homebrew.rb
   $ ruby install_homebrew.rb
      

4. Install your own iconv. I don’t know what Apple did to
   theirs, but it’s a huge headache. You’re best installing your own, in my
   experience.

   
   $ curl http://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.13.1.tar.gz | tar -zx -
   $ cd libiconv-1.13.1
   $ ./configure --prefix=/opt && make && make install
   $ cd ..
     

5. Install Apache-HTTPD from source. This isn’t
   absolutely necessary, but Apple seems to have done some weird stuff with
   their Apache, and in my experience, it’s best to build your own. If you
   skip over this step, you’ll need to change the apxs in the
   PHP configure command, below.

   First, find your
   closest mirror.

   
   $ curl http://apache.mirror.iweb.ca/httpd/httpd-2.2.15.tar.bz2 | tar -jxf -
   $ cd httpd-2.2.15/
   $ ./configure --enable-rewrite --enable-ssl && make && make install
   $ cd ..
      

6. Install PHP dependencies using Homebrew. Easy, huh?

   
   $ echo "gd jpeg libpng libxml2 libzzip mcrypt mysql" | xargs brew install
   $ echo "libpng libxml2 readline" | xargs brew link
     

7. Install PHP from source by first selecting a href="http://php.net/get/php-5.3.2.tar.bz2/from/a/mirror">mirror.

   Note: you will need to use a really nasty patch to get this to
   build properly. See the note on iconv above. Even Apple’s own href="http://opensource.apple.com/source/apache_mod_php/apache_mod_php-53/patches/iconv.patch">iconv patch for PHP
   doesn’t work (at least not for me).

   
   $ curl -L http://ca2.php.net/get/php-5.3.2.tar.bz2/from/this/mirror | tar -jxf -
   $ cd php-5.3.2
   $ curl http://www.php.net/~scoates/patches/php-5.3.1-Makefile.global-iconv.patch | patch -p0
   $ ./configure --prefix=/usr/local --with-xsl --with-gd --with-zlib-dir \
     --enable-sockets --enable-exif --with-mcrypt --enable-soap \
     --enable-embedded-mysqli --with-mysql --with-pdo-mysql --with-curl \
     --with-libedit --with-apxs2=/usr/local/apache2/bin/apxs --enable-mbstring \
     --with-openssl --with-iconv=/opt && make && make install
   $ cd ..
     

8. Configure Apache. If you’ve done this on other
   platforms, this step should look familiar.

   1. In /usr/local/apache2/conf/httpd.conf, in the
      <IfModule mime_module> block, add the following:

      
      AddType application/x-httpd-php .php
      AddType application/x-httpd-php-source .phps
          

   2. Optionally, add PHP to DirectoryIndex by changing

      
      DirectoryIndex index.html
          

      to

      
      DirectoryIndex index.php index.html
          

   You can now test Apache + PHP by creating a phpinfo() page,
   and restarting Apache:

   
   $ echo "<?php phpinfo(); ?>" > /usr/local/apache/htdocs/info.php
   $ ln -s /usr/local/apache2/bin/apachectl /usr/local/bin/apachectl
   $ sudo /usr/local/bin/apachectl restart
     

   Now, visit localhost/info.php,
   and you should have an independent, custom-compiled Apache-PHP
   stack.

I hope this has been helpful. If I’ve given bad instructions, or if
something doesn’t work for some reason, please let me know in the
comments.

In November of 2009, I wrote about why developers should write their own frameworks. I pointed out at the time that often developing a framework forces developers to make the kinds of architectural choices that frameworks require, which helps them better understand the architectural choices in the most popular frameworks.

I haven?t stopped believing in the [...]

Sesuai dengan saran dari teman-teman di Mailing List, kode sumber Keuangan Guyub kini sudah ditaruh di repository sumber Google Code yang menggunakan Subversion atau SVN.
SVN sendiri -kalau menurut wikipedia Id- adalah adalah suatu perangkat lunak sumber terbuka pengontrol versi yang dapat mengatur proses pengembangan perangkat lunak yang dilakukan oleh suatu kelompok pemrogram yang terpisah [...]