Database Not Connected
Connect Supabase for permanent, shared data storage. Currently using browser localStorage only (device-specific).
—
Active Notices
—
Alumni
—
Board Toppers
—
JEE/NEET
—
Staff & Faculty
Active Notices
Manage All| Title | Type | Date | Badge | Status |
|---|---|---|---|---|
🔌 Connect Supabase Database
Follow these 5 steps to connect a free PostgreSQL database. All notices, alumni, toppers, faculty data will be saved permanently and shared across devices.
1
Create Free Account
Go to supabase.com → Sign up → New project (name: "ssic-db")
2
Run SQL — Create All Tables
SQL Editor → New Query → paste below → Run:
create table if not exists alumni (id bigint generated always as
identity primary key, name text not null, role text not null, org text, batch text, location text,
category text default 'other', branch text, quote text, photo text, created_at timestamptz default
now());
create table if not exists toppers (id bigint generated always as identity primary key, name text not
null, score text not null, class text, year text, father text, subject text, quote text, photo text,
created_at timestamptz default now());
create table if not exists selections (id bigint generated always as identity primary key, name text
not null, exam text not null, score text not null, batch text, inst text, father text, sub text, quote
text, photo text, created_at timestamptz default now());
create table if not exists team (id bigint generated always as identity primary key, name text not
null, role text not null, dept text, qual text, exp text, bio text, type text not null, photo text,
sort_order integer default 0, created_at timestamptz default now());
create table if not exists notices (id bigint generated always as identity primary key, title text not
null, body text, day text, month text, type text default 'notice', badge text, is_active boolean
default true, sort_order integer default 0, created_at timestamptz default now());
create table if not exists ticker (id bigint generated always as identity primary key, text text not
null, is_active boolean default true, sort_order integer default 0, created_at timestamptz default
now());
alter table alumni enable row level security;
alter table toppers enable row level security;
alter table selections enable row level security;
alter table team enable row level security;
alter table notices enable row level security;
alter table ticker enable row level security;
create policy "Public" on alumni for all using (true) with check (true);
create policy "Public" on toppers for all using (true) with check (true);
create policy "Public" on selections for all using (true) with check (true);
create policy "Public" on team for all using (true) with check (true);
create policy "Public" on notices for all using (true) with check (true);
create policy "Public" on ticker for all using (true) with check (true);
3
Get Your Credentials
Settings → API → copy "Project URL" and "anon public" key
4
Enter Credentials Below
5
Migrate Existing Data (Optional)
Move any locally saved data to Supabase.
Ticker / News Bar
| Text | Order | Active | Actions |
|---|
0 itemsThese
scroll in the red ticker bar on the home page.