Knowledgebase

The Knowlege base arranges tips and userful informations scattered on the web.

L’ovviologo

Ci sono una nuova generazione di “nullasapienti”, persone che con una inutile laurea (tipicamente in legge) diventano giornalisti dilettanti, seguono i trend della “blogosfera” e leggono magari qualche bel libro di comunicazione. Il risultato è che pubblicano video che non sono scontati, non sono banali ma non sono neppure perle di saggezza. Sono ovvi. La …

L’ovviologo Read More »

Removing duplicate rows in PostgreSQL, Oracle and SQLite

Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. On every big database there is something called “rowid” which can be used to indentify a column in a unique way. On PostgreSQL is called ctid, as we shall see: Oracle way: DELETE FROM your_table WHERE rowid not …

Removing duplicate rows in PostgreSQL, Oracle and SQLite Read More »

Oracle SQL Developer Keep Alive plugin

On some environment, on some customers, Oracle connections are drop after some idle time (i.e. 2 minutes). I have found a small plugin for Sql Developer to solve this issue: it is very handy and logs its usage. Code is also very clean https://github.com/scristalli/sql-developer-keepalive 17 forks. 103 stars. 1 open issues. Recent commits: Update README.md, GitHub …

Oracle SQL Developer Keep Alive plugin Read More »

La mia esperienza nell’open source

Nel 2011,  per studiare node js creai un progetto chiamato OrgModeParser. Org Mode è un package per l’editor Emacs, ed è pensato per tenere note strutturate, pianificare progetti con una schedulazione, mantenere una lista di cose da fare e generare poi documenti word o html da tali file in modo piuttosto efficace. Il package è …

La mia esperienza nell’open source Read More »

AngularJS alterantive: Micro JavaScript framework on the 2017

AngularJS is indeed a good framework, but if you lose some grip on it (i.e. you go in vacation for 2 weeks), it is very complex to re-grasp. Also I have seen junior JavaScript developer confused my $scope use. JavaScript on client side has damned destiny: it is too easy to develop a framework from …

AngularJS alterantive: Micro JavaScript framework on the 2017 Read More »

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 tr -d ‘\15\32′ < winfile.txt > unixfile.txt I prefer the awk way of life: [bash] awk ‘{ sub("\r$", ""); print }’ winfile.txt > unixfile.txt awk ‘sub("$", "\r")’ unixfile.txt > winfile.txt [/bash] …

dos2unix for poor basic unix Read More »