Spaces:

Comfoa
/

Civilly-Simplified-Backend

Sleeping

App Files Files Community

Civilly-Simplified-Backend / backend /api

Commit History

May 31

03:57
fix:fetch-page-image-urls-for-existing-records

Comfoa

ccaa906
03:49
fix:populate-page-image-urls-in-fetch-latest-endpoint

Comfoa

a3a2425
00:34
feat: scrape all cities every 2h add /api/scrape-all cron endpoint enable Sulphur Springs

Comfoa

74a944c

May 30

21:02
fix: add asyncio timeouts to prevent Vercel 502 on slow Laserfiche fetches

Comfoa

3890aa9
19:46
fix: 502/503 errors, add Google Vision OCR, improve geo-locate robustness

Comfoa

a3716c2
19:36
fix: OCR async, connector fetch_page_images, lambda closures, parsers init

Comfoa

36f705a
17:38
fix: force re-summarize with force parameter, remove broken _execute import

Comfoa

22e3f53
17:23
feat: add force parameter to fetch-latest to clear cached summaries

Comfoa

b4ac2b4
05:02
fix: reuse event loop across requests in ASGI bridge, make OCR.space sync to avoid loop issues

Comfoa

ad6b9b4
03:57
fix: combine ASGI-to-WSGI bridge with direct lifespan init for connectors/DB/summarizer

Comfoa

6d83c40
03:54
fix: use Mangum lifespan=auto so DB, connectors, and summarizer initialize on first request

Comfoa

a52678f
03:07
fix: replace Mangum with custom ASGI-to-WSGI bridge for Vercel experimentalServices

Comfoa

af12bff
03:03
fix: set Mangum handler to Handler.HTTP explicitly for Vercel experimentalServices

Comfoa

7df68d3
02:55
fix: absolute minimal WSGI entry point - imports only inside handler

Comfoa

9c10afa
02:48
fix: replace psycopg2-binary with pg8000 (pure Python) to avoid Vercel Lambda 250MB native dep crash

Comfoa

65d006f
02:43
fix: make Vercel entry point lazy-load FastAPI on first request to prevent cold-start crash

Comfoa

39db043
02:20
fix: wrap lifespan startup in try/except so health endpoint works even if DB init fails

Comfoa

21bb921

May 29

23:29
feat: Vercel-ready OpenCouncil with 3 cities connected (Paris, Sulphur Springs, Frisco)

Comfoa

6ce841a

May 10

02:04
Implement Three P's framework: Life-Centric categories, Big Picture TL;DR, What You Can Do

Comfoa

ec586f2

May 9

23:50
Add /api/minutes/seed endpoint for pushing pre-computed OCR data to HF Space PostgreSQL

Comfoa

a40a869
15:48
fix: make OCR work always and consistently

Comfoa

7927eff
04:32
fix: add direct page image download fallback when PDF generation fails on HF Spaces

Comfoa

e207bf6
04:26
fix: extract page_image_urls from raw_text to avoid second HTTP request

Comfoa

b730e9f
04:24
fix: OCR pipeline not receiving page images for summarization

Comfoa

e889678
01:10
Fix DeepSeek hallucination: draconian prompt, temperature 0.0, save OCR text to raw_text

Comfoa

0178699
00:56
Fix: reset DB endpoint, filter future dates, prevent DeepSeek hallucination

Comfoa

960388b
00:48
Replace GPT-4o Vision with free Tesseract OCR pipeline

Comfoa

4c0742d
00:25
Add GPT-4o Vision support for scanned document images; remove all agenda code; focus on minutes

Comfoa

f4320f0

May 8

20:58
Debug: use model_dump(mode='json') to bypass Pydantic serialization, add traceback

Comfoa

7d791de
20:26
Fix 500 error: wrap DB lookups in try/except, add NULL-safe json.loads and datetime parsing in _row_to_agenda and _row_to_summary

Comfoa

89d75b7
20:17
Fix agenda detail 500 error: deterministic IDs via SHA-256 hash, fix timezone-naive datetime fallback, add better error logging

