The sqlpage.random_string function

Introduced in SQLPage 0.7.2.

Returns a cryptographically secure random string of the given length.

Example

Generate a random string of 32 characters and use it as a session ID stored in a cookie:

INSERT INTO login_session (session_token, username) VALUES (sqlpage.random_string(32), :username)
RETURNING 
    'cookie' AS component,
    'session_id' AS name,
    session_token AS value;

Parameters

length

The length of the string to generate.
INTEGER
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