[gdal-dev] Berkeley DB OGR "driver"

[Jeff McKenna]

On 2013-03-14 10:03 AM, Ivan Lucena wrote:
> Hi Jeff,
> 
> Yes, once we figure out how to deal with the driver name issue I will
> write instruction to the GDAL Wiki.
> 
> But I am curious. How do use BDB on MapServer/MapCache? Do you use the
> SQLITE API or goes directly to the DBD API?
> 
> How do you compare BDB to SQLITE in terms of performance and functionality?

Hi Ivan,

I'm not the developer of MapCache so I can't fully answer your questions
(but maybe others lurking on this list can). Or we can switch this/your
exact questions to the MapServer-dev list.

For me on the Windows compile side of things, I am able to point to
SQLITE libs for sqlite tile output support for MapCache, or BDB libs for
BDB tile output support for MapCache.  I'm not aware of the magic in how
that happens, you'll have to discuss this more on MapServer-dev.

In terms of performance, I notice both are very fast (maybe BDB
faster?), I don't have exact numbers.  I believe SQLITE is limited to
2TB in size, and maybe BDB is not?  I can't remember this issue/rule.
BDB support in MapCache is still pretty new/most are not using this yet
I feel.

I did find and file an issue where BerkeleyDB tile caches created
through MapCache cannot be opened with the BDB dbsql.exe utility
(https://github.com/mapserver/mapcache/issues/58), but that is
unanswered.  The support for BDB is still very new.

-jeff




-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/