[sqlite] sqlite and NAS

2005-10-02 Thread Vinj Vinj
All our storage is on windows based NAS servers. We have multiple computers reading a sqlite db file and one server writing it. Is there any NAS server that this will work on? I've tried it on windows and it does not work. If a server opens a db file then any other server will recieve a database

Re: [sqlite] Assertion failure in btree.c, line 1166

2005-09-26 Thread Vinj Vinj
I got the same errors where the python application would just crap out. For some time I thought it was a problem with apsw. I migrated to apsw frompysqlite. I searched all over but then did a .dump of my database and recreated it and the error went away. Pretty scary though and I never received

[sqlite] How do you ignore errors when loading csv data into sqlite

2005-09-02 Thread Vinj Vinj
I'm using the following command: sqlite3 -separator , %(dbFile)s ".import %(csvFilePath)s %(tableName)s" I was moving to sqlite from mysql where I was using the mysql command 'load from file' command. The mysql gives you a good summary as x records loaded, x had warnings, and x had erros. It see