halilim

TL;DR

Use a single field with the least amount of constraints possible. A 255 character UTF-8 field should be OK.

The list

• First name, middle name, last name. Why not Full Name?
• Merging firstname/last name into one field
• Falsehoods Programmers Believe About Names
• Personal names around the world and field design by W3C

halilim

Security

• If you don't have a really loaded CPU/harddisk (or have a good performance CPU/harddisk - in practice anything with an i5/i7 CPU should be OK) you should use full disk encryption - FileVault 2 if you have anything in your computer that needs security/privacy.

Hardware/drivers etc

• Macbook Pro EFI Firmware Update 2.3 (for AES-NI) (only some early 2011/late 2011 models).

(["Developers"]*3).join(", ")

halilim

INSERT districts
    SELECT
        NULL
        , district_other.name
        , district_other.province_other_id
        , IFNULL(province_other.name, '')
    FROM other_db.district_other
        LEFT JOIN other_db.province_other ON province_other.id = district_other.province_other_id
;

halilim

for dir in ./*; do (echo "- $dir" && cd "$dir" && git pull); done

halilim

* -A in SSH enables agent forwarding.
* -p 2122 is not needed if you use the default port of 22.
* Replace SSH_USER and example.com with your own values.
* Example run: $ envoy run deploy_demo
* --no-scripts because Laravel composer.json's post-install-cmd includes optimize, which is already done by php artisan dump-autoload
 
@servers(['test' => '-A -p 2122 -l user test.example.com', 'prod' => '-A -p 2122 -l user example.com'])

@task('install_test', ['on' => ['test']])
    cd project

halilim

Solr Field Manual

This is a specific setup for use with periodic MySQL import, but can be used as a general solution by excluding the irrelevant parts.

Legend

Code	Description
<SOLR>	E.g.: /var/lib/tomcat#/solr, /etc/solr, ...
<CORE>	Core name

halilim

Nginx

sudo add-apt-repository ppa:nginx/stable
sudo apt-get update
sudo apt-get install nginx

halilim

sudo nano /etc/apt/sources.list.d/pgdg.list
# - Add
# deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
# - and save
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.3 libpq-dev
sudo nano /etc/postgresql/9.3/main/pg_hba.conf

halilim

tr:
  admin:
    js:
      true: Doğru
      false: Yanlış
      is_present: Mevcut
      is_blank: Boş
      date: Tarih ...
      between_and_: ... ile ... arası
      today: Bugün

halilim

#!/bin/bash
#
# chkconfig: 2345 95 20
# description: Sphinx searchd for example app.
# processname: searchd_example

SEARCHD=/usr/local/bin/searchd
CONF=/home/user/app/sphinx.conf

# Source function library.