Using sqlite3 from gen_server about erlang-sqlite3 HOT 3 CLOSED

I don't see anything wrong with that, you want named table that you can access by just name you can have only one (and you code can absolutely handle that already_started error, and work as table was normally opened), how we could know which table should be used with given name if we created separated table on each call? If you don't care about table name use anonymous.

from erlang-sqlite3.

The problem here is that gen_server:start_link is hidden behind open().
It would be more logical to allow user to start process instead and then call sqlite3:open/2.

also I do not find unregister call. Those named processes are left in memory until process restarts ?

from erlang-sqlite3.

Name is registered until process is run, you can terminate it by calling sqlte3:close

from erlang-sqlite3.