I've been searching the Internet for information regarding the replacement of astdb with a modern sql engine.
There are several reasons one would like to do this. First of all, external applications have a hard time reading/writing to the now-old astdb format. Also (and this is what interests me most), the sql astdb could easily be clustered throughout several servers (I'm looking for a master-master MySQL 2-server cluster solution). Asterisk has brought up Realtime which is very powerful but, correct me if I'm wrong, it still requires astdb internally. In other words, if I call Set(DB) in the dialplan then it will always be using astdb regardless of realtime. Some projects like Callweaver have forked from Asterisk 1.2 and replaced astdb with sqlite. I'm wondering if Asterisk has plans to allow the user to choose the astdb backend: standard db1, sqlite, MySQL (which I would use with nbcluster for my clustering purposes), Postgresql with Slony-II, PGcluster, etc. Or is it already possible? There has been some talk on this before: http://lists.digium.com/pipermail/asterisk-dev/2004-December/007846.html Also, the func_odbc feature seems to be very powerful: http://www.asteriskpbx.org/func_odbc but: 1) would there be potential issues with db handles on a very busy asterisk system after a relatively long run time? 2) would there be a way to "map" the odbc function(s) to the DB functions (Set(DB), read and write, DBdel, etc) so that rewriting the whole dialplan would not be necessary? (that's the whole point of defining a different astdb "backend") If there are known problems/issues/projects/alternatives then please let me know. Thanks ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
