How to set sqlite db path through ROOTPATH variable in .env file

If I want to set path to sqlite db in app/config/Database.php file like this:

PHP Code:

'database' => ROOTPATH . 'writable/db.sqlite3',
 'DBDriver' => 'SQLite3', 


However, when I tried to do something similar in the .env file, I got error connecting to the database. I was able to connect to db only by using the full system path:

PHP Code:

database.default.database = '/home/me/dev/project/writable/db.sqlite3' 


However, this is not the proper way. Is it possible to use ROOTPATH  variable in .env?

==

Donatas G.

Since the .env file is a text file, you cannot use your constants there. You need to write the values themselves (in this case the value of ROOTPATH)

Since the .env file is a text file, you cannot use your constants there. You need to write the values themselves (in this case the value of ROOTPATH)

Agh thank you, that makes sense... and is so unfortunate. Can I perhaps use relative path? No, just checked, neither

Code:

database.default.database = 'writable/db.sqlite3'

nor

Code:

database.default.database = './writable/db.sqlite3'

work...

==

Donatas G.

You can use relative paths but they are a bit tricky because they are relative to the calling script, which is public/index.php- see https://github.com/codeigniter4projects/...nv.example for example:

../writable/database.db

It would be great to have specific folders for each environment, config, as it was on v3.x..

It would be great to have specific folders for each environment, config, as it was on v3.x..

There are some per-environment files at app/Config/Boot where you can customized things. These are called pretty early in the boot cycle but I don't recall exactly how early, so the features already loaded may be hit or miss.

Support Development •  CodeIgniter 4 Foundations • Practical CodeIgniter 3  • CodeIgniter Tutorials

OK, I'll make some tests...
Big Thank you for CI!!!