Spaces:
Sleeping
Sleeping
Commit History
-
Untrack legacy directories; keep them local-only
Palani-UnisonRemoves from the GitHub repo (but keeps on disk locally via .gitignore): - .claude/, docs/, scrapers/, supabase/, web/ - db/edge_functions/, db/migrations/, db/triggers/, db/schema.sql - memory.md, .env.example - pipelines/weekly_filings.py, pipelines/compute_summaries.py - tests/test_sgxnet_parser.py, tests/test_manager_aliases.py - scripts/db_push.py, scripts/export_data.py The published repo is now lean: streamlit_app/, src/, pipelines/ (only the active four), tests/ (only the surviving), db/schema_duckdb.sql, scripts/init_duckdb.py, requirements.txt, README, CLAUDE, LICENSE, .streamlit/, data/eqdp.duckdb. CLAUDE.md rewritten to drop references to the now-untracked trees. NOTE: memory.md previously contained a tracked admin password ("Eqdp2026!"). That value is permanently in the public-period git history and should be rotated immediately.aaf9c9f -
Swap Supabase for DuckDB-in-repo
Palani-UnisonPipelines now write to a single DuckDB file at data/eqdp.duckdb committed to the repo. Streamlit Cloud reads it directly — no managed database, no secrets, no auth. Mechanics: - src/store.py: DuckStore with a supabase-py-compatible chainable API (table().upsert/insert/update/select.eq/gte/lte/order/range/limit.execute, count="exact" supported). Every pipeline call site keeps working unchanged. - src/db.py: get_supabase() now returns the DuckStore. get_pg_conn() returns a raw DuckDB connection. - streamlit_app/lib/store.py: read-only DuckDB reader. lib/supabase.py removed; every page import flipped to lib.store. - db/schema_duckdb.sql: DuckDB-compatible schema. Drops auth.users, user_profiles, engagement_events, RLS, and the generated dollar_volume column (computed in pipelines instead). - scripts/init_duckdb.py: idempotent schema apply. - requirements.txt: drops supabase + psycopg2-binary. - .gitignore: whitelists data/eqdp.duckdb (the rest of data/ is still developer-lo…aa3be69 -
Initial commit: flip web layer from Next.js to Streamlit
Palani-UnisonThe project pivots from a Next.js + Vercel web app to a Streamlit + Supabase data-science dashboard hosted on Streamlit Community Cloud (free tier). What's in this commit: - Python analytical core (src/, scrapers/, pipelines/, tests/) — unchanged. - Supabase Postgres schema (db/schema.sql + supabase/migrations/) — unchanged. - streamlit_app/ — new multi-page app: Home, Tracker, Event Studies, Universe, Ticker Analyzer (candlestick + RSI/MACD/Bollinger/Amihud), Filings, Methodology, Brief (placeholder), About, Disclaimer. - streamlit_app/lib/ — cached Supabase reader (anon key, with paging to defeat the 1000-row PostgREST cap), pure-pandas TA helpers, dark "forensic" Plotly template, shared components. - requirements.txt — adds streamlit + streamlit-extras. - README, CLAUDE.md, docs/PLAN.md — updated to reflect the pivot. - web/ (legacy Next.js prototype) retained for reference; do not extend.f6dac2a