Every analytics tool wants a subscription. And your data. I built Twiligent instead. YouTube stats. Instagram stats. One dashboard. Runs locally on your machine.
CREATE TABLE "public"."settings" (
"user_id" uuid NOT NULL,
"key" text NOT NULL,
"value" jsonb NOT NULL DEFAULT '{}'::jsonb,
"created_at" timestamp with time zone NOT NULL DEFAULT now(),
"updated_at" timestamp with time zone NOT NULL DEFAULT now(),
CONSTRAINT "settings_pkey" PRIMARY KEY (user_id, key),
CONSTRAINT "settings_user_id_fkey" FOREIGN KEY (user_id) REFERENCES auth.users(id) ON DELETE CASCADE,
CONSTRAINT "settings_value_check" CHECK ((jsonb_typeof(value) = 'object'::text))
);
ALTER TABLE "public"."settings"
ENABLE ROW LEVEL SECURITY;
CREATE TRIGGER settings_set_updated_at
BEFORE UPDATE ON public.settings
FOR EACH ROW
EXECUTE FUNCTION public.set_updated_at();
GRANT DELETE, INSERT, MAINTAIN, REFERENCES, SELECT, TRIGGER, TRUNCATE, UPDATE ON TABLE "public"."settings" TO "service_role";
REVOKE ALL ON TABLE "public"."settings" FROM "postgres";
GRANT DELETE, INSERT, MAINTAIN, REFERENCES, SELECT, TRIGGER, TRUNCATE, UPDATE ON TABLE "public"."settings" TO "postgres";
REVOKE ALL ON TABLE "public"."settings" FROM "anon", "authenticated";