[Freeswitch-users] Database suggestions/pointers/?

[Steve Klein]

Thanks for the suggestions. We'll explore.


-----Original Message-----
From: freeswitch-users-bounces at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Tim Uckun
Sent: Sunday, December 06, 2009 5:00 PM
To: freeswitch-users at lists.freeswitch.org
Subject: Re: [Freeswitch-users] Database suggestions/pointers/?

On Mon, Dec 7, 2009 at 9:07 AM, Steve Klein <sklein at 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 at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org