<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> Shadhin Rahman wrote: <blockquote cite="mid:AANLkTikVWg_yrjd3OQSDSQkTbfw7LS4L=rVQPfLx_Md0@mail.gmail.com" type="cite">All, NdoUtils is particularly written for mysql and postgres. I am thinking about creating a few more connection handles such as oracle, DB2 and possibly sybase. I need a few opinions on this subject. </blockquote> ndoutils is mysql specific. otherwise the logic with the insert ... on duplicate key update ... would have been implemented more generally, as this is just a mysql specific standard, but not official sql standard. postgres and oracle need an adapted upsert logic to realize that. so for what it's worth, you'll need to find a solution on that at first glance. <blockquote cite="mid:AANLkTikVWg_yrjd3OQSDSQkTbfw7LS4L=rVQPfLx_Md0@mail.gmail.com" type="cite"> 1) IDoUtils already has oracle support, porting the code to Ndo, is there any license restrictions associated with this? </blockquote> assuming that you keep the credits to icinga while porting the code, feel free to do so. although i'd recommend getting in touch with the devs first because i do think the code is not self explaining right now. <blockquote cite="mid:AANLkTikVWg_yrjd3OQSDSQkTbfw7LS4L=rVQPfLx_Md0@mail.gmail.com" type="cite"> 2) NDoUtils has many embaded sql statements, what is your opinion restructuring the code and making it modular. I am suggesting decouple the queries from application logic. Create sql interface which queries get passed into? </blockquote> an interface is a good idea, first off - normalize the insert queries to sql standard. <blockquote cite="mid:AANLkTikVWg_yrjd3OQSDSQkTbfw7LS4L=rVQPfLx_Md0@mail.gmail.com" type="cite"> 3) If I (am bold enough) attempt to restructure the code, which version is a better option, 1.28 or 1.29? </blockquote> i'd recommend just providing a diff instead of re-versioning this. kind regards, Michael <blockquote cite="mid:AANLkTikVWg_yrjd3OQSDSQkTbfw7LS4L=rVQPfLx_Md0@mail.gmail.com" type="cite"> Cordially, Shadhin Rahman <pre wrap=""> <fieldset class="mimeAttachmentHeader"></fieldset> ------------------------------------------------------------------------------ Protect Your Site and Customers from Malware Attacks Learn about various malware tactics and how to avoid them. Understand malware threats, the impact they can have on your business, and how you can protect your company and customers by using code signing. <a class="moz-txt-link-freetext" href="http://p.sf.net/sfu/oracle-sfdevnl">http://p.sf.net/sfu/oracle-sfdevnl</a></pre> <pre wrap=""> <fieldset class="mimeAttachmentHeader"></fieldset> _______________________________________________ Nagios-devel mailing list <a class="moz-txt-link-abbreviated" href="mailto:Nagios-devel@lists.sourceforge.net">Nagios-devel@lists.sourceforge.net</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/nagios-devel">https://lists.sourceforge.net/lists/listinfo/nagios-devel</a> </pre> </blockquote> <pre class="moz-signature" cols="72">-- DI (FH) Michael Friedrich Vienna University Computer Center Universitaetsstrasse 7 A-1010 Vienna, Austria email: <a class="moz-txt-link-abbreviated" href="mailto:michael.friedrich@univie.ac.at">michael.friedrich@univie.ac.at</a> phone: +43 1 4277 14359 fax: +43 1 4277 14338 web: <a class="moz-txt-link-freetext" href="http://www.univie.ac.at/zid">http://www.univie.ac.at/zid</a> <a class="moz-txt-link-freetext" href="http://www.aco.net">http://www.aco.net</a> Icinga Core & IDOUtils Developer <a class="moz-txt-link-freetext" href="http://www.icinga.org">http://www.icinga.org</a> </pre> </body> </html>