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-keepalive 16 forks. 97 stars. 2 open issues. Recent commits: Update README.md, GitHub …
Today I took a light rail with my son, to bring him to school. That tram is 90 years old. It has been maintained for 90 years. Milan city sold some of them to San Francisco too.
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 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 …
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 »
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. …
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 …
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
Let it go, let it go! Can’t hold it back any more. Let it go, let it go! Turn away and slam the door. … Let it go, let it go. I am one with the wind and sky. Let it go, let it go. You’ll never see me cry. (by Demi Lovato, “Frozen”) I …
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 …
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.
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 »
I stumbled upon a very brain-f**k error on Oracle 10g on these days. Context: the following query [sql]SELECT * FROM ( SELECT TO_NUMBER(CUSTOMER_ID) AS SNDG FROM BAD_CODES_TABLE WHERE AND I_LIKE=UPPER(‘STATIC_CONDITION’) AND CUSTOMER_ID NOT LIKE ‘%P%’ ) S WHERE TO_NUMBER(S.SNDG) >2000[/sql] could trigger a Invalid number if CUSTOMER_ID column contains invalid numbers. Why? Well…if you ask …
E’ notizia fresca di stampa il rilascio di Tcl 8.6, che introduce parecchie novità a dispetto del fatto che sia una “minor” release. In particolatre Tcl 8.6 introduce un motore “stackless”, integra nel linguaggio le estensioni OOP, ed aggiunge le coroutine. Parliamo quindi diffusamente di Tcl, un linuaggio che ho sempre trascurato perché mi sembrava …
Come evitare iniezione SQL: lato SQL Server (SP_EXECUTESQL) In generale va evitato nel modo più assoluto la scrittura di query sql diamiche. Va evitato cioè l’uso lato SQL Server di sp_executesql e EXEC Di seguito mostriamo come trasformare una query “dinamica” in una “statica” [sql]CREATE PROCEDURE search_orders @custid nchar(5) = NULL, @shipname nvarchar(40) = …
Come evitare iniezioni SQL lato DB in SQLServer, Oracle, MySQL Read More »
