Knowledgebase

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

isync: free IMAP and MailDir mailbox synchronizer

February 4, 2019 / English Content, Knowledgebase

isync: free IMAP and MailDir mailbox synchronizerisync is a command line application which synchronizes mailboxes; currently Maildir and IMAP4 mailboxes are supported. New messages, message deletions and flag changes can be propagated both ways. isync is suitable for use in IMAP-disconnected mode.Synchronization is based on unique message identifiers (UIDs), so no identification conflicts can occur …

isync: free IMAP and MailDir mailbox synchronizer Read More »

Fail2Ban

February 1, 2019 / English Content, Knowledgebase, Unix

On these days I decided to tune a bit my new shiny linux server box. I started to set up fail2ban. I think fail2ban is very imporant nowadays because it is a good example of a tool for slowing down attacks without closing your server too much. Fail2ban is a daemon: it wll monitor your …

Fail2Ban Read More »

Thinking in Angular 4: Templates

July 30, 2018 / English Content, IT Featured Content, Knowledgebase

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

January 5, 2019 / Italian Content, Knowledgebase

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

February 21, 2019 / English Content, Knowledgebase, Structured Query Language (SQL)

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

February 21, 2019 / English Content, Knowledgebase, Software, Structured Query Language (SQL)

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 keepalive extension for Oracle SQL Developer 4+https://github.com/scristalli/SQL-Developer-4-keepalive6 forks.80 stars.7 open issues.Recent commits: Fix …

Oracle SQL Developer Keep Alive plugin Read More »

La mia esperienza nell’open source

January 20, 2017 / Italian Content, Knowledgebase, Software

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

January 26, 2017 / English Content, Knowledgebase, Software

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 »