just wanted to point out the size increase. personally i can also live with the full monty, native spatialite libs for all platforms in PLUS! other GIS are 200MB in size and popular nonetheless!
..ede On 25.12.2013 16:39, Rahkonen Jukka wrote: > 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 > ------------------------------------------------------------------------------ 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
