IT Featured Content

IT Featured Articles on cool technologies, focused on System Administration and Programming Languages

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 »

And finally Git wins: Microsoft Windows is developed with git aid!

A small, relaxing news was published some days ago: It’s been 3 months since I first wrote about our efforts to scale Git to extremely large projects and teams with an effort we called “Git Virtual File System”.  […] Today, I want  to share our results.  In addition, we’re announcing the next steps in our GVFS journey …

And finally Git wins: Microsoft Windows is developed with git aid! 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 keepalive extension for Oracle SQL Developer 4+https://github.com/scristalli/SQL-Developer-4-keepalive6 forks.82 stars.6 open issues.Recent commits: Fix …

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 »