Re: New AWS-based website

[Maciej Sobczak <see.my.homepage@gmail.com>]

On 13 Kwi, 10:05, Ludovic Brenta <ludo...@ludovic-brenta.org> wrote:

> 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?

I cannot exclude this will be the case in some future. We might need
to scale up and making some scalability provisions from the very
beginning was important.
There are already several clients connecting, as there are some batch
processing jobs running in the background. They are managed separately
from the main server process, so having them as tasks/threads within
the server was not an option.
A "real" RDBMS has lots of useful features that we intend to benefit
from and SQLite is not a valid choice.
To be frank, SQLite belongs to the same category of solutions as
template parsers mentioned previously - they are not needed in hello
world programs and they don't offer anything adequate in complex
systems either.

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

I know.

--
Maciej Sobczak * http://www.inspirel.com