in-memory db? gadfly?

[chris]

I'm looking for a completely in-memory sql db.  I have seen gadfly, but
its startup method seems to require a directory for the on-disk file
storage.  I have a script and I want to create a database/tables in the
script, insert some data (not much), and execute some queries, all
in-memory.  Don't need to persist anything.  Possible, or am I just
talking crazy here?

Thanks,
Chris