[erlang-questions] Re: Storing erlang terms in RDMBS

[Koushik Narayanan]

On Sat, May 30, 2009 at 05:46:29PM +0100, Robert Raschke wrote:
> 
> Since you don't say what your DB column types are and you are using
> the odbc module which doesn't support BLOBs, I assume you are storing
> the 'term' in a suitably large varchar column. In that case, you'll
> always need to parse whatever you get back from the DB. It's just a
> string, after all. You may want to investigate the erl_parse module
> for more flexibility.

Yes erl_parse works fine for this case. And I am using a varchar 
for the field.

> 
> Potentially, using some DB binding lib that can deal with binary
> objects, you may be able to get shorter code.

I thought ODBC is the recommended way to connect to RDBMSs from erlang
since the odbc application part of the OTP distribution and is also 
flexible enough to try with different Dbs.

> 
> I take it, you don't want to 'just' use mnesia instead of a RDBMS.
> 

I already have a mnesia backend in place, was trying to implement a 
DBMS backend too and abstract the system from this,compare performance 
correct mistakes and so on.


Koushik Narayanan