Hi, That is true. How about including only the jdbc driver, it is 3.5 MB, serves all platforms and it is enough for doing the basic spatialite blob reading which is also the unique feature in DB Query? I fear that if users would need to do several downloads from different places before running a plugin, they won't do it. At least before we have some kind of plugin manager tool.
-Jukka Rahkonen- ________________________________________ Edgar Soldin wrote: > 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 ------------------------------------------------------------------------------ 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
