[Asterisk-Dev] PostgreSQL support in Asterisk 1.2?

[Daniel Swarbrick]

Andrew Kohlsmith <akohlsmith-asterisk at benshaw.com> wrote:

> Data consistency is part of a DB's job.  MySQL doesn't do this consistently.  
> People feel that it's all right to work around such egregious failures on the 
> application side but that doesn't make them right or acceptable, and only 
> introduces a metric ton of problems down the road as your application grows 
> or you acquire new interfaces to the data.

If Asterisk Realtime was designed with a better DB schema, that utilised
primary keys and unique keys in the right places, and also utilised
foreign keys (dependant on RDBMS supporting it, which excludes all MySQL
versions prior to 5.0), then it could be smart enough that when a SIP
account was deleted for example, it would also be automatically removed
from queues, extensions etc. This would be a nicer solution than
Asterisk trying to connect to a channel referenced by 'extensions', yet
not existing in the sip or iax config.