Hi, I understand the problems with dlls. However, DB Query Plugin in the basic SQLite mode does not need them. All it needs is the JDBC driver (sqlite-jdbc-3.7.15-SNAPSHOT.jar) which does contain native code but it is all packed inside the jar. Perhaps that would suit better for the OJ Plus version.
-Jukka Rahkonen- Michaël Michaud wrote: > Hi, > Just a side note about OpenJUMP + personnal database : > I'm sure that SQLite database has great qualities and can add > great capabilities to OpenJUMP, but I've always been reluctant > to introduce dll into OpenJUMP distribution (difficulty to keep > it multiplatform, lack of visibility on C code due to my ignorance, > code duplication to achieve the same goal like JTS/Geos in this > case...) > For these reasons, good or bad, I'd be much more enthousiast > to integrate java projects like h2 database (a small java database > which can be used both as an embeded database or as a server), > hatbox (a spatial index for h2 which works a bit like the one of > spatialite (as far as I know), Jaspa (a project adding to all ST_xxx > geometry functions to h2). Unfortunately, there is still some work > to integrate such projects into OpenJUMP and my time and my > skill are too limited for that. > Just wanted to share this thought, but I admit that Spatialite is > a mature project which can add nice capabilities with a smaller > effort. My 2 cents, Michaël >> Hi, >> >> Not really, Spatialite is a spatial extension for SQLite database engine and >> it does not work with other databases. > >> However, this is not the whole truth and it is indeed possible to use SQLite >> and Spatialite functions for handling external data that is not stored into >> the SQLite data file at all. SQLite has some magic system called "virtual >> table" which makes it possible to connect a CSV file or Excel spreadsheet >> virtually from SQLite database without importing data. When this connection >> is made it is possible to do SQL queries agains the native files as they >> were real database tables. Of course this connection is not optimal when it >> comes to speed. > GDAL can also utilise SQLite and Spatialite as a database engine. For > example, it is possible to do a spatial query against a shapefile (or any > other format which is supported by GDAL/OGR) as in this example from the > document http://www.gdal.org/ogr/ogr_sql_sqlite.html > SELECT EAS_ID, ST_Area(GEOMETRY) AS area FROM poly WHERE > ST_Intersects(GEOMETRY, BuildCircleMbr(479750.6875,4764702.0,100)) > >> I don't know how easy or difficult it would be to utilise those advanced >> features and tricks from Java and OpenJUMP. However, there are many >> interesting things to do with plain SQL by considering Spatialite just as a >> zero-configuration relational database http://sqlite.org/zeroconf.html > > -Jukka. > ________________________________________ > Lähettäjä: edgar.sol...@web.de [edgar.sol...@web.de] > Lähetetty: 8. huhtikuuta 2013 17:59 > Vastaanottaja: OpenJump develop and use > Aihe: Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions. > > well, done.. thanks. will definitely put that into my queue! one question > still: > do i understand correctly that spatiallite extensions will pretty much work > with any database connection? e.g. postgis, mysql as well? > > ..ede > > > On 08.04.2013 16:38, Rahkonen Jukka wrote: >> Hi, >> >> Well, I made a test database from Hamburg and wrote a short manual about >> installing and testing >> http://latuviitta.org/documents/OpenJUMP_Spatialite_test_manual.pdf >> >> >> -Jukka- >> >> Jukka Rahkonen wrote: >> >>> edgar Soldin wrote: >>> >>>> ok, this sounds too difficult for a last minute inclusion. but we can >>>> start on integrating over the course of the next months. >>>> can you give me a data test set and/or step by step instructions how >>>> it is supposed to work? spatiallite input and spatiallite functions, >>>> which seems to be something different? >>> I can make a test database for you from the OpenStreetMap data. What part >>> of Germany would you like to play with? Select from here >>> http://download.geofabrik.de/europe/germany.html >>> >>> -Jukka- >>> >>> >>> ------------------------------------------------------------------------------ >>> Minimize network downtime and maximize team effectiveness. >>> Reduce network management and security costs.Learn how to hire the most >>> talented Cisco Certified professionals. Visit the Employer Resources Portal >>> http://www.cisco.com/web/learning/employer_resources/index.html >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> Jump-pilot-devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> ------------------------------------------------------------------------------ >> Minimize network downtime and maximize team effectiveness. >> Reduce network management and security costs.Learn how to hire >> the most talented Cisco Certified professionals. Visit the >> Employer Resources Portal >> http://www.cisco.com/web/learning/employer_resources/index.html >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> > ------------------------------------------------------------------------------ > Minimize network downtime and maximize team effectiveness. > Reduce network management and security costs.Learn how to hire > the most talented Cisco Certified professionals. Visit the > Employer Resources Portal > http://www.cisco.com/web/learning/employer_resources/index.html > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ > Minimize network downtime and maximize team effectiveness. > Reduce network management and security costs.Learn how to hire > the most talented Cisco Certified professionals. Visit the > Employer Resources Portal > http://www.cisco.com/web/learning/employer_resources/index.html > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html _______________________________________________ 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
