adhipg

CREATE TABLE IF NOT EXISTS `country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

oodavid

Backup MySQL to Amazon S3

This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)

Sister Document - Restore MySQL from Amazon S3 - read that next

1 - Install s3cmd

this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc

cyfdecyf

// run with go test -test.bench Bench

package main

import (
	// "fmt"
	"runtime"
	"sync"
	"sync/atomic"
	"testing"

nikic

Why objects (usually) use less memory than arrays in PHP

This is just a small post in response to [this tweet][tweet] by Julien Pauli (who by the way is the release manager for PHP 5.5). In the tweet he claims that objects use more memory than arrays in PHP. Even though it can be like that, it's not true in most cases. (Note: This only applies to PHP 5.4 or newer.)

The reason why it's easy to assume that objects are larger than arrays is because objects can be seen as an array of properties and a bit of additional information (like the class it belongs to). And as array + additional info > array it obviously follows that objects are larger. The thing is that in most cases PHP can optimize the array part of it away. So how does that work?

The key here is that objects usually have a predefined set of keys, whereas arrays don't:

nikic

PHP.net archives: http://news.php.net/php.internals (not searchable, no threads)

Markmail: http://markmail.org/search/?q=list%3Anet.php.lists.internals (usually a lot better)

routelastresort

---
- digital_ocean: >
      state=present
      command=ssh
      name={{ digitalocean.sshkeyname }}
      ssh_pub_key="{{ digitalocean.sshkey }}"
      client_id={{ digitalocean.clientid }}
      api_key={{ digitalocean.apikey }}
  
- digital_ocean: >

matteocaberlotto

#!/bin/bash


# include config
# config example below:
#
#
# Example deploy_config.sh
#
# dev_env() {

bdecarne

set :application, "My App"
set :domain,      "domain.com"
set :deploy_to,   "/home/domain/www"
set :app_path,    "app"

set :user,        "deploy"
set :use_sudo,    false
# default_run_options[:pty] = true

set :repository,  "git@xxx.com:project"

tsiege

ANNOUNCEMENT

I have moved this over to the Tech Interview Cheat Sheet Repo and has been expanded and even has code challenges you can run and practice against!






\

jgudavalli

imports:
    - { resource: parameters.yml }
    - { resource: security.yml }
framework:
    #esi:             ~
    #translator:      { fallback: %locale% }
    secret:          %secret%
    router:
        resource: "%kernel.root_dir%/config/routing.yml"
        strict_requirements: ~