!Support Ukraine!

Posted in English Content, Italian Content | Leave a comment

Smart Sync

On 2002, I was forced to build a small java class to “sync” two databases (sorry for Italian):

SmartSync used the Metadata offered by JDBC API to be able to copy data between two tables.
In the last years I evolved it to be able to support a special use case called “dump to SQLite”.

I am a sqlite fan, and sometimes I need to stage data for Data Warehouse study or simple for off-line analysis.

SmartSync was a winner in such scenarios. It is still in beta, full of rouch edges, but it works on JDK 11 and look cool:

 

Posted in English Content, Gio's Software Projects | Tagged , , , | Comments Off on Smart Sync

runif

This entry is part 8 of 10 in the series Unix swissknife

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 teach use, this script should only do an action if needed.

I have this need for a complex set of migration procedures.
I was unable to do it bash
It was an overkilll using Java

So runif popped out

Try the examples running them from the root directory

The run() function is very handy to fire direct command, like you would do in a bash script, like running git pull or so on

Note: runif it is NOT a replacement for Gradle, GNU Make, Maven, etc.

Launch example

Install the package with

python setup.py install

Here an example of what happen if you run twice the same script:

$ python examples/stepByStep.py
[INFO] runif.py.run_if_missed demo ===> step1
[INFO] runif.py.run_if_missed demo/demofile.txt ===> step2
[INFO] runif.py.run_if_missed demo/demofile2.c ===> step2
[INFO] runif.py.run_if_unmarked demo/demofile.txt ===> Step3
[INFO] runif.py.run_if_present demo/demofile.txt ===>
demo/demofile.txt present!
[INFO] runif.py.run_each demo\demofile2.c ===>
** demo\demofile2.c

$ python examples/stepByStep.py
[INFO] runif.py.run_if_present demo/demofile.txt ===>
demo/demofile.txt present!
[INFO] runif.py.run_each demo\demofile2.c ===>
** demo\demofile2.c

https://github.com/daitangio/runif

Posted in English Content, Gio's Software Projects, Knowledgebase, Projects, Python, Software | Tagged , | Comments Off on runif

Introduction to org mode parser

Org-mode is an Emacs mode for keeping notes, maintaining To-do lists, doing project planning, and authoring with a fast and effective plain-text system.

Node.js is a event-based server for the V8 JavaScript Engine.

So Org Mode Parser for Nodejs is a parser for reading org-mode files.

Follow OrgMode updates and news clicking on this link

 

To try it out, from a bash shell with node.js in the path:

$ npm install org-mode-parser
$ node
> orgParser=require('org-mode-parser');
{ enableDebug: [Function: enableDebug],
  asLines: [Function],
  intercept: [Function],
  Orgnode: [Function: Orgnode],
  parseBigString: [Function],
  makelistWithPerformance: [Function],
  makelist: [Function] }

LICENSE

Org Mode is distributed under GNU PUBLIC License 2.0

 

Github last commits:

 

 

Posted in English Content, Gio's Software Projects, Org Mode Parser | Comments Off on Introduction to org mode parser

SQLite Oracle Compatibility Layer

The Sqlite Oracle Compatibility Functions is an experimental compatibility layer for SQLite vs Oracle, written in Python 3.

 

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

Posted in English Content, Gio's Software Projects, Projects, Python, Structured Query Language (SQL) | Tagged , , | Comments Off on SQLite Oracle Compatibility Layer

Stereo Sid 2.0.6 update

Posted in English Content, Gio's Software Projects, Retro Computing | Tagged | Comments Off on Stereo Sid 2.0.6 update

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.

 

 

 

Posted in English Content, Gio's Software Projects, Org Mode Parser | Tagged , | Comments Off on Org Mode parser 0.1.3 is out!

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

 

Posted in English Content, Gio's Software Projects, Knowledgebase, Software, Structured Query Language (SQL) | Tagged , , , | Comments Off on Oracle SQL Developer Keep Alive plugin