Re: libgnadeodbc

[Paul Rubin <no.email@nospam.invalid>]

"Randy Brukardt" <randy@rrsoftware.com> writes:
> Maybe because it is all most projects need, but clueless management has 
> required a DBMS? So the programmers fake it by using SQLite and saying it is 
> a DBMS? (Few problems really need a DBMS.)

It wouldn't have occurred to me that sqlite is somehow not a DBMS.  It's
an SQL database that happens to be serverless.  It's still ACID since it
handles concurrency through file locking.  Yes you link it into your
application as a library.  If you were using Postgres you'd instead link
in a client library that speaks some wire protocol to a remote server.
Either way, you link a library.

I like sqlite and use it for small databases all the time.  Of course
you get more features and performance with heavyweight databases, but
they're also harder to maintain.  You have to keep the server running,
the data is spread across multiple files, etc.  By contrast, an sqlite
client can simply launch, do its thing with the database, and shut down.
The sqlite db itself is just one disk file, making backups simple, etc.