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 …

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 …

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 …
Read More