Via Cà Matta 2 - Peschiera Borromeo (MI)
+39 02 00704272
info@synaptica.info

Author: Ivan Revelli

Digital solution partner

Charset Firebird 3.0 [malformed string error]

Character set encoding In Firebird 3.0, as is known in a field of a varchar or char type table, it is possible to define the type of encoding managed, or not specific. Through Firebird it is possible to record the content of the story from one set of characters and another simply with the SQL…
Read more

Oracle import/export schema via SQL script running a JOB.

tested on Oracle XE 10g to make a simple bk from Oracle you can use dbms library like: create or replace directory dumpdir as ‘/home/[youruserpath]/’ /* ESPORTA DATI E METADATI DI UNO SCHEMA */ declare handle number; begin handle := dbms_datapump.open(‘EXPORT’,’SCHEMA’); dbms_datapump.add_file(handle,'[destination_file_name].dmp’,’DUMPDIR’); DBMS_DATAPUMP.add_file( handle => Handle, filename => ‘.log’, directory => ‘DUMPDIR’, filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE…
Read more

Delphi and WebSoket

WebSocket is a technology that allows a bidirectional interaction between server and client, you will tell me, nothing new with a socket connection of the 90’s we did the same thing. True!!! The thing that makes this technology very advantageous is that first of all, it implements standards in data transmission and use protocols but…
Read more

How to Restrict access to the phpMyAdmin by IP Address

Tested on Ubuntu 18.04 LTS

SVN Tips

Completely remove SVN references from a folder recursively:

Undo add … if by mistake as often happens it is called “add” and involuntarily you add infinite files to be committed that you did not want to version, to go back before having committed just run:

 

Embedded World 2020

Embedded World 2020 — Norimberga As every year, the Embedded World fair was held, dedicated to all operators in the hardware and software sector dedicated to creating custom IT solutions. No one was missing, for any type of project there was the right supplier. Truly a very specialized fair, the only flaw in my opinion…
Read more