Knowledgebase

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

Thinking in Angular 4: Templates

To understand Angular 4, after the “Hero” tutorial you should start from the Template syntax.  We highlighted some statement in red below: Data direction Syntax Type One-way from data source to view target {{expression}} [target]=”expression” bind-target=”expression” Interpolation Property Attribute Class Style One-way from view target to data source (target)=”statement” on-target=”statement” Event Two-way [(target)]=”expression” bindon-target=”expression” Two-way …

Thinking in Angular 4: Templates Read More »

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 legge 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 and Oracle

Oracle trick: [sql] DELETE FROM your_table WHERE rowid not in (SELECT MIN(rowid) FROM your_table GROUP BY column1, column2, column3); [/sql] Postgresql equivalent is ctid, so you can try something like [sql] delete from mytable where exists (select 1 from mytable t2 where t2.name = mytable.name and t2.address = mytable.address and t2.zip = mytable.zip and t2.ctid …

Removing duplicate rows in PostgreSQL and Oracle 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-4-keepalive  

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 »