Write-up · Petoskey Church of Christ
The pastor writes the week once. Everything else follows.
Every week the pastor of Petoskey Church of Christ wrote the same content three times: on the website, again for the Sunday email, and again in Canva for the printed bulletin. Now he writes it once, as that week's Weekly Vine. The website, the email, the printed bulletin, the slides in the sanctuary, the lobby TV and the titles on the sermon video all take it from there.
Three copies of one week
Typing a week three times wasn't only slow. It gave the week three chances to disagree with itself. Rebuilding the bulletin in Canva was the biggest manual job of his week, and the copy it produced drifted from the website every time.
One record, read one way
The week now lives in a single record: the sermon title, the reading, the pastor's thought, the announcement, prayer requests and the week's plans. Every surface reads that record through one function that turns it into the shape a page renders from, so a field added to the record reaches every surface without each one being changed. Text that is the same every week, like service times and the address, lives in the church's settings, so it is never typed again. No surface keeps its own copy.
One answer to "is it live yet?"
The pastor often writes the Vine days ahead, and a sermon must not be announced before it is preached. So a Vine stays out of public view until 10:30 on its Sunday, unless he chooses to publish it early.
That hold first lived inside the Worship page, because it was the only page that showed a Vine. Then other pages learned to show one, and a Vine written ahead leaked onto three of them at once, because none of them asked. A sermon title went public before the sermon. The fix was one check, and every surface calls it. A surface that doesn't is a defect, however right it looks in a browser.
Checking that fix turned up a second bug. Every Vine on the public archive was dated the Saturday before its service. The stored date is a calendar date, and two places converted it as if it were a moment in time, through UTC, which in Michigan lands on the evening before. It was first filed as cosmetic. It isn't: a sermon dated wrong is the church saying something false about itself, so it was fixed straight away.
Two surfaces show part of the Vine early on purpose. The lobby TV and the welcome slides show that day's sermon title and reading from midnight on Sunday, because people read them walking in, before the service begins. They only ever show the Vine dated today, never a later week's.
The cache that kept the gate shut
The 10:30 switch was built without a scheduled job: the stored answer to "which Vine is current" expired by itself at the next go-live time. That worked on staging. In production a page cache sits in front of the site, keeps a page for up to seven days, and answers without running any of the site's code. So the copy cached on Saturday, with last week's Vine on it, was what visitors got all Sunday. The check was right, and nothing ever asked it. It went on for three months.
The proof took one pair of requests in the same second, to the same server: the cached Worship page showed the previous Sunday's sermon, and the same page with a cache-busting parameter showed the right one.
Now, saving a Vine dated ahead books a purge for its go-live minute, and a weekly Sunday sweep at 10:30 backs it up. Both clear the same four pages through one function, so there is one list of what to clear.
A page that loads from a cache proves the page loaded, not that the code ran. Before trusting what a page shows, I check whether the cache answered it.
The bulletin lays itself out
The printed bulletin is the Vine on both sides of a sheet of Letter paper. Each side is sized to the largest type that fits. Only if the front would drop below about 8 point does the end of the pastor's thought carry over to the back, a paragraph at a time, never mid-paragraph.
While he writes, the real print view can sit beside what he's writing, updating a moment after he stops typing. It is built from the unsaved text, and nothing is stored until he saves. Every place the print code reads the record goes through the same lookup, so a single hook hands it the unsaved values and no reader had to change. Because it is the print view itself and not an imitation of it, the preview can't disagree with the printout.
Slides, the lobby TV and the sermon video
The projector computer runs presentation software that takes PowerPoint files, so the site builds the welcome slides as a PowerPoint deck. Each slide is drawn as a picture rather than as text boxes, because that computer doesn't have the site's font and a substitute would undo the design. The site checks the deck every fifteen minutes and rebuilds it when anything on it has changed, so the download is current and instant. The prayer and benediction slides take their verses from the Vine the same way.
The lobby TV mixes photos with slides built from what the site already holds: upcoming events, what each event still needs, the gatherings through the week, and that day's sermon title. Nobody types a slide for it.
After the service, a script reads that Sunday's Vine, renders the title card for the video's intro, and writes the YouTube title and description. The YouTube title is the Vine's sermon title, word for word.
The Sunday email
Subscribing, confirming and sending are a small amount of the site's own code instead of a newsletter plugin, with mail sent through a transactional email service. No plugin update can break the send, and the subscriber list stays in the church's own database. Each Sunday's email carries everything new since the last one went out, with the Vine leading. Counting from the last send rather than a fixed week means a late Vine doesn't turn into a silent Sunday.
How it is run
It's WordPress, so people at the church can run it without me. Every change is tested on a copy of the site first and deployed to production by script. Only code moves between them; content never does.
Where it falls short
- The design is tied to WordPress. The pages are built in a page builder, so the design can't leave WordPress without being rebuilt. The next step is moving the church onto Intelligrace.
- Two safety nets haven't been seen to catch anything yet. The Sunday email's path for a week with no Vine has never fired in production, and I haven't yet watched a Sunday go live on its own since the purge fix. Until they do, they're designed, not proven.
- Two things are still typed twice. The slides shown during the sermon are still ones the pastor makes himself, by his choice, so a sermon title can still be worded one way there and another in the Vine. And the record has no field for who preached, so the preacher's name is typed again for the video when it isn't the pastor.