rithvika=# SELECT * FROM whoami;

Hi, I'm Rithvika.
I think in tables & queries.

-- also:

Junior at North Creek High School in Bothell, WA. I build full-stack apps, research PostgreSQL replication, lead student organizations, and play the violin. This whole site is one big database — go ahead and query it.

SELECT * FROM projects; GitHub ↗

PostgreSQLNext.js · ReactJavaPython · PyTorchSQLUSACO Gold Qualifier

ALTER TABLE me ADD COLUMN photo bytea; -- pending

rithvika@dev: ~/portfolio — psql

$ psql -h rithvika.dev -U visitor -d rithvika

psql (17.5, student 17.0) · SSL: TLSv1.3, cipher: CURIOSITY_AES_256

Type "help" for help. You are connected as a very welcome guest.

rithvika=# SELECT name, role, loves FROM whoami;

name │ Rithvika Devisetti

role │ high school junior · full-stack builder · database enthusiast

loves │ PostgreSQL, clean schemas, and ideas that help real people

(1 row)

rithvika=#

rithvika=# \dt -- list all tables

Browse the schema

Every section of this site is a table. Click one to query it.

about_me

1 row

who I am, in more than one row of text

interests

6 rows

what keeps me up at night (happily)

hobbies

5 rows

life outside the terminal

projects

6 rows

things I've built and researched

experience

8 rows

internships, leadership, community

academics

10 rows

coursework — some columns are private

awards

5 rows

trophies & qualifications

skills

4 rows

languages, frameworks, databases, tools

contact

2 rows

where to find me

rithvika=# SELECT story FROM about_me;

About me

I'm Rithvika Devisetti, a high school junior from Bothell, Washington. Most people meet databases in a textbook; I met them while building things — and I never really left. What started with a GPA-calculator web app for an FBLA competition turned into full-stack platforms, research automation for a University of Washington lab, and eventually independent research on PostgreSQL logical replication.

I love the moment when a messy real-world problem turns into a clean schema — when "we need to track businesses, reviews, and bookings" becomes tables, relations, and constraints that just work. That same instinct for structure shows up everywhere: in the nonprofit I founded, in the honor society I lead, and even in orchestra, where sixty musicians somehow commit one transaction of sound together.

Outside of code, I care a lot about people. I founded Mind Mission, a student-run nonprofit for mental health awareness, and I serve as Western Regional Director for Address Teen Stress. Technology is my favorite tool — community is the reason I build.

schoolNorth Creek High School

class_of2027

baseBothell, WA

favorite_dbPostgreSQL 🐘

instrumentViolin (since 5th grade)

foundedMind Mission (nonprofit)

currentlypredicting replication lag

rithvika=# SELECT * FROM interests FULL JOIN hobbies ON true;

Interests & hobbies

interests · ORDER BY obsession DESC

postgresqlreplication, indexing, query planning — the most fun I've had with a computer

full_stackschema → API → UI, end to end, with Next.js and React

machine_learningPyTorch + pandas; best when it predicts something concrete

competitive_progUSACO puzzles with a scoreboard — Gold division qualifier

entrepreneurshipproduct strategy & market research at Harvard's HUVTSP

automationreplacing hours of manual work with a script that runs in seconds

hobbies · stored as JSONB, obviously

"violin"school orchestra since 5th grade — my longest-running process

"mentoring"teaching assistant & alumni at Mana Samskriti, my cultural community since 2018

"advocacy"organizing mental-health workshops and writing wellness content

"competitions"FBLA programming events — part coding, part presenting, all adrenaline

"tinkering"side projects, benchmarks, and "what happens if I turn this knob?"

rithvika=# SELECT * FROM projects ORDER BY impact DESC;

Projects

Full source and more experiments at github.com/rithvika1221.

pg_replication_lag

independent research

Nov 2025 · research

Predictive modeling of PostgreSQL logical replication lag under high-throughput workloads. Controlled workload experiments, large-scale metric ingestion, and a model that predicts when replicas fall behind — before they do.

PostgreSQLPythonMLbenchmarking

neighbourly

Aug 2025 – present · full-stack platform

A local business discovery platform: search, reviews, favorites, bookings, AI chatbot support, owner dashboards with analytics, and admin approval workflows — database-driven with SSR and secure auth.

Next.js 15React 19TypeScriptVercel PostgresNextAuthMaps APIOpenAI

seal_lab_automation

UW research lab

Jun – Aug 2024 · University of Washington SEAL Lab

Automated energy-assessment reporting for UW's Industrial Assessment Center. JavaScript + Apps Script pipelines to search, clean, and summarize industrial data — supporting 50+ professional reports.

JavaScriptApps Scriptdata automation

