Extending the field size of core's db_data table?
Hello, We use the DB api for storing and caching various data. We need to store data that is longer than 255 characters, which is the current limit on the field size there. The backend for this API is MySQL (via ODBC). Can I just increase the field size in MySQL, or is there some dependency in FreeSwitch on this size? Thanks, __Yehavi:
I would send this to the -dev list. -MC On Mon, Dec 19, 2011 at 10:35 PM, Yehavi Bourvine <yehavi.bourvine@gmail.com
wrote:
Hello,
We use the DB api for storing and caching various data. We need to store data that is longer than 255 characters, which is the current limit on the field size there.
The backend for this API is MySQL (via ODBC). Can I just increase the field size in MySQL, or is there some dependency in FreeSwitch on this size?
Thanks, __Yehavi:
_________________________________________________________________________ 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
I think you could just ALTER TABLE ... or re-create the table maybe sqlite doesn't support alter table? -- About: http://about.me/dujinfang Blog: http://www.dujinfang.com Proj: http://www.freeswitch.org.cn Sent with Sparrow (http://www.sparrowmailapp.com) On Tuesday, December 20, 2011 at 2:35 PM, Yehavi Bourvine wrote:
Hello,
We use the DB api for storing and caching various data. We need to store data that is longer than 255 characters, which is the current limit on the field size there.
The backend for this API is MySQL (via ODBC). Can I just increase the field size in MySQL, or is there some dependency in FreeSwitch on this size?
Thanks, __Yehavi:
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org (mailto: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 (mailto: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
I know I can do ALTER TABLE, but I've asked what is the implication about FreeSWITCH software. Anyway, I managed to bypass the problem by other means. Thanks, __Yehavi: 2012/1/29 Seven Du <dujinfang@gmail.com>
I think you could just ALTER TABLE ... or re-create the table maybe sqlite doesn't support alter table?
-- About: http://about.me/dujinfang Blog: http://www.dujinfang.com Proj: http://www.freeswitch.org.cn
Sent with Sparrow <http://www.sparrowmailapp.com>
On Tuesday, December 20, 2011 at 2:35 PM, Yehavi Bourvine wrote:
Hello,
We use the DB api for storing and caching various data. We need to store data that is longer than 255 characters, which is the current limit on the field size there.
The backend for this API is MySQL (via ODBC). Can I just increase the field size in MySQL, or is there some dependency in FreeSwitch on this size?
Thanks, __Yehavi:
_________________________________________________________________________ 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
I have not audited the code in that app, but easiest way to tell for sure is to just give it a try, I suspect there is no built in limit, but if you find one, let us know. MIke On Jan 29, 2012, at 6:56 AM, Yehavi Bourvine wrote:
I know I can do ALTER TABLE, but I've asked what is the implication about FreeSWITCH software.
Anyway, I managed to bypass the problem by other means.
Thanks, __Yehavi:
2012/1/29 Seven Du <dujinfang@gmail.com> I think you could just ALTER TABLE ... or re-create the table maybe sqlite doesn't support alter table? On Tuesday, December 20, 2011 at 2:35 PM, Yehavi Bourvine wrote:
Hello,
We use the DB api for storing and caching various data. We need to store data that is longer than 255 characters, which is the current limit on the field size there.
The backend for this API is MySQL (via ODBC). Can I just increase the field size in MySQL, or is there some dependency in FreeSwitch on this size?
Thanks, __Yehavi:
you can probably safely change it to a TEXT field. SQLite ignores col lens internally so it only matters to your db of choice. On Mon, Jan 30, 2012 at 4:15 PM, Michael Jerris <mike@jerris.com> wrote:
I have not audited the code in that app, but easiest way to tell for sure is to just give it a try, I suspect there is no built in limit, but if you find one, let us know.
MIke
On Jan 29, 2012, at 6:56 AM, Yehavi Bourvine wrote:
I know I can do ALTER TABLE, but I've asked what is the implication about FreeSWITCH software.
Anyway, I managed to bypass the problem by other means.
Thanks, __Yehavi:
2012/1/29 Seven Du <dujinfang@gmail.com>
I think you could just ALTER TABLE ... or re-create the table maybe sqlite doesn't support alter table? On Tuesday, December 20, 2011 at 2:35 PM, Yehavi Bourvine wrote:
Hello,
We use the DB api for storing and caching various data. We need to store data that is longer than 255 characters, which is the current limit on the field size there.
The backend for this API is MySQL (via ODBC). Can I just increase the field size in MySQL, or is there some dependency in FreeSwitch on this size?
Thanks, __Yehavi:
_________________________________________________________________________ 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
participants (5)
-
Anthony Minessale
-
Michael Collins
-
Michael Jerris
-
Seven Du
-
Yehavi Bourvine