Hmm, actually you can use the internal sqlite engine of freeswitch.

Ledr and I recently added that to freeswitch.dbh. You can create new tables and use them immediately.

If you use ‘core:tablename’  as the dsn, freeswitch will automatically create a new tablename.db sqlite file if it did not exist yet.

For simple queries and when using lua , there is no need to install  mysql, postgres or whatever odbc database, and there is also no need to use LuaSQL, and yet you still have persistent storage (unless you use in memory filesystem).

Garmt

From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Michael Collins
Sent: Thursday, 10 February, 2011 18:01
To: FreeSWITCH Users Help
Subject: Re: [Freeswitch-users] lua question db

On Thu, Feb 10, 2011 at 10:36 AM, David Ponzone <david.ponzone@ipeva.fr> wrote:

You can't use the internal db for your application.

You must use an external DB (Posgres, MySQL, or anyting accessible through ODBC).

Technically you *could* use the db (or hash) API to store the call-forward information in much the same way that the Local_Extension and the call_return & call-pickup extensions work. I'll leave it as an exercise for the OP to review these extensions in conf/dialplan/default.xml for hints on how to proceed:

Local_Extension

global-intercept

group-intercept

intercept-ext

redial

call_return

-MC