mythic_pathways

Jan 2025 · FBLA project

An interactive storytelling web app where users shape their own adventure through dynamic choices — custom branching-narrative logic with an immersive, user-tested interface.

ReactNext.jsTailwind CSS

grademaster

Jan 2024 · FBLA project

A GPA calculator web app with AI features that helps students track academic performance — built for FBLA and refined through rounds of real user feedback.

ReactNext.jsTailwind CSSAI

girls_who_code

2023 – 2024 · summer immersion & competitions

Creative coding projects built with JavaScript and p5.js through Girls Who Code's Summer Immersion Program and competitions, with mentorship from industry engineers.

JavaScriptp5.js

rithvika=# SELECT org, role FROM experience ORDER BY start_date DESC;

Experience & leadership

FBLA — Industry Relationsteam member & competitor2025 – now

Industry outreach plus competing in programming & business presentation events.

Harvard HUVTSPsummer intern2025

Selected for the Harvard Undergraduate Ventures–TECH Summer Program; market research, business analysis & product strategy on startup teams.

Roveintern (via HUVTSP)2025

Travel-tech projects: user research and data-driven business recommendations.

Address Teen StressWestern Regional Director2024 – now

Leading regional outreach and partnerships for teen mental health.

Mind Missionfounder & president2024 – now

Founded a student-run nonprofit for mental health awareness; manage a team of writers & volunteers.

Advanced Technology Honor Societypresident2024 – now

Leading a tech honor society at NCHS; organizing student projects and technical events.

NCHS Counseling Advisory Councilmember2023 – now

Working with counselors to improve student mental-health resources.

Girls Who Codecompetition manager · SIP2023 – 24

Led club competition teams; Summer Immersion Program participant.

rithvika=# SELECT course FROM academics; -- Class of 2027, coursework only

Academics

Advanced Programming TopicsCS AP Computer Science ACS AP Computer Science PrinciplesCS AP Calculus ABmath AP Physics 1science AP Environmental Sciencescience AP English Languagehumanities AP English Literaturehumanities AP World Historyhumanities AP Human Geographyhumanities

rithvika=# SELECT gpa, test_scores FROM academics;

ERROR: permission denied for columns "gpa", "test_scores"

HINT: Row-level security is enabled. Some data stays between me and the admissions office.

rithvika=# SELECT award, event, year FROM awards ORDER BY year DESC;

Awards & honors

🏆

3rd Place — Intro to Programming

FBLA National Leadership Conference

2025

🥇

1st Place — Intro to Programming

FBLA Washington State Conference

2025

⭐

Gold Division Qualifier

USA Computing Olympiad (USACO)

2025

🏅

4th Place — Intro to Programming

FBLA Washington State Conference

2024

📜

Certifications

Java Programming (Duke) · Full Website with WordPress

—

rithvika=# SELECT category, unnest(items) FROM skills;

Skills

languages

Java
Python — pandas, NumPy, Matplotlib, PyTorch
SQL
JavaScript / TypeScript
HTML & CSS

databases

PostgreSQL — replication & performance
MySQL + Workbench
JDBC
Schema design

frameworks

Next.js & React
Spring Boot
Tailwind CSS
Bootstrap

tools

VS Code · Eclipse
Google Apps Script
Vercel
Git

rithvika=# EXPLAIN ANALYZE SELECT future FROM rithvika;

The query plan

How I got here — every step feeds the next one.

projects built & shipped

AP & advanced courses

leadership roles

years playing violin

Nested Loop (cost=curiosity..limitless) (actual time=2019..2027)

-> Seq Scan on violin (2019 – now) — first instrument, process still running

-> Index Scan on girls_who_code (2023) — found programming, never looked back

-> Hash Join on uw_seal_lab (2024) — first research: automating 50+ reports

-> Parallel Append on mind_mission, address_teen_stress (2024) — founded & led nonprofits

-> Index Scan on harvard_huvtsp (2025) — startups, strategy, teamwork

-> Aggregate on pg_replication_research (2025) — independent PostgreSQL research

-> Result: class_of_2027 (loading…)

Planning Time: ongoing

Execution Time: just getting started

rithvika=# -- your turn

Try the shell

This prompt is real. Try \dt, \d projects, or a SELECT.

rithvika-sql — interactive

Welcome to rithvika-sql, the interactive portfolio shell.

Type help for commands. Try SELECT * FROM hobbies;

rithvika=#

supported: help · \dt · \d <table> · SELECT * FROM <table>; · SELECT gpa FROM academics; · \q

rithvika=# SELECT * FROM contact;

Let's connect

github

github.com/rithvika1221 ↗

Rithvika Devisetti ↗