Sample CRUD application with Node.JS, using MySQL, Mongo and Redis. Basically, I am using it as a boiletplate (template, skeleton) for all new backend apps I start

Caligula is a almost zero configuration data collection engine based on MySQL. It allows to collect data on any host where a MySQL installation is available and then make it available to a central vault which pulls it automatically and asynchronously. In its core version it collects variables and status data from the MySQL installation where the 'agent' is installed. The agent is totally SQL based. A SQL API is available to feed Caligula Agent with external data. For example if you want to feed it with existing agents technology like nagios nrpe checks or munin or any existing os tools you can feed it using the simple SQL API. I plan to build adapters (most probably in Perl) for the existing agents, e.g. NRPE--->ADAPTER:NRPE--->CALIGULA:AGENT. In its core funcionality of collecting MySQL data it can be used as mysql monitoring&graphing (status), and CMDB (variables). Caligula uses many of the new features of MySQL 5.1 and newer: Stored Procedures Events Prepared Statements plus the Federated storage engine.

Here

Move a MySQL dump to SQLite

php

If you install mysql through homebrew and add it to the LaunchAgents, you wont be able to use mysql.server start|stop. Instead you want to use launchctl by doing following,

To start: launchctl load ~/Library/LaunchAgents/com.mysql.mysqld.plist
To stop: launchctl unload ~/Library/LaunchAgents/com.mysql.mysqld.plist

Book: SQL Performance Tuning
Book: SQL Tuning
Book: The Art of SQL
Book: Refactoring SQL Applications
Book: Database tuning: principles, experiments, and troubleshooting techniques
Use The Index, Luke! - A Guide to database performance for developers
PostgreSQL (wiki) (PGsearch)

Performance Optimization
Quick PostgreSQL Optimization
Explain Analyze Interpreter
PostgreSQL Performance Tips
MySQL

Hidden Features of MySQL
Book: High Performance MySQL / Blog: High Performance MySQL
Blog: Xaprb (for MySQL DBAs)

In /etc/apache2/httpd.conf, uncomment this line:

LoadModule php5_module libexec/apache2/libphp5.so
Restart Apache

sudo apachectl restart
Fix a warning appearing in phpinfo()

Create /etc/php.ini and make it writable

cd /etc
sudo cp php.ini.default php.ini
sudo chmod 666 php.ini

development environment up and running (I did a clean install). After the jump, I'll outline the steps that I took to get a functioning Apache, PHP, MySQL installed. Sure, you could use the leopard-bundled Apache and PHP, but if you're like me, you generally upgrade PHP (and use weird extensions) a lot more often than Apple will upgrade it.

Built on Rasmus' birthday. How appropriate (-:

First, a couple things should be noted: I'm still without local SSL support on Apache. I've been in touch with the maintainer of apache2 on macports (who, coincidentally, is probably familiar to many of you due to his past work on the PHP project: James Cox), but I still don't have a solution. See this bug report for info. The second thing is that my colleague/client/boss/friend (wow.. that sounds like a dangerous combination!) Marco helped me out quite a bit with the initial leopard-friendly incantations to make things build.

UPDATED: Updated to use PHP 5.3.1 and with easier instructions for fixing PHP’s iconv linking problem via Apple’s iconv.patch file.

Although Mac OS X Snow Leopard (10.6) finally comes with current versions of open source software developers use, the default setup is not enough for our needs so we’ve compiled this easy to follow guide to setting up a PHP development environment including the following:
PHP 5.3
Apache 2.2
MySQL 5.1
As I mentioned, we needed to add a few things to the PHP install that Apple left out:
GeoIP
libjpeg
libpng
IMAP
libmcrypt
gettext

The normal forms defined in relational database theory represent guidelines for record design. The guidelines corresponding to first through fifth normal forms are presented here, in terms that do not require an understanding of relational theory. The design guidelines are meaningful even if one is not using a relational database system. We present the guidelines without referring to the concepts of the relational model in order to emphasize their generality, and also to make them easier to understand. Our presentation conveys an intuitive sense of the intended constraints on record design, although in its informality it may be imprecise in some technical details. A comprehensive treatment of the subject is provided by Date [4].

The normalization rules are designed to prevent update anomalies and data inconsistencies. With respect to performance tradeoffs, these guidelines are biased toward the assumption that all non-key fields will be updated frequently. They tend to penalize retrieval, since data which may have been retrievable from one record in an unnormalized design may have to be retrieved from several records in the normalized form. There is no obligation to fully normalize all records when actual performance requirements are taken into account.

Cinderella is a fully managed development environment for open source hacking on Mac OSX. It's powered by rvm, homebrew and chef. You only need Xcode to get started.

Cinderella builds everything up in ~/Developer. It won't stomp on any of your current installations so you don't have to commit your entire machine immediately. It's simple to rollback if you really want to.

Menu Navigation extension for CodeIgniter PHP framework

An open source utility for Codeigniter inspired by Ruby on Rails. The one thing Ruby on Rails has that Codeigniter does not have built in is database migrations. That function to keep track of database chages (versions) and migrate your database to what ever version you need. Migrate up or migrate down. With this library you can now do this. This library is not complete, please read http://codeigniter.com/wiki/Migrations for future needs and issues. This "fork" of Mat'as orginal work just tweets something to work better in our work. Both Libraries are powerful and work in nearly the same way. Maybe someday we can create a joint project with Mat'as or even better get this into that core of Codeigniter.

mbstring

I'm trying to amass a list of programming books with opensource licenses, like Creative Commons, GPL, etc. The books can be about a particular programming language or about computers in general.

The websites I create are never powered by WordPress. Sure I may add a blog to the website but I’ve never created a client website that was run by the powerful blogging software. In an effort to tie the website and blog together, I’ll usually do some quick PHP/MySQL programming to pull in recent blog post titles and links to the individual posts. Here’s the PHP and MySQL that accomplishes that task.

orange