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
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 #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
> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
> IRC: irc.freenode.net #freeswitch
>
> FreeSWITCH Developer Conference
> sip:888@conference.freeswitch.org
> googletalk:conf+888@conference.freeswitch.org
> pstn:+19193869900
>
> _________________________________________________________________________
> 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