Tag Archives: mysql

Buy My Book!

Was I really involved in writing something that sounds this classy?!?! “Modern bioinformatics encompasses a broad and ever-changing range of activities involved with the management and analysis of data from molecular biology experiments. Despite the diversity of activities and applications, … Continue reading

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

Visualizing Your DBIC Schema

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

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

Auto-Increment ID’s in Oracle

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