Categorie: Programare

E inspirat din noua interfata Windows Mobile. Am fost luni la o conferinta unde au explicat design-ul si ideea.

Si eu care credeam ca Apple le-a bagat deja mintile in cap astora de la M$. Cand trebuie sa explici un design, you’re doing it wrong. Asta o stie pana si un developer.

Apropo – ieri am mai butonat si eu un Windows 7 dupa multa vreme ca sa-i rezolv unui prieten diverse dude. The horror! In XP le gaseai in 2 click-uri. Acum le gasesti dupa 5, ascunse bine sub multe grupuri si subgrupuri. Functionalitatea, bineinteles identica. Asta e evolutie mai nou – muta-le si ascunde-le, totul e mai greu de gasit si folosit, deci avem versiune noua.

Am avut nevoie zilele acestea de extensia Oracle in PHP, pe un MacOS X 64bit cu XAMPP. Primele incercari de instalare a extensiei via pecl au esuat din cauza bibliotecilor compilate pentru 64bit iar XAMPP-ul avea nevoie de 32, asa ca a trebuit purces la lucru manual.

Dupa download-ul pachetelor basic si sdk ale Instant Client de la Oracle, le-am despachetat in /usr/lib/oracle si am creat doua symlink-uri in structura urmatoare:

bash-3.2# ls -al /usr/lib/oracle/10.2.0.4/
total 196144
drwxr-xr-x  15 root  wheel       510  5 Mai 11:36 .
drwxr-xr-x   3 root  wheel       102  5 Mai 11:24 ..
-rw-r--r--   1 root  wheel       278  1 Apr  2009 BASIC_README
-r--r--r--   1 root  wheel   1609607  2 Feb  2008 classes12.jar
-rwxr-xr-x   1 root  wheel     30556  1 Apr  2009 genezi
lrwxr-xr-x   1 root  wheel        20  5 Mai 11:36 libclntsh.dylib -> libclntsh.dylib.10.1
-rwxr-xr-x   1 root  wheel  21537536 31 Mar  2009 libclntsh.dylib.10.1
-rwxr-xr-x   1 root  wheel   1683924 12 Feb  2009 libnnz10.dylib
lrwxr-xr-x   1 root  wheel        18  5 Mai 11:36 libocci.dylib -> libocci.dylib.10.1
-rwxr-xr-x   1 root  wheel   1142284 12 Feb  2009 libocci.dylib.10.1
-rwxr-xr-x   1 root  wheel  72626824  1 Apr  2009 libociei.dylib
-rwxr-xr-x   1 root  wheel    106184 25 Mar  2009 libocijdbc10.dylib
-rwxr-xr-x   1 root  wheel    106184 25 Mar  2009 libocijdbc10.jnilib
-r--r--r--   1 root  wheel   1555682  2 Feb  2008 ojdbc14.jar
drwxr-xr-x   7 root  wheel       238  1 Apr  2009 sdk

Dupa un pecl download oci8 si despachetarea arhivei, a urmat un /Applications/XAMPP/xamppfiles/bin/phpize-5.3.0 in directorul respectiv, apoi un configure cu:

MACOSX_DEPLOYMENT_TARGET=10.6 CFLAGS='-O3 -fno-common -arch i386 -arch x86_64' LDFLAGS='-O3 -arch i386 -arch x86_64' CXXFLAGS='-O3 -fno-common -arch i386 -arch x86_64' ./configure --with-php-config=/Applications/XAMPP/xamppfiles/bin/php-config-5.3.0 --with-oci8=instantclient,/usr/lib/oracle/10.2.0.4/

make && make install

Ne asiguram ca biblioteca are arhitectura corecta:

bash-3.2# cd /Applications/XAMPP/xamppfiles/lib/php/php-5.3.0/extensions/no-debug-non-zts-20090626/
bash-3.2# file mysql.so 
mysql.so: Mach-O universal binary with 2 architectures
mysql.so (for architecture i386):	Mach-O bundle i386
mysql.so (for architecture ppc):	Mach-O bundle ppc
bash-3.2# file oci8.so 
oci8.so: Mach-O universal binary with 2 architectures
oci8.so (for architecture i386):	Mach-O bundle i386
oci8.so (for architecture x86_64):	Mach-O 64-bit bundle x86_64

Am adaugat in /Applications/XAMPP/etc/php.ini:

extension=oci8.so

Iar in /Applications/XAMPP/xamppfiles/bin/envvars:

DYLD_LIBRARY_PATH="/Applications/XAMPP/xamppfiles/lib:/usr/lib/oracle/10.2.0.4:$DYLD_LIBRARY_PATH"
export DYLD_LIBRARY_PATH
ORACLE_PATH=/usr/lib/oracle/10.2.0.4
export SQLPATH="${ORACLE_PATH}"
export TNS_ADMIN="${ORACLE_PATH}"
export ORACLE_HOME="${ORACLE_PATH}"
export NLS_LANG="AMERICAN_AMERICA.UTF8"

Un restart Apache si PHP stie in sfarsit sa vorbeasca cu Oracle.

Eclipse are o varsta venerabila. Lumea il recomanda, zeci de plugin-uri, face si cafea. Ba chiar tata PHP-ului si-a bazat Studio-ul pe el. Totusi, Eclipse nu stie nici pana acum line wrapping. Cine-ar avea nevoie de o chestie atat de exotica, oricum?