I'd advise strongly against this. There is a worse problem than performance that you'll encounter eventually - concurrent writes can corrupt the database.
Like Justin mentioned, sqlite uses a file-locking mechanism to control concurrent writes, which seems to work 99.9% of the time. The time it doesn't will corrupt your database. I've seen it happen. IMO, sqlite is great for storing single-user application data and as a test database, but if you're intending to store critical data that will be written to by multiple machines over a network, I would bite the bullet with PostgreSQL, MySQL, etc. On Sun, Sep 15, 2013 at 8:55 PM, Joe Weidenbach <[email protected]> wrote: > That's for 2012+ by the way. > > > On 9/15/2013 8:49 PM, Jay Goodman wrote: > >> Are you planning to connect to the DB from within maya? There are (or >> were) issues with maya and sqlite: from the dll not being included with the >> maya install to memory access issues. I thought I read this was fixed as >> of 2012, but I'm stuck on 2009, and haven't verified. >> >> If anyone has resolved the memory access issues (which are very rare and >> random)--I would be interested in that solution. >> thanks >> >> > -- > You received this message because you are subscribed to the Google Groups > "Python Programming for Autodesk Maya" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to > python_inside_maya+**[email protected]<python_inside_maya%[email protected]> > . > To post to this group, send email to > python_inside_maya@**googlegroups.com<[email protected]> > . > For more options, visit > https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> > . > -- John Patrick 404-242-2675 [email protected] http://www.canyourigit.com -- You received this message because you are subscribed to the Google Groups "Python Programming for Autodesk Maya" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
