I am using Storable to put information into an SQLite database. As it happens, I am freezeing the structure into a string, then inserting that into a Text-type column. (Of course, I am binding to a query parameter, thus allowing me to insert the arbitrary string.) It all seems to be working fine.
But then, a colleague’s question got me to wondering ... should I be using the Blob field-type for this? I don’t think so, but, “when in doubt, humbly petiton the Monks ...”
This arrangement is perfectly satisfactory for my needs... I’m not transporting the data anywhere, don’t have to keep it for a long time, don’t need the “freeze to a file” features of Storable, and don’t really need to “get jiggy wid it” (if you know what I mean). I simply need to store a Perl data-structure that took some time to create, so that I don’t have to create it a second time. But if there might be some column-data-type related conversion issue that I am not aware of, I’d just like to know about it sooner rather than later. (The target file-format will always be SQLite.)