[Freeswitch-users] Changes to how ODBC, SQL, etc works

[Yiftach Golan]

It is just about how fast is ODBC compare to native mysql
http://www.devtoolshed.com/content/performance-benchmarks-odbc-vs-oracle-mysql-sql-server-net-providers
Also for what ken wrote we used the non thread safe version and protected
the call to the database with mutex


On Sat, Nov 3, 2012 at 1:25 PM, curriegrad2004 <curriegrad2004 at gmail.com>wrote:

> ODBC's there for this reason. Why invent more wheels when we already
> have that wheel sitting around?
>
> On Sat, Nov 3, 2012 at 11:36 AM, Anthony Minessale
> <anthony.minessale at gmail.com> wrote:
> > Plus as a friend of mine used to say: "It's not MY sql its YOUR sql!"
> >
> > It is a fact that we have an incredible amount of bugs come up that end
> up
> > being mysql+odbc memory errors and thread safety issues.
> > I would be concerned with more blame falling on us of we had the code
> deeper
> > into our core.
> >
> > I would not condone adding any more db support unless we we architected
> it
> > to use db modules so we could still properly blame it on mysql when it
> was
> > not working.
> >
> >
> >
> >
> > On Sat, Nov 3, 2012 at 12:32 PM, Ken Rice <krice at freeswitch.org> wrote:
> >>
> >> While this may solve the issue... This does not address a number of
> other
> >> issues
> >>
> >> A) 90+% of the primary FreeSWITCH developers use PostgreSQL primarily...
> >>
> >> B) There is that whole threadsafe vs non-threadsafe mysql client lib
> >> issue,
> >> so we would have to come up with a way in the build system to detect
> which
> >> we have, and never use the non-thread safe one... (if we don't do this,
> >> the
> >> code would never be stable as we could never know for sure which one
> >> actually got detected and linked against)
> >>
> >>
> >>
> >>
> >>
> >> On 11/3/12 1:40 AM, "Gabriel Gunderson" <gabe at gundy.org> wrote:
> >>
> >> > On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004
> >> > <curriegrad2004 at gmail.com> wrote:
> >> >> Quite impossible. The reason is because of the license that the MySQL
> >> >> libs are licensed under. iirc, they are GPL licensed and they are not
> >> >> compatible with the MPL that FreeSWITCH uses.
> >> >
> >> > I've got PostgreSQL, so I've got all I need :) But, it seems like this
> >> > legal issue is easily resolved:
> >> >
> >> > http://www.mysql.com/about/legal/licensing/foss-exception/
> >> >
> >> > Anyway, I'm not a lawyer or even a very thorough reader ;)
> >> >
> >> >
> >> > Best,
> >> > Gabe
> >> >
> >> >
> >> >
> _________________________________________________________________________
> >> > Professional FreeSWITCH Consulting Services:
> >> > consulting at freeswitch.org
> >> > http://www.freeswitchsolutions.com
> >> >
> >> > 
> >> > 
> >> >
> >> > Official FreeSWITCH Sites
> >> > http://www.freeswitch.org
> >> > http://wiki.freeswitch.org
> >> > http://www.cluecon.com
> >> >
> >> > FreeSWITCH-users mailing list
> >> > FreeSWITCH-users at lists.freeswitch.org
> >> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> >> > UNSUBSCRIBE:
> http://lists.freeswitch.org/mailman/options/freeswitch-users
> >> > http://www.freeswitch.org
> >>
> >> --
> >> Ken
> >> http://www.FreeSWITCH.org
> >> http://www.ClueCon.com
> >> http://www.OSTAG.org
> >> irc.freenode.net #freeswitch
> >>
> >>
> >>
> >>
> _________________________________________________________________________
> >> Professional FreeSWITCH Consulting Services:
> >> consulting at freeswitch.org
> >> http://www.freeswitchsolutions.com
> >>
> >> 
> >> 
> >>
> >> Official FreeSWITCH Sites
> >> http://www.freeswitch.org
> >> http://wiki.freeswitch.org
> >> http://www.cluecon.com
> >>
> >> FreeSWITCH-users mailing list
> >> FreeSWITCH-users at lists.freeswitch.org
> >> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> >> UNSUBSCRIBE:
> http://lists.freeswitch.org/mailman/options/freeswitch-users
> >> http://www.freeswitch.org
> >
> >
> >
> >
> > --
> > Anthony Minessale II
> >
> > FreeSWITCH http://www.freeswitch.org/
> > ClueCon http://www.cluecon.com/
> > Twitter: http://twitter.com/FreeSWITCH_wire
> >
> > AIM: anthm
> > MSN:anthony_minessale at hotmail.com
> > GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
> > IRC: irc.freenode.net #freeswitch
> >
> > FreeSWITCH Developer Conference
> > sip:888 at conference.freeswitch.org
> > googletalk:conf+888 at conference.freeswitch.org
> > pstn:+19193869900
> >
> > _________________________________________________________________________
> > Professional FreeSWITCH Consulting Services:
> > consulting at freeswitch.org
> > http://www.freeswitchsolutions.com
> >
> > 
> > 
> >
> > Official FreeSWITCH Sites
> > http://www.freeswitch.org
> > http://wiki.freeswitch.org
> > http://www.cluecon.com
> >
> > FreeSWITCH-users mailing list
> > FreeSWITCH-users at lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> >
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121103/38443b79/attachment.html