[Gambas-user] SQLite memory database

[tobias]

good evening,
i have a more sqlite related question:
what does it mean in the doc: For SQLite, you can also create and use a 
database in memory by giving as database name the string ":memory:". 
(from gambas2 doc, gb.db.connection.name)

what is creating a database in memory?? simply a temporary database or 
is that a special term used with sqlite??
what is the difference (with Connection.Type = "sqlite3") between
Connection.Name = "" (which means /tmp/sqlite.db)
and
Connection.Name = ":memory:"??
just that there is a temporary file in the first case and in the second 
everything is done in memory??