Sankofa Market
A neighbourhood grocery whose stock list lives in a database.
Self-directed build for an invented business — nobody commissioned this. Everything you can click is real and working; only the company is made up.
A five-page site for an invented African grocery, with product categories and weekly specials driven from Postgres so the shop could update them without touching code.
Sankofa Market is an invented neighbourhood grocery, built to work through a question that comes up on almost every small-business project: who changes the site once it is live?
The name is an Akan word meaning roughly "go back and fetch what you left behind" — which is the shop's whole premise, and a useful reminder that a name doing some work is worth more than a name that merely sounds nice.
Product categories and the specials board both read from a Postgres database rather than sitting in the code. Updating what is on the shelves means editing a row, not booking a developer — which is the difference between a site that stays current and one that is abandoned within a year.
Row Level Security locks every table down by default. The public key can read categories and active specials and write a contact message; it cannot read messages back. That is enforced by the database itself, so a mistake in the frontend cannot leak anything.
Pages are statically pre-rendered and revalidate every 60 seconds, so they load instantly while the content stays fresh.