[Gdal-dev] Re: OGR C API question

[Frank Warmerdam]

Daniel Morissette wrote:
> I actually saw a presentation on SQLite last week at the PHP Conference 
> in Montreal and was quite impressed. My first reaction was that we 
> should add support for it in OGR and could then use it to create simple 
> point (x,y) data sources.  SQLite offers the power of a RDBMS (with some 
> known limitations) for fast SQL queries in a flatfile format, and it 
> runs as well on Unix/Linux as on Windows so it's easy to deploy and port 
> apps from one system to another... that could be the solution to many of 
> the problems we have run into in the past storing and querying point and 
> attribute data in other file formats for webmapping for instance.

Daniel,

When I looked at it last it was quite tied to it's own dbm (gdbm?) format
backend and wasn't easily applied to other formats.  Has that changed?
I was actually looking at it then as a general SQL processor for OGR but
came to the conclusion it would be too hard to retarget it to operate
on OGR features for OGR driver backends.

> Anyway, please keep us posted on your progress with the SQLite driver, I 
> think it will be very welcome.

Hmm, I think "progress with the SQLite driver" is a bit too concrete a way
to discuss it.  I have this nice fuzzy idea in the back of my head that it
might be nice someday to build an SQLite driver.  Should anything come of it
I will update the list, but don't expect anything.  I have lots of warm fuzzy
ideas about things that would be nice to do.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent