Add a method for retrieving the database location

[geeksilva97]

What is the problem this feature will solve?

This might be useful for cases where only the DatabaseSync object is received.

What is the feature you are proposing to solve the problem?

Add the method DatabaseSync.prototype.location as a wrapper to sqlite3_db_filename. It might receive the database name as an argument.

What alternatives have you considered?

N/A

[tniessen]

While simple enough, I am wondering if this is a pattern that we want to promote? I assume the intention is that applications can re-open the same database again? If so, then relying on this path alone may discard connection parameters since Node.js is setting SQLITE_OPEN_URI as far as I remember, and some VFS implementations may even allow moving database files around while they are open. If that is not the primary use case, I'd be curios what is.

[geeksilva97]

I assume the intention is that applications can re-open the same database again?

That's correct.

Honestly, this is the case I used so far. These use cases you brought are interesting, and SQLite docs mention ways to handle them https://sqlite.org/c3ref/uri_boolean.html.

Maybe we can start with this very basic implementation and add more capabilities later?