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 »
Language based on JVM are the new trend in Java World. It seems everyone dislike Oracle on these days. Kotlin score some point on these days because it will be supported officially on Android (Mid-May announce): Starting now, Android Studio 3.0 ships with Kotlin out of the box, meaning Android developers no longer need to install …
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 »
Scenario: Andando a scuola tuo figlio non vuole capire che deve mettersi 0,5ml di collirio nell’occhio arrossato, né accetta il fatto che tu glielo abbia messo di forza mentre stavi uscendo di casa, nel tentativo di scongiurare una congiuntivite estiva, non arrivare tardi al lavoro, e trattenerti da dargli una sculacciata. Papà: Se non ti …
