René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Variable context support","articleBody":"The httpserver not seems to be aware of variables that were set (in the session?), returning NULLs.\n\nAn example use case where this would be handy is when you'd like to run a cronjob (using that extension) inside a running httpserver instance regularly (for example to update a table daily which is then served over the httpserver API.\n\nThe goal would to be able to have a statement like running:\n\n```sql\nselect cron('create or replace table hr_today as (from read_csv_auto(getvariable(''hr_today_filepath'')))', '0 0 0 8 * *');\n```\nCould it be that when httpserver starts, some process or thread is forked and the variables set when the server starts (in an init.sql script) is not \"brought along\" and therefore lost? Currently it seems variables that are set are blanked out when the server is running and just return NULL.\n\nPerhaps some change similar to https://github.com/Query-farm/cronjob/pull/6/commits/5eed5fdc08a2267aba3b9fb9b4fc8124266550e2 might be able to alleviate this?","author":{"url":"https://github.com/mskyttner","@type":"Person","name":"mskyttner"},"datePublished":"2025-10-23T09:58:18.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/48/httpserver/issues/48"}