Thanks for this link, Paolo - I've been wondering if there's a JDBC driver for Sqllite.
Are there any issues with using this driver with SpatialLite? Or is SpatialLite 100% transparent from the driver point of view? In general this seems like a nice way to go. Even nicer IMHO would be a pure Java DB like H2. But someone needs to step to "spatializing" H2 for this to be appealing for OJ. Probably a similar approach to SpatialLite can be taken here, except for one thing - H2 doesn't have an Rtree index. Ultimately it would be nice to see the spatial datatype more fully integrated in H2, like it is in PostGIS. That's my dream, anyway... P.Rizzi Ag.Mobilità Ambiente wrote: > Good idea!!! > > I see there's even a JDBC driver for it: > http://www.zentus.com/sqlitejdbc/ > > so I may take a look at it, but even if I can add SQLite support to the SISDB > plugin, > it will be read-only like any other OJ DataStore. > > But the great thing would be the adoption of a light DB, such as > SQLite/SpatialLight, > as the "native" file storage/exchange system of OpenJump!!! > > Bye > Paolo Rizzi > > > ________________________________ > > Da: Rahkonen Jukka [mailto:jukka.rahko...@mmmtike.fi] > Inviato: ven 09/01/2009 14.09 > A: OpenJump develop and use > Oggetto: [JPP-Devel] (no subject) > > > > Hi, > > Sooner or later all data do not fit in the memory and OpenJUMP user has > troubles. Having PostGIS or Oracle datastore solves size limits, but OJ > does not support updates well. In addition, many people seem to fear > PostGIS, and for sure it is a bit heavy weight pair for OpenJUMP which > is very simple to install and run. How about trying some leight weight > spatial database as well? It took 2 minutes for the first timer to > download, install and launch the SpatiaLite database on a Windows > machine. No admisnistrator rights are needed, and when installed it is > just one single 3 MB exe file on a disk! Perhaps some developer could > have a look and say if it could be useful with OpenJUMP? SpatiaLite > seems to include Proj4, so is could give OpenJUMP support for > projections as well. See: > > http://www.gaia-gis.it/spatialite-2.2/index.html > > Regards, > > -Jukka Rahkonen- > > ------------------------------------------------------------------------------ > Check out the new SourceForge.net Marketplace. > It is the best place to buy or sell services for > just about anything Open Source. > http://p.sf.net/sfu/Xq1LFB > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > Check out the new SourceForge.net Marketplace. > It is the best place to buy or sell services for > just about anything Open Source. > http://p.sf.net/sfu/Xq1LFB > ------------------------------------------------------------------------ > > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > -- Martin Davis Senior Technical Architect Refractions Research, Inc. (250) 383-3022 ------------------------------------------------------------------------------ Check out the new SourceForge.net Marketplace. It is the best place to buy or sell services for just about anything Open Source. http://p.sf.net/sfu/Xq1LFB _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
