You can executed any SQL statements you want through 'sqlops', including
invocation of stored procedures.
Our Kamailio-based Class 4 routing/trunking product is built almost entirely on Postgres
stored procedures. We have dozens of them.
As to whether they are "really needed", I don't know how to answer that. :-)
In our case, we decided they were really needed because they offer the opportunity to
execute complex business logic beyond what Kamailio's relatively primitive route
scripting language can offer, while eliminating unnecessary back-and-forth data
interchange between Kamailio and the database. Stored procedures and triggers also execute
in a transactional manner, which is additionally beneficial.
Shankar <shankar.rk(a)plintron.com> wrote:
Hello All,
Does Kamailio support invoking stored procedures instead of sending
plain DB
queries already?
We have been asked to migrate to stored procedures. I am trying to
estimate
the effort involved in migrating Kamailio code to support stored
procedure.
Other question that comes to my mind is whether stored procedures are
really
needed in Kamailio. Can someone please clarify?
Regards,
Shankar
------------------------------------------------------------------------
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Sent from my mobile, and thus lacking in the refinement one might expect from a fully
fledged keyboard.
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0671
Web:
http://www.evaristesys.com/,
http://www.alexbalashov.com