Italian Accent Oracle fix

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 to be destroyed if you past them in your html page without using the correct html entity (i.e. è )

Sometimes you need to export the data inserted with accent: an Oracle Virtual column can be an elegant solution….if you have at least Oracle 11g.

 

Also a magic update can fix some nasty problems….here the solution:

 

ALTER TABLE TEST_TABLE ADD( NAME_NORMALIZED generated
always
AS
( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(
ACCENT_COLUMN,
'à','a'''),'è','e'''),'é','e'''),'ì','i'''),'ò','o'''),'ù','u''') ));

Arduino Real Time OS Evolution (flash news)

A new version of an Arduino Realtime OS is on the go:

I have used with profit and fun NilRTOS, and I strongly suggest to you this new variant.

A preemptive multi tasking RTOS in a 2KB 1-MIPS, 8 bit microcontroller remember be the ugly time when a MS-Windows 3.x with 1 MB of RAM was an inferior operative system no-preemptive at all, but with nice software like Excel and Access

Org Mode parser 0.1.3 is out!

Beauty (OrgMode Parser 0.1.3) is here to stay!
OrgMode parser is a small nodeJS library to parse Emacs OrgMode files (more info at this link).

This version features:

  • Fixed empty header issue
  • Code Cleanup
  • Migration from jade to pug2 (new name of jade)
  • Added optional logging framework (winston)

Also I’d like to thank all the people contributed: I have a list now.

 

 

 

Oracle SQL Developer Keep Alive plugin

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

 

AngularJS alterantive: Micro JavaScript framework on the 2017

AngularJS is indeed a good framework, but if you lose some grip on it (i.e. you go in vacation for 2 weeks), it is very complex to re-grasp.

Also I have seen junior JavaScript developer confused my $scope use.

JavaScript on client side has damned destiny: it is too easy to develop a framework from scratch: so roll you dice, cross your finger and find plenty of AngularJS alternatives

Continue reading “AngularJS alterantive: Micro JavaScript framework on the 2017”