[GRASS-dev] sqlite and grass64

[Glynn Clements]

Michael Barton wrote:

> >> I would like to ask you for your opinion... to use sqlite as default
> >> db driver for grass64 (instead of dbf). What do you think?
> >
> > Yes, that would be very good. AFAIK:
> >
> > Functionality
> > - it does all the DBF driver does and way more
> >
> > Portability
> > - works on all common operating systems
> >
> > Installation efforts:
> > - despite the base installation, zero maintenance
> >
> > Markus
> 
> AFAICT, SQLite has considerably more functionality than our current  
> dbf driver. I like it for a lot of reasons. A couple issues to  
> consider, however.
> 
> dbf is a widely recognized file format that can be read or imported by  
> very many other applications directly. While the SQLite database  
> engine can export into several interchange format, the native SQLite  
> file format is much less widely read by other applications.

I would have expected most applications to access databases via ODBC,
rather than trying to interface with DBMS-specific libraries,
protocols or file formats directly.

-- 
Glynn Clements <glynn at gclements.plus.com>