We ran into a lot of problems using sqllite in a web application. Particularly when the web application had A lot of writing to the database. As a result almost all of our work is now done using Mysql.
I have looked at the Eddie’s electronics example (which uses SQLite) and it seems adequate for Applications that use the data basically to display data.
I should probably just stick to MySql rather than fool around with SQLlite.
I sure would like to hear arguments in either direction of use the database in a web application.
Each session has its own connection. Because we can also do something without a session (handle special url, for example, and some email processing) the application also has its own connection. If the session connection is available we use it, otherwise we use the application connection.