from my experience..
1. specify full path when connecting to the database with a .db extension
2. it is not sufficient if you give write permissions only to the database.. sqlite3 requires that the directory containing the database has write permissions as well..
3. while giving placeholders like "?" only one argument is taken irrespective of the number of placeholders.. keep all ur arguments in a tuple
Subscribe to:
Post Comments (Atom)
1 comment:
The first two rules hold good for any form of scripting/specifying paths anywhere (unless you wanna do the relative path thingy, which isn't such a bad idea either, depending on the situation).
Post a Comment