<html v="urn:schemas-microsoft-com:vml" o="urn:schemas-microsoft-com:office:office" w="urn:schemas-microsoft-com:office:word" x="urn:schemas-microsoft-com:office:excel" m="http://schemas.microsoft.com/office/2004/12/omml"><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /><meta name="Generator" content="Microsoft Word 12 (filtered medium)" /><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang="EN-US" link="blue" vlink="purple">You can executed any SQL statements you want through 'sqlops', including invocation of stored procedures. <br>
<br>
Our Kamailio-based Class 4 routing/trunking product is built almost entirely on Postgres stored procedures. We have dozens of them. <br>
<br>
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. <br>
<br><br><div class="gmail_quote">Shankar <shankar.rk@plintron.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--><div class="WordSection1"><p class="MsoNormal">Hello All,</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Does Kamailio support invoking stored procedures instead of sending plain DB queries already? </p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">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. </p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Other question that comes to my mind is whether stored procedures are really needed in Kamailio. Can someone please clarify?</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Regards,</p><p></p><p class="MsoNormal">Shankar</p><p></p></div>
<p style="margin-top: 2.5em; margin-bottom: 1em; border-bottom: 1px solid #000"></p><pre class="k9mail"><hr /><br />SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br />sr-users@lists.sip-router.org<br /><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br /></pre></blockquote></div><br>
--<br>
Sent from my mobile, and thus lacking in the refinement one might expect from a fully fledged keyboard. <br>
<br>
Alex Balashov - Principal <br>
Evariste Systems LLC<br>
235 E Ponce de Leon Ave<br>
Suite 106<br>
Decatur, GA 30030<br>
United States<br>
Tel: +1-678-954-0671<br>
Web: <a href="http://www.evaristesys.com">http://www.evaristesys.com</a>/, <a href="http://www.alexbalashov.com">http://www.alexbalashov.com</a></body></html>