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<MSN%3Aanthony_minessale@hotmail.com>>
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com < mailto:PAYPAL%3Aanthony.minessale@gmail.com<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<sip%3A888@conference.freeswitch.org>>
googletalk:conf+888@conference.freeswitch.org < mailto:googletalk%3Aconf%2B888@conference.freeswitch.org<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