mirror of
https://github.com/windmill-labs/windmill.git
synced 2026-08-25 16:02:11 +00:00
hugocasa
63f9d85bf6
* feat: public app rate limiting + fork hub raw apps + raw apps publish to hub button * sqlx * missing sqlx file * cache rate limiting --------- Co-authored-by: Ruben Fiszel <ruben@windmill.dev>
20 lines
756 B
PL/PgSQL
20 lines
756 B
PL/PgSQL
ALTER TABLE workspace_settings
|
|
ADD COLUMN IF NOT EXISTS public_app_execution_limit_per_minute INTEGER DEFAULT NULL;
|
|
|
|
-- Add trigger function for rate limit changes
|
|
CREATE OR REPLACE FUNCTION notify_workspace_rate_limit_change()
|
|
RETURNS TRIGGER AS $$
|
|
BEGIN
|
|
INSERT INTO notify_event (channel, payload)
|
|
VALUES ('notify_workspace_rate_limit_change', NEW.workspace_id);
|
|
RETURN NEW;
|
|
END;
|
|
$$ LANGUAGE plpgsql;
|
|
|
|
-- Create trigger on workspace_settings (drop first if exists)
|
|
DROP TRIGGER IF EXISTS workspace_rate_limit_change_trigger ON workspace_settings;
|
|
CREATE TRIGGER workspace_rate_limit_change_trigger
|
|
AFTER UPDATE OF public_app_execution_limit_per_minute ON workspace_settings
|
|
FOR EACH ROW
|
|
EXECUTE FUNCTION notify_workspace_rate_limit_change();
|