Session Close Event and databases

[Ralph_Alvy]

In a Web app that has a Session.DB property (As SQLiteDatabase), should I Nil that property in the Session Close Event? I have been doing this:

If Self.DB <> Nil Then Self.DB.Close

But I’m wondering if I should also be setting Session.DB to Nil to prevent memory leaks.

[Ralph_Alvy]

Found my answer from Greg O’Lone here:

https://forum.xojo.com/13824-best-practice-ending-a-session/0

The database should be closed. I suggest having a property on the Session for the DB connection. That will automatically get destroyed once the session goes away.

which is exactly what I’ve been doing.