Instantly check if a Singapore HDB resale flat or private property is fairly priced based on real transaction data from data.gov.sg and URA.
🔗 Live site: worthit.canlah.app
A free tool for Singapore homeowners and buyers — check HDB resale prices, condo transaction history, price trends, and fair-value estimates for any town, district, or project.
Check My Price: search any HDB postal code, enter an asking price, and get a 0–100 Deal Score with a fair-value range from storey-adjusted comparable sales nearby — flat type, size, floor, and remaining lease are inferred automatically from the block's transaction history.
WorthIt uses a split architecture:
- Frontend: Static files (
public/) served via Cloudflare Pages (ornode server/index.jslocally) - API Server: Node.js/Express on Fly.io with SQLite database
- The SPA always calls same-origin
/api/*(public/config.jssetsAPI_BASE = ''): locally Express serves it; in production the Cloudflare Pages Function (functions/[[path]].js) proxies it to Fly.io
npm install
npm run setup # Python venv + requirements.txt for the data scriptsnpm run download # HDB (data.gov.sg) then URA private (needs URA_API_ACCESS_KEY in .env)
# npm run download-hdb # HDB only — rebuilds the DB from scratch
# npm run download-ura # URA only — replaces the private rows in an existing DBThis builds server/db/resale.db. download-hdb deletes and recreates the DB, so always run
download-ura after it (or use npm run download) or private-property data will be missing.
npm startOpen http://localhost:3000 in your browser. Express serves both the frontend and API.
npm install -g flyctl
fly auth loginfly launch # Follow prompts (choose region, set app name)npm run deploy # API + frontend (runs npm test first, bumps ?v=N, pings IndexNow)
npm run deploy:api # API only (npm test && fly deploy)The Fly.io machine (256MB RAM) is too small to run the Python download scripts. Instead, build the database locally and upload it:
npm run download # build server/db/resale.db (HDB + URA)
npm run deploy:data # WAL checkpoint → gzip → SFTP → atomic swap on /data → restartDon't upload with a bare fly ssh sftp put: without PRAGMA wal_checkpoint(TRUNCATE) first,
rows still in the WAL file are silently lost.
curl https://<your-app>.fly.dev/api/status
# Expected: {"status":"ok","total_transactions":<count>,"latest_month":"<YYYY-MM>",...}fly logs # live log stream
fly logs --no-tail # recent logs onlyfly machines list # list all machines and their states
fly machine status <id> # detailed status of a machinefly ssh issue # one-time: create SSH certificate
fly ssh console # open a shell on the machineInside the SSH shell:
ls -la /data/ # check database file exists
ls -la /app/ # check deployed files
curl localhost:8080/api/status # test API from inside the machine
cat /app/server/index.js | head # verify deployed codefly ssh sftp put local_file.txt /data/remote_file.txt # upload
fly ssh sftp get /data/resale.db ./downloaded.db # downloadfly machine restart <machine-id> # restart a specific machine
fly machines restart # restart all machines| Problem | Cause | Fix |
|---|---|---|
503 Database not ready |
No DB file on volume | Run download scripts locally, then fly ssh sftp put |
| OOM kill on SSH | Not enough RAM for Python | Build DB locally and upload via SFTP |
| SSH auth failed | No SSH certificate | Run fly ssh issue then fly ssh establish |
no_database status |
DB missing at /data/resale.db |
Upload via SFTP |
Automatic: the Refresh Data GitHub Action (.github/workflows/refresh-data.yml) runs daily at
03:00 SGT — npm run download, a row-count guard, then npm run deploy:data. It can also be
triggered manually from the Actions tab.
Manual: npm run download && npm run deploy:data. Never upload an HDB-only DB — it would wipe the
private-property data in production.
npm run deploy:frontendThis runs npm test, bumps the ?v=N cache-bust in index.html (scripts/bump-version.js),
uploads public/ + functions/ with wrangler (scripts/deploy-frontend.js, uses
CLOUDFLARE_API_TOKEN from .env), then submits the sitemap to IndexNow. Avoid a bare
wrangler pages deploy — it skips the tests, the version bump and the IndexNow ping.
The SPA calls same-origin /api/*; the edge function (functions/[[path]].js) proxies it to Fly.io.
The frontend is live at worthit.canlah.app. Here's how it was configured:
- Go to dash.cloudflare.com → Add a site
- Enter your root domain (e.g.,
canlah.app) → Continue - Select Free plan → Continue
- Review DNS records → Continue
- Note the two nameservers Cloudflare provides
- At Porkbun (or your registrar) → Domain Management → Authoritative Nameservers
- Replace with Cloudflare's nameservers
- Wait for propagation (minutes to a few hours)
- Cloudflare emails you when active
- Go to Cloudflare Dashboard → Pages → worthit → Custom domains
- Click Set up a custom domain
- Enter
worthit.canlah.app - Cloudflare automatically creates the CNAME record and provisions SSL
- SSL is automatic (Universal SSL) — no extra steps needed
curl -I https://worthit.canlah.app
# Should return HTTP 200 with Cloudflare headers| Endpoint | Description |
|---|---|
GET /api/status |
Database status and record count |
GET /api/towns |
List all HDB towns + district labels |
GET /api/flat-types |
List all flat types |
GET /api/resolve?q= |
Resolve town name or postal code |
GET /api/area-overview?town= |
Main HDB market overview endpoint (accepts lat/lng for 500m radius) |
GET /api/valuation?postal=&price= |
Deal Score + fair value from storey-adjusted nearby comps |
POST /api/feedback |
In-app feedback (5/IP/hour + 200/day global cap, separate feedback.db) |
GET /api/private/projects?q= |
Search private property projects |
GET /api/private/project-overview?project= |
Private project details |
GET /api/private/property-types |
List private property types |
GET /api/private/district-summary?districts= |
District aggregate stats |
GET /api/private/district-overview?district= |
Full district overview |
GET /api/nearby-hdb?lat=&lng= |
Nearby HDB transactions + private projects (800m) |
GET /api/bto/launches |
All BTO launches grouped by exercise |
GET /api/bto/projects?q= |
BTO project autocomplete |
GET /api/bto/project-overview?project= |
BTO project flats, nearby-resale comparison, and own resales once past MOP |
GET /api/seo/metadata?route= |
Bot metadata for edge-function injection |
GET /api/seo/sitemap |
Sitemap URLs (consumed by Cloudflare edge function) |
WorthIt/
├── scripts/
│ ├── download_data.py # HDB data download (data.gov.sg)
│ ├── download_ura_data.py # URA private property data
│ ├── bto_launches.json # Hand-curated BTO launch data
│ ├── fetch_bto_blocks.py # BTO project → HDB blocks (OneMap)
│ ├── bto_project_blocks.json # Output of fetch_bto_blocks.py
│ ├── hdb_blocks.csv # HDB block coordinates (seeds hdb_block_coords)
│ ├── run-python.js # venv wrapper for the Python scripts (npm run setup/download)
│ ├── read-feedback.js # dump in-app feedback (npm run feedback)
│ ├── bump-version.js # ?v=N cache-bust, run by deploy scripts
│ ├── deploy-frontend.js # wrangler deploy wrapper
│ └── indexnow-ping.js # sitemap → IndexNow after frontend deploy
├── server/
│ ├── index.js # Express API server
│ └── db/
│ ├── resale.db # SQLite database (generated)
│ └── feedback.db # In-app feedback (writable, generated)
├── functions/
│ └── [[path]].js # Cloudflare edge: /api proxy, bot SEO injection, sitemap
├── public/
│ ├── index.html # Main SPA
│ ├── config.js # API base URL config (same-origin)
│ ├── css/
│ │ └── styles.css
│ └── js/
│ ├── api.js # API client
│ ├── app.js # Main app logic
│ ├── charts.js # Chart.js configs
│ └── map.js # Leaflet map
│ └── data/mrt_stations.json # MRT overlay + nearest-station labels
├── Dockerfile # Fly.io Docker config
├── fly.toml # Fly.io app config
├── tests/ # Vitest + supertest (npm test); tests/python/ = pytest
├── memory-bank/ # Project context docs (kept current per CLAUDE.md)
├── design.md # UI style guide
├── CLAUDE.md # Architecture + patterns for Claude Code
├── package.json
├── requirements.txt
└── README.md
- Data: data.gov.sg HDB Resale Flat Prices + URA private property transactions
- Pipeline: Python 3 + SQLite
- Backend: Node.js + Express + better-sqlite3
- Frontend: Vanilla JS + Tailwind CSS + Chart.js + Leaflet
- Hosting: Fly.io (API) + Cloudflare Pages (frontend)
- HDB Resale Flat Prices via data.gov.sg
- URA Real Estate Transactions via URA
Prices shown are indicative and based on historical transaction data. They should not be considered as professional valuations. Always consult a licensed valuer or property agent for formal advice.