Re: New AWS-based website

["Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>]

On Fri, 13 Apr 2012 01:05:11 -0700 (PDT), Ludovic Brenta wrote:

> I too like PostgreSQL but my first choice of database would
> be SQLite because it avoids all the network and administrative
> overhead associated with a database server.  I would use
> PostgreSQL as a second choice if I really needed to run the
> database and the web server on different machines or if there
> were more than one client connecting to the same database.  Is
> that your case?

But SQLite and full-scale RDBMS have just different applications. SQLite is
for single-file, single-client cases. If the standard Ada library provided
an OS-agnostic transaction safe persistence, you would not need SQLite at
all. A true stand-alone RDBMS is an absolutely different beast.

> (Oh and in case you ask: you do not need ODBC to talk to an
> SQLite database).

Yes, that follows from the above. You need no abstraction layer for the
cases where SQLite comes in question.

ODBC is about communication to a possibly unknown server in a more or less
independent way, since SQL failed to deliver. Well, ODBC failed too, but on
a lesser scale.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de