Members register, rebuilt
Hypothetical. Not a client, not a result.
// The problem
A community centre keeps its members and families in an old Access database on one office computer, with no backup and no record of who has looked at what.
// What we would build
We move every record out of the old database, check it with your office team, and rebuild the register as a small web app with roles, so a group leader sees only their group, the office sees what it needs, and every change and export is logged.
// What is in it
- Every member, family and group moved out of the old database, and checked with you
- Roles so group leaders see only their own group
- A log of every change and export
- Consent recorded for photos, mailing lists and directories
- Backups every night, and the old database kept read-only until you retire it
// Stack
- Next.js
- PostgreSQL
- Access and spreadsheet import
- DigitalOcean Toronto
// estimate
- Build
- ≈ US$61,200 to US$93,600, delivered within 16 weeksCAD 87,200 to 133,300
- Hosting
- ≈ US$176 a monthCAD 250 a month
- Support
- ≈ US$1,000 a monthCAD 1,425 a month
Prices in your currency are estimates from today's Bank of Canada rate. All invoicing is in CAD or USD.
Timeline by milestone
- Discovery
- 2.9 to 3.4 weeks
- Design approved
- 2.9 to 4.4 weeks
- Core features
- 1.9 to 3.4 weeks
- Full build
- 1.4 to 2.4 weeks
- Testing and fixes
- 0.9 weeks
- Moved records checked with your office
- 0.9 weeks
- Launch
- 0.9 to 1.4 weeks
How it is paid
- Deposit 20%
- CAD 17,440 to 26,660
- Discovery 6.8%
- CAD 5,929.60 to 9,064.40
- Design approved 6.8%
- CAD 5,929.60 to 9,064.40
- Core features 20.4%
- CAD 17,788.80 to 27,193.20
- Full build 13.6%
- CAD 11,859.20 to 18,128.80
- Testing and fixes 6.8%
- CAD 5,929.60 to 9,064.40
- Moved records checked with your office 8.7%
- CAD 7,586.40 to 11,597.10
- Launch 6.9%
- CAD 6,016.80 to 9,197.70
- Holdback, 30 days after launch (10%)
- CAD 8,720 to 13,330