SQLite Forum

Bad practice to open AND attach the same database?
Login
I can tell you that there is a widely used program which does this.  Not in the shell tool but in C code.  The program opens a database, then uses the C API to <code>ATTACH</code> a few databases including the original one.  It works fine.  Interlaced use of access to both 'names' of the database work as they should do.