I wrote a blog-compiler which imports a series of blog-posts, from plain-text files, into an SQLite database.

The database lives in the home directory of the current user. That makes sense for me, but if it doesn't the user can specify it via a command-line argument.

(App::Chronicle for reference.)

Beyond that it depends on the use-case for the database. Is it supposed to be updated? Will things function if it is deleted/not-present?