[OpenSIPS-Users] LCR Route Prefixes -> Gateways (From Scratch)

[Muhammad Shahzad]

Well, a very basic sign of good piece of software, that is driven by
database,is that it ALWAYS uses column names, instead of index numbers.
OpenSIPS not only confirm to this very basic standard but it further
improves it by allowing user to define table and column names as module
parameter that will be internally called by module through SQL queries. So,
yes adding more columns should not and will not effect its processing.
However, be sure to only add columns that are really need or at least fit
to the philosophy of the module.

In my personal view routing and rating are two distinct entities and for
sake of data independence they should not be mixed together in a single
table. Perhaps you should to be interested in call-control module or
something similar. If you are good in PERL or LUA you can even write up
your own module for rating and billing, and it would work like a charm even
for high loads, as long as you keep your database optimized. And yes, you
can make such rating / billing module on commercial license.

Thank you.




On Mon, Aug 5, 2013 at 6:00 PM, Nick Khamis <symack at gmail.com> wrote:

> Hello Muhammad,
>
> I have no problem updating the DB script and relevant code using optimized
> indexing/views, and sharing that with the community. It's about time I
> contribute in some form or another... :)
>
> Furthermore, I would also like to share the final DB schema and script in
> charge of creating an OpenSIPS LCR instance with the community. And would
> be happy to see it posted on the OpenSIPS Tut section. I will have some
> questions to steer me to the right direction however, will keep them short
> and connect the dots without taking too much of the community's time.
>
> My first question will be, is it safe to add additional fields to the
> `dr_rules` table. What I will need are things like (bill_minimum,
> bill_increment, list/retail_rate etc..). Things we usually see in a rate
> deck ;). What I am asking is do the OpenSIPS code use index based queries
> or actual field names when querying the database. The latter would be safer
> and thus pose no problem when adding extra fields...
>
> PS I will use this email as a thread to this subject.
>
> Kind Regards,
>
> Nick.
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>


-- 
Mit freundlichen Grüßen
Muhammad Shahzad
-----------------------------------
CISCO Rich Media Communication Specialist (CRMCS)
CISCO Certified Network Associate (CCNA)
Cell: +49 176 99 83 10 85
MSN: shari_786pk at hotmail.com
Email: shaheryarkh at googlemail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130805/eca43176/attachment.htm>