Recently I moved from Fedora 13 to Ubuntu 10.04 on my work laptop. So, I faced again with problem to setup Oracle PHP interface. Oracle provides RPMs only and not DEBs. So, to install the client RPMs should be converted to the DEBs. It can be done easily using utility alien: sudo alien oracle-instantclient11.1-basic-11.1.0.7.0-1.i386.rpm sudo alien oracle-instantclient11.1-devel-11.1.0.7.0-1.i386.rpm sudo alien oracle-instantclient11.1-sqlplus-11.1.0.7.0-1.i386.rpm They can be installed then […]
Export result of query from mysql console to CSV file
Sure all GUI DB tools can do export of result of query into CSV file. But what if you have to do this from command line? There is a simple way perform that task. Here is an example: SELECT * INTO OUTFILE ‘/tmp/products.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ ESCAPED BY ‘\\’ LINES TERMINATED BY ‘\n’ FROM products When you run that query all […]
Trick with variable name transformation in CakePHP
CakePHP is a good PHP MVC framework. You can study it easily and start developing web sites very fast. But it has some disadvantages, of course. One of them is strange rules for transformation variable name when it set in the controller. Statement $my_var = ‘Hello world!’; $this->set(‘my_var’, $my_var); will make the variable $my_var accessible in your view: <?php echo $my_var; ?> The phrase ‘Hello […]
Cyprus Winter
It was rainy on Cyprus this week. That’s really good for island in general because we’ll have enough water on Summer. But it’s terrible for drivers.
How to rebuild Ubuntu package from the sources
There are two ways (at least) to rebuild Ubuntu package from the source. Using Ubuntu diff file and dpkg-buildpackage Download source from Ubuntu repository. Download Ubuntu diff file and apply it: patch -p1 < ubuntu.diff Build package: dpkg-buildpackage -rfakeroot Using .dsc file and debuild Download .dsc file Run following command: dpkg-source -x file.dsc Note, sometimes the archive with sources should be presented in the same […]
Gift idea: Plantronics Discovery 925
Bluetooth handset Plantronics Discovery 925 can be a really good Christmas present for web workers. It’s stylish and elegant. The headset offers a hight quality voice and adaptive noise reduction. But the most interesting feature in my mind is ability to connect to the mobile and PC in the same time. So, you can make mobile or Skype call using one headset. The handset Plantronics […]
Perfect notebook for travellers
If I’d travel a lot I’d buy the ACER Aspire 1410 notebook. It looks like netbook and costs the same. But instead of Atom processor it’s equiped with stronger Intel Celeron. The rest spec includes 11.6-inch LCD display with 1366 x 768 resolution, GMA 4500MHD graphics, a 6-cell battery, 250 GB hard drive, and up to 4GB of RAM. The Acer Aspire 1410 offers a […]