As they say, when you have a hammer, all you see is nails. In my
previous life I was a database programmer, hence my proclivity towards
using them. Mostly, I use this tool for finding rig paths in an easy
fashion. The tool loads a list of characters that it knows about (one
query), and then loads the known control and envelope rigs for those
characters (another query), finally using that info for another query to
actually feed the file paths into a referencer to make the appropriate
constraints. It would be simple enough to write a text parser for a
flat file, but I like SQL a lot better than string parsing.
That's most of it :) However, on a much larger tool I'm working on,
it's going to be managing studio-wide settings and preferences. I was
planning on using sqlite for the single-user version, and MySQL for the
enterprise. Is that the wrong approach?
On 9/16/2013 9:35 PM, Justin Israel wrote:
Is your application running queries against the data, or simply
retrieving a payload of rig data for a given key?
On Tue, Sep 17, 2013 at 4:09 PM, Joe Weidenbach <[email protected]
<mailto:[email protected]>> 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] <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 <tel: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]
<mailto:[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.
--
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.
--
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.
