the simple way
Some times we just want to store some non (that) structured data on SQL database and the big issue may be how to manage them.
Having the following planets data:
lets create simple table structure:
CREATE TABLE planets(
id SERIAL PRIMARY KEY,
On linux/unix environments scp are rsyncare widely used to transfer/synchronize files between servers since they provide a secure way to transfer files between two or more computer nodes.
Quickly (for inpatients):
me@server1 ~ % nc -l -p 4444 < file.txt
me@server2 ~ % nc -w 3 server1 4444 > file.txt