[sr-dev] git:pd/crocodile: srdb1, modules_k/xcap_server: Added support for XML documents larger than 64k in MySQL

[Peter Dunkley]

Hi,

The previous check-in on the branch
(5cd87175faa97161023c37e2cc0f0c064e08d571) made the SQL buffer size
configurable for all DBs.

This change:
- makes the MySQL table definition use MEDIUMBLOB (up to 16M) where
previously it was a BLOB (up to 64k)
- increases the size of an internal buffer in xcap_server

The PostgreSQL table definition already uses BYTEA which does not appear
to have a maximum size limit.  As such, the combination of the previous
commit and this change to xcap_server means you can store bigger
documents with PostgreSQL.  This PostgreSQL usage has been tested here
at Crocodile.

Peter

On Wed, 2011-07-27 at 14:05 +0200, Klaus Darilion wrote:

> 
> Am 27.07.2011 13:16, schrieb Peter Dunkley:
> > Module: sip-router
> > Branch: pd/crocodile
> > Commit: 6033da2e644ccdca7fa57bee03f82cb03c36e45e
> > URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6033da2e644ccdca7fa57bee03f82cb03c36e45e
> > 
> > Author: pd <peter.dunkley at crocodile-rcs.com>
> > Committer: pd <peter.dunkley at crocodile-rcs.com>
> > Date:   Wed Jul 27 12:13:25 2011 +0100
> > 
> > srdb1, modules_k/xcap_server: Added support for XML documents larger than 64k in MySQL
> 
> Can this be done for postgresql too?
> 
> regards
> klaus
> 
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev


-- 
Peter Dunkley
Technical Director
Crocodile RCS Ltd
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20110727/16354cb9/attachment.htm>