Comfoa

bb8ce2c
19:59
Add minutes support: fetch, store, summarize city council minutes from Laserfiche

Comfoa

9bace39
19:15
fix: report actual storage backend in health endpoint (was hardcoded to sqlite)

Comfoa

1125f3a
18:08
fix: update comments from Railway to HF Spaces, fix DB init print message

Comfoa

dc339f5
03:57
Switch from experimental services to builds/routes approach, fix API_BASE to empty string

Comfoa

c42f066
03:46
Fix Vercel backend 500 errors

Comfoa

8a15226
03:27
Add Vercel experimental services monorepo config (frontend + backend)

Comfoa

c9551c3
03:22
Initial commit: Civic City Hub - DeepSeek API, SQLite storage, encrypted API keys, professional news site frontend

Comfoa

e1ad28e

Commit History

May 31

fix:fetch-page-image-urls-for-existing-records

fix:populate-page-image-urls-in-fetch-latest-endpoint

feat: scrape all cities every 2h add /api/scrape-all cron endpoint enable Sulphur Springs

May 30

fix: add asyncio timeouts to prevent Vercel 502 on slow Laserfiche fetches

fix: 502/503 errors, add Google Vision OCR, improve geo-locate robustness

fix: OCR async, connector fetch_page_images, lambda closures, parsers init

fix: force re-summarize with force parameter, remove broken _execute import

feat: add force parameter to fetch-latest to clear cached summaries

fix: reuse event loop across requests in ASGI bridge, make OCR.space sync to avoid loop issues

fix: combine ASGI-to-WSGI bridge with direct lifespan init for connectors/DB/summarizer

fix: use Mangum lifespan=auto so DB, connectors, and summarizer initialize on first request

fix: replace Mangum with custom ASGI-to-WSGI bridge for Vercel experimentalServices

fix: set Mangum handler to Handler.HTTP explicitly for Vercel experimentalServices

fix: absolute minimal WSGI entry point - imports only inside handler

fix: replace psycopg2-binary with pg8000 (pure Python) to avoid Vercel Lambda 250MB native dep crash

fix: make Vercel entry point lazy-load FastAPI on first request to prevent cold-start crash

fix: wrap lifespan startup in try/except so health endpoint works even if DB init fails

May 29

feat: Vercel-ready OpenCouncil with 3 cities connected (Paris, Sulphur Springs, Frisco)

May 10

Implement Three P's framework: Life-Centric categories, Big Picture TL;DR, What You Can Do

May 9

Add /api/minutes/seed endpoint for pushing pre-computed OCR data to HF Space PostgreSQL

fix: make OCR work always and consistently

fix: add direct page image download fallback when PDF generation fails on HF Spaces

fix: extract page_image_urls from raw_text to avoid second HTTP request

fix: OCR pipeline not receiving page images for summarization

Fix DeepSeek hallucination: draconian prompt, temperature 0.0, save OCR text to raw_text

Fix: reset DB endpoint, filter future dates, prevent DeepSeek hallucination

Replace GPT-4o Vision with free Tesseract OCR pipeline

Add GPT-4o Vision support for scanned document images; remove all agenda code; focus on minutes

May 8

Debug: use model_dump(mode='json') to bypass Pydantic serialization, add traceback

Fix 500 error: wrap DB lookups in try/except, add NULL-safe json.loads and datetime parsing in _row_to_agenda and _row_to_summary

Fix agenda detail 500 error: deterministic IDs via SHA-256 hash, fix timezone-naive datetime fallback, add better error logging

Add minutes support: fetch, store, summarize city council minutes from Laserfiche

fix: report actual storage backend in health endpoint (was hardcoded to sqlite)

fix: update comments from Railway to HF Spaces, fix DB init print message

Switch from experimental services to builds/routes approach, fix API_BASE to empty string

Fix Vercel backend 500 errors

Add Vercel experimental services monorepo config (frontend + backend)

Initial commit: Civic City Hub - DeepSeek API, SQLite storage, encrypted API keys, professional news site frontend