Tag Archives: sql

Install phpPgAdmin on Ubuntu 7.10

Posted on November 14, 2007 by Daz

Update: These instructions have been tested and work fine in the latest version of Ubuntu (8.04, Hardy Heron). phpPgAdmin is a web based GUI for administrating a PostgreSQL database server. Here’s some quick notes on getting it installed easily on … Continue reading →

Posted in linux, postgresql | Tagged , , , , , | 13 Comments

Visualizing Your DBIC Schema

Posted on October 19, 2007 by Daz

What a great idea - will give this a bash next week… If you want a somewhat pretty picture of your DBIC schema (with relationships drawn, of course), install GraphViz, SQL::Translator, and DBICx::Deploy from the CPAN, and then run: $ … Continue reading →

Posted in perl | Tagged , , , , | Leave a comment

MySQL 4.X to Oracle Notes

Posted on October 11, 2007 by Daz

Stumbled across this useful page full of examples and notes on how MySQL 4.x and Oracle differ, and how you can avoid complications if you want to migrate a database between the two… About once a year I need to … Continue reading →

Posted in mysql, oracle, snippets | Tagged , , | Leave a comment

Log/Audit Tables in Oracle

Posted on October 5, 2007 by Daz

One of the useful things that i’ve been asked to set-up lately is automatic logging of changes to several of our database tables. My first thought was to do this in Perl (as the rest of the system is in … Continue reading →

Posted in noteworthy, oracle | Tagged , | Leave a comment

Auto-Increment ID’s in Oracle

Posted on October 4, 2007 by Daz

This is old news to most people who have been using Oracle for a while, but to me this is something new that I learnt today. How to have MySQL like “auto-increment” id’s for your tables in Oracle. Here’s an … Continue reading →

Posted in noteworthy, oracle | Tagged , , | Leave a comment