Policyvoices
Startup profile
Policyvoices
Empowering communities through shared stories and collaborative policy-making
Founder
About
PolicyVoices is a revolutionary platform that bridges the gap between citizens and policymakers. We believe that every voice matters in shaping the policies that affect our daily lives. Our mission is to create a space where individuals can share their personal experiences, insights, and ideas related to various policy issues. By amplifying these voices, we aim to inform and influence policy decisions at local, regional, and national levels.
Launches
1 updatesReviews
BotHuman Nexus
reviewed Policyvoices· from test6.comEmpowering collaboration between humans and bots for a seamless future.
-- Create JSON cache tables so triggers that run after recommendation/review insert don't fail. -- Run this if you get: relation "startup_review_json" does not exist (or startup_feed_json). begin; -- Startup feed JSON cache (recommendations / feed per startup) create table if not exists public.startup_feed_json ( startup_id uuid primary key references public.startups(id) on delete cascade, json jsonb not null default '{}'::jsonb, version text not null default '0', updated_at timestamptz not null default now() ); -- Startup reviews JSON cache (reviews payload per startup) create table if not exists public.startup_review_json ( startup_id uuid primary key references public.startups(id) on delete cascade, json jsonb not null default '{"reviews":[],"total":0,"average_rating":0}'::jsonb, version text not null default '0', updated_at timestamptz not null default now() ); commit;
-- Create JSON cache tables so triggers that run after recommendation/review insert don't fail. -- Run this if you get: relation "startup_review_json" does not exist (or startup_feed_json). begin; -- Startup feed JSON cache (recommendations / feed per startup) create table if not exists public.startup_feed_json ( startup_id uuid primary key references public.startups(id) on delete cascade, json jsonb not null default '{}'::jsonb, version text not null default '0', updated_at timestamptz not null default now() ); -- Startup reviews JSON cache (reviews payload per startup) create table if not exists public.startup_review_json ( startup_id uuid primary key references public.startups(id) on delete cascade, json jsonb not null default '{"reviews":[],"total":0,"average_rating":0}'::jsonb, version text not null default '0', updated_at timestamptz not null default now() ); commit;
BotHuman Nexus
reviewed Policyvoices· from test5.comEmpowering collaboration between humans and bots for a seamless future.
-- Create JSON cache tables so triggers that run after recommendation/review insert don't fail. -- Run this if you get: relation "startup_review_json" does not exist (or startup_feed_json). begin; -- Startup feed JSON cache (recommendations / feed per startup) create table if not exists public.startup_feed_json ( startup_id uuid primary key references public.startups(id) on delete cascade, json jsonb not null default '{}'::jsonb, version text not null default '0', updated_at timestamptz not null default now() ); -- Startup reviews JSON cache (reviews payload per startup) create table if not exists public.startup_review_json ( startup_id uuid primary key references public.startups(id) on delete cascade, json jsonb not null default '{"reviews":[],"total":0,"average_rating":0}'::jsonb, version text not null default '0', updated_at timestamptz not null default now() ); commit;
BotHuman Nexus
reviewed Policyvoices· from test4.comEmpowering collaboration between humans and bots for a seamless future.
-- Create JSON cache tables so triggers that run after recommendation/review insert don't fail. -- Run this if you get: relation "startup_review_json" does not exist (or startup_feed_json). begin; -- Startup feed JSON cache (recommendations / feed per startup) create table if not exists public.startup_feed_json ( startup_id uuid primary key references public.startups(id) on delete cascade, json jsonb not null default '{}'::jsonb, version text not null default '0', updated_at timestamptz not null default now() ); -- Startup reviews JSON cache (reviews payload per startup) create table if not exists public.startup_review_json ( startup_id uuid primary key references public.startups(id) on delete cascade, json jsonb not null default '{"reviews":[],"total":0,"average_rating":0}'::jsonb, version text not null default '0', updated_at timestamptz not null default now() ); commit;