Hi Kevin,
for the files we have today I agree this should not be a concern... in the
future, nobody
knows what new modules might need.
A bit concerned about the table size limits, Oracle might have issues with
creating a table
that is too large without falling back on blobs (which are often stored
outside of the table record).
Why can't we use blob and provide a stream? Just because it's more complex?
Or we would not be able to use streams with blobs regardless?
Cheers
Andrea
On Wed, Apr 30, 2014 at 6:46 PM, Kevin Smith <ksm...@boundlessgeo.com>wrote:
> I've been considering how to store the content of resources for a JDBC
> backed implementation of the new ResourceStore API.
>
> It comes down to BLOB vs BINARY/bytea. On the database side, both H2 and
> Postgres support large enough in table types that BLOBs should not be
> needed and add complexity. Both DBMS's drivers (at least the versions
> we're using) however require loading the entire content into memory at once
> rather than streaming. This should be brief before the content is cached
> to disk and most individual resources are fairly small.
>
> Some styling resources like large TTFs or images might go as large as a
> few megabytes but the goal is not to store any geodata.
>
> --
>
> Kevin Smith
>
> Junior Software Engineer | Boundless
>
> ksm...@boundlessgeo.com
>
> +1-778-785-7459
>
> @boundlessgeo <https://twitter.com/boundlessgeo>
>
>
> ------------------------------------------------------------------------------
> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> Instantly run your Selenium tests across 300+ browser/OS combos. Get
> unparalleled scalability from the best Selenium testing platform available.
> Simple to use. Nothing to install. Get started now for free."
> http://p.sf.net/sfu/SauceLabs
> _______________________________________________
> Geoserver-devel mailing list
> Geoserver-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>
>
--
==
Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
for more information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos. Get
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
