[Asterisk-Dev] sql storage for voicemail

[Jon Pounder]

If you use an odbc api, there are no licencing issues, and it can still 
work with mysql (or at that point any other database of the user's choice).

Be sure though if you are used to mysql only that you take a look at some 
of the other databases and keep clear of using reserved words as column 
names, and keep your column types generic enough to be compatible with 
other databases. It is not really that hard, a few years ago we made a list 
of about 10 do's and don't which would keep your schema's portable. Access 
is the only really weird case, and we don't have to worry about that on 
unix anyway.


At 01:40 PM 10/23/2003, you wrote:
>         I am looking to write mysql support for voicemail storage.  I have
>looked at it from many different angles (though I dare not say all angles)
>and can.t figure out which is the better way to go.  I want to avoid a
>completely separate voicemail app, though it looks like that would be the
>easiest of the options.
>
>I see these as my options:
>1 . Extend file.c to support storage in mysql.  This would have minimal
>side effects on app_voicemail2, as the data streams would more or less
>remain untouched.  There would need to be changes in the message counting,
>sequencing, and a few other places.
>
>2 . Write a separate voicemail application designed strictly to operate
>with the database
>
>3 . Pull all of the file operations out into functions and create a mysql
>version of each, allowing a toggle for sql, the way it is done now for the
>config file.
>
>I really don.t want to end up with a completely separate voicemail
>application that will need separate maintenance.  On the other hand, how
>often has the voicemail app changed recently?
>
>Also, I.ve only worked with mysql and it seems that the licensing change
>last month will prevent a mysql-based voicemail app from residing in
>regular cvs.
>
>I.ve been going back and forth on this for a couple weeks now, and figured
>I should just ask for some input.
>
>Thanks,
>
>Steve
>
>
>___________________________________________________________
>Steve Creel                                screel at turbs.com
>
>
>_______________________________________________
>Asterisk-Dev mailing list
>Asterisk-Dev at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-dev