current PLUS is 43MB.. an extra 9MB would make it 20% bigger, that is quite something!
what would be the drawback if we do not deliver the native libraries? Larry: will you integrate the sqlite-jdbc-*.jar into your extensions distro? how about creating a package like the one for gdal, that people can download and extract into their OJ folder? ..ede On 25.12.2013 16:01, Rahkonen Jukka wrote: > Hi, > > Why not to offer a really cutting edge Spatialite support with OpenJUMP? > Dowload sizes are not at all huge > > - jts 1.4 snapshot - no extra > - sqlite-jdbc-3.8.0-20130827.035027-1.jar - 3.5 MB > - spatialite-4.2.0-test-win-x86 (native Spatialite dlls for Win-32) 2.5 MB > zipped > - spatialite-4.2.0-test-win-amd64 (native Spatialite dlls for Win-32) 2.6 MB > zipped > > All these are not offially available with any other GIS program so we could > stand on a peak for a while. Packages take only 9 MB extra space when zipped > and under 40 MB after unzipping the dll files. I have made tests with 32-bit > and 64-bit Windows. Both the pure java blob reading and advanced Spatialite > stuff seems to work OK. For testing with spatialite dlls I placed the all the > dll files into lib\ext and added the following string into spatialite > connection > ?spatialite=spatialite.dll > > Ede may know how to install the native 32/64 bit stuff so that right version > will be selected and that the spatialite.dll finds right versions of the > dependencies. > > About real spatialite support for Linux and Mac, I have no idea about how to > do that. It looks like 80% of OJ downloads are for Windows so perhaps it > would be acceptable to support only Windows at first. The download links for > the Windows binaries can be found from document > http://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/java.html > > I guess that there will be stable packages soon but today the download links > are > http://www.gaia-gis.it/gaia-sins/spatialite-4.2.0-test-win-x86.7z > http://www.gaia-gis.it/gaia-sins/spatialite-4.2.0-test-win-amd64.7z > > The speed is really good. On a 64-bit laptop the direct blob reader gets > 500000 OpenStreetMap multipolygons in 4 seconds, and reading the same > polygons reprojected to other SRS with Spatialite binaries takes 34 seconds. > > -Jukka- > > ________________________________________ > Lähettäjä: edgar.sol...@web.de [edgar.sol...@web.de] > Lähetetty: 25. joulukuuta 2013 12:25 > Vastaanottaja: OpenJump develop and use > Aihe: Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS > > Jukka & all, > > would you like to see the SQLite jdbc driver part of DBQuery extension or > rather download it separately for sake of small distro size? > > ..ede > > On 24.12.2013 23:37, Rahkonen Jukka wrote: >> Hi, >> >> To be best compatible with the next version of Spatialite native binaries it >> would be good to use a jdbc driver for SQLite version 3.8. A snapshot is >> available at >> https://oss.sonatype.org/content/repositories/snapshots/org/xerial/sqlite-jdbc/3.8.0-SNAPSHOT/sqlite-jdbc-3.8.0-20130827.035027-1.jar >> >> SQlite 3.7.x will work fine for direct reading of Spatialite blobs but 3.8.x >> version is needed for loading the next version of Spatialite as an extension. >> http://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/java.html >> >> -Jukka Rahkonen- >> ________________________________________ >> edgar soldin wrote: >> >>> i would make including sqlite jar depending on how your extension handles >>> it. meaning, we actually package your extension, so if it is included in >>> there it'll end up in OJ, if not you hopefully have it documented in a >>> readme or such ;) >> >> ..ede >> >> On 24.12.2013 16:33, Larry Reeder wrote: >>> Hey Ede, >>> >>> I tested with OpenJUMP-20131224-r3854-PLUS (jar installer, installing on >>> Linux), and it didn't work initially due to missing sqlite JDBC jars. I >>> added the jdbc jar to the classpath (put it in lib/ext/jumpdbquery-0.9.0) >>> and multigeometries worked great. If you want to add SQLite JDBC drivers >>> to the OpenJump package, you can download them here: >>> https://bitbucket.org/xerial/sqlite-jdbc/downloads. Alternatively, the >>> maven pom dependency entry is: >>> >>> <dependencies> >>> <dependency> >>> <groupId>org.xerial</groupId> >>> <artifactId>sqlite-jdbc</artifactId> >>> <version>3.7.2</version> >>> </dependency> >>> </dependencies> >>> >>> >>> >>> I tested on Linux with both sqlite-jdbc-3.7.2.jar and the more recent >>> sqlite-jdbc-3.7.15-M1.jar. >>> >>> I think we discussed this previously, but theSQLite jars are Apache 2.0 >>> licensed, so should be suitable for repackaging with OpenJump. >>> >>> Thanks........... lreeder >>> >>> >>> On Tue, Dec 24, 2013 at 3:23 AM, <edgar.sol...@web.de >>> <mailto:edgar.sol...@web.de>> wrote: >>> >>> Larry, Jukka, >>> >>> i just committed jts 1.14 snapshot to OJ trunk. could one of you please >>> check if the spatialite multigeometry bug has vanished finally? >>> >>> happy holidays.. ede >>> >>> >>> On 23.12.2013 04 <tel:23.12.2013%2004>:40, Martin Davis wrote: >>> > Thanks, Larry. Patch is commited. >>> > >>> > Martin >>> > >>> > >>> > On Sun, Dec 22, 2013 at 9:22 AM, Larry Reeder <lnree...@gmail.com >>> <mailto:lnree...@gmail.com> <mailto:lnree...@gmail.com >>> <mailto:lnree...@gmail.com>>> wrote: >>> > >>> > Martin, I've attached a patch for WKBReader that uses the >>> initial endian flag for multigeometries and ignores the flag for contained >>> geometries if the endianness flag is something besides the XDR/NDR flags. >>> The patch also includes a test case that use multigeometries exported from >>> the Spatialite internal BLOB format. >>> > >>> > The patch was made against a recent checkout of JTS 1.14 from the >>> Sourceforge SVN. Can you apply to the JTS trunk? Let me know if you'd >>> like me to submit it in some other way. >>> > >>> > Thanks........... lreeder >>> > >>> > >>> > >>> > >>> > On Mon, Dec 2, 2013 at 4:12 PM, Martin Davis <mtncl...@gmail.com >>> <mailto:mtncl...@gmail.com> <mailto:mtncl...@gmail.com >>> <mailto:mtncl...@gmail.com>>> wrote: >>> > >>> > That strategy still makes sense to me. >>> > >>> > M >>> > >>> > >>> > On Mon, Dec 2, 2013 at 2:51 PM, Larry Reeder >>> <lnree...@gmail.com <mailto:lnree...@gmail.com> <mailto:lnree...@gmail.com >>> <mailto:lnree...@gmail.com>>> wrote: >>> > >>> > Now that cold is here, I've got more time to stay >>> indoors and code. I'm willing to submit a JTS patch with sample data and >>> unit tests. >>> > >>> > Martin, in implementing the patch, I will be following >>> the guidance in your suggestion on April 21, 2013: >>> > >>> > " The WKBReader can be changed to only switch endianess >>> when >>> > the code is one of the two specified in the standard (0 = >>> BigEndian, 1 = >>> > LittleEndian). If any other code is read then the >>> endianess will be left >>> > unchanged. That should handle the SpatialLite BLOB >>> format, right? And >>> > it avoids any explicit dependency on magic numbers from >>> SpatialLite. >>> > And it still allows switching endianness mid-WKB, as per >>> the standard, >>> > should anyone be so perverse as to do that." >>> > >>> > Let me know if you see any problems there. >>> > >>> > Thanks........... lreeder >>> > >>> > >>> > On Mon, Dec 2, 2013 at 3:39 PM, Martin Davis >>> <mtncl...@gmail.com <mailto:mtncl...@gmail.com> <mailto:mtncl...@gmail.com >>> <mailto:mtncl...@gmail.com>>> wrote: >>> > >>> > I have very little time to look at this by year-end, >>> I'm afraid. >>> > >>> > Did someone have code to commit for fixing this? >>> (with sample data for unit tests) ? >>> > >>> > >>> > >>> > >>> > On Mon, Dec 2, 2013 at 1:30 PM, <edgar.sol...@web.de >>> <mailto:edgar.sol...@web.de> <mailto:edgar.sol...@web.de >>> <mailto:edgar.sol...@web.de>>> wrote: >>> > >>> > On 02.12.2013 22:11, Rahkonen Jukka wrote: >>> > > Hi, >>> > > >>> > > We have many exciting new features and I >>> suppose we will have a great new OpenJUMP 1.7 rather soon. It would be >>> excellent to have a well working Spatialite support in OJ 1.7 Plus through >>> DB Query plugin, but the issue with reading multigeometries remains [1]. >>> Martin almost promised to make a fix into JTS [2] but I do not see such a >>> commit in the JTS code [3]. The best I can hope to happen is to get the fix >>> into the new BSD/EPL licensed JTS release [4] but perhaps Martin is busy >>> with other things and that will not happen. >>> > > >>> > > Do we have other alternatives for making the DB >>> Query plugin to work well with Spatialite on current OJ than flipping in >>> the old JTS version when Spatialite support is on a wishlist? Taking an old >>> jts-1.12.jar and renaming it into jts-1.13.jar makes the plugin happy but >>> probably breaks some cool new stuff and is thus a poor workaround. >>> > > >>> > > [1] >>> http://sourceforge.net/p/jts-topo-suite/bugs/36/ >>> > > [2] >>> http://sourceforge.net/p/jts-topo-suite/mailman/message/31118630/ >>> > > [3] >>> http://sourceforge.net/p/jts-topo-suite/code/commit_browser >>> > > [4] >>> http://sourceforge.net/p/jts-topo-suite/mailman/message/31422827/ >>> > > >>> > >>> > i already proposed an alternative, >>> > >>> http://comments.gmane.org/gmane.comp.java.jts.topo-suite.user/6 >>> > >>> > but Larry wanted to wait for Martin.. >>> > @Larry, Martin: what's your take on this nearing >>> the end of this year? >>> > >>> > ..ede >>> > >>> > >>> > >>> > >>> > >>> > >>> >>> >>> ------------------------------------------------------------------------------ >>> Rapidly troubleshoot problems before they affect your business. Most IT >>> organizations don't have a clear picture of how application performance >>> affects their revenue. With AppDynamics, you get 100% visibility into >>> your >>> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of >>> AppDynamics Pro! >>> >>> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> Jump-pilot-devel@lists.sourceforge.net >>> <mailto:Jump-pilot-devel@lists.sourceforge.net> >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>> >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Rapidly troubleshoot problems before they affect your business. Most IT >>> organizations don't have a clear picture of how application performance >>> affects their revenue. With AppDynamics, you get 100% visibility into your >>> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics >>> Pro! >>> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk >>> >>> >>> >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> Jump-pilot-devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>> >> >> ------------------------------------------------------------------------------ >> Rapidly troubleshoot problems before they affect your business. Most IT >> organizations don't have a clear picture of how application performance >> affects their revenue. With AppDynamics, you get 100% visibility into your >> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics >> Pro! >> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> >> ------------------------------------------------------------------------------ >> Rapidly troubleshoot problems before they affect your business. Most IT >> organizations don't have a clear picture of how application performance >> affects their revenue. With AppDynamics, you get 100% visibility into your >> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics >> Pro! >> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> > > ------------------------------------------------------------------------------ > Rapidly troubleshoot problems before they affect your business. Most IT > organizations don't have a clear picture of how application performance > affects their revenue. With AppDynamics, you get 100% visibility into your > Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ > Rapidly troubleshoot problems before they affect your business. Most IT > organizations don't have a clear picture of how application performance > affects their revenue. With AppDynamics, you get 100% visibility into your > Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
