Programming languages

GraalVM

  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 »

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 »

SQL: One of the most valuable skills – Craig Kerstiens

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 »

IoT Async

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 …

IoT Async Read More »

Removing duplicate rows in PostgreSQL and Oracle

Oracle trick: [sql] DELETE FROM your_table WHERE rowid not in (SELECT MIN(rowid) FROM your_table GROUP BY column1, column2, column3); [/sql] Postgresql equivalent is ctid, so you can try something like [sql] delete from mytable where exists (select 1 from mytable t2 where t2.name = mytable.name and t2.address = mytable.address and t2.zip = mytable.zip and t2.ctid …

Removing duplicate rows in PostgreSQL and Oracle Read More »