SQLite Forum

In the CLI 

> ,databases


> PRAGMA database_list

tells me which databases are <i> in scope</i> in the current session (as Simon Slavin points out) ... but I see the <i>alias</i> as  <i>main</i> and not the handle i.e. as returned by the out parameter of sqlite3_open(dbname, out handle).

Programmatically, I will need to use  sqlite3_open--which creates <i>handles</i> and not <i>aliases</i> as the CLI--to open databases.

To paraphrase, my original question was simply to figure out whether I could get the list of databases I've opened together with their corresponding handles ... <i> programmatically </i>.

It looks like I have to manage this within my application. Correct?