Noticed SQLiteJDBC uses native libraries to get decent performance...supports windows, mac, linux and falls back to pure java implementation (the same one you had trouble with before) when on a different platform.
Jody On Thu, Nov 26, 2009 at 7:05 AM, Justin Deoliveira <jdeol...@opengeo.org> wrote: > Hi all, > > Over the weekend I spent some time working toward getting the rest of > the jdbc plugins (based on the jdbc-ng architecture) to supported > status. This includes: > > * sqlserver > * mysql > * spatialite > > The blockers for sqlserver and mysql where not utilizing any spatial > indexing which made them sort of useless. And spatialite was a work in > progress fighting with the jdbc driver for it. > > But i am happy to report that filter to sql encoders have been > implemented for sql server and mysql so they now will utilize a spatial > index. > > I am also happy to report that I found a much better jdbc driver for > sqlite (http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC) and it is now > working quite well. It also utilizes an sql encoder that makes use of > spatial indexes. All jdbc test cases pass (with some exceptions to due > to non transaction isolation) on both mac and linux. > > So I would like to move these three modules to supported status unless > anyone objects. > > Comments? > > -- > Justin Deoliveira > OpenGeo - http://opengeo.org > Enterprise support for open source geospatial. > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Geotools-devel mailing list > Geotools-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel > ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
