[Asterisk-Users] Re: DB virtualization for multiple database support - Was Re: [Asterisk-Users] How to use vmdb.sql in voicemail.conf/extension.conf

[Daniel Sloan]

What about libdbi?  It already has the "pluggable" driver system, so 
thats half the work done already.
Its also licensed under the LGPL instead of the GPL, which if I have 
understood the discussions about
the GPL issues, should resolve problems of linking to that code.

Support for sqlite is cool too, since it saves running a database server 
for small setups that don't want
the extra (albeit small) overhead.

It would also be great if it is structured so that other "vitualization" 
interfaces can be written, to
provide the same sort of functionality for other parts of Asterisk.


Garry Adkins wrote:

>
> > > I am trying a scenerio where the * will take the email and mailbox 
> number from the Mysql database for sendming mail to a voicemail user. 
> I have seen vmdb.sql file but is not able to determine its use.
>
> > You can't anymore MySQL was ripped from Asterisk because the client libs
> > are GPL.
>  
> I would be more than happy to help write a DB "Virtualization" 
> function for *.
>  
> I *love* the way it works in Java, but that's not a real possibility.  
> It wouldn't need to be as complicated as JDBC but it's a nice model.
>  
> We could however:
> 1)  Abstract out the schema from the database calls
> 2)  Develop a "pluggable" driver interface to translate to whatever DB 
> you're using.
>  
> This way...  You want MySQL, you develop a "translation driver" that 
> maps * db calls to MySql.  (fairly trivial)
> Same for Postgres  (I'd suggest making this the default, as no GPL 
> issues for mark, etc.)
> Same for Oracle, etc.