Sorry Joe, my reply was intended for the OP. I think the embedded single-user or read-only case is where SQLite makes sense.
To clarify, I would not recommend sqlite in a situation requiring multiple users writing to a single db over a network. On Monday, September 16, 2013, Joe Weidenbach wrote: > John, > > Are there any other decent cross-platform embedded solutions? In my case, > this is a distributed project, so it's all single user, and they're only > reading the database--the TD's (me mostly) load it up with rig data for > loading the characters on the animation end, and the animators just install > the tool, load the project, and use the tool to load the characters. In a > production situation, I'd go MySQL in a heartbeat, but I don't know of any > other reliable options for this scenario. > > What other options would you suggest? > > Thanks, > > Joe > > On 9/16/2013 9:24 AM, John Patrick wrote: > > 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]<javascript:_e({}, 'cvml', '[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 [email protected]<javascript:_e({}, >> 'cvml', >> 'python_inside_maya%[email protected]');>. >> To post to this group, send email to >> [email protected]<javascript:_e({}, 'cvml', >> '[email protected]');> >> . >> For more options, visit https://groups.google.com/groups/opt_out. >> > > > > -- > John Patrick > 404-242-2675 > [email protected] <javascript:_e({}, 'cvml', '[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]<javascript:_e({}, > 'cvml', > '[email protected]');>. > To post to this group, send email to > [email protected]<javascript:_e({}, 'cvml', > '[email protected]');> > . > For more options, visit https://groups.google.com/groups/opt_out. > > > -- > 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]<javascript:_e({}, > 'cvml', > 'python_inside_maya%[email protected]');>. > To post to this group, send email to > [email protected]<javascript:_e({}, 'cvml', > '[email protected]');> > . > For more options, visit https://groups.google.com/groups/opt_out. > -- Sent from Gmail Mobile -- 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.
