Bash scripting is very easy to setup. So we end up using it all the time for simple procedural script. Sometimes is it useful to have idempotent script, like Ansible and Saltstack teach use, this script should only do an action if needed. Some tima ago, I have the need to convert a bunch of …
Some co-workers started using Apache Kafka con a bunch of our Customers. Apache Kafka is a community distributed event streaming platform capable of handling trillions of events a day. Initially conceived as a messaging queue, Kafka is based on an abstraction of a distributed commit log[*]. To get this goal, Apache Kafka needs a complex …
I think constants are evil (just joking but….I will explain why). I am tired of seeing a lot of Java classes filled with the same constants repeated over and over again, instead of collecting them in a common file, which in C Language was called include files (ooooah!). Sometimes it is impossible to understand if …
I have done a quick peek of the Rust Programming language: it is very popular on Internet, it rivals with Go on the popularity score. Anyway, I find it too much “Haskell-like”, with heavy rules and concept.
GraalVM is a universal virtual machine for running applications written in JavaScript, Python, Ruby, R, JVM-based languages like Java, Scala, Kotli n, Clojure, and LLVM-based languages such as C and C++.GraalVM removes the isolation between programming languages and enables interoperability in a shared runtime. It can run either standalone or in the context of …
Ring – Cache interface as a programming language integrationRing provides function-oriented cache interface for various backends. Repository: https://github.com/youknowone/ring/ Source: Ring – Cache interface as a programming language integration — Ring 0.7.2 documentation
WebAssembly (often shortened to Wasm) is a standard that defines a binary format and a corresponding assembly-like text format for executables used by web pages. [….] WebAssembly code is intended to be run on a portable abstract structured stack machine,[27] which is designed to be faster to parse than JavaScript, as well as faster to execute,[21] and to enable very compact code representation.In …
In the 1980 comments were used to reduce the “gap” between unstructured code and “rationale” behind the code. C/64 Peek and poke where oscure. Gosub on function pointed by numbers was bad 8-bit systems was tight on command names and so on (think to write a python interpreter in Arduino/bbc:Micro, or look at the memory …
I admit it. I suffered from an “algebra narcoleptic syndrome” during my relational database lessons at University (1996 circa). Ok it is a fake. But it seems so real on these days. I was unable to avoid sleeping. I learned to love SQL after some years and now I think SQL is the most powerful, …
SQL: One of the most valuable skills – Craig Kerstiens Read More »
For a complete description see https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
It aims to provide a minimal compatibility with Oracle. The need was having some regular expression functions, and I do not like to work with risky C code, like this university project did
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 colelzzionava 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 …
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 »
In Italian language we have accent words like àèéìòù They are quite important because for instance “is” is spelled è whereas “and” is spelled e Accent are bad guys even today: if you copy them from MS-Word inside an Oracle sql script you can end up with different UTF-8 values. Also the accent are likely …
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-keepalive13 forks.89 stars.8 open issues.Recent commits: Fix …
