XAMPP is a very easy to install Apache Distribution for Linux, Solaris, Windows and Mac OS X. The package includes the Apache web server, MySQL, PHP, Perl, a FTP server and phpMyAdmin.

PHing Is Not GNU make; it's a project build system based on Apache Ant. You can do anything with it that you could do with a traditional build system like GNU make, and its use of simple XML build files and extensible PHP "task" classes make it an easy-to-use and highly flexible build framework. Features include file transformations (e.g. token replacement, XSLT transformation, Smarty template transformations), file system operations, interactive build support, SQL execution, CVS operations, tools for creating PEAR packages, and much more.

via Phing.

After a bit of work, I have managed to optimize the performance of my Postgresql Server.

I have spent a saturday morning digging around postgresql, using the fantastic komodo editor, and I am happy with the final solution.

I followed  some suggestion on power PostgreSQL site, and now my postgres is blazing fast. For small needs, tuning postgres is easy as working with MySql. And with postgres you get for free Transaction and PL/SQL without the need to do extra configuration or tuning or your database.

Read More

I have read http://www.manageability.org/blog/stuff/chandler-failure and I think it is very danger way of exposing concepts.

In the article pointed out, the quite dead Chandler project is compared to the multi-billion Eclipse project. And then a too easy analysis is done against dynamic languages, where Java is the absolute winner.

Read More

Oracle buys BEA and Sun buys MySql.

In reply,Migrosoft is hungry and is watching Yahoo :-)

<joking> 

Any bets on the next money-based-news?

I'm going for

• Oracle buys Sun: "We need more hardware to run Oracle and WebLogic together! "
  
• Google buys Oracle: "We have *even* more hardware...come on!"
  
• Apple buys Google: "So nice LOGO", retrodating a bunch of stock options, I suppose.
  
• Microsoft buys Apple ("So annoied their are more cool then us!") and shut down all them all so you will end up using their search engine, I hope.

</joking> 

Read More

Sometimes I need to build a small script to delete a huge set of tables of a schema.

In Oracle is easy to do it, using the meta tables "all_tables", "all_views", and "all_sequences":

select  'drop table ' || table_name || ' cascade constraints;' 
   from all_tables where owner='protoss' and  table_name not like 'BIN%';

select  'drop view ' || view_name || ' ;' 
   from all_views where owner='zerg' ;
  
  select  'drop sequence ' || sequence_name || ' ;' 
   from all_sequences where sequence_owner='spacemarine' ; 

The "BIN%" table are special temp tables of oracle.

Read More

The installation was fine. I have some problems with the sqlite3 driver and I ought to switch back to the PostreSQL driver. I initially planned sqlite3 as deployment platform.I have to change my mind after losing over three hours trying to resolve a linking problems on the production machine. By the way with PostgreSQL I will have more powerful exporting capabilities

Read More

Biblio Wolf (Bwolf for firends) is a webapp app for managing a book collection. BWolf is written in python using the Django web framework, and it is born from a Customer request. BWolf is open source, and you can get a full description here including links to downloads. I will mantain a blog of all the work I will do. In the last two months I set up a Subversion Repository and played a little with Django.

 

Read More