Knowledgebase

The Knowlege base arranges tips and userful informations scattered on the web.
For more information, take a look to the introduction

Oracle Auto increment trigger HOWTO

Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I will describe to you right now. Even if  Oracle databases (<12) does not support auto increment, you can easily ask to your sql data modeler to generate for you a sequence and a trigger in a automatic …

Oracle Auto increment trigger HOWTO Read More »

Oracle Database Sync

Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I will describe to you right now. I will show here a very fast way of comparing different database and auto-generate migration script. Reverse engineer the source database using Oracle Data Modeler Now select the right arrow  shown …

Oracle Database Sync Read More »

Finding the good one: mithril

I have just read this insightful statement on this blog article about congitive load in Javascript jQuery is undoubtedly useful when dealing with browser quirks, but once an application grows over a few thousand lines of code, unstructured jQuery code simply becomes too difficult to maintain, and you start needing the discipline of a framework …

Finding the good one: mithril Read More »

dos2unix for poor basic unix

Do you have cygwin base install right? So no dos2unix…you can convert a windows file to unix format with a small tr command like

[bash] awk ‘{ sub("\r$", ""); print }’ winfile.txt > unixfile.txt awk ‘sub("$", "\r")’ unixfile.txt > winfile.txt [/bash] See also the bash secret power addendum.