ssh only. period. nothing gets in or out except
on 22.
You can forward the database-access through an SSH-tunnel.
additionally this system must be 24/7 and setting up HA setups for
postgresql is tricky (i've done it twice before).
Perhaps you should look at FirebirdSQL it is suitable for 24/7
Hannes Roth schrieb:
1. Why is the SQLite database much much bigger than the MySQL table and
the raw csv file? I didn't use any index and vacuumed all the time ;)
SQLite does store everything as string, therefore the DB cannot be
significantly small than the CVS-file. MySQL does store