asterisk users - Apr 2006 - ODBC Storage for voicemail messages in database

Seems like other postings tend to think that saving recordings as
files and not as blobs in the database are a more reliable way to go. 
Opinions on this?  Looking at supporting it for ARI and judging
interest.

Dan
512.791.0137
www.littlejohnconsulting.com

Hi Dan -
> Seems like other postings tend to think that saving recordings as
> files and not as blobs in the database are a more reliable way to go.
> Opinions on this?  Looking at supporting it for ARI and judging
> interest.
As far as integrity of the actual data, I think you're safe either
way.  In either case, the messages will get to the hard drive, they'd
just be accessed by different methods.  In terms of availability of
that data, it may be less reliable with a database.  We use ODBC
message storage on all our asterisk boxes, and while it has never
happened to us (knock on formica), if the database service does ever
go bye bye, you will not have access to the messages until the
database service is running properly once again.  So, I think the real
question is: "How reliable is my database (and the ODBC driver)?". 
We're using MySQL 5.0.18, and so far it has been as reliable as the
machines it is running on.

- Noah