Programming languages

Simple method to add historic feature to SQLite

April 9, 2021 April 6, 2021 / English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) / database, sqlite / Leave a Comment

Abstract: Make a database which can be store historic modification is often considered a “secondary” activity, but bad design leads to databases that are difficult to optimize and often not very understandable. In this article we illustrate a simple method that respects the dictates of relational theory & is easy to understand. As a plus …

Simple method to add historic feature to SQLite Read More »

Semplice metodo per storicizzare i dati su database

March 17, 2021 April 7, 2021 / Italian Content, Structured Query Language (SQL) / database, oracle / Leave a Comment

Abstract: Storicizzare i dati spesso è un attività considerata “secondaria”, ma un cattivo design porta a base dati difficili da ottimizzare e spesso poco comprensibili. In questo articolo illustriamo un semplice metodo che rispetta i dettami della teoria relazionale, è facile da capire ed è attivamente usato in produzione. Autori: Ernesto Ghetti (idea), Giovanni Giorgi …

Semplice metodo per storicizzare i dati su database Read More »

runif

May 28, 2020 March 15, 2021 / English Content, Gio's Software Projects, Knowledgebase, Projects, Python, Software / bash, python

Idempotent and minimal python 3 library for rapid scripting. Provide support for creating file, adding data to them, patching and so on. Why? (Ba)sh 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 …

runif Read More »

Pybash

January 15, 2020 May 28, 2020 / English Content, Knowledgebase, Python, Software / bash, python

The project has been renamed into “runif”. This page left only for Google Search happiness. Pybash is a python library to make python script as easy as in Bourne Again Shell (Bash). Bash scripting is very easy to setup. So we end up using it all the time for simple procedural script. Sometimes is it …

Pybash Read More »

Avoid Kafka if unsure (think twice series)

December 2, 2019 December 2, 2019 / English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) / java, kafka, nosql

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 …

Avoid Kafka if unsure (think twice series) Read More »

On Constants

October 4, 2019 October 4, 2019 / English Content, Humor, Programming languages, Software / evil, ideas, java

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 …

On Constants Read More »

Rust Programming Language

September 23, 2019 September 26, 2019 / English Content, Programming languages

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

June 10, 2019 April 16, 2019 / English Content, Java, Programming languages

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 …

GraalVM Read More »

Ring – Cache interface as a programming language integration

May 28, 2019 May 28, 2019 / English Content, Knowledgebase, Python / cache, python

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

April 23, 2019 April 16, 2019 / English Content, Java / webassembly

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 …

WebAssembly Read More »

Comments are evil?

April 15, 2019 November 28, 2019 / English Content, Programming languages, Software / evil, ideas, java

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 …

Comments are evil? Read More »

SQL: One of the most valuable skills – Craig Kerstiens

February 20, 2019 March 12, 2021 / English Content, Structured Query Language (SQL) / postgresql, skill, sql, sqlite

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 »

Outer full and inner SQL joins: you are wellcome

August 27, 2018 February 21, 2019 / English Content, Structured Query Language (SQL) / sql

For a complete description see https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

SQLite Oracle Compatibility Layer

August 7, 2018 March 15, 2021 / English Content, Gio's Software Projects, Projects, Python, Structured Query Language (SQL) / oracle, sql, sqlite

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 Github link: https://gitlab.com/daitangio/sqlite_ora_functions

IoT Async

May 18, 2018 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 »