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@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@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@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@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@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@gundy.org> wrote:
>>
>> > On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004
>> > <curriegrad2004@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@freeswitch.org
>> > http://www.freeswitchsolutions.com
>> >
>> > FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>> > http://www.cudatel.com
>> >
>> > Official FreeSWITCH Sites
>> > http://www.freeswitch.org
>> > http://wiki.freeswitch.org
>> > http://www.cluecon.com
>> >
>> > FreeSWITCH-users mailing list
>> > FreeSWITCH-users@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@freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>> http://www.cudatel.com
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users@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@hotmail.com <mailto:MSN%3Aanthony_minessale@hotmail.com>
> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com <mailto:PAYPAL%3Aanthony.minessale@gmail.com>
> IRC: irc.freenode.net <http://irc.freenode.net>  #freeswitch
>
> FreeSWITCH Developer Conference
> sip:888@conference.freeswitch.org <mailto:sip%3A888@conference.freeswitch.org>
> googletalk:conf+888@conference.freeswitch.org <mailto:googletalk%3Aconf%2B888@conference.freeswitch.org>
> pstn:+19193869900 <tel:%2B19193869900>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting@freeswitch.org
> http://www.freeswitchsolutions.com
>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
> http://www.cudatel.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org