Hi, > On 09.04.2013 16:01, Rahkonen Jukka wrote: >> edgar soldin wrote: >>> On 09.04.2013 15:33, Rahkonen Jukka wrote: >>>>>> 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? >>>> Myself I will for sure use Spatialite extension with Larry's plugin but I >>> consider that the plugin is pretty good as it is and I would not like to >>> pollute it >>> much with extra decorations. >>> >>> Jukka: did you ever use the mentioned sqlite/spatialite plugin? is there >>> such >>> a thing? >> I suppose it is this one; I have been reading about it ;) >> http://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=OpenJUMP_with_SpatialLite#Using_SpatiaLite_with_Spatialite_Reader_Plugin >> >> Michaël has touched the plugin code a bit lately and it is almost working >> again. It has some nice features like the possibility to test the query in a >> table view and function list and syntax help. On my computer it is suffering >> from the same "Unknown WKB type 0" problem with multigeometries. The plugin >> looks nice but is not as robust as DB Query plugin and it does not handle >> empty geometries and sometimes it is very slow. It is a good model for >> another approach. >> > question to all then > > so what'd you suggest. rather > > 1. make sqlite plugin autoload spatiallite.dll and/or gdal (if possible) btw. > who wrote this plugin? > 2. allow the same for dbquery (it'd actually autoload if available and > visually hint the non-/support) > 3. don't do nothing, other topics more important :) I'm not a expert as Jukka in this area, but it seems that with its last addition (loading of spatialite spatial function), dbquery now includes dbquery capabilities and extend it (with other db access). Moreover, it has an active maintener (Larry Reeder), which is a big +. -> I would vote for working on DB Query PlugIn rather than dbquery
About 1.6 releasing, I would vote for DB Query PlugIn addition without dll in 1.6 (as asked by Jukka), and to take more time for integration of spatial function (which is probably more complex). If a clean integration of DB Query PlugIn + dll is possible soon, we'll make it available as an external plugin, or in the next PLUS release. My 2 cents, Michaël > > ..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 > > ------------------------------------------------------------------------------ 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
