Thanks for the suggestions. We'll explore. -----Original Message----- From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Tim Uckun Sent: Sunday, December 06, 2009 5:00 PM To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Database suggestions/pointers/? On Mon, Dec 7, 2009 at 9:07 AM, Steve Klein <sklein@singular.com> wrote:
Greetings. We need to add database access to an IVR application we are prototyping. Based on FS best practice suggestions, we are using Lua for the scripts. Since FS uses SQLite internally, we presumed that Lua + SQLite would be a recommended approach. However, we cant find any examples of this combo anywhere. So, what is the best practice scripting + database recommendation for a high-volume database-driven FS app?
I would suggest you take a look at freeswitcher (http://github.com/bougyman/freeswitcher). The good thing is that it's ruby and therefore you can use any database compatible with ruby (that's all of them pretty much). You can also use an ORM of your choice or if you don't want to use an ORM you can use the amazingly fantastic sequel library. Being ruby it will run outside of the freeswitch memory space and you will have to use the inbound/outbound socket API. That may be a good thing if you want to separate your database and IVR logic from the machine running your freeswitch. Ruby is pretty easy to pick up if you don't know it and there are a wealth of libraries if you want to do other things like connect to web sites, manipulate XML, etc. There is also a liverpie http://github.com/jsgoecke/liverpie which is more of a proxy thing you can interface with any language. I am sure lua is nice but it seems like people are having some problems with ODBC, memory leaks etc when it comes to databases. If you go a ruby library that all goes away. _______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org