FreeSWITCH 1.8

db and hash: simple key/value stores

You can arbitrarily insert, delete, select, and update values from the internal FreeSWITCH database.

db will work on persistent tables, be they SQLite files in /usr/local/freeswitch/db, or ODBC or PGSQL remote tables.

hash will work instead on memory resident simple hash tables, extremely fast and efficient, not persistent after a FreeSWITCH restart.

The general format for database commands is:

    ${db(command/table/key/value)}
  

or

    ${hash(command/table/key/value)}
  

And you have also the corresponding dialplan application "db" and "hash".

Commands can be insert, select, or delete, followed by the table, followed by a key and (when appropriate) a value.

 <action application="hash" data="insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}"/> ...