How I Built a Programmatic SEO Site with 16,750 Pages Using FastAPI and PostgreSQL
The article discusses the creation of BSBFinder.com, a programmatic SEO site designed for Australian BSB number lookups. It details the technology stack used, including FastAPI and PostgreSQL, and emphasizes the importance of server-side rendering for SEO. The site features a comprehensive data pipeline and unique content for each of the 16,750 BSB pages to enhance search engine indexing.
- ▪BSBFinder.com is a free tool for looking up Australian BSB numbers, built using FastAPI and PostgreSQL.
- ▪The site includes a data pipeline that processes BSB data from AusPayNet, allowing for historical tracking of changes.
- ▪Each BSB page is generated from a template but contains unique content to improve SEO performance.
DEV.to (Top) files mainly under programming. We currently carry 4,924 of its stories.
Story provenance
Source · retrieval · rights · ranking — open for full record
inspect →
Attribution is not the same as permission. This drawer separates discovery metadata, excerpts, WeSearch-generated summaries, reuse status, and whether the publisher receives the visit. Nothing here claims a legal grant the publisher has not made.
Record
| Original publisher | DEV.to (Top) |
| Canonical URL | https://dev.to/lactustech/how-i-built-a-programmatic-seo-site-with-16750-pages-using-fastapi-and-postgresql-33ji |
| Publication time | Tue, 26 May 2026 17:31:40 +0000 |
| Retrieval time | 2026-05-26T17:37:50.291Z |
| Last seen | 2026-05-26T17:37:50.291Z |
| Headline source | Publisher (no WeSearch rewrite) |
| Excerpt source | publisher body |
| Excerpt method | First ~120 words (~800 chars) of extracted publisher body, fair-use limited. |
| Summary | WeSearch · cerebras-chat (WeSearch summarizer) |
| Summary source text | contentText |
| Citation coverage | Summary is a WeSearch-generated derivative; primary citation is the original publisher URL. |
| Cluster | BuSrnxxVmwi7 |
| Cluster logic | Grouped by semantic title/content similarity across sources within a rolling window. Same-publisher template collisions are excluded from coverage comparison. |
| Ranking reason | Story pages are not engagement-ranked. Hub feeds use recency, with optional source-diversified chronological ordering (cap consecutive stories per source). No personalized ranking. |
| Publisher visit | Yes — open original |
| Substitutes article? | No — link-out required for full text |
Rights status (four layers)
WeSearch handling by dimension
| Indexing | May the item be indexed (stored, ranked, made findable)? | Allowed |
| Snippet | May a short excerpt of the publisher's text be shown? | Allowed |
| AI summary | May WeSearch generate its own short summary of the article? | Limited |
| Retrieval / RAG | May the content be exposed for third-party retrieval-augmented generation? | Not asserted |
| Model training | May the content be used to train AI models? | Not asserted |
| Commercial reuse | May the content be reused commercially? | Not permitted |
Basis: Derived from the published RSS/Atom feed. Contact: [email protected]. Reviewed: 2026-07-24.
Opening excerpt (first ~120 words) tap to expand
try { if(localStorage) { let currentUser = localStorage.getItem('current_user'); if (currentUser) { currentUser = JSON.parse(currentUser); if (currentUser.id === 3952999) { document.getElementById('article-show-container').classList.add('current-user-is-article-author'); } } } } catch (e) { console.error(e); } Ujwal Jayendran Posted on May 26 How I Built a Programmatic SEO Site with 16,750 Pages Using FastAPI and PostgreSQL #webdev #python #seo #fastapi A deep dive into building BSBFinder.com — a free Australian BSB number lookup tool — from data pipeline to deployment. Every Australian bank transfer requires a BSB number — a 6-digit code identifying the bank and branch.
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at DEV.to (Top).
Discussion
0 commentsMore from DEV.to (Top)
