The sqlpage.current_working_directory function

Introduced in SQLPage 0.11.0.

Returns the current working directory of the SQLPage server process.

Example

SELECT 'text' AS component;
SELECT 'Currently running from ' AS contents;
SELECT sqlpage.current_working_directory() as contents, true as code;

Result

Currently running from /home/user/my_sqlpage_website

Notes

The current working directory is the directory from which the SQLPage server process was started. By default, this is also the directory from which .sql files are loaded and served. However, this can be changed by setting the web_root configuration option.

basic_auth_password basic_auth_username cookie current_working_directory environment_variable exec fetch hash_password header link path persist_uploaded_file protocol random_string read_file_as_data_url read_file_as_text request_method run_sql uploaded_file_mime_type uploaded_file_name uploaded_file_path url_encode variables version