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

Mon Nov 5 05:37:35 MSK 2012

I do not know Postgres (and maybe it is a good chance to try it) but
probably there is a penalty with Postgres as well
It is just that OpenSIPs goes very well with FreeSWITCH (at least for us)
and OpenSIPs use mysql as its primary db
Therefore using one DB for both makes a lot of sense for us
BTW, I did not get an answer for posting the Germany number that we added
for the conference, do you want it or should I return it to our poll?

Thanks,
Yiftach.

On Sun, Nov 4, 2012 at 7:07 AM, Ken Rice <krice at freeswitch.org> wrote:

>  Oh yeah, lets let 1 thread run at a time access the database... Mysql is
> the only one that shows this issue... So why should we cripple the DB
> interfaces for just mysql
>
>
>
> On 11/3/12 10:59 PM, "Yiftach Golan" <yiftah at choochee.com> wrote:
>
> 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 <http://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 <
> mailto:MSN%3Aanthony_minessale at hotmail.com<MSN%3Aanthony_minessale at hotmail.com>>
>
> > GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com <
> mailto:PAYPAL%3Aanthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>>
>
> > IRC: irc.freenode.net <http://irc.freenode.net>  #freeswitch
> >
> > FreeSWITCH Developer Conference
> > sip:888 at conference.freeswitch.org <
> mailto:sip%3A888 at conference.freeswitch.org<sip%3A888 at conference.freeswitch.org>>
>
> > googletalk:conf+888 at conference.freeswitch.org <
> mailto:googletalk%3Aconf%2B888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>>
>
> > pstn:+19193869900 <tel:%2B19193869900>
> >
> > _________________________________________________________________________
> > 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
>
>
>
> ------------------------------
> _________________________________________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121104/681b8056/attachment-0001.html 