Creating an Application Based Database

Question

I am working on an application where I would like to store all my current user authentications (users that are currently logged in with their login tokens) in a database in memory. Currently I have an HSQL DB that I do a DROP and CREATE TABLE command onApplicationStart to store the authentications, but I was wondering if their is a way that I could just wipe out the database when the application restarts (currently it is stored until the server restarts).

Is there a way that I could create an in memory database that has limited access from only the application that uses it, and that destroys itself when the application restarts?

Answer 1

Sounds like this is exactly what you need:

Networked In-Memory Databases With ColdFusion

Using An In-Memory Database With ColdFusion (Out Of The Box)

Answer 2

TRUNCATE TABLE <tablename> works in MySQL, maybe there is a similar function?