This discussion is archived
2 Replies Latest reply: May 29, 2012 1:18 PM by user603925 RSS

Berkeley DB supporting SpatiaLite

user603925 Newbie
Currently Being Moderated
Can Berkeley DB 11gR2 make use of SpatiaLite, an extension for SQLite to store and process geospatial data?
Are there any whitepapers, articles, OBEs available for this?
Many thanks in advance,
Karin
  • 1. Re: Berkeley DB supporting SpatiaLite
    Oracle, Sandra Whitman Journeyer
    Currently Being Moderated
    Hello,

    Our general recommendation for SpatiaLite (or any other product layered on top of SQLite) is to try it. BDB is SQLite API compatible, so it should work. We don't have any documentation or white papers on the topic, but third party products that work with SQLite using the standard SQLite API should work with BDB 11gR2. When you try this out, please let us know the results.

    Thanks,
    Sandra
  • 2. Re: Berkeley DB supporting SpatiaLite
    user603925 Newbie
    Currently Being Moderated
    Sandra,

    Here is an update on my own question.
    I´ve tried it out for BDB 11.2 using SQL API and it worked fine.
    Here is what I´ve done:
    - Downloaded Spatialite from https://www.gaia-gis.it/fossil/libspatialite/index
    - Unzipped and copied necessary binaries and DLLs into BDB installation (bin,include,lib)
    - Downloaded SQLite3 sample db from http://www.gaia-gis.it/spatialite-2.3.0/resources.html
    - Used SQLite3 to export sample db with sqlite>. dump...
    - Started BDB SQL API
    - Spatialite libraries loaded with dbsql>.load 'libspatialite-2.dll'
    - Import of exported sample db with dbsql>.read...
    - Tests of Spatialite extension using tutorial http://www.gaia-gis.it/gaia-sins/spatialite-tutorial-2.3.1.html
    First test results are the same for SQLite3+Spatialite and BDB+Spatialite.
    (Full test to be finished after my vacation in April)

    Karin

    Edited by: user603925 on 29.05.2012 13:18

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points