[erlang-questions] Storing erlang terms in RDMBS
Sat May 30 09:50:38 CEST 2009
On Fri, 29 May 2009 04:23:39 pm Koushik Narayanan wrote:
> Hi all,
> What is the right way to store erlang terms in a RDBMS accessed using
> the odbc application.
> Since the sql_param function takes a string as query argument, how do
> we write a binary and more importantly fetch it back ?
> One naive idea would be to base64 the binary, but that is ineffecient
> and surely there should be a better way.
"inefficient" will depend on whether you are looking to minimise time or
space. I do
term_to_binary -> zlib:deflate -> base64 encode
The deflate cancels out the space growth of base64. I doubt the execution time
matters compared against the work done writing it to the db.
Anthony Shipman Mamas don't let your babies
als@REDACTED grow up to be outsourced.
More information about the erlang-questions