Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^2: DBI fetchall_hashref convert to scalar

by afoken (Chancellor)
on Feb 03, 2017 at 13:02 UTC ( [id://1180957]=note: print w/replies, xml ) Need Help??


in reply to Re: DBI fetchall_hashref convert to scalar
in thread DBI fetchall_hashref convert to scalar

Storable

Storable is ok for short-time storage, e.g. caching stuff that needs a long time to be recalculated. But DBI sounds like long-time storage. OS, platform, and Perl versions may change over time, and because Storable depends on all of these, that will break Storable.

Stuffing serialised perl data structures into a database does not sound sane. It means the database is not normalised. Ideally, all data would be stored in database-native formats.

Anyway, there are various other formats to serialise data structures that do not depend on the exact perl version, e.g. XML, JSON, YAML.


See also:

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
  • Comment on Re^2: DBI fetchall_hashref convert to scalar

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1180957]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (3)
As of 2024-04-19 21:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found