Yes. And you don't need to redecalre tables - if MyTable and MyTable2
are realy the same table - just do

MyTable.createTable(ifNotExists=True, connection=connection2)

> And after that, it is not necessary to take care about the connection in the
> rest of the code?

  No, after that there are many different calls to pass connection2 to. Of
course if MyTable and MyTable2 are really two different tables and every
one of them are in two different databases you just set connection2 to be
the default connection for MyTable2:


  and forget about connections. But if you want to copy data between two
identical tables in two different databases - you have to pass connection2
to all methods you call:
My tables are two different tables in two different databases.

I am using some small table(s) to store data to communicate (signalize) between two running scripts on one computer (I am not skilled enough to write a multithread script). I am on Linux  and to achieve reasonable speed I am using tmpfs (kind of RAM disk: "mount -t tmpfs -o size=10m none /work").

Because of that I need to have two different databases (connections). One for persistent data and the other one for signaling.

Thanks for your help.