I've got to admit, I don't love the idea of storing pickle strings in a database. There are so many ways that it can go wrong based on differences between the environment on the machine that writes the pickle and the one that reads it. Pickles are a great short term storage format, but they are pretty horrible for long term storage (changed the name of a module and all your data breaks). I would not want to build my pipeline around something so fragile.
If custom columns are needed the first thing I would look into is ensuring that the Stalker base classes are easily extended with new sqlAlchemy properties. The second thing I would look at is storing data as json: Postgres actually has a json field type and support for this is going to get even better with version 9.3, allowing keys to be used as indices in queries a la mongo. My 2 c -chad — Sent from Mailbox On Fri, May 30, 2014 at 7:17 AM, Nils Lerin <[email protected]> wrote: > Regarding the addition of storing TEXT such as JSON. Whouldn't that just > mean adding a attribute/column to a entity of type text to hold your data? > Or am I missing something? > On Fri, May 30, 2014 at 8:00 AM, Marcus Ottosson <[email protected]> > wrote: >> Ah sorry, missed the quoted part. Thanks for clearing that up! >> >> >> On 29 May 2014 21:10, Chad Dombrova <[email protected]> wrote: >> >>> >>> On Thu, May 29, 2014 at 12:43 PM, Marcus Ottosson <[email protected] >>> > wrote: >>> >>>> that’s the plan :) >>>> >>>> The plan for Stalker? Are you helping Erkan develop this? That’s awesome! >>>> >>> We're working on a web UI built using meteor, which is what Shih Hwa Lai >>> was referring to. Our front-end will work with any relational database >>> that has well defined schema (i.e. defined using something like sqlalchemy >>> or bookshelf.js), so I think it will be a perfect complement to Stalker. >>> >>> chad. >>> >>> >>> -- >>> 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 view this discussion on the web visit >>> https://groups.google.com/d/msgid/python_inside_maya/CAGq9Q7HBqDNP9FQ9OAg%2B4FvmqZhkZ12pV1Sws494jfh%2ByijW1A%40mail.gmail.com >>> <https://groups.google.com/d/msgid/python_inside_maya/CAGq9Q7HBqDNP9FQ9OAg%2B4FvmqZhkZ12pV1Sws494jfh%2ByijW1A%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> *Marcus Ottosson* >> [email protected] >> >> -- >> 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 view this discussion on the web visit >> https://groups.google.com/d/msgid/python_inside_maya/CAFRtmOD5OX54VKFscf%3D%2Brdw8mrf9NYZN6GJi93VvfV4eo%2Ban%3Dg%40mail.gmail.com >> <https://groups.google.com/d/msgid/python_inside_maya/CAFRtmOD5OX54VKFscf%3D%2Brdw8mrf9NYZN6GJi93VvfV4eo%2Ban%3Dg%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > -- > 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 view this discussion on the web visit > https://groups.google.com/d/msgid/python_inside_maya/CAGkBUFfP9oo93_qRbNQYMtofAFMQbSAGR1cz-%2BU_YndvX2ehbA%40mail.gmail.com. > For more options, visit https://groups.google.com/d/optout. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/python_inside_maya/1401463325588.4512584d%40Nodemailer. For more options, visit https://groups.google.com/d/optout.
