table created with one connection does not exists on the others about sqlite HOT 2 CLOSED

The reason this is occurring is because by default in memory databases are per-connection. This means that in your example the table created on the first connection is not visible to any other connection.

Your example will not panic if you use an actual path for the database instead of an empty string.

It is also possible to use a shared-cache in-memory database using the URI "file::memory:?cache=shared".

More information from the official SQLite docs can be found here:
https://sqlite.org/inmemorydb.html

from sqlite.

Oh, thank you!

The documentation for sqlite3_open_v2 confused me: I didn't realized that with sqlitex n different connection would be opened to different private databases. In fact, as a workaround I started using a file to hold the db and then migrate/reopen the pool, without thinking of why it worked.

So, thank you again and sorry for the noise :)

from sqlite.