oracle
Oracle Recommends Achievo ATK PHP Framework
OTN (Oracle Technology Network) writes about how to develop a complete PHP application with no more than 30 lines of code using ATK PHP Framework.
I must admit they have a great and simple to follow tutorial. I am a fan of CakePHP framework unfortunately
However it caught my interest and plan to give it a go today and see how I can flex it’s muscles.
The 30 lines application tutorial can be found here
http://www.oracle.com/technology/pub/articles/jansch_atk.html
PHP & Oracle – Singapore Meeting
I recently invested some of my time to watch the PHP & Oracle presentation video from the meeting which took place this month in Singapore:
If you are in the PHP business it really worth considering porting your database to Oracle 10gR2 or 11g and using oci8 as oracle datasource for your application.
Just some of the performance features you will get:
-prefetching rows (reducing round trips from web to database servers)
guidelines to follow when prefetching rows:
* don’t prefetch more data than necessary
* use SQL to process data especially analytics functions
-binding scalars
(avoiding double parsing SQL statements like SELECT * FROM USERS WHERE user_id=2 and SELECT * FROM USERS WHERE user_id=3)
A great advantage is that avoids SQL injections too!
-transactions
-PL/SQL
-array binds
-statement cache