Programming languages

IoT Async

April 6, 2021 / English Content, Erlang, Esp8266
Qualche mese fa avevo sviluppato una applicazione IoT per misurare la temperatura e spedire i dati ad una coda mqtt. Poi c’era uns server che collezionava i dati. Totale: tre server, con tre punti di fallimento ma architettura molto “cool” In effetti però la potenza dei moderni chip embedded è tale che è possibile implementare …

IoT Async Read More »

Removing duplicate rows in PostgreSQL, Oracle and SQLite

November 28, 2019 / English Content, Knowledgebase, Structured Query Language (SQL) / , , , , , , ,
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

March 15, 2021 / English Content, Gio's Software Projects, 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 https://github.com/scristalli/SQL-Developer-4-keepalive  

Oracle Auto increment trigger HOWTO

February 21, 2019 / English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) / , , , ,
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

February 21, 2019 / English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) / , ,
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 »

Il saggio progetto svedese, rinato: Elixir e Phoenix

February 21, 2019 / Erlang, IT Featured, Italian Content / , , ,
Negli ultimi 20 anni sono successe tante cose imprevedibili. Nel 1995 nasce Java. Nello stesso periodo nasce Erlang. Java inizialmente segue la strada culturale tracciata da Sun, e si configura come un linguaggio estremamente verboso, con API specifiche per la gestione della concorrenza (es keyword synchronized per gestire nativamente le zone critiche che necessitano di …

Il saggio progetto svedese, rinato: Elixir e Phoenix Read More »

Recuperare Erlang

February 21, 2019 / Erlang, Italian Content / , , / 1 Comment
Erlang è un linguaggio a mio avviso sottostimato, che ha parecchie cose da insegnare ai vari Scala/Rust/Java(Script) out of there… In particolare ci sono un insieme di feature di Erlang che prese singolarmente non sono difficili da comprendere e implementare, ma è l’insieme delle idee fondanti di Erlang che lo rende assai diverso dagli altri. …

Recuperare Erlang Read More »

Erlang: a lesson to learn…again!

October 15, 2020 / English Content, Erlang, Evergreen, IT Featured, Knowledgebase, Programming languages / , ,
Erlang is a great language. [2019-UPDATE] Erlang 22 is OUT, so I wanna to come to the party! On April 2015, Erlang father’s Joe Armstrong give us a very interesting lesson I want to tell about. There was a long thread titled “Erlang and Akka, The Sequel” on the erlang mailing list, reasoning about the need …

Erlang: a lesson to learn…again! Read More »

Rebar poor proxy git fixer

February 21, 2019 / English Content, Erlang, Knowledgebase / , , , ,
Sometimes you are behind a http proxy, and the git:// protocol is not accessible. For instance on erlang rebar, all developers  prefer the git:// protocol when listing dependency. But how to fix it if you are behind a http proxy? Ask help to git… [bash] git config –global url.https://github.com/.insteadOf git://github.com/ [/bash] Credits: http://erlang.org/pipermail/erlang-questions/2014-March/078402.html

ErZauker Revenge!

February 21, 2019 / English Content, Erlang, IT Featured, Knowledgebase, Software / , , ,
After a bunch of time, I take back my Erlang Hammer from the sand of time. The result is ErZauker v0.0.2 the first pure-Erlang implementation of a code indexer. Er Zauker is a tiny but speedy search engine tailoring code searches. Zauker is backed by REDIS, the fastest RAM-based NoSQL engine you have never seen. The code get …

ErZauker Revenge! Read More »

Erlang Power Links

September 6, 2019 / English Content, Erlang / , ,
Ready to study the Erlang? Take a look to http://howistart.org/posts/erlang/1 for understanding how erlang releases works (and how to deal with them). Erlang Maps are the next big thing and this article from Joe Amstong introduce you to them. For some lengthly tutorial take a look to this http://learnyousomeerlang.com/maps   And Finally Lisp Flavored Erlang and Ruby Flavored Erlang.

Intervista a Francesco Cesarini di Erlang Solutions

July 6, 2020 / Erlang, Interviste, IT Featured, Italian Content / , , , ,
A language that doesn’t affect the way you think about programming, is not worth knowing. Yale Professor Alan Perlis In occasione dell’Elixir Conf siamo lieti di pubblicare una intervista con Francesco Cesarini.  Nel 2009 abbiamo già recensito “Erlang Programming A Concurrent Approach to Software Development” scritto a quattro mani con Simon Thompson. Ora siamo lieti di ospitare una intervista ad …

Intervista a Francesco Cesarini di Erlang Solutions Read More »