Search
Translate / Traduci
Support Gioorgi Editorial Board
Facet
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 database, mssqlserver, oracle, sqlite
Comments Off on Smart Sync
runif
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
Posted in English Content, Gio's Software Projects, Knowledgebase, Projects, Python, Software
Tagged bash, python
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
- Npm package page
- Git source repository:https://github.com/daitangio/org-mode-parser
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 oracle, sql, sqlite
Comments Off on SQLite Oracle Compatibility Layer
Stereo Sid 2.0.6 update
After a bunch of years, I am happy to announce StereoSID 2.0.6 is here to stay.
It spots a new sid_player example and some optimization on the I2C implementation.
Posted in English Content, Gio's Software Projects, Retro Computing
Tagged stereosid
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 org-mode, org-mode-parser
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 oracle, plugin, sql, sqldeveloper
Comments Off on Oracle SQL Developer Keep Alive plugin