[Asterisk-Users] Realtime sipbuddies table structure why?????

Matthew Boehm mboehm at cytelcom.com
Thu Dec 23 08:32:11 MST 2004


> just poor data modeling

    How so? How would you change it? Are you aware that they have written
code into app_voicemail.c that allows you to store the actual soundfiles for
voicemail in the database itself? You want to talk about poor database
design...sheesh..

> Read it, makes no difference, it's broken :)

    Whats broken?

> Also, it doesn't say why the table structure is the way it is.

    It most certainly does. Seems you didn't read the REAME after all.

Quoted from README.extconfig:

<quote>

It is designed to provide a flexible, seamless integration between
Asterisk's internal configuration structure and external SQL other other
databases

the columns in your tables should line up with the
fields you would specify in the given entity declaration.

For example, an entity that looks like:

[foo]
host=dynamic
secret=bar
context=default
context=local

could be stored in a table like this:

+------+--------+-------+--------------+----------+-----+-----------+
| name | host   | secret| context      | ipaddr   | port| regseconds|
+------+--------+-------+--------------+----------+-----+-----------+
| foo  | dynamic|  bar  | default;local| 127.0.0.1| 4569| 1096954152|
+------+--------+-------+--------------+----------+-----+-----------+

</quote>

Seems pretty simple and easy to use. This way if new config options are ever
added, all you have to do to support them is to add a new column. And if all
you are storing in most columns is 1 byte, it can't take up that much space.

-Matthew

----- Original Message ----- 
From: "Greg - Cirelle Enterprises" <gcirino at cirelle.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Thursday, December 23, 2004 9:00 AM
Subject: Re: [Asterisk-Users] Realtime sipbuddies table structure why?????


> At 09:53 AM 12/23/04, you wrote:
> >It was written the way it is because that is how RealTime works. =P If
you
> >don't like the schema design, talk to Mark so he can rewrite RealTime for
> >you.
> >
> >Read up some more on how RealTime works then you will understand why all
the
> >tables are designed the way they are.
> >
> >Read docs/README.extconfig
> >
> >-Matthew
>
>
> Read it, makes no difference, it's broken :)
>
> Also, it doesn't say why the table structure is the
> way it is.  just poor data modeling.
>
> greg
>
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users




More information about the asterisk-users mailing list