[OSGeo-Discuss] Open Geo Database

[Traian Stanev]

It looks like nemesis stores geometry as ASCII text. Which means it would be SLOW to put stuff in and get stuff out of the database (atof and sprint are the, ahem, nemesis of speed).

I got my information from reading the source file SQLiteDatabase.cpp (http://nemesis-code.googlecode.com/svn/trunk/src/database/SQLiteDatabase.cpp), not sure if that was the right place to look.

Traian


From: discuss-bounces at lists.osgeo.org [mailto:discuss-bounces at lists.osgeo.org] On Behalf Of Sampson, David
Sent: Monday, January 14, 2008 3:14 PM
To: discuss at lists.osgeo.org
Subject: [OSGeo-Discuss] Open Geo Database

Hey Folks,
Just wondering if there is still thought out there from the previous thread about a portable and open geodatabase.  I came across the nemesis project "an experimental finite element code. Utilizes SQLite to store, handle and retrieve geometry and analysis data. "
http://www.nemesis-project.org/index.php/Main_Page
Thought that might be a good place to start that is already using geometry in sqlite.
As for software adoptions it looks like GRASS already has an SQLITE driver.
QGIS looks hopeful. Here is a GRASS/QGIS-SQLITE tutorial http://whatnick.blogspot.com/2007/12/using-sqlite-with-qgis-grass-toolbox.html
GDAL has some SQLITE http://www.gdal.org/ogr/drv_sqlite.html

Just some more info for the fire.
Cheers