Storing plain-text as pickled Python objects?
On 30 May 2014 16:33, Fredrik Averpil <fredrik.aver...@gmail.com> wrote: > You are probably completely right. I wasn't thinking of storing anything > but plain text initially. I'm using MySQL (not Postgres) and to my > knowledge there's no special JSON field type so it'll just be plain text. > > // Fredrik > > > > On Fri, May 30, 2014 at 5:25 PM, Marcus Ottosson <konstrukt...@gmail.com> > wrote: > >> I'm with Chad on this one. >> >> In fact, I'd stay away from pickle altogether; if for no other reason >> than to enforce thought into what data you eventually end up >> persisting/send across a network. Pickle is much to kind in what you're >> allowed to send/store. >> >> >> On 30 May 2014 16:22, Chad Dombrova <chad...@gmail.com> wrote: >> >>> 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 <https://www.dropbox.com/mailbox> >>> >>> >>> On Fri, May 30, 2014 at 7:17 AM, Nils Lerin <nils.le...@gmail.com> >>> 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 < >>>> konstrukt...@gmail.com> wrote: >>>> >>>>> Ah sorry, missed the quoted part. Thanks for clearing that up! >>>>> >>>>> >>>>> On 29 May 2014 21:10, Chad Dombrova <chad...@gmail.com> wrote: >>>>> >>>>>> >>>>>> On Thu, May 29, 2014 at 12:43 PM, Marcus Ottosson < >>>>>> konstrukt...@gmail.com> 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 python_inside_maya+unsubscr...@googlegroups.com. >>>>>> 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* >>>>> konstrukt...@gmail.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 python_inside_maya+unsubscr...@googlegroups.com. >>>>> 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 python_inside_maya+unsubscr...@googlegroups.com. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/python_inside_maya/CAGkBUFfP9oo93_qRbNQYMtofAFMQbSAGR1cz-%2BU_YndvX2ehbA%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/python_inside_maya/CAGkBUFfP9oo93_qRbNQYMtofAFMQbSAGR1cz-%2BU_YndvX2ehbA%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 python_inside_maya+unsubscr...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/python_inside_maya/1401463325588.4512584d%40Nodemailer >>> <https://groups.google.com/d/msgid/python_inside_maya/1401463325588.4512584d%40Nodemailer?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> *Marcus Ottosson* >> konstrukt...@gmail.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 python_inside_maya+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/python_inside_maya/CAFRtmODwy6hVSgh0u%2BoVwC0tk13kn03S%3Dkap%2BsnGthFDKxV4gg%40mail.gmail.com >> <https://groups.google.com/d/msgid/python_inside_maya/CAFRtmODwy6hVSgh0u%2BoVwC0tk13kn03S%3Dkap%2BsnGthFDKxV4gg%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 python_inside_maya+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/python_inside_maya/CAD%3DwhWPKiqdQ5Ra%3DXCBHtYfgt5GrKioZENPRH8ip3xXR4OEnbA%40mail.gmail.com > <https://groups.google.com/d/msgid/python_inside_maya/CAD%3DwhWPKiqdQ5Ra%3DXCBHtYfgt5GrKioZENPRH8ip3xXR4OEnbA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- *Marcus Ottosson* konstrukt...@gmail.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 python_inside_maya+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/python_inside_maya/CAFRtmOAiBO8Zn%2BAAbrZpWSn9Cw0NSJFuoyo08upz8obVsXkbKw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
