On 09.04.2013 05:32, Larry Reeder wrote: > > > > On Mon, Apr 8, 2013 at 1:03 PM, <edgar.sol...@web.de > <mailto:edgar.sol...@web.de>> wrote: > > On 08.04.2013 20:48, Michaël Michaud wrote: > > Just wanted to share this thought, but I admit that Spatialite is > > a mature project which can add nice capabilities with a smaller > > effort. > > ok, as far as i understand for now. DBQuery is working and in use. it > uses native libs, but on the other hand we will probably not get this > functionality going java only. > so, let's polish up native libs and DBQuery and consider to add it to > PLUS after 1.6.0. > > > One clarification: my plugin doesn't directly load native libraries. It > uses the sqlite JDBC libraries, which handle the loading spatialite and other > sqllite extensions.
what about the mysql, oracle, postgis support .. doesn't it need native libs for these? >I also share some of the same concerns that Michaël mentioned, and think that >adding native libraries introduces risk and complexity: > > 1. A bug in the native libraries can cause the JVM to crash, taking down OJ > in the process (not just a stack trace but an outright crash. can happen > 2. When done right, Java is write once, run everywhere. With native libs, > you have to provide a library version for each platform you are deploying to: > Windows 32bit/64bit, Linux 32/64, Mac OSX PowerPC/Intel, etc. well, yes and no. mostly yes, but lot's of specific quirks (starting the app, different implementations of system api functions) and let's not forget the classic *Whoops* the new jre has a bug that the old one hadn't . > 3. Regarding the spatialite lib, you not only need to include the correct > version of that, but the correct versions of everything it depends on, > including proj, geos, sqlite, and others. of course. still the functionality is there, so why not leverage it? > 4. Adding all these libs would reproduce in native code much of what OJ > already does in Java. yes, it would blow up PLUS significantly. question is how much. i would make it depending on that. > > Larry: would you be willing to accept patches on the regard above? would > be a good opportunity to reuse a native lib loader that i created for the > RXTX using gps extension originally. > > > Ede, I'm always open to new patches, I just don't think a native lib loader > is needed due to SQLite JDBC handling the loading. what about the other db's mentioned above? also it would ease the use of spatiallite as it could be found automagically and would not have to be specified in the url. same would go for users deciding they wanted to use the gdal lib support together with sqlite. also, i'd anyway like to enhance the support for loading native code in OJ core. something along the lines that you just have to put it in lib/native/<os>/<version>/<arch> or above if it works over several os versions and the setting up of native lib paths goes away. > Finally, the main purpose of the DBQuery plugin is to provide a bridge > between OJ and spatial databases that it might not support (if any now), as > well as provide a way to submit ad-hoc queries that don't have or need > backing tables to return features. While I'm glad my recent changes make it > more useful for spatialite users, adding all the native libs to support > spatialite would weigh it very heavily toward the spatialite side. If the > main goal is to improve spatialite, perhaps a better approach is to build up > the current sqlite/spatialite plugin to do so? i am no user, so i'd ask jukka. what do you think is the better starting point here? ..ede ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
