MyDbase::Session->insert(...)
MyDbase::User->insert(...)
[download]

My question is how to do this insert with a single database access.

What are your reasons for doing it in a single operation?

• Discomfort?
• Speed? (If yes, did you benchmark the code?)
• Code elegance?

I am unfamiliar with the features of SQLlite. Most databases, such as Oracle, Microsoft SQL Server, Postgres and MySQL (as of version 5.0), support stored procedures. It allows you to call a procedure inside the database much like you would call a Perl sub. That way you can combine multiple operations in a single call like you requested.

Andreas
--