The Default storage location of SQLite database in a pod of kubernetes is /home/me/. When every I create a database it gets stored inside /home/me/ directory.

I want to change this to /home/database.

I tried changing it myself by trying to change data_store_directory like this

PRAGMA data_store_directory; 

PRAGMA data_store_directory = 'directory-name';

But this doesn't writes anything inside data_store_directory.

Can anyone please specify how to customize the storage location of SQLite database running inside a pod in kubernetes.