Australia photo & PC memo

xajax PHP Class Library - The easiest way to develop asynchronous Ajax applications with PHP

Recursive convert dos newlines to unix ones with dos2unix

$ find . -type f -name "*.php" -exec dos2unix {} \;

ログアウトしてもバックグラウンド ジョブを継続する方法

$ nohup ./abc.sh > out.log 2> err.log &
$ nohup ./abc.sh > out.log 2> err.log < /dev/null &

OTN Japan - ソフトウェア : Oracle SQL Developer

nuoveXT GNOME-Look.org

Ustream.tv

JavaScript: Defer Execution - with the defer attribute of the script element

Network Security & Port Scanner - LanSpy
第7回 魂まで支配されかねない「名前を知られる」という事件

SELECT column_a FROM table_a WHERE id IN (SELECT table_a_id FROM table_b);
SELECT DISTINCT column_a FROM table_a, table_b WHERE table_a.id = table_b.table_a_id;

SELECT column_a FROM table_a WHERE id NOT IN (SELECT table_a_id FROM table_b);
SELECT column_a FROM table_a LEFT JOIN table_b ON table_a.id = table_b.table_a_id WHERE table_b.table_a_id IS NULL;

MySQL does not allow to use a table in a subquery if that table is going to be updated.

MySQL AB :: MySQL 5.1 Reference Manual :: 1.8.5 MySQL Differences from Standard SQL

1.8.5.1. SELECT INTO TABLE
1.8.5.2. Transactions and Atomic Operations
1.8.5.3. Stored Routines and Triggers
1.8.5.4. Foreign Keys
1.8.5.5. Views
1.8.5.6. '--' as the Start of a Comment

MySQL AB :: MySQL Presentations: Optimizing MySQL

* SELECT SQL_BUFFER_RESULTS ...
Will force MySQL to make a temporary result set. As soon as the temporary set is done, all locks on the tables are released. This can help when you get a problem with table locks or when it takes a long time to transfer the result to the client.

* SELECT SQL_SMALL_RESULT ... GROUP BY ...
To tell the optimizer that the result set will only contain a few rows.

* SELECT SQL_BIG_RESULT ... GROUP BY ...
To tell the optimizer that the result set will contain many rows.

* SELECT STRAIGHT_JOIN ...
Forces the optimizer to join the tables in the order in which they are listed in the FROM clause.

* SELECT ... FROM table_name [USE INDEX (index_list) | IGNORE INDEX (index_list)] table_name2
Forces MySQL to use/ignore the listed indexes.

ONLamp.com -- Writing Google Desktop Search Plugins

SourceForge.net: google-kongulo

Client Authentication with w3m

% openssl pkcs12 -cacerts -nokeys -in （PKCS#12型式ファイル） -out （PEM型式の「CA証明書ファイル」）
% openssl pkcs12 -clcerts -in （PKCS#12型式ファイル） -out （PEM型式の「クライアント証明書ファイル」）

FreeCAでWebサーバーのデジタル証明書を取得する

$ openssl pkcs12 -in loadcert.p12 -out certs.txt
Enter Import Password:
（FreeCAから証明書を取得したときのパスワードを入力します。）
MAC verified OK 
Enter PEM pass phrase:
（ここには秘密鍵を暗号化するパスワードを入力します。）
Verifying password - Enter PEM pass phrase:

$ openssl x509 -in certs.pem -noout -enddate
有効期限を確認する

curl_setopt - PHPプロ！マニュアル

PHPEclipseでリモートデバッグ(DBG) | TOnDa TondA
The debugging environment for PHPeclipse