Re: [sqlite] locking via windows nfs client

2004-08-20 Thread Elmar Haneke
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

Re: [sqlite] MySQL / SQLite

2004-04-14 Thread Elmar Haneke
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