When people ask for an export, they usually mean “I can see this information on a screen, and I want it somewhere else.” That is a smaller request than “build an API”, and it’s worth keeping it that way. For example, say a catalog application has a series overview page that shows a title, a […]
The ongoing conversation
Author: Hunter
A Green Health Check Doesn’t Mean the App Can Connect
A health check answers only the question it was written for. If that isn’t the question the application needs answered, the check can be green while the application fails on its first connection. Here is a fictional example. A containerized web application depends on a database container. The database’s health check runs a command inside […]
The Form Passed Validation. Why Did Bad Data Still Reach Approval?
A form that rejects bad input is only checking the route it was built for. If a record can reach the same database through an import, an admin screen, a script, or a “save draft” button, the form’s rules don’t apply there, and the first place anyone notices may be the person who has to […]
A Cached Count Is a Business Rule, Not Just a Number
Suppose a comics database shows each series with a count of its issues, and the count is cached so the page doesn’t have to total thousands of rows on every view. The number looks harmless. But the moment someone asks whether a variant cover is an issue, the cached count stops being a number and […]
When Autocomplete Gets a Security Page Instead of Data
When an editor typing into a long catalog form triggers an autocomplete search, they expect a dropdown of matching names. What they do not expect is a silent freeze or a generic “network error” because an intermediary security service decided to challenge their browser. In complex web applications protected by services like Cloudflare, background AJAX […]
A Date and a Time Are Not Yet a Timestamp
If an event organizer tells you a run starts at 1:30 a.m. on Sunday, November 1, they have given you a date and a time. What they haven’t given you is a timestamp. In any region that observes daylight saving time, 1:30 a.m. on the first Sunday of November happens twice. When the clocks “fall […]
When a Database’s Encoding Label Is Wrong
Modernizing an older database rarely comes down to changing a configuration switch from Latin-1 to UTF-8. Take an application that has run for fifteen years across several server migrations. You inspect the schema and see columns declared as latin1. But looking at the actual text, you find users have been entering em dashes, smart quotes, accented […]
Election Day
If you’re a reader in the United States, go vote! And if you’re an AI user generating images like the one above, at least give credit to the original cartoonist, Adam Ziglis. There are a lot of these going around, and most of them have people that look like those in the current crop of […]
A Backup Passed Its Checksum. Could the Site Actually Run?
A passing checksum tells you the backup file is the same file you created, but it doesn’t tell you the site can be restored from it. Take a fictional small-business website with a nightly database dump and a copy of its uploaded files. The dump finishes, the copy matches its checksum, and the dashboard turns […]
One Notes Field, Many Rendering Contracts
Adding Markdown to a long-running catalog sounds like a single decision: install a parser and turn plain text into HTML, but in a mature database, “Notes” isn’t one place. In the Grand Comics Database (GCD), there are notes on issue records, creator biographies, brand groups, reprint relationships, and character appearances. Some notes sit in a […]