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]
<mailto:[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]
<mailto:python_inside_maya%[email protected]>.
To post to this group, send email to
[email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/groups/opt_out.
--
John Patrick
404-242-2675
[email protected] <mailto:[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.
--
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.
