Archive for July, 2009

S3fm, Ajax File Manager for Amazon S3

S3fm is the first 100% Ajax file manager application for Amazon S3. It runs directly in your browser as a standalone Javascript application and loads from and communicates directly with Amazon S3 without having to share your access credentials with a 3rd party Web site. S3fm features include : Multiple files upload and download support (Adobe Flash required). All usual file/folder manipulations (copy, move, ACL, etc). Web URL file sharing with Query String Authentication.

Inserting and Updating Oracle XMLType columns in PHP

If you have issues with manipulating XMLType columns beyond the 4K limit imposed by character-type handling, Christopher Jones posted code on how to INSERT in Oracle database, since the SELECT and UPDATE are already covered in Underground PHP and Oracle Manual ( new manual page ). My free book (see sidebar) has examples of how to do this using CLOB handling in PHP. I noticed that my xmlinsert.php example in the book does a SELECT and UPDATE, but never actually does an INSERT. The INSERT code is conceptually no different from UPDATE but, for completeness, here is an expanded example explicitly showing it The idea of the code is to use oci_bind_by_name with maxlength=-1 and type=OCI_B_CLOB while you bind value using oci_new_descriptor : $xml = ”; // xml data here // Insert new XML data using a temporary CLOB $s = oci_parse($c, “insert into xwarehouses (warehouse_id, warehouse_spec) values (:id, XMLType(:clob))”); oci_bind_by_name($s, ‘:id’, $id); $lob = oci_new_descriptor($c, OCI_D_LOB); oci_bind_by_name($s, ‘:clob’, $lob, -1, OCI_B_CLOB); $lob-> writeTemporary($xml); oci_execute($s); $lob-> close();

Setup Your Own Pear Channel on Ubuntu 9.04

Last night I installed a Pear channel on my Aspire One so thought about sharing the installation process with you. You might have a look at Greg Beaver’s howto , three years old but it’s the official installation, add it to your bookmarks anyway. First if you don’t have a LAMP already run sudo tasksel install lamp-server Then follow the installation process, which documented here . Then we need to install PEAR iself : sudo apt-get install php-pear You can make sure that pear is correctly installed by running: pear -V I recommend you to use ubuntu pear package instead of downloading go-pear.phar and install it manually.

10 Best Practice Tips For Firefox Tabs

If you are not big fan of bookmarking services and you use extensively Firefox tabs, you will notice at a certain time that you really need help to get all these tabs organized. A friend of mine “discovered” last month while closing FF that he got 159 tabs open, and some of them are three months old ! Don’t let your daily browsing kill you, it’s better to get organized since the beginning and use a bookmarking service to save your links. Here is 11 Firefox addons that will help you keep your tabs more organized. 1- HideTab The first tip is a very new Firefox addon that will let you hide and restore tabs. HideTab is an experimental addon, but already do the job and let you hide all of your current tabs by using ALT+Q shortcut. You can use CTRL+ALT+Q to restore them again or simply restore one by one using the HideTab icon in the status bar. 2- FaviconizeTab The second addon will let you reduce tab to show only the favicon, it will not only give you more space but will makes tabs look cooler. The only issue here is with websites without favicons. Keep reading, there are more tips below.

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!

Innomatic, Distributed PHP 5 Web Applications Container

Innomatic is a mature and easy-to-use distributed container for PHP 5 Web applications. It is particularly oriented towards business and administrative applications such as CRM, CMS, Web-based frontends for legacy applications, and so on. It can contain multiple applications and customers or sites. It introduces a new way to distribute and manage Web applications through AppCentral. Main high-level features and benefits : Container of multiple applications and customers/sites: a single installation of Innomatic is able to contain and manage multiple shared PHP applications and separately enable them to multiple customers/sites

eZ Publish is 20% Faster With PHP 5.3.0

Lukasz Serwatka wrote an eZ Publish benchmark to show performance gained with PHP5.3.0 . Lukasz found that you can boost your application up to 20% with 5.3 compared to 5.2. PHP accelerator is essential for eZ Publish according to benchmark results to get the highest performance. From community feedback it appears that eZ Publish using Windows is about 30% quicker with PHP 5.3.0. I decided to validate these reports and confirm the performance of eZ Publish using PHP 5.3.0 with a linux environment.

The PEAR Installer Manifesto, FREE Book

To celebrate their five years birthday, Packt Publishing offered five books FREE for download. Books include Building Online Communities with phpBB 2 , Invision Power Board: A User Guide , Building Websites with e107 , and The PEAR Installer Manifesto . Since there is not much books about PEAR, here is one of the few ones available for download free : the PEAR installer manifesto, written by Gregory Beaver, 296 pages and published by Packt on October 30, 2006. The book covers the PEAR Installer version 1.4.0 onwards. Current PEAR stable version is 1.8.1.