sobstel

.clipped_text {
	white-space: nowrap;
	width: 100%; # for IE 6
	overflow: hidden;
	text-overflow: ellipsis;
}

sobstel

We couldn’t find that file to show.

sobstel

#1
LOAD DATA INFILE...

#2
ALTER TABLE name DISABLE KEYS; // tells MySQL to stop updating nonunique indexes
INSERT ...
...
ALTER TABLE name ENABLE KEYS; // re-creates missing indexes (much faster than inserting one by one)

#3 (InnoDB)

sobstel

<?php
// old way
$value = $value ? $value : false;

// new way
$value = $value ?: false;

// however...
$value = isset($value) ?: false; // if eg. $value="value", then it returns (bool)true, and not (string)"value"

sobstel

<?php
class Test
{
    private $foo;

    public function __construct($foo)
    {
        $this->foo = $foo;
    }

sobstel

<?php
$stmt = $pdo_connection->query('SELECT id, name, surname FROM people');
$people = $stmt->fetchAll(\PDO::FETCH_GROUP | \PDO::FETCH_UNIQUE | \PDO::FETCH_ASSOC);

/*
$people will now contain:
array(
  1 => array(
    'name' => 'Juan',
    'surname' => 'Sorin',

sobstel

#!/usr/bin/env ruby

# Apache log analyzer
# by Przemek Sobstel (przemek@sobstel.org)

require 'rubygems'
require 'slop'
require 'time'

class Array

sobstel

# (?=) Positive look ahead assertion foo(?=bar) matches foo when followed by bar.
"Best player ever is Leo Messi.".match(/Leo(?=\s?Messi)\s\w+/)
=> ["Leo Messi"]

# (?!) Negative look ahead assertion foo(?!bar) matches foo when not followed by bar.
> "Or maybe Javier Mascherano? Or Javier Zanetti?.".scan(/Javier(?!\s?Mascherano)\s\w+/)
=> ["Javier Zanetti"]

# (?<=) Positive look behind assertion (?<=foo)bar matches bar when preceded by foo.
"Some say it is Sergio Aguero, but Sergio Batista does not let him play much".scan(/\w+\s(?<=Sergio\s)\w+/)

sobstel

<?php
// now
$date = date_create('2010-12-31 22:00:01', timezone_open('Europe/Amsterdam'));

// Buenos Aires
date_timezone_set($date, timezone_open('America/Argentina/Buenos_Aires'));
echo $date->format('Y-m-d H:i:s');
// 2010-12-31 18:00:01

// UTC

sobstel

class User
  extend ClassMethods

  devise :database_authenticatable, :omniauthable, :registerable, :confirmable, :recoverable, :rememberable

  module ClassMethods
    def find_for_database_authentication(conditions)
      value = conditions[authentication_keys.first]
      where(["username = :value OR email = :value", { :value => value }]).first
    end