The downsides of a binary file approach is that you lose the ACID transactions of a database and the nework overhead you dislike is very useful for spatial data: geographic data can grow expontionally, and huge datasets are best centralized. It would be nice to have a java spatial database that can scale from handhelds to terabyte sized databases on workstations or servers.
--Christopher --- On Mon, 1/12/09, Sunburned Surveyor <sunburned.surve...@gmail.com> wrote: > From: Sunburned Surveyor <sunburned.surve...@gmail.com> > Subject: Re: [JPP-Devel] (no subject) > To: "OpenJump develop and use" <jump-pilot-devel@lists.sourceforge.net> > Date: Monday, January 12, 2009, 7:50 AM > Jukka, > > Thank you for your suggestion. It looks like there is some > excitement > among other programmers about the ability to use SQLLite, > H2, or a > similar database to support writable large datasets in > OpenJUMP. I > agree with the comment in your post, PostgreSQL can be a > pretty big > elephant for a lot of users. > > I have done some work on feature caching for large datasets > using > binary files accessed directly from Java. However, this > work isn't > currrently complete. It would be another option. I > personally prefer > this solution, as it doesn't require the complexity or > overhead of > JDBC and/or network communications with a separate software > package. > > This would be a good project for a Google Summer-of-Code > student. :] > > SS > > On Fri, Jan 9, 2009 at 5:09 AM, Rahkonen Jukka > <jukka.rahko...@mmmtike.fi> wrote: > > 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 ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
