DEV Community: Mahmut Gündüzalp

MySQL Will Quietly Eat Your Data If You Let It: Truncation, Charsets, and the 1366 You Never See

Mahmut Gündüzalp — Sun, 23 Aug 2026 08:30:21 +0000

A WhatsApp button on a shop was dialling the wrong number. Not a formatting problem — a genuinely different number, three digits short of the one in the admin panel.

The admin panel had saved it. The page was reading it. Nothing errored. The column was varchar(10), the number arrived with a country code, and MySQL had done exactly what it was configured to do: chop the value to fit and carry on.

That column had been wrong for months. Nobody noticed because nothing anywhere in the stack raised its voice.

Here is the family of bugs that behaves this way, how to find them in a database you inherited, and why the obvious fix — "just turn on strict mode" — creates a different bug if you do only that.

Part 1: The truncation

Run this on any MySQL or MariaDB instance:

SELECT @@GLOBAL.sql_mode, @@SESSION.sql_mode;

If neither contains STRICT_TRANS_TABLES or STRICT_ALL_TABLES, then for every INSERT and UPDATE your server is in the business of making data fit, not of telling you it doesn't.

What that means concretely:

CREATE TABLE t (phone VARCHAR(10));
INSERT INTO t VALUES ('905551234567');
SHOW WARNINGS;
-- Level: Warning  Code: 1265  Message: Data truncated for column 'phone' at row 1

SELECT phone FROM t;
-- 9055512345

Note the level. Warning, not error. The statement succeeded. affected_rows is 1. PDO in exception mode throws nothing, because there is nothing to throw — MySQL considers this a completed statement. Your ORM reports success. Your integration test asserting "the row exists" passes. The value is wrong.

The same mechanism applies well beyond strings:

You wrote	Column	Non-strict result
`'905551234567'`	`VARCHAR(10)`	`'9055512345'`
`300`	`TINYINT`	`127`
`'2026-02-31'`	`DATE`	`'0000-00-00'`
`''`	`INT NOT NULL`	`0`
`12.999`	`DECIMAL(4,2)`	`13.00`

Every one of those is a silent, permanent difference between what your application believed and what your database holds. And unlike a crash, there is no timestamp to correlate against — you cannot tell from the row when it happened or how many rows before it went the same way.

Finding the damage in a database you inherited

You cannot recover truncated values — the tail is gone. But you can find the columns where it is happening, which is what matters going forward. Truncated values pile up at exactly the column limit, so the suspects are the columns where real rows sit at the maximum length:

-- 1. list the string columns and their limits
SELECT TABLE_NAME, COLUMN_NAME, CHARACTER_MAXIMUM_LENGTH AS max_len
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE()
  AND DATA_TYPE IN ('varchar', 'char')
  AND CHARACTER_MAXIMUM_LENGTH <= 64      -- short columns are where this bites
ORDER BY CHARACTER_MAXIMUM_LENGTH;

Then, per interesting column:

SELECT COUNT(*) AS at_the_limit
FROM settings
WHERE CHAR_LENGTH(phone) = 10;

A handful of rows sitting exactly at the limit can be a coincidence. A majority of rows sitting exactly at the limit is not a coincidence, it is a report. In our case the count was every row that had ever been saved with a country code.

Two details that matter when you run this:

Use CHAR_LENGTH(), not LENGTH(). LENGTH() counts bytes; CHAR_LENGTH() counts characters. On multi-byte text they disagree, and VARCHAR(n) limits characters, not bytes.
Do this on a replica or a restored dump if the table is large. CHAR_LENGTH() in a WHERE clause means a full scan.

Part 2: Strict mode is necessary and not sufficient

The obvious response is to turn strict mode on. Do it — but understand what you are buying.

Strict mode does not repair the mismatch between what your application sends and what the column accepts. It changes how you find out about it: instead of quietly storing a wrong value, MySQL raises error 1406 (Data too long for column) and your code, which never expected a write to fail, hands the user a 500.

I have seen exactly this on an admin form. Strict mode was correctly enabled; the title field in the form had no maxlength and no server-side length check; the column was varchar(150). Someone pasted a long headline. Instead of a validation message the editor got a blank error page, and — worse — a story they thought they had saved and hadn't.

That is still better than silent corruption, because it is loud and it is immediate. But the actual fix is at the boundary:

$rules = [
    'title' => ['max' => 150],   // same number as the column, in one place
    'phone' => ['max' => 20],
];

foreach ($rules as $field => $rule) {
    if (mb_strlen($input[$field] ?? '') > $rule['max']) {
        return back()->withError("{$field}: at most {$rule['max']} characters.");
    }
}

Three habits that keep this honest:

Validate before you write, with the column's real limit. Generate the limits from information_schema if you can — a hand-copied number drifts the first time someone runs an ALTER.
Turn strict mode on so the boundary check has a backstop. Validation you wrote can be bypassed; the database is the last honest party in the chain.
Widen the column when the data is legitimately bigger. VARCHAR(10) for a phone number was never right. Truncation is a symptom; a wrong schema is the disease.

Part 3: Charsets, where "it worked on the old server" lives

A database was copied to a new server. Everything imported. Row counts matched. A week later somebody noticed that Turkish characters in older records had turned into question marks in some tables and not others.

The mistake was trusting the database default:

SHOW CREATE DATABASE app;
-- CHARACTER SET utf8mb4  ← looks fine, means almost nothing

The database default applies to newly created tables that do not specify their own. It says nothing about the columns you already have. The columns are where the truth is:

SELECT TABLE_NAME, COLUMN_NAME, CHARACTER_SET_NAME, COLLATION_NAME
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'app'
  AND CHARACTER_SET_NAME IS NOT NULL
  AND CHARACTER_SET_NAME <> 'utf8mb4';

If that returns rows, you have a mixed-charset database, and every dump/restore across it is a chance to lose bytes.

Two more charset facts worth having in your head:

utf8 in MySQL is not UTF-8. The alias utf8 (historically utf8mb3) stores at most three bytes per character, so it cannot hold anything outside the Basic Multilingual Plane — emoji, some CJK extensions, some historic scripts. Insert one into a utf8 column and, in non-strict mode, MySQL truncates the value at the emoji and keeps whatever came before. utf8mb4 is real UTF-8. Use it everywhere, including the connection charset.

The connection charset is part of the pipeline. Your column can be utf8mb4, your data can be perfect, and your terminal or client can still show you mojibake because the session negotiated something else. Which leads to the most useful debugging habit in this whole article:

When you think data is corrupted, check the bytes

SELECT title, HEX(title), LENGTH(title), CHAR_LENGTH(title)
FROM articles WHERE id = 42;

HEX() is the ground truth. It is not affected by your client, your terminal font, or the connection charset. I have twice now "found" data loss that turned out to be a display artefact of the command-line client, and both times HEX() settled it in one query: the bytes were intact, the rendering was not.

The tell for genuine UTF-8 content is LENGTH() > CHAR_LENGTH(). If they are equal on text you know contains non-ASCII characters, something upstream already flattened it.

Part 4: The application-side version of the same bug

Databases are not the only layer that cuts strings. This is a summary excerpt in PHP:

$summary = substr($body, 0, 200);   // wrong

substr() counts bytes. On UTF-8 text, byte 200 lands in the middle of a multi-byte character about half the time, and you send MySQL a string ending in half a character. Then either:

the column is utf8mb4 and strict mode is on → error 1366, Incorrect string value, and you get a 500 from what looked like a formatting line; or
strict mode is off → MySQL drops the invalid tail silently, and your summaries are quietly one character shorter than you think, sometimes ending in a replacement glyph.

The fix is one letter and three characters:

$summary = mb_substr($body, 0, 200);   // counts characters

Whenever you see strlen, substr, strtoupper, or str_pad applied to user text, treat it as a bug report waiting to happen. Error 1366 in a log almost always traces back to one of them.

The checklist

Run these on any project you did not set up yourself. They take about ten minutes together.

SELECT @@GLOBAL.sql_mode; — is STRICT_TRANS_TABLES present? If not, plan to enable it after auditing lengths, not before.
List varchar columns with small limits, then count rows sitting exactly at the limit. That count is your truncation report.
List columns whose CHARACTER_SET_NAME is not utf8mb4. Fix them before the next migration, not during it.
Confirm the connection charset your application actually negotiates — the DSN, not the config file you hope it reads.
Grep the codebase for byte-based string functions applied to user content, and replace them with the mb_ versions.
When you suspect corruption, run HEX() before you conclude anything. Half the time the data is fine and the client is lying.

The theme across all of this: the database is willing to accept an approximation of what you gave it, and by default it will not argue. Make it argue. Then make sure your code is ready to hear it.

I build and run news and e-commerce platforms at alestaweb.com. Every example above cost somebody a real afternoon.

Your Uptime Monitor Says 200. Your Contact Form Has Been Dead for Three Days.

Mahmut Gündüzalp — Sun, 23 Aug 2026 08:27:02 +0000

The contact form on a company site I look after stopped producing leads. Not "fewer leads" — zero, for three days. No alert fired. The uptime monitor was green the entire time. The status page had a nice unbroken bar.

The monitor was checking the homepage. The homepage was fine. /contact had been returning a fatal error since a Tuesday afternoon deploy.

This is the most boring class of outage there is, and it is the one that costs the most, because nothing tells you it is happening. Below is what actually broke, the four ways a site can be broken while still answering 200, and the small set of checks I run now instead of pinging the root URL.

What broke

The site loads a list of helper files at boot. During an unrelated edit, that list was rewritten, and one entry did not survive the rewrite — a helper that supplied data to a few templates.

Most pages never touch that helper, so they kept rendering. One page called it in a template. That page fataled. In production, with display errors off, a fatal means an empty response body or a generic error page — depending on how the stack is configured, sometimes with a 500 status, sometimes with the web server's own branded page and a status you did not choose.

The error log had the answer on line one, at the exact timestamp of the deploy. Nobody looked, because nothing said to look.

Three days of a form that a campaign was actively driving traffic to. The traffic arrived. The page did not.

Four ways to be broken and still return 200

If your health check is curl -o /dev/null -w "%{http_code}" https://example.com/ you are testing one route, one time, for one property. Here are the failure modes that sail straight through it.

1. The route you don't check. A site is not a URL, it is a few dozen to a few hundred routes. Homepages are the least likely page to break, because everything touches them and everyone looks at them. The pages that break are the ones with one unusual dependency: the form page, the search page, the report that joins four tables.

2. The page renders, but a part of it silently didn't. Templates are forgiving by design. A partial that throws inside a try/catch, a widget whose data source returned an empty array, a block that renders only when a config key exists — none of these change the status code. The page looks right at a glance and is missing the thing that made it worth serving.

I found one of these in the same audit: a function that emitted structured data (Article, BreadcrumbList) existed, was correct, and was called from nowhere. Thirty news URLs had been building JSON-LD that never reached the HTML. Status: 200. Value delivered: none.

3. The page is fine and the form is not. This one is hard to see. A full-page HTML cache was turned on. HTML caches are dumb by nature: they store bytes. Those bytes included a CSRF token. Every visitor got the first visitor's token, every POST failed validation, and the failure looked to the user like a page reload with no message. Every page on the site: 200. Every form on the site: broken.

4. The error page returns 200. Custom error handlers that render a friendly "something went wrong" view and forget to set the status. Frameworks that catch late and fall back to a template. Reverse proxies serving a static maintenance page with the default status. Your monitor sees 200 and a body of some length, and reports health.

What to assert instead

The fix is not a bigger monitoring product. It is asserting the things you actually care about. Four checks, in increasing order of value.

Check every route, not one route

You already have the route list — it is in your router, your sitemap, or both. Walk it.

#!/usr/bin/env bash
# routes.txt: one path per line, from the sitemap or the router
FAIL=0
while read -r path; do
  code=$(curl -s -o /tmp/body -w '%{http_code}' "https://example.com${path}")
  size=$(wc -c < /tmp/body)
  if [ "$code" != "200" ] || [ "$size" -lt 2000 ]; then
    echo "FAIL ${path} status=${code} bytes=${size}"
    FAIL=1
  fi
done < routes.txt
exit $FAIL

The size floor is doing real work here. A fatal that returns 200 with an empty or near-empty body is caught by bytes, not by status. Pick the floor from your own smallest legitimate page, then subtract a little.

Assert content, not just bytes

One string per route, chosen to be the thing that page exists to do. The form page must contain a <form and a submit button. The article page must contain an <h1. The page with structured data must contain application/ld+json.

grep -q '<form' /tmp/body || echo "FAIL ${path}: no form in body"
grep -qi 'fatal error\|<b>Warning</b>\|stack trace\|Undefined variable' /tmp/body \
  && echo "FAIL ${path}: error signature in HTML"

That second grep catches the inverse case: the page that renders and prints a warning into the output where a visitor — or a crawler — can read it.

Diff the error log around every deploy

This is the cheapest high-value check in the list and almost nobody does it. Record the log size before the deploy, read the tail after.

BEFORE=$(stat -c%s /path/to/error.log)
# ... deploy ...
sleep 30
AFTER=$(stat -c%s /path/to/error.log)
if [ "$AFTER" -gt "$BEFORE" ]; then
  tail -c $((AFTER - BEFORE)) /path/to/error.log
  echo "New errors appeared during deploy — investigate before walking away."
fi

In our incident this would have printed the missing helper, by name, thirty seconds after the deploy that caused it. The information was there the whole time. Nothing surfaced it.

Round-trip the form

The only way to know a form works is to submit it. A synthetic submission is about twenty lines and can run hourly:

<?php
// 1. Fetch the page like a browser would, keeping cookies.
$ch = curl_init('https://example.com/contact');
curl_setopt_array($ch, [
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_COOKIEJAR      => '/tmp/probe-cookies',
    CURLOPT_COOKIEFILE     => '/tmp/probe-cookies',
]);
$html = curl_exec($ch);

// 2. Pull the CSRF token out of the markup, exactly like a browser.
preg_match('/name="_token" value="([^"]+)"/', $html, $m);
$token = $m[1] ?? null;
if (!$token) { exit("FAIL: no CSRF token on the page\n"); }

// 3. Submit with a marker you can find and delete later.
$marker = 'probe-' . date('YmdHi');
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query([
    '_token'  => $token,
    'name'    => $marker,
    'email'   => 'probe@example.com',
    'message' => 'automated probe, safe to delete',
]));
curl_exec($ch);

// 4. Assert the effect, not the response.
$found = (int) $pdo->query(
    "SELECT COUNT(*) FROM leads WHERE name = " . $pdo->quote($marker)
)->fetchColumn();

echo $found === 1 ? "OK\n" : "FAIL: submitted, nothing stored\n";

Step 4 is the point of the whole thing. Not "did the POST return 200" — did a row appear. That single assertion catches the frozen-token case, the silently failing mail transport, the validation rule someone tightened, and the database column that quietly truncated the input.

Give the probe an obvious marker and delete its rows on a schedule. Yes, this writes to production. That is the trade: a handful of tagged test rows a day against not knowing your lead form is dead.

Why this keeps happening

Three reasons, and none of them are laziness.

Monitoring defaults are shaped by hosting, not by the product. A default check answers "is the machine up and serving". That was the right question when a machine going down was the common failure. The common failure now is code that is up and wrong.

Green is a feeling, and feelings are expensive to give up. An unbroken status bar makes people stop looking. Silence should mean "the assertions passed". In practice it means "nothing asserted anything".

Silent failure has no symptom by definition. A crash gets escalated in an hour. A form that swallows submissions gets noticed when someone asks why the pipeline is empty — which, in our case, took three days, and only because someone went looking for a different number.

The short version

A status code is a transport fact. It says the request reached something. It does not say the page did its job.
Check every route, not the homepage. Your sitemap already lists them.
Assert one meaningful string per route, and grep the body for error signatures while you are there.
Diff the error log across every deploy, automatically. Cheapest check here.
Round-trip the forms that make you money, and assert the stored row, not the response.
Anything that renders "sometimes" — structured data, widgets, conditional blocks — needs an output assertion, because code review will not catch a function that is never called.

None of this is sophisticated. The whole set is a cron job and about a hundred lines. The reason to write it is that the alternative is finding out from a person, and by then you have already paid for the traffic.

I build and maintain news and e-commerce platforms at alestaweb.com. Most of what I know about monitoring came from outages exactly this dumb.

The Query That Ate 75% of Our Database CPU: A MySQL Full-Text Post-Mortem

Mahmut Gündüzalp — Thu, 06 Aug 2026 22:11:21 +0000

A news platform I maintain started serving pages in six seconds. Load average sat at 16 on a 12-core box for hours. Nothing had been deployed. Traffic was up, but not 10x up.

The cause turned out to be a single SELECT that looked completely reasonable — the kind of query that passes code review, works fine on a 5,000-row table, and quietly becomes a wrecking ball at 80,000 rows.

Here is the whole investigation: how I found it, why it was slow, what the fix was, and the three unrelated things I learned along the way.

Symptom first

The obvious metrics:

Load average 16.7 on 12 cores
MySQL at 92% CPU, resident memory 9.8 GB out of 15 GB
4.8 GB pushed into swap
Time to first byte on article pages: 6.3 seconds

The tempting move here is to start tuning. Bump the buffer pool, add more cache, blame the bots. I've done that before and it's mostly a way of not finding the bug.

Find the query, not a query

The mistake I see most often at this stage is taking one snapshot of the process list, spotting something slow, and declaring victory. One snapshot tells you what was running at one instant. It doesn't tell you what dominates.

Sample it instead:

for i in $(seq 1 20); do
  mysql -N -e "SELECT info FROM information_schema.processlist
               WHERE command='Execute' AND info IS NOT NULL"
done | sed -E 's/.*MATCH.*/RELATED-ARTICLES/' | sort | uniq -c | sort -rn

Twenty cheap samples, bucketed by shape. The result:

    202 RELATED-ARTICLES
     41 other article queries
     21 rate-limit counter

202 of 268 active queries — 75% — were the same statement. That's not a slow query problem, that's a "one feature is eating the server" problem.

The query

It powers the "related articles" block under every story:

SELECT a.id, a.title, a.summary, a.image, a.published_at,
       MATCH(a.title, a.summary) AGAINST(? IN NATURAL LANGUAGE MODE) AS relevance
FROM articles a
LEFT JOIN categories c ON a.category_id = c.id
WHERE MATCH(a.title, a.summary) AGAINST(? IN NATURAL LANGUAGE MODE)
  AND a.id != ? AND a.status = '1'
ORDER BY (relevance / (DATEDIFF(NOW(), COALESCE(a.sort_date, a.published_at)) / 30 + 1)) DESC
LIMIT 6

Read that ORDER BY again. It divides the relevance score by the article's age in months, so a strong match from 2019 loses to a decent match from last week. It's a genuinely nice ranking idea. Freshness matters in news.

And the search term passed in? The current article's entire title plus the first 200 characters of its summary.

Why it's expensive

Two things compound.

Natural language mode is not a filter, it's a scorer. Feed it a long string and it matches on any meaningful token in that string. I measured it:

SELECT COUNT(*) FROM articles
WHERE MATCH(title, summary) AGAINST('<full title + 200 chars of summary>'
                                    IN NATURAL LANGUAGE MODE);
-- 16,141

16,141 rows matched out of 80,836 — about 20% of the table. A long natural-language term is a very wide net. Every extra common word widens it further.

The ORDER BY cannot use an index. It sorts on an expression computed per row. The optimizer has no choice:

+----------+----------------+----------------------------------------------+
| type     | key            | Extra                                        |
+----------+----------------+----------------------------------------------+
| fulltext | ft_title_summ  | Using where; Using temporary; Using filesort  |
+----------+----------------+----------------------------------------------+

Using temporary; Using filesort on a fulltext scan is the whole story. To return 6 rows, the server:

scores ~16,000 rows,
materialises them into a temporary table,
computes relevance / (age/30 + 1) for every one of them,
sorts all 16,000,
throws away 15,994.

Measured cost: ~0.22 s of CPU per call. On every article page view. With half the traffic coming from crawlers walking the archive, each hitting a different article — so per-article caching had a near-zero hit rate for exactly the traffic causing the load.

At a handful of article views per second, that one query alone wants more cores than the machine has.

Fix 1: stop searching with a paragraph

The search term should be the subject of the article, not the article. I extract meaningful words from the title only — drop stopwords, drop anything under three characters, cap at eight words:

function searchTermFromTitle(string $title): string
{
    $stop = ['and','the','with','for','from','that','this','was','are','has'];
    $clean = preg_replace('/[^\p{L}\p{N}\s]+/u', ' ', $title);
    $clean = trim(preg_replace('/\s+/u', ' ', $clean));

    $picked = [];
    foreach (explode(' ', $clean) as $word) {
        $lower = mb_strtolower($word, 'UTF-8');
        if (mb_strlen($lower, 'UTF-8') < 3 || in_array($lower, $stop, true)) {
            continue;
        }
        $picked[] = $word;
        if (count($picked) >= 8) break;
    }
    return $picked ? implode(' ', $picked) : $clean;
}

Match count dropped from ~16,000–58,000 (it varied wildly by article) to ~2,500–13,000. Better, not solved.

A note for non-English text: build the stopword list for the language you actually store. Mechanically reusing an English list on Turkish, German or Finnish content will either strip nothing or strip the wrong things, and morphology means a naive list misses inflected forms.

Fix 2: rank in two stages

The real problem isn't the match count, it's sorting all matches by an expression. So don't. Take the top N by raw relevance — which the fulltext index can drive with a bounded sort — then apply the freshness weighting to those N in an outer query:

SELECT t.id, t.title, t.summary, t.image, t.published_at, t.relevance
FROM (
    SELECT a.id, a.title, a.summary, a.image, a.published_at,
           MATCH(a.title, a.summary) AGAINST(? IN NATURAL LANGUAGE MODE) AS relevance,
           COALESCE(a.sort_date, a.published_at) AS rank_date
    FROM articles a
    LEFT JOIN categories c ON a.category_id = c.id
    WHERE MATCH(a.title, a.summary) AGAINST(? IN NATURAL LANGUAGE MODE)
      AND a.id != ? AND a.status = '1'
    ORDER BY relevance DESC
    LIMIT 60
) t
ORDER BY (t.relevance / (DATEDIFF(NOW(), t.rank_date) / 30 + 1)) DESC
LIMIT 6

The expensive sort now runs over 60 rows instead of 16,000. The derived table has a LIMIT, so it can't be merged away — it's materialised, which is precisely what I want here.

Ranking quality barely moves. A result that wins after freshness weighting was already a strong relevance match; it was never sitting at position 4,000.

Results

Measured against real rows, old query vs new, five articles:

	Before	After
5 queries, total	2.571 s	0.572 s
Share of active queries	75%	16%
Load average	16.7	7.4
TTFB, worst page	6.34 s	1.91 s

4.5x on the query. And no caching layer involved — this is the same work, arranged so the database isn't asked to sort a haystack to hand back six needles.

Three things I learned that weren't the bug

InnoDB does not give space back. I pruned about 2.9 million rows from some log tables. data_free went up by 270 MB and the files didn't shrink. Deleted rows leave free pages inside the tablespace, reusable by that table but not returned to the OS. OPTIMIZE TABLE rebuilds it. If your cleanup job only deletes, your disk usage will never reflect it.

A dynamic variable can fail silently. innodb_buffer_pool_size is dynamic on modern MariaDB, so I resized it live. No error. The value didn't change. The reason: innodb_buffer_pool_chunk_size read as 0, and resizing works in chunk units. Always read the variable back after you set it — don't trust the absence of an error.

Long-lived MySQL processes bloat. That instance had been up 85 days with a 1 GB buffer pool and was holding 9.8 GB resident, 4.8 GB of it swapped. After a restart with a properly sized pool: 1.96 GB resident, swap essentially empty, and 8 GB handed back to the OS. Per-connection buffers and temp-table churn accumulate; a restart is sometimes the honest fix.

What I'd take away

Sample the process list, don't snapshot it. The dominant query and the slowest query are usually different queries, and the dominant one is what's hurting you.
Using temporary; Using filesort next to a LIMIT 6 is a smell. It means the server built the whole set to return a fraction of it.
Natural language full-text search scales with term length. A search term built from a whole paragraph is a query against a fifth of your table.
Fix the shape before you add cache. Caching this would have hidden it from users while the crawler traffic — cache-missing by construction — kept the CPU pinned.

The bug had been there for a long time. It only became visible when the archive got big enough and the crawlers got busy enough for those two curves to cross.

I build news and e-commerce platforms in PHP at Alesta WEB, an independent software company running since 2005.

Self-Hosted MCP: Building a Model Context Protocol Server in PHP

Mahmut Gündüzalp — Thu, 23 Jul 2026 11:11:26 +0000

Most of the Model Context Protocol tutorials you'll find are written in TypeScript or Python, because those are the languages with official SDKs. That leaves a fair number of us — people maintaining PHP applications that hold years of business data — wondering whether the protocol is even available to us.

It is. MCP is a wire protocol, not a library. If your language can read a line from standard input and write JSON back, you can implement a server in it. This post walks through what the protocol actually asks of you, what a PHP implementation looks like in outline, and — the part I underestimated — what changes when you expose an internal system to a model.

What MCP actually is

The Model Context Protocol is an open standard for connecting AI assistants to external systems: your data, your tools, your APIs. The problem it solves is combinatorial. Before a standard existed, every assistant needed a bespoke integration with every data source. MCP defines one interface so that any compliant client can talk to any compliant server.

Underneath, it's JSON-RPC 2.0. Requests carry a jsonrpc version, a method, a params object, and an id; responses carry the matching id and either a result or an error. Notifications are requests without an id and expect no reply. If you've implemented a JSON-RPC service before, you already know 80% of the transport story.

A server exposes three kinds of primitive:

Tools — actions the model can invoke. Each has a name, a description, and a JSON Schema describing its inputs. This is the primitive that does something: query a database, create a record, send a request. The model chooses when to call them.
Resources — data the model can read, addressed by URI. Files, records, generated documents. These are for context, not action, and the client generally decides what to pull in.
Prompts — reusable prompt templates the user can invoke deliberately, often surfaced in the client's UI as a slash command or menu item.

The distinction between tools and resources matters more than it first appears. A rough rule: tools are model-controlled, resources are application-controlled. If the model should decide whether to fetch something, make it a tool. If the user or the host application decides, make it a resource.

The two transports

MCP defines two standard transports, and picking the right one is the first architectural decision.

stdio. The client launches your server as a subprocess and talks to it over standard input and output — newline-delimited JSON, one message per line. This is the simplest possible setup: no ports, no HTTP server, no authentication layer, because the only thing that can talk to your process is the parent that spawned it. It's the right choice for anything running on the same machine as the client.

Two rules with stdio, both easy to break in PHP:

Never write anything but protocol messages to stdout. A stray echo, a var_dump left in from debugging, or a PHP warning printed to stdout corrupts the message stream and the client will fail to parse it. Send diagnostics to stderr instead, which the client typically forwards to a log.
Turn off output buffering and flush after every write, or your responses sit in a buffer while the client waits.

Streamable HTTP. The server runs as an ordinary HTTP endpoint. The client POSTs JSON-RPC messages to it; the server replies with either a single JSON response or a stream of server-sent events when it needs to push multiple messages for one request. This is the transport for a server that runs somewhere other than the user's machine — which, for most PHP shops, is the interesting case, because that's the deployment model we already know how to operate.

(An older HTTP+SSE transport exists in earlier revisions of the spec. New work should target Streamable HTTP.)

The handshake

Whichever transport you pick, the conversation starts the same way. The client sends initialize with the protocol version it speaks and the capabilities it supports. Your server replies with its own protocol version, its capabilities, and its name and version. The client then sends an initialized notification, and normal operation begins.

Capabilities are how the two sides negotiate. If your server doesn't implement resources, you don't advertise the resources capability, and a well-behaved client won't call resources/list. Don't advertise what you haven't built.

After the handshake, the methods that matter are predictable:

Method	What it does
`tools/list`	Return the tools you expose, with descriptions and input schemas
`tools/call`	Execute one tool with the given arguments, return its result
`resources/list`	Return available resources with their URIs
`resources/read`	Return the contents of one resource
`prompts/list`	Return available prompt templates
`prompts/get`	Return one filled-in prompt

A minimal but genuinely useful server is initialize plus tools/list plus tools/call. Everything else is optional.

What the PHP side looks like

The structural shape, transport-independent:

read a JSON-RPC message
  → dispatch on `method`
  → build a result (or an error)
  → write the response with the same `id`

For stdio, that's a loop over fgets(STDIN), json_decode, a match on the method name, and fwrite(STDOUT, json_encode($response) . "\n"). For Streamable HTTP, it's a single endpoint that decodes the request body and returns the encoded response. The dispatch layer in the middle is identical; only the read and write ends change. Write it that way from the start and you can support both from one codebase.

Three PHP-specific things worth knowing before you start:

Tool schemas. Every tool needs a JSON Schema for its inputs. Hand-writing those as nested arrays gets tedious fast. Deriving them from something you already maintain — a validation ruleset, a DTO, a set of typed constructor parameters read via reflection — keeps the schema and the actual implementation from drifting apart. Schema drift is the single most common cause of "the model keeps calling the tool wrong."

Error handling. Distinguish two kinds of failure. A malformed request or an unknown method is a protocol error: return a JSON-RPC error object. A tool that ran but failed — record not found, validation rejected the input — is a tool error: return a normal result with the error flag set and a human-readable message. The distinction matters because the second kind goes back to the model, which can read the message and adjust. A protocol error just tells it something broke. Convert PHP exceptions into the second kind wherever the failure is something the model could plausibly recover from.

Long-running work. PHP's request-per-process model is a good fit for stdio (the process lives as long as the session) and a slightly awkward one for HTTP if a tool takes minutes. Keep tool calls short. If a tool kicks off something slow, return a job identifier immediately and expose a second tool that reports status. Models handle that pattern well; they handle a request that times out badly.

Connecting it to Claude

Once the server runs, there are three broad ways to reach it.

Local, over stdio. Desktop and CLI clients — Claude Desktop, Claude Code, and various IDE integrations — let you register a server by specifying a command to run and its arguments (php, plus the path to your server script), and they manage the subprocess for you. This is the fastest way to get from "it responds to tools/list" to "I'm using it."

Remote, over HTTP. A Streamable HTTP server deployed at a URL can be registered with clients that support remote connections. The Claude API also has an MCP connector: you declare the server's URL in the request, and the API makes the connection server-side, so the model can call your tools without you writing a client loop. Note that hosted MCP servers generally authenticate with OAuth bearer tokens rather than a service's own native API key — those are different auth systems, and assuming the latter works is a common early stumble.

From your own code. If you're building an agent rather than using an existing client, most AI SDKs can convert MCP tool definitions into their native tool format, so an MCP server becomes a source of tools for a loop you control.

Whichever route, debug over stdio first. The failure modes are simpler: no TLS, no auth, no proxy, no CORS. Get the protocol right, then move it to HTTP.

The part I underestimated: exposure

Here's the thing that changes when you put an MCP server in front of an existing system. Every tool you expose is a capability granted to a model that is, at least in part, steered by text it reads from the outside world. If the model can be persuaded to call your tool, your tool runs.

The practical consequences:

Scope tools narrowly. A generic run_query tool that accepts arbitrary SQL is the most convenient thing to build and the worst thing to ship. Prefer specific tools with typed parameters — find_customer_by_email, list_orders_in_range — and validate every argument server-side as if it came from an anonymous HTTP request. It did, effectively.

Read and write are different risk classes. Read-only tools have a disclosure risk. Write tools have a this actually happened risk. Separate them, and put anything destructive or irreversible behind an explicit confirmation in the host application rather than trusting the model to be careful.

The description is part of the security surface. Tool descriptions are instructions the model reads. A vague description invites the model to call a tool in situations you didn't intend. Being prescriptive about when a tool should be used — not just what it does — measurably improves both correctness and safety.

Don't leak what you didn't mean to expose. Return the fields the task needs, not whole records. An internal note, a cost price, or a personal phone number that shouldn't be in a customer-facing answer shouldn't be in a tool result either. Filter at the server, not in the prompt.

Log every call. Tool name, arguments, caller, outcome. When someone asks "why did it do that," the log is the only answer you'll have.

None of this is exotic — it's the same discipline you'd apply to a public API endpoint. The difference is that the caller is a language model rather than a developer reading your docs, so ambiguity gets resolved in ways you didn't anticipate rather than surfacing as a support ticket.

Worth it?

For a PHP application sitting on years of accumulated business data, MCP is the cheapest bridge I've found between that data and an assistant that can actually reason about it. There's no SDK to wait for. It's JSON-RPC over a pipe or an HTTP endpoint — both things PHP has done well for twenty years.

Start with three read-only tools that answer questions someone in your organization asks weekly. Ship it over stdio to one person. See what they actually ask for. That's a far better spec than anything you'd design up front.

If you've built an MCP server in a language without an official SDK, I'd be curious what tripped you up — the transport, the schemas, or the scoping.

From Generic CMS to Purpose-Built: What 200 Site Migrations Taught Me

Mahmut Gündüzalp — Thu, 23 Jul 2026 11:09:31 +0000

Migrating a live website to a new content management system is one of those jobs that looks like a data transfer and turns out to be an exercise in risk management. The database part is usually the easy half. The hard half is that a working site has years of accumulated meaning attached to it — URLs search engines memorised, editors' habits, a content model that drifted far from whatever it was on day one.

Over the past years I've moved a few hundred sites — mostly news portals and online stores — off general-purpose, plugin-assembled CMS setups onto purpose-built platforms. Some of those migrations were clean. A few taught me things the hard way. This is the accumulated checklist, aimed at anyone about to do their first serious one.

Why sites migrate at all

Nobody migrates a CMS for fun. The trigger is almost always one of four things, and it's worth naming yours honestly before you start, because it determines what "success" means.

Plugin sprawl. A site starts generic and grows domain-specific through add-ons: one plugin for the ticker, one for the photo gallery, one for the ad slots, one for the newsletter, three for SEO. Each one is maintained by a different party on a different release cadence. The site works, but nobody can predict what a routine update will break.

Performance under spikes. A general CMS with fifteen plugins executes a lot of code to render a page that is, semantically, one article. For a news site where a single story can bring 40× normal traffic in ten minutes, that overhead stops being academic.

Editorial friction. This is the one clients articulate least well and feel most. If publishing a story with a photo gallery, a source credit, a related-articles block, and an agency attribution takes eleven clicks across four screens, your newsroom will invent workarounds, and your data model will slowly fill with those workarounds.

Cost of ownership. Ten commercial add-on licences plus a maintenance retainer, renewed annually, forever.

Write your trigger down. If it's performance, you need before/after numbers. If it's editorial friction, you need to time the actual publishing workflow before and after. A migration that can't be measured will be judged on vibes, and vibes after a migration are always bad for the first two weeks.

The part everyone underestimates: URLs

Here is the single highest-risk element of any migration of an established site: the URL is not a detail, it's the asset.

A news site that has been publishing for eight years has tens of thousands of indexed URLs. Some carry external links. Some rank on page one for terms the business depends on. Every one of them that returns a 404 after cutover is value thrown away, and search engines are considerably slower to give it back than they were to take it.

So before touching anything else:

Export the complete URL inventory. Not the sitemap — the sitemap is what the old CMS thinks exists. Pull the real list from server access logs (every distinct path with a 200 in the last 12 months), from the search console's indexed-pages report, and from the database. Union all three. The gap between the sitemap and the logs is routinely 20–30%, and it's where the old, still-ranking content lives.
Classify it. Articles, category pages, tag pages, author pages, static pages, media files, feeds, pagination, and the long tail of oddities — print views, AMP variants, tracking-parameter duplicates, dated archive pages.
Decide the target URL scheme once, on purpose. If the new system can preserve the existing pattern, preserve it. Redesigning URLs "while we're in there" doubles the risk of the migration for aesthetic gain. If you genuinely must change the scheme, you now owe every old URL a permanent redirect.
Build the redirect map as data, not as rules. Regex rules feel elegant and fail silently on the exceptions. A generated lookup table of old path → new path, produced from the actual inventory, is boring and verifiable. You can test all 40,000 entries automatically; you cannot test a regex against the URLs you forgot existed.
Verify with a crawl, not a spot check. After cutover, crawl the full old inventory against the live site and assert: status is 301 (not 302, not 200-with-different-content), the destination resolves 200 in one hop, and no chains or loops exist. Redirect chains are where migrations quietly leak ranking.

The rule I'd tattoo on a junior developer: a migration is not done when the content is moved; it's done when the old URLs still work.

Content models never map one-to-one

The second discovery of every migration is that the old content model is not what the documentation says. It's what editors made it.

You will find, reliably:

A "category" that is actually used as a workflow flag ("Ready", "Legal check").
Three tags that mean the same thing with different capitalisation, plus one with a trailing space.
HTML pasted into a plain-text summary field, because the summary needed a line break in 2019.
Images referenced by absolute URL to the old domain, inside article bodies.
A custom field that is empty on 90% of records and load-bearing on the other 10%.

Two practical responses. First, profile before you map. For every field you intend to migrate, run the actual distribution: how many distinct values, how many nulls, the longest value, how many contain HTML, how many contain absolute URLs. Ten minutes of profiling prevents a mapping decision built on an assumption.

Second, decide explicitly what not to migrate. Migration is the one moment when dropping dead weight is cheap. Fifteen years of unused tags, an abandoned events module, a decade of spam comments — carrying them forward means maintaining them forever. Just make the decision consciously and record it, rather than discovering the loss in month three.

The transformation itself I'd keep as a repeatable, re-runnable script, never a hand-edited dump:

read source record
  → normalise (trim, fix encoding, resolve relative media paths)
  → map fields to target model
  → validate (required fields present, slug unique, dates sane)
  → write, or write to a rejects file with the reason

Re-runnable matters more than it sounds. You will run the migration many times — against a copy, into staging, into a rehearsal, and finally for real. If the process is a script that takes the source and produces the target from scratch, every run is identical and every fix is permanent. If it's a script plus "and then I manually fixed those 40 rows", you have no repeatable process, and the final run will differ from the rehearsal in ways you can't see.

Media is where the disk space and the surprises are

Content rows are small. Media is not, and it's messier:

Files referenced in article bodies by absolute URL — these break the moment the domain or path changes and must be rewritten during transformation.
Orphan files: uploaded, never referenced. Often 30–50% of the media directory.
Referenced files that don't exist. Someone cleaned up a folder in 2021.
Generated thumbnail variants in a naming scheme the new system doesn't share.
Filenames with non-ASCII characters and spaces, which behave differently across filesystems and web servers.

Before the migration, produce two lists: referenced-but-missing (fix or accept — these become broken images), and present-but-unreferenced (usually skip). Never regenerate thumbnails on first request under production traffic; pre-generate them during the migration, or your launch-day load test will be an unintentional one.

Rehearse the cutover, then rehearse it again

The cutover is a sequence of steps under time pressure, which is exactly the condition in which people improvise. So write it down as a runbook with times, owners, and — for each step — the answer to "how do we undo this?"

A workable shape:

T-7 days: full migration into staging with production data. Editors do real work in it for a week. This is the only reliable way to surface editorial-workflow problems, and it's the step most often skipped for schedule reasons.
T-2 days: dry run of the entire cutover against staging, stopwatch running. You now know how long the real one takes. It's always longer than the estimate.
T-1 day: DNS TTL lowered. Content freeze agreed with the newsroom, in writing, with a named person responsible.
T-0: final delta sync (only content created since the main import), switch, smoke tests, redirect crawl.
T+1 hour: the checks below.
T+7 days: daily monitoring of crawl errors and index coverage.

Pick your window by traffic, not by convention. For a news site the quiet hour is usually early morning local time — but check the actual analytics, and check the editorial calendar. Cutting over the night before a major scheduled news event is a self-inflicted wound.

Define the rollback before you need it. What's the trigger (error rate above X, homepage down more than Y minutes)? Who decides? How long does reverting take? A rollback plan that takes four hours isn't a rollback plan; it's a wish. In practice this usually means: keep the old stack running and untouched, switch at the DNS or proxy layer, and don't decommission anything for at least a fortnight.

What to check in the first hour, and the first month

Immediately after cutover, in this order:

Homepage and a sample of article pages return 200 with the right content.
The redirect crawl passes across the full old-URL inventory.
Feeds and the sitemap are valid and reachable; submit the new sitemap.
robots.txt is the production one. (Staging's Disallow: / reaching production is a classic, and it is genuinely expensive.)
Canonical tags and structured data render correctly on article pages.
Search: does querying an old, well-known headline return it?
Publishing works end to end — an editor publishes a real story with an image while you watch.
Analytics and any ad slots are firing.

Then over the following weeks, watch crawl errors (a slow rise in 404s means the URL inventory had gaps), index coverage (a drop means something is deindexing content — check canonicals and robots directives first), server response time under real traffic, and the numbers that justified the migration in the first place.

Expect a short dip in traffic. A one-to-two week wobble while search engines re-crawl is normal even on a clean migration. A sustained four-week decline is not a wobble; it's a bug, and it's nearly always URLs, canonicals, or robots directives — in that order of likelihood.

The things I'd tell myself before the first one

Preserve URLs. Everything else is negotiable.
Profile the real data before mapping it. The schema is a claim; the data is the fact.
Make the migration a re-runnable script, never a manual fix-up.
Rehearse with editors, not just with developers. They will find in one afternoon what a test suite won't find in a month.
Keep the old system alive and reversible for two weeks. It costs a little hosting and buys a lot of sleep.
Measure the thing you migrated for. Otherwise the only feedback you'll get is the first complaint.

None of this is exotic. A CMS migration is mostly the discipline to do unglamorous inventory work before the interesting part, and the honesty to define in advance what "it went wrong" looks like.

If you've done a large migration, I'm curious what bit you that isn't on this list — the failure modes seem to be endlessly inventive.

PHP 8.2 in 2026: Why It's Still the Best Choice for News & E-commerce CMS

Mahmut Gündüzalp — Thu, 02 Jul 2026 13:16:52 +0000

Every year someone announces that PHP is finished, and every year a large slice of the web keeps running on it — including most of the news portals and online stores I work with. That's not nostalgia. After building content and commerce systems for 200+ production sites, PHP 8.2 keeps winning the specific fight that matters for this domain: shipping a stable, fast, server-rendered site that a small team can maintain for years without a rewrite.

This isn't a "PHP is actually cool now" hype piece. It's the concrete reasons a boring, typed, request-per-page runtime is still the right default for news and e-commerce CMS work in 2026 — and the honest places where it isn't.

The workload, not the benchmark

News and commerce sites have a very particular shape:

Read-heavy, cache-friendly. Most visitors are anonymous and see the same article or product page. You want to render HTML on the server, cache it hard, and get out of the way.
Spiky. A breaking story or a campaign can multiply traffic in minutes. The runtime has to degrade gracefully, not fall over.
Long-lived. These sites run for 5–10 years. The team that maintains them in year 6 is rarely the team that built them in year 1.
SEO-critical. For news, Google News and fast Largest Contentful Paint aren't nice-to-haves; they're the business.

PHP's execution model fits this shape almost embarrassingly well. Each request starts clean, does its work, and dies. No long-lived process accumulating memory leaks, no shared mutable state to reason about across requests. For a page that reads from a database, renders a template, and returns HTML, "shared-nothing" is a feature, not a limitation.

What 8.2 actually gave us

The jump from PHP 5.x/7.x thinking to 8.2 changed how these codebases read. A few features carry most of the weight in practice.

readonly properties made value objects trustworthy. In a CMS you pass a lot of small immutable things around — a resolved article, a price with currency, a category node. Being able to say "this cannot change after construction" at the language level removes a whole category of "who mutated this?" bugs.

final class Money
{
    public function __construct(
        public readonly int $amount,      // minor units (kuruş/cents)
        public readonly string $currency, // 'TRY', 'USD'
    ) {}

    public function withVat(int $ratePercent): self
    {
        return new self(
            (int) round($this->amount * (100 + $ratePercent) / 100),
            $this->currency,
        );
    }
}

No setter, no accidental mutation three layers down, and money math stays in integer minor units where it belongs.

Enums (from 8.1, but they land fully in 8.2 codebases) replaced the pile of const STATUS_DRAFT = 0 integers that every legacy CMS drags around. An article status or an order state becomes a real type the IDE and the type checker understand:

enum OrderStatus: string
{
    case Pending  = 'pending';
    case Paid     = 'paid';
    case Shipped  = 'shipped';
    case Refunded = 'refunded';

    public function isFinal(): bool
    {
        return $this === self::Refunded || $this === self::Shipped;
    }
}

Constructor promotion + typed properties cut the ceremony that made older PHP feel heavy. A service class is now mostly signal:

final class ArticleRenderer
{
    public function __construct(
        private readonly TemplateEngine $view,
        private readonly CacheInterface $cache,
    ) {}
}

never return types, readonly classes, and stricter type coercion together mean the type checker catches far more before code ever reaches staging. On a long-lived codebase, that's the difference between refactoring with confidence and refactoring with prayer.

None of these are flashy. Collectively they turn PHP from "scripting language you tolerate" into "typed application language that happens to have the best deployment story on the web."

Server-rendered HTML is a competitive advantage again

For a few years the default answer to "how do I build the frontend?" was a JavaScript SPA. For a news article or a product page, that was almost always the wrong trade. You paid a bundle-size and complexity tax to re-implement, in the browser, the one thing the server already does perfectly: turn data into HTML.

PHP renders HTML on the server as its native act. Pair it with a template engine and a sprinkle of hypermedia-style JavaScript for the genuinely interactive bits (filters, infinite scroll, cart updates) and you get:

First paint that doesn't wait on a JS runtime — good for LCP, good for Google News.
HTML that's fully present for crawlers and AI scrapers without a headless-render step.
A frontend a backend developer can maintain, instead of a second full stack.

The industry rediscovering server-rendered HTML in 2024–2026 was, from a PHP seat, watching everyone walk back to where the language already stood.

Handling the spikes: cache, don't scale

The read-heavy, spiky profile has a well-worn answer in PHP land, and 8.2's execution model makes it clean:

Full-page cache for anonymous traffic. Most visitors on a breaking story are logged out and identical; serve them a cached HTML page and never touch the database.
Opcode + preloading so the framework itself isn't re-parsed on every request.
A cache layer that switches on under load rather than being always-on — normal traffic hits the database for freshness, a spike flips the site into aggressive caching automatically.

Because each request is isolated, there's no warm-up state to protect and no cross-request corruption to worry about when you throw a cache in front. The mental model stays simple, which is exactly what you want at 3 a.m. when a story goes viral.

The maintenance argument nobody puts on slides

The feature that keeps me choosing PHP 8.2 for client work isn't in any release note: you can hand the codebase to a different developer in year 4 and they can be productive in a week.

The request lifecycle is obvious. Request in, response out.
Deployment is rsync and a cache flush, not an orchestration diagram.
The hosting is everywhere and cheap, which matters enormously for regional news sites and small stores.
The type system now documents intent well enough that a newcomer can read a service class and know what it does.

For software that has to outlive its authors, that boringness is the whole point. A clever runtime that only its original author understands is a liability on a 10-year site.

Where PHP 8.2 is not the answer

Being honest keeps this credible. I don't reach for PHP when:

The workload is long-lived and stateful — a websocket server, a real-time collaboration backend, a streaming pipeline. Shared-nothing-per-request is the wrong shape there; that's a job for a long-running process in another runtime.
The product is fundamentally a rich client app — a design tool, an editor with heavy live interaction. That genuinely wants a real frontend stack.
You need CPU-bound number crunching. PHP will do it; it won't be the tool you're happy with.

News and e-commerce CMS work is none of those. It's data-in, HTML-out, cache-heavy, maintained-for-years. That's PHP's home field.

The 2026 verdict

Language choice is a maintenance decision disguised as a technical one. For content and commerce systems, the constraints that actually bite are: fast server-rendered pages, graceful behavior under spikes, cheap ubiquitous hosting, and a codebase a small team can still understand years later. PHP 8.2 — typed, readonly, enum-shaped, opcode-cached — hits every one of those without asking you to be clever.

That's why the sites I build for news and e-commerce still start from PHP 8.2, and why I expect them to still be running, and still be maintainable, long after the next "PHP is dead" post. If you want to see what a modern PHP news and e-commerce stack looks like in production, that's the whole business at alestaweb.com.

Pick the runtime you can still afford to maintain in year six. For this domain, that's still PHP.

Building Newsroom AI Modules in PHP: 50+ Specialized Workflows

Mahmut Gündüzalp — Fri, 26 Jun 2026 08:50:23 +0000

When people picture "AI in a newsroom," they usually imagine one big chat box bolted onto the editor. That's the wrong mental model, and it's the reason most of those features get used twice and then ignored.

A newsroom doesn't have one AI need. It has dozens of small, specific, repetitive ones: write three headline options, pull a 280-character social blurb, suggest a category, tag entities, generate alt text for the lead image, flag a defamation risk, translate the dek into English, propose an SEO title under 60 characters. Each is a tiny job with its own input shape, its own output contract, and its own tolerance for being wrong.

After running this across 200+ news sites, the architecture that actually stuck was not "an AI feature." It was a registry of small, specialized workflows behind a uniform interface. This article is how that's built in PHP, and the handful of decisions that matter more than which model you pick.

The unit of work: a task, not a prompt

The first thing to get right is the boundary. The reusable unit is a task — a named workflow with a fixed contract — not a free-floating prompt string. A task knows three things: what it needs, what it promises to return, and how expensive it's allowed to be.

interface AiTask
{
    public function name(): string;          // 'headline.suggest'
    public function tier(): string;          // 'cheap' | 'standard' | 'premium'
    public function build(array $input): array;   // -> messages for the model
    public function parse(string $raw): array;    // -> validated structured output
}

That parse() method is the part teams skip and regret. A model that returns prose when you expected JSON is not an edge case — it's Tuesday. If every task is responsible for validating its own output, a bad response fails inside the task where you can retry or fall back, instead of leaking malformed data into the editor.

A concrete task looks like this:

final class HeadlineSuggestTask implements AiTask
{
    public function name(): string { return 'headline.suggest'; }
    public function tier(): string { return 'cheap'; }

    public function build(array $input): array
    {
        return [
            ['role' => 'system', 'content' =>
                'You are a Turkish news copy editor. Return exactly 3 headline '
                . 'options as a JSON array of strings. Max 70 characters each. '
                . 'No clickbait, no ALL CAPS.'],
            ['role' => 'user', 'content' => mb_substr($input['body'], 0, 4000)],
        ];
    }

    public function parse(string $raw): array
    {
        $data = json_decode($this->stripFences($raw), true);
        if (!is_array($data) || count($data) < 1) {
            throw new BadOutputException('headline.suggest: not a list');
        }
        return array_slice(array_map('strval', $data), 0, 3);
    }
}

Once you have one of these, you have the shape for fifty. The interesting work isn't writing the fiftieth task — it's the machinery around them.

Why "50+" is an architecture choice, not a brag

The number isn't the point; the granularity is. You could collapse "suggest headline," "suggest SEO title," and "suggest social blurb" into one mega-prompt that returns all three. Don't. Three reasons:

Different cost tiers. A category suggestion can run on a fast, cheap model. A legal-risk flag should not.
Different failure handling. If headline generation fails, you shrug and the editor types one. If entity tagging fails silently, your archive search quietly rots.
Different UX surfaces. The blurb belongs to the social scheduler; the alt text belongs to the image picker. Coupling them in one call couples two unrelated screens.

Small tasks compose. Big prompts calcify.

Here's the rough taxonomy that emerged — grouped, because grouping is how editors actually find them:

Group	Example tasks
Headlines & framing	headline options, SEO title, social blurb, push-notification text
Structure	summary/dek, key-points list, "read more" suggestions
Classification	category suggest, tag/entity extraction, topic clustering
Media	image alt text, caption draft, thumbnail crop hint
Quality & risk	tone check, defamation/risk flag, fact-claim highlighter, profanity filter
SEO & distribution	meta description, schema keywords, related-article linking
Language	translate dek, simplify, localize idiom

That's already 25+ before you count per-language and per-section variants. The registry is what keeps it from becoming chaos.

The registry and the router

The registry is boring on purpose: a name-to-task map. The router is where the one genuinely valuable idea lives — routing by tier, not by vibes.

final class AiRouter
{
    /** @param array<string, AiTask> $tasks */
    public function __construct(
        private array $tasks,
        private ModelGateway $gateway,
        private AiCache $cache,
    ) {}

    public function run(string $taskName, array $input): array
    {
        $task = $this->tasks[$taskName]
            ?? throw new UnknownTaskException($taskName);

        $key = $this->cacheKey($taskName, $input);
        if ($hit = $this->cache->get($key)) {
            return $hit;
        }

        $messages = $task->build($input);
        $raw      = $this->gateway->complete($task->tier(), $messages);

        try {
            $out = $task->parse($raw);
        } catch (BadOutputException $e) {
            // one retry on the next tier up before giving up
            $raw = $this->gateway->complete($this->escalate($task->tier()), $messages);
            $out = $task->parse($raw);
        }

        $this->cache->put($key, $out, $task->ttl());
        return $out;
    }
}

Three things are doing real work here and each earns its place:

Caching by (task, input) hash. The same article body gets a headline suggestion once. Editors click these buttons repeatedly; without a cache you pay for every nervous re-click. This single layer was the biggest cost reduction we measured.
Tier-based escalation on bad output. Cheap model first. If it returns garbage that fails parse(), retry once on a stronger tier. Most cheap-model failures are formatting failures, and they don't repeat on the better model. You get cheap-model economics with premium-model reliability on the tail.
The gateway hides the provider. complete(tier, messages) is the entire surface the task sees. Whether 'cheap' maps to one provider this month and another next month is an ops decision, not a code change in 50 tasks.

The gateway: one seam for every provider

The gateway is what makes provider diversity survivable. News work is bursty and rate limits are real, so you want the freedom to move a tier between providers without touching task code.

final class ModelGateway
{
    public function __construct(private array $tierConfig) {}

    public function complete(string $tier, array $messages): string
    {
        $cfg = $this->tierConfig[$tier];          // provider + model + limits
        $provider = ProviderFactory::make($cfg['provider']);

        return $provider->chat(
            model:    $cfg['model'],
            messages: $messages,
            maxTokens: $cfg['max_tokens'],
        );
    }
}

The payoff is operational, not architectural elegance for its own sake. When a provider degrades at 9 a.m. on an election morning — and it will — you change a config map, not a deployment. Keeping the model identity out of the task and in the tier config is the difference between a five-minute mitigation and a panic.

Quality gates: cheap models lie confidently

A specialized-task design tempts you toward cheap models everywhere, because each job is small. The trap is that small jobs still produce confidently wrong output. The defense is deterministic gates around non-deterministic output — code, not another model, checks the boring constraints.

function validateHeadlines(array $headlines): array
{
    return array_values(array_filter($headlines, function (string $h): bool {
        $len = mb_strlen($h);
        if ($len < 15 || $len > 70)           return false; // length contract
        if ($h === mb_strtoupper($h))          return false; // no ALL CAPS
        if (preg_match('/!{2,}|\?{2,}/', $h))  return false; // no "!!!"
        return true;
    }));
}

Notice there's no model in that function. The expensive judgment ("is this a good headline?") stays with the human editor. The cheap, mechanical judgment ("is this even a valid headline-shaped string?") is plain PHP that runs in microseconds and never hallucinates. Push every constraint you can express as code out of the prompt and into a gate. Prompts are for taste; code is for rules.

The one place to spend a premium model deliberately is risk — defamation, sensitive claims, anything where a wrong call has legal weight. That task should run on your strongest tier, never cache its "looks fine" verdict for long, and always present as advisory to a human. AI flags; people decide.

Asynchronous by default

Editors will not wait four seconds for a button. Anything slower than roughly a second belongs in the background, with the result arriving when it's ready rather than blocking the save.

// On save: enqueue, don't block.
$queue->push('ai.enrich', [
    'article_id' => $id,
    'tasks'      => ['summary.make', 'tag.extract', 'category.suggest', 'seo.meta'],
]);

// A worker drains the queue and writes suggestions back as drafts
// the editor can accept or ignore — never auto-published.

Two rules that saved us real pain:

Suggestions are drafts, never silent writes. AI output lands in a "suggested" state. A human accepts it. The day you let a model write directly to the published field is the day you explain a hallucinated dateline to your editor-in-chief.
Idempotent jobs. Queues retry. If summary.make runs twice, the second run should overwrite the same suggestion slot, not create a duplicate. Key the write by (article_id, task_name).

What I'd tell my past self

Model the task contract first, the prompt second. The interface outlives any specific model.
Validate output inside the task. Malformed responses are normal; treat them as control flow, not exceptions to your worldview.
Route by tier, cache by input. These two together did more for cost and reliability than any prompt-engineering cleverness.
Keep rules in code, taste in prompts. Every constraint you can check deterministically is one the model can't violate.
Async, advisory, idempotent. The newsroom trusts a tool that suggests and never surprises.

The "50+" isn't a feature count to put on a slide. It's what falls out naturally once each AI job is small enough to have a single clear contract. Build the seam — task, registry, router, gateway, gate — and adding the fifty-first workflow is an afternoon, not a project.

We've been refining this pattern in production news software at Alesta WEB, across publishers of very different sizes, and the lesson keeps repeating: the architecture, not the model, is what makes newsroom AI feel reliable instead of gimmicky.

KVKK, İYS, BİK: Turkish Software Compliance for Engineers (with PHP examples)

Mahmut Gündüzalp — Sun, 21 Jun 2026 12:45:03 +0000

If you build software that serves Turkish users, three acronyms will eventually land on your desk: KVKK, İYS, and BİK. They are not optional "nice to have" features — they are legal obligations with real fines attached. Yet most engineering write-ups about them are written by lawyers, for lawyers, and stop exactly where the interesting part begins: the code.

This is the article I wish I had when we first had to make 200+ production sites compliant. It's the engineer's view — what each rule actually requires from your application, and how to implement it cleanly in PHP. The examples are intentionally generic; adapt the storage and framework details to your own stack.

The three you'll meet

Acronym	Full name	What it governs	Who enforces it
KVKK	Kişisel Verilerin Korunması Kanunu	Personal data protection (Turkey's GDPR analogue)	KVKK Authority (KVKK Kurumu)
İYS	İleti Yönetim Sistemi	Commercial electronic messages (SMS/email/calls)	Managed via a central national registry
BİK	Basın İlan Kurumu	Press/news site requirements & official announcements	Basın İlan Kurumu (for news publishers)

KVKK touches almost every app. İYS hits you the moment you send a marketing message. BİK is specific to news publishers. Let's take them in order.

1. KVKK — personal data protection

KVKK shares its DNA with GDPR, so if you've done GDPR work the concepts will feel familiar: lawful basis, explicit consent, data minimization, the right to erasure, breach notification, and registration with a central inventory (VERBİS) once you cross certain thresholds.

The mistakes I see most often are not legal misreadings — they're engineering shortcuts. Three of them matter.

Separate consent from the action

A checkbox that says "I accept the terms and consent to marketing" bundles two different lawful bases. KVKK wants explicit, specific, unbundled consent. In practice that means storing each consent as its own record with enough metadata to prove it later.

// Each consent is its own row — never a single boolean on the user.
function recordConsent(int $userId, string $purpose, bool $granted): void
{
    $stmt = $pdo->prepare(
        'INSERT INTO consent_log
            (user_id, purpose, granted, ip, user_agent, created_at)
         VALUES (:uid, :purpose, :granted, :ip, :ua, :now)'
    );
    $stmt->execute([
        'uid'     => $userId,
        'purpose' => $purpose,                 // e.g. 'marketing_email', 'analytics'
        'granted' => $granted ? 1 : 0,
        'ip'      => $_SERVER['REMOTE_ADDR'] ?? '',
        'ua'      => substr($_SERVER['HTTP_USER_AGENT'] ?? '', 0, 255),
        'now'     => date('Y-m-d H:i:s'),
    ]);
}

The point of the ip, user_agent, and timestamp is not surveillance — it's that when someone asks "did this user actually consent, and when?", you can answer with evidence instead of a shrug. Consent is also revocable, so you append a new granted = 0 row rather than mutating the old one. The history is the proof.

The cookie banner has to actually block scripts

A banner that loads Google Analytics and the Meta pixel before the user clicks "accept" is theatre. Under KVKK (as under GDPR) non-essential trackers must not fire until consent exists. The cleanest implementation is to gate the script tags server-side:

function trackingScripts(int $userId): string
{
    if (!hasConsent($userId, 'analytics')) {
        return ''; // nothing loads, no third-party calls
    }
    return '<script src="/js/analytics.js" defer></script>';
}

If your analytics is purely first-party and aggregated (no cross-site identifiers, no PII), you have a much easier compliance story — which is one practical reason a lot of Turkish products lean toward self-hosted, first-party analytics.

Erasure means erasure (but keep the legal minimum)

The right to be forgotten collides with other obligations: you may be legally required to keep invoice and transaction records for years. The resolution is anonymization, not blind deletion. Strip the identifying fields, keep the financially/legally required skeleton.

function eraseUser(int $userId): void
{
    // Anonymize, don't orphan: invoices must survive for tax law.
    $pdo->prepare(
        "UPDATE users SET
            name='[deleted]', email=CONCAT('deleted_', id, '@invalid'),
            phone=NULL, address=NULL, anonymized_at=:now
         WHERE id=:id"
    )->execute(['now' => date('Y-m-d H:i:s'), 'id' => $userId]);

    // Hard-delete things with no retention requirement.
    $pdo->prepare('DELETE FROM consent_log WHERE user_id=:id')
        ->execute(['id' => $userId]);
}

Decide your retention periods deliberately, document them, and make them queryable. "We delete logs after N days" is a sentence you want to back with a cron job, not a hope.

2. İYS — the commercial message registry

İYS is the part that surprises foreign engineers. In Turkey there is a central national registry for commercial electronic message consent. Before you send a marketing SMS, email, or call to someone, their consent must exist in that registry — and your own database agreeing isn't enough on its own.

The engineering consequence: never send marketing straight from your app's consent table. You check İYS first. Transactional messages (order confirmations, password resets, shipping updates) are exempt — but the line between "transactional" and "marketing" is exactly where people get fined, so be conservative.

function canSendMarketing(string $recipient, string $channel): bool
{
    // 'channel' is one of: MESAJ (SMS), EPOSTA (email), ARAMA (call)
    $status = iysLookup($recipient, $channel); // calls the registry/integrator API

    // Only an explicit, active opt-in counts.
    return $status === 'ONAY';   // vs 'RET' (rejected) or 'ALICI_YOK' (unknown)
}

function sendCampaign(array $recipients, string $channel, string $message): void
{
    foreach ($recipients as $r) {
        if (!canSendMarketing($r, $channel)) {
            logSkipped($r, 'no_iys_consent');
            continue;            // skipping is cheaper than a fine
        }
        dispatch($channel, $r, $message);
    }
}

Two practical notes from running this at scale:

Sync both directions. When a user opts in or out in your UI, push that change up to the registry. When the registry changes (a user opts out there), pull it down. A nightly reconciliation job catches drift.
Cache lookups, but not forever. Hammering the lookup API per-recipient on a large campaign is slow and rude. A short-TTL cache (hours, not weeks) keeps you fast without letting stale "ONAY" values send messages to someone who opted out this morning.

3. BİK — for news publishers

If you don't run a news site, skip this section. If you do, BİK compliance is what stands between you and being eligible for official announcements (resmî ilan) and the credibility that comes with it.

BİK's requirements are more editorial than algorithmic, but several do translate into application features:

Mandatory imprint (künye): publisher identity, responsible editor, contact, and address must be present and reachable. This is a structured page, not a footer afterthought.
Source attribution (mahreç): agency-sourced content must be labelled with its origin. If you ingest from news agencies, carry the source field through your pipeline to the rendered article.
Content cadence & originality: a minimum flow of original editorial content, which in practice means your CMS needs solid authorship, scheduling, and audit metadata.
Archive integrity: published pieces should remain accessible and stable at their URLs.

The imprint and source-attribution pieces are the ones that bite teams late, because they're easy to bolt on at the end and easy to get subtly wrong. Model them as first-class fields from the start:

// Carry the source through to render — don't lose it in the import step.
function renderArticleMeta(array $article): string
{
    $out = '<div class="article-meta">';
    $out .= '<span class="author">' . e($article['author_name']) . '</span>';
    if (!empty($article['source_agency'])) {
        $out .= '<span class="source">Kaynak: '
              . e($article['source_agency']) . '</span>'; // mahreç
    }
    $out .= '<time datetime="' . e($article['published_at']) . '">'
          . e(formatTr($article['published_at'])) . '</time>';
    return $out . '</div>';
}

This is the kind of requirement that pushed our news CMS work toward treating source, author, and publish metadata as non-negotiable columns rather than optional extras — it's far cheaper than retrofitting attribution across an archive later.

A checklist you can paste into a ticket

[ ] KVKK: consent stored per-purpose, with timestamp + evidence, revocable as an append
[ ] KVKK: non-essential trackers gated server-side, fire only after consent
[ ] KVKK: erasure = anonymize-and-retain-legal-minimum, with documented retention periods
[ ] KVKK: VERBİS registration checked against your data-controller thresholds
[ ] İYS: registry lookup before every marketing send; transactional messages clearly separated
[ ] İYS: two-way sync (UI ⇄ registry) + nightly reconciliation + short-TTL cache
[ ] BİK: structured imprint (künye) page, reachable
[ ] BİK: source attribution (mahreç) carried end-to-end from import to render
[ ] BİK: stable article URLs and accessible archive

Closing thought

None of this is exotic engineering. It's mostly the discipline of modeling consent and provenance as data you can prove, not state you assume. Do it at the schema level on day one and compliance becomes a property of the system. Bolt it on at the end and it becomes a migration you'll dread.

We've shipped this pattern across 200+ Turkish production sites at Alesta WEB, and the single biggest lesson is the boring one: make consent and source first-class data, and the legal requirements mostly take care of themselves.

This is general engineering guidance, not legal advice — confirm specifics for your situation with a qualified professional.

How We Reduced LLM Costs by 95%: Cache + Batch + Cascade in PHP

Mahmut Gündüzalp — Sat, 13 Jun 2026 11:10:36 +0000

How We Reduced LLM Costs by 95%: Cache + Batch + Cascade in PHP

We build news software — a content platform used by more than 200 publishers at Alesta WEB. Once we wired language models into the newsroom workflow (headline suggestions, summaries, SEO fields, tag extraction, draft scaffolding), something predictable happened: the AI bill started growing faster than the feature list.

The naive version of "add AI" is a thin wrapper around one expensive frontier model, called fresh on every request. It works in a demo. In production, across thousands of articles a day, it's a slow way to set money on fire.

This is the architecture we settled on after eighteen months of running it. Three layers — cache, batch, cascade — plus the quality gates that make the cheap layers safe to rely on. The result was roughly a 95% reduction in per-task cost versus the naive "frontier-model-only, no cache" baseline, with no measurable drop in editorial quality.

The code is PHP, because the platform is PHP. The ideas are language-agnostic.

1. The Naive Approach (and What It Costs)

Here's the version almost everyone ships first:

function generateHeadline(string $articleBody): string
{
    $response = $client->chat([
        'model'    => 'gpt-4o',
        'messages' => [
            ['role' => 'system', 'content' => 'You write concise news headlines.'],
            ['role' => 'user',   'content' => $articleBody],
        ],
    ]);

    return $response['choices'][0]['message']['content'];
}

Nothing is wrong with this code. The problem is the usage pattern around it:

The same wire-service story gets posted by dozens of sites, so we generate near-identical headlines over and over.
Editors regenerate three or four times to compare options.
A frontier model is doing work — extracting tags, normalizing a category — that a model costing a fraction as much would do just as well.
Every call is synchronous and real-time, even when nothing about the task is urgent.

When you multiply "fresh frontier call every time" by real newsroom volume, the per-article AI cost lands somewhere that makes the CFO ask uncomfortable questions. Each of the three layers below attacks one of those waste sources.

2. Layer 1 — Cache: What to Cache, and What Not To

The single biggest win is the most boring one: don't ask the same question twice.

A large share of LLM calls in a news system are functionally identical. The key insight is that the cache key should be derived from the meaningful inputs — the task type, the model, the prompt template version, and a normalized hash of the content — not from the raw request object.

function cachedComplete(string $task, string $content, callable $compute): string
{
    $key = sprintf(
        'llm:%s:%s:%s',
        $task,
        PROMPT_VERSION[$task],          // bump to invalidate on prompt change
        hash('xxh128', normalize($content))
    );

    $hit = $cache->get($key);
    if ($hit !== null) {
        return $hit;                    // ~0 cost, sub-millisecond
    }

    $result = $compute($content);       // the actual API call
    $cache->set($key, $result, ttlFor($task));
    return $result;
}

function normalize(string $s): string
{
    // collapse whitespace, strip volatile boilerplate so trivially
    // different inputs map to the same key
    return trim(preg_replace('/\s+/u', ' ', $s));
}

Two details matter more than the cache engine you pick (we use Redis, but a database table works):

Version the prompt in the key. When you change a prompt template, you want every cached answer for that task to become a miss. Putting a PROMPT_VERSION constant into the key turns prompt edits into a clean, instant invalidation instead of a stale-output bug you chase for a week.

Know what not to cache. Anything personalized, anything real-time, anything where two identical inputs should legitimately produce different outputs (a "give me a fresh alternative" button) must bypass the cache. We mark those tasks explicitly rather than relying on TTL alone.

In our workload the cache hit rate sits around 60–70%, mostly because syndicated content repeats across sites. That one layer alone removes well over half the spend.

3. Layer 2 — Batch APIs: Trade Latency for Money

A surprising amount of LLM work in a newsroom is not time-sensitive. Nightly re-tagging of the archive. Generating summaries for the previous day's articles. Backfilling SEO descriptions on older content. None of it needs an answer in 800 milliseconds.

The major providers offer batch endpoints that run asynchronously — you submit a file of requests, and within a window (typically up to 24 hours) you get the results back, at roughly half the price of the synchronous API.

// Collect non-urgent jobs into a single batch submission
$lines = [];
foreach ($pendingJobs as $job) {
    $lines[] = json_encode([
        'custom_id' => $job->id,
        'method'    => 'POST',
        'url'       => '/v1/chat/completions',
        'body'      => [
            'model'    => $job->model,
            'messages' => $job->messages(),
        ],
    ]);
}

$batchFile = uploadJsonl(implode("\n", $lines));
$batch     = $client->batches()->create([
    'input_file_id'     => $batchFile['id'],
    'endpoint'          => '/v1/chat/completions',
    'completion_window' => '24h',
]);

// A worker polls for completion and writes results back by custom_id
$queue->later('poll_batch', ['batch_id' => $batch['id']], minutes: 15);

The discipline this forces is healthy: you have to classify each task as interactive (editor is waiting) or deferred (a cron job can handle it tonight). Once we did that audit, far more work turned out to be deferrable than we expected. Roughly a quarter of our remaining spend — after caching — moved onto batch pricing for a flat ~50% discount on that slice.

A caveat: batch pricing differs by provider, and so does the completion window and the failure behavior. Build your batch layer behind an interface so the provider is swappable, and always handle partial failures — a batch of 5,000 requests will occasionally return 4,997.

4. Layer 3 — Cascade Routing: Match the Model to the Task

The last layer is the one people resist, because it feels like cutting corners. It isn't — it's refusing to pay frontier prices for kindergarten work.

Not every task needs the smartest model. Extracting tags from a story, mapping a category, cleaning up whitespace, classifying sentiment — small, cheap models handle these perfectly. Reserve the expensive model for genuinely hard generation: nuanced summaries, editorial rewriting, anything where a mistake is visible to readers.

const TASK_TIER = [
    'tag_extraction'   => 'cheap',
    'category_map'     => 'cheap',
    'sentiment'        => 'cheap',
    'summary'          => 'mid',
    'headline'         => 'mid',
    'editorial_rewrite'=> 'frontier',
];

const TIER_MODEL = [
    'cheap'    => 'gpt-4o-mini',
    'mid'      => 'gpt-4o',
    'frontier' => 'the-strongest-model-you-trust',
];

function modelFor(string $task): string
{
    return TIER_MODEL[TASK_TIER[$task] ?? 'mid'];
}

We run six providers behind one interface (the editorial team never sees which one answered), which means cascade routing can also fail over: if a cheap model's output fails a quality gate, the task is automatically re-run one tier up. That gives you the cost of the cheap tier on the 90%+ of cases it handles well, and the safety of the expensive tier on the cases it doesn't.

Cascade routing is what takes you from "big savings" to "almost free for the easy majority."

5. Quality Gates: Keeping Cheap Models Honest

Cascade routing only works if you can detect when a cheap model got it wrong — otherwise you're trading money for garbage. Quality gates are cheap, deterministic checks that run on the output before it's accepted:

function passesGate(string $task, string $output): bool
{
    return match ($task) {
        'headline' => mb_strlen($output) <= 90
                      && !str_contains($output, "\n")
                      && !looksTruncated($output),

        'summary'  => mb_strlen($output) >= 100
                      && sentenceCount($output) >= 2,

        'tag_extraction' => isValidJsonArray($output),

        default    => $output !== '',
    };
}

None of these call an LLM. They're string length, format validity, structure checks — the kind of thing that costs nothing and catches the most common cheap-model failures (truncation, wrong format, empty output). When a gate fails, the cascade re-runs the task one tier up and logs it. If a particular task fails its gate too often, that's your signal to move it up a tier permanently.

This is the piece that makes the whole architecture trustworthy. Without gates, "use a cheaper model" is a gamble. With gates, it's a measured decision with an automatic safety net.

6. A Cost Dashboard You Actually Look At

You can't optimize what you don't measure. We log every LLM call with four fields: task, tier, whether it was a cache hit, and the token counts. That's enough to answer the only questions that matter:

Which task is costing the most? (Usually the surprise here is a "cheap" task being called a million times.)
What's our real cache hit rate, per task?
How often is the cascade escalating — and which tasks?

A weekly rollup of per-task economics turns cost control from a panic ("the bill doubled!") into a routine ("tag extraction escalation rate crept up, the prompt drifted, fix the template"). The dashboard is boring on purpose. Boring means in control.

7. The Numbers, After Eighteen Months

Against the naive baseline (one frontier model, every call fresh and synchronous), the layers compound:

Cache removes ~60–70% of calls outright.
Batch takes ~50% off a meaningful slice of what remains.
Cascade routes the easy majority of the rest to models costing a fraction of frontier prices.

Stacked, that lands at roughly 95% lower per-task cost for the same workload — and, because cache hits are instant and cheap models are fast, the median latency for AI features actually improved. Cheaper and faster, which is not the trade-off people expect when they hear "we cut the AI budget."

The editorial quality held because the expensive model still does all the work that's actually hard; we just stopped paying it to do the easy work.

8. What's Next: Prompt Caching

The newest lever we're rolling out is provider-side prompt caching — where a long, stable system prompt (style guide, formatting rules, examples) is cached on the provider's side and billed at a steep discount on repeat calls. For a news system with a large, rarely-changing editorial style prompt prepended to thousands of calls, that's a natural fit on top of the three layers above.

The throughline across all of it is the same: a language model is a power tool, not a default. Cache the repeats, defer what isn't urgent, route easy work to cheap models, and verify cheap output with checks that cost nothing. Do that, and AI features stop being a line item that scares the finance team and go back to being what they should be — a feature.

We build news software used by 200+ publishers — agency integration, AI-assisted editorial workflows, native mobile apps, and subscription infrastructure. More on the platform at alestaweb.com.

Schema.org NewsArticle: A Complete Implementation Guide for Google News in 2026

Mahmut Gündüzalp — Sun, 31 May 2026 23:00:47 +0000

Schema.org NewsArticle: A Complete Implementation Guide for Google News in 2026

Most news sites that fail to get into Google News don't fail because of their content. They fail because their structured data is wrong, incomplete, or missing — and nobody told them, because the failure is silent. No error, no email, just no traffic.

This is a field guide to getting NewsArticle structured data right. It comes from running it across 200+ production news portals over the last 18 months at Alesta WEB, where a single malformed datePublished field can quietly drop a story out of the news index for a publisher who has no idea why.

I'll cover every field that matters, the publisher markup that ties it together, the news sitemap's brutal 48-hour window, how AMP and canonical interact in 2026, IndexNow for instant Bing/Yandex pickup, and the validation pipeline we run before anything ships.

1. Why Structured Data Matters Beyond Google

It's tempting to think of NewsArticle JSON-LD as "the thing Google wants." It is, but that framing undersells it.

Structured data is now the machine-readable contract for your content across the entire discovery layer: Google News and Top Stories, Bing News, the knowledge graphs that feed voice assistants, and — increasingly — the LLMs that summarize current events. When a model is asked "what happened in city X today," it leans on sources whose articles are cleanly typed, dated, and attributed. Ambiguous HTML doesn't get parsed reliably. Clean JSON-LD does.

So the payoff isn't one channel. Getting NewsArticle right is the cheapest single thing you can do to make a story legible to every automated consumer at once.

2. NewsArticle: Every Field That Matters

Here is a complete, valid NewsArticle block. I'll annotate the fields that people get wrong.

<script type="application/ld+json">
{
  "@context": "https://schema.org",
  "@type": "NewsArticle",
  "mainEntityOfPage": {
    "@type": "WebPage",
    "@id": "https://example.com/news/city-council-approves-budget"
  },
  "headline": "City Council Approves 2026 Budget After Three-Hour Debate",
  "image": [
    "https://example.com/img/budget-16x9.jpg",
    "https://example.com/img/budget-4x3.jpg",
    "https://example.com/img/budget-1x1.jpg"
  ],
  "datePublished": "2026-06-01T08:30:00+03:00",
  "dateModified": "2026-06-01T09:15:00+03:00",
  "author": {
    "@type": "Person",
    "name": "Ayşe Yılmaz",
    "url": "https://example.com/author/ayse-yilmaz"
  },
  "publisher": {
    "@type": "NewsMediaOrganization",
    "name": "Example Daily",
    "logo": {
      "@type": "ImageObject",
      "url": "https://example.com/logo-600x60.png",
      "width": 600,
      "height": 60
    }
  },
  "description": "The council passed the budget 7-4 after debate over transit funding.",
  "articleSection": "Local",
  "inLanguage": "en"
}
</script>

The fields people break, in order of how often I see them broken:

datePublished without a timezone. This is the number one cause of silent failure. "2026-06-01T08:30:00" is ambiguous. Google may interpret it as UTC, your server may mean local time, and the gap can push a story outside the freshness window or make it look hours old at publication. Always include the offset: +03:00, Z, whatever is correct — but never omit it.

dateModified going backwards or matching publish exactly forever. If you genuinely edit an article, update dateModified. But don't fake it by bumping it on every page load — Google notices articles whose modification date changes without content changing, and it erodes trust. Set it when the content actually changes.

headline over 110 characters. Google truncates and may ignore long headlines for Top Stories. Keep it under 110 characters. This is a hard, documented limit, not a suggestion.

image with a single small image. Provide multiple aspect ratios (16x9, 4x3, 1x1) at a minimum width of 1200px. A 600px-wide thumbnail disqualifies you from large image treatment in Top Stories.

author.url missing. An author object with just a name is weak. Give every author a real, crawlable profile page and link it via url. This is also an E-E-A-T signal — the author needs to be a verifiable entity, not a string.

3. NewsMediaOrganization: The Publisher Half

The publisher inside each article should be a NewsMediaOrganization, and that organization should also exist as a standalone entity on your home page or a dedicated /about page. The two reinforce each other.

<script type="application/ld+json">
{
  "@context": "https://schema.org",
  "@type": "NewsMediaOrganization",
  "name": "Example Daily",
  "url": "https://example.com",
  "logo": {
    "@type": "ImageObject",
    "url": "https://example.com/logo-600x60.png",
    "width": 600,
    "height": 60
  },
  "sameAs": [
    "https://twitter.com/exampledaily",
    "https://www.facebook.com/exampledaily"
  ],
  "diversityPolicy": "https://example.com/diversity-policy",
  "ethicsPolicy": "https://example.com/ethics-policy",
  "masthead": "https://example.com/masthead"
}
</script>

The logo constraints trip people up: it must be a raster format (PNG/JPG, not SVG), no wider than 600px, and no taller than 60px. The ethicsPolicy, diversityPolicy, and masthead properties are optional but they are genuine trust signals for news specifically — having real pages behind them helps with Google News eligibility reviews.

One rule we enforce in production: the publisher name and logo must be byte-identical across every article and the organization entity. Inconsistency here — "Example Daily" in one place, "ExampleDaily" in another — is read as two different publishers.

4. Sitemap-news.xml: The 48-Hour Window

A news sitemap is not a regular sitemap. It only lists articles published in the last 48 hours, and it carries extra <news:news> metadata.

<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
        xmlns:news="http://www.google.com/schemas/sitemap-news/0.9">
  <url>
    <loc>https://example.com/news/city-council-approves-budget</loc>
    <news:news>
      <news:publication>
        <news:name>Example Daily</news:name>
        <news:language>en</news:language>
      </news:publication>
      <news:publication_date>2026-06-01T08:30:00+03:00</news:publication_date>
      <news:title>City Council Approves 2026 Budget After Three-Hour Debate</news:title>
    </news:news>
  </url>
</urlset>

Two things make or break this:

Drop articles older than 48 hours. Leaving stale URLs in the news sitemap is a quality signal against you. The sitemap must be generated dynamically and prune itself. We regenerate ours on publish and on a short cron, never as a static file.

news:publication_date must match datePublished. Same timezone, same value. If your JSON-LD says one time and your sitemap says another, you've told Google two contradictory things about the same article.

5. AMP vs Canonical in 2026

This used to be a real decision. In 2026 it mostly isn't.

Google dropped the AMP requirement for Top Stories back in 2021, and Core Web Vitals became the actual gate. If your canonical pages are fast — good LCP, low CLS, responsive — you do not need AMP to appear in Top Stories. We removed AMP from most sites and saw no ranking loss, plus we deleted an entire parallel rendering path and its bugs.

The honest guidance:

Default: ship fast canonical HTML, no AMP. One source of truth, less to maintain.
Keep AMP only if you have a specific downstream consumer that still requires it, or your canonical pages genuinely can't hit good Core Web Vitals and you can't fix the root cause.

If you do serve both, the canonical page must point to itself with rel="canonical", and the AMP page must point back to the canonical with rel="canonical". Getting that backwards is a common way to deindex your real pages.

6. IndexNow: Instant Pickup on Bing and Yandex

Google still crawls on its own schedule. Bing and Yandex, however, accept a push: IndexNow lets you notify them the instant an article goes live, instead of waiting for a crawl.

The setup is trivial. Host a key file at your root, then POST URLs on publish:

# 1. Host the key at https://example.com/<key>.txt containing just the key
# 2. On every publish, ping:
curl "https://api.indexnow.org/indexnow?url=https://example.com/news/city-council-approves-budget&key=<key>"

Or submit a batch as JSON:

{
  "host": "example.com",
  "key": "your-key-here",
  "urlList": [
    "https://example.com/news/article-1",
    "https://example.com/news/article-2"
  ]
}

For a news site where being first matters, the minutes you save on Bing/Yandex indexing are real. We wire IndexNow into the same publish hook that regenerates the news sitemap — one event, both actions.

7. A Validation Pipeline That Catches Errors Before Deploy

Hand-checking structured data doesn't scale past a few articles. Across hundreds of sites it has to be automated, and it has to run before content reaches users.

What our pipeline checks on every article render in staging:

JSON-LD parses. A trailing comma silently disables the whole block. Parse it as JSON; fail the build if it throws.
Required fields present. headline, image, datePublished, author, publisher — assert each exists and is non-empty.
datePublished has a timezone offset. Regex-reject any ISO timestamp without Z or ±HH:MM.
headline ≤ 110 characters.
image width ≥ 1200px (check the actual asset, not just the URL).
Publisher name/logo match the canonical organization entity.
Sitemap date == JSON-LD date for the same URL.

A minimal version of check 3, the highest-value one:

function assertHasTimezone(string $iso): void
{
    if (!preg_match('/(Z|[+\-]\d{2}:\d{2})$/', $iso)) {
        throw new RuntimeException("datePublished missing timezone: $iso");
    }
}

Beyond the build, use Google's Rich Results Test and the schema.org validator on a sample of live URLs weekly. The build catches structural errors; the external validators catch the rules Google changes without announcing.

8. Passing vs Failing: A Side-by-Side

Failing markup — and why:

{
  "@type": "NewsArticle",
  "headline": "City Council Approves The 2026 Municipal Budget After A Long And Contentious Three-Hour Public Debate Session",
  "datePublished": "2026-06-01 08:30:00",
  "author": "Ayşe Yılmaz",
  "image": "https://example.com/thumb.jpg"
}

Four problems: headline over 110 chars, datePublished with no timezone and a space instead of T, author as a bare string instead of a Person object with a URL, and a single thumbnail-sized image. Each one individually can keep this out of Top Stories.

Passing markup is the full block from section 2: typed author with a profile URL, ISO-8601 date with offset, headline under the limit, and multiple large images. The difference between these two blocks is the difference between being indexed and being invisible.

Wrapping Up

NewsArticle structured data isn't glamorous, but for a news publisher it's the highest-leverage SEO work there is. The content is yours to write; the markup is what makes machines trust it.

Get the five required fields right, give every date a timezone, keep your news sitemap pruned to 48 hours, push to IndexNow on publish, and validate before you deploy. Do that consistently and the silent failures stop being silent — they stop happening.

If you run a single site, do this by hand once and template it. If you run many, build the validation pipeline first. We learned the hard way that across 200+ portals, the cost of one wrong datePublished format multiplied by every article is a traffic problem you'll spend weeks tracing back to one missing +03:00.

Haber yazilimi, haber scripti, haber sistemi: ayni urun, uc ayri arama niyeti

Mahmut Gündüzalp — Tue, 26 May 2026 00:50:55 +0000

TL;DR

Turkce yazilim pazarinda haber yazilimi, haber scripti ve haber sistemi terimleri cogunlukla ayni urunu tanimlar: bir haber portalini yoneten icerik yonetim sistemi. Vurgu farklidir, paket icerik ayni olabilir. Bu yazi uc terim arasindaki ince farki, yayincilarin hangisini ne zaman aradigini ve modern bir haber CMS'inde olmasi gereken ozellikleri anlatir.

Neden bu kadar cok terim?

Turkce arama davranisi yabanci dillerden farklidir. Ingilizcede "news CMS" veya "news publishing platform" dominanttir. Turkcede ayni urun icin uc ayri Google sorgusu yapilir:

Sorgu	Aylik Trafik (kabaca)	Niyet
haber scripti	~2.000	Kod tabanli paket arayan
haber yazilimi	~1.500	Butuncul cozumu arayan
haber sistemi	~700	Kurumsal yayin sistemi arayan

Uc terim de pratikte ayni tedarikciye yonelir, ama yayincilar urunu farkli adlandirir.

Uc terim arasindaki ince fark

Haber scripti

Mevcut bir altyapidan baska bir altyapiya gecmek isteyen yayincilarin terimidir. "X haber scripti satin aldim, ozellestirdim, sunucuya yukledim" tarzi kullanim. PHP/MySQL ile yazilmis, kod tabanini gormek, ozellestirmek isteyen IT departmanlarinin/teknik sahiplerin tercihi.

Haber yazilimi

Yeni bir haber portali kurmak isteyen yayincilarin terimidir. Sadece kod degil, paket (mobil uygulama, sunucu, kurulum, destek, egitim) dahil. Genelde son musteri (yayinci) terminolojisi.

Haber sistemi

Cok yazarli, cok rolu, surec yonetimi gerektiren kurumsal yayinlarin terimidir. Editor onayi, yetkilendirme matrisi, raporlama, istatistik bekleyen yayinlar "haber sistemi" der. Buyuk yayin kuruluslari ve kurumsal sirketler bu terimi tercih eder.

Hangisini ne zaman aramaliyiz?

Yeni bir yayin acacaksam        -> haber yazilimi (butuncul paket)
Mevcut yayinda kod degistirecegim -> haber scripti (kod tabani)
Kurumsal yayin yonetecegim      -> haber sistemi (operasyonel iskelet)

Uc senaryoda da musterinin aradigi ozelliklerin %90'i ayni tedarikci tarafindan ayni paketle saglanir.

Modern bir haber CMS'inde olmasi beklenen ozellikler

Yayincilarin 2026 sonrasinda bekledigi temel modullerin listesi:

Icerik

Cok tipli icerik: haber, video, galeri, makale, etkinlik, podcast, biyografi, vefat ilani
Ajans entegrasyonu: AA, DHA, IHA, ANKA, THA, HIBYA, IGFA, BHA gibi haber ajanslarindan otomatik haber cekme
AI ile icerik uretimi: GPT, Gemini, Claude, DeepSeek, Groq gibi modeller ile haber yazma, baslik onerme, ozetleme

SEO ve gorunurluk

Google News uyumu: sitemap-news.xml, NewsArticle Schema
AMP destegi: Hizli mobil gorunum
AI Overview optimizasyonu: FAQPage Schema, llms.txt, ai-sitemap.xml
IndexNow API: Anlik indeksleme (Bing + Yandex)

Mobil

Native uygulama: iOS + Android (kurulum + uygulama magazasi yayini dahil)
PWA destegi: Offline okuma
Push bildirim: OneSignal veya benzeri

Operasyonel

Cok yazarli panel: Editor, yazar, yonetici rolleri
Abonelik / Paywall: Premium icerik kapatma (iyzico, PayTR vb. odeme)
Reklam yonetimi: AdSense, banner pozisyonlari
Newsletter / E-bulten

Performans ve guvenlik

Cache katmanli: Redis + dosya cache + CDN
Gorsel optimizasyon: WebP otomatik donusum, lazy loading
Guvenlik: CSRF, XSS, IP banlama, rate limiting
SSL/TLS: Let's Encrypt veya benzeri

Karar matrisi

Yayinciliga baslayacak biri tedarikci sectiginde bakmasi gerekenler:

Ihtiyac	Bakilacak ozellik
Yerel haber portali	Haber ajansi entegrasyonu + reklam
Kurumsal yayin	Cok yazar yonetimi + raporlama
Yuksek trafik	Cache + CDN + mobil
Premium icerik	Abonelik / Paywall modulu
Google News basvurusu	NewsArticle Schema + sitemap-news
AI ile icerik uretimi	Coklu AI saglayici destegi

Lisans modelleri

Pazarda iki ana lisans modeli vardir:

Tek seferlik lisans: Bir kerelik odeme, kaynak kod erisimi, surekli kullanim hakki. Uzun vadede daha ekonomik.
Aylik abonelik (SaaS): Sunucu + yazilim + destek paket halinde aylik odeme. Daha az baslangic maliyeti.

Buyuk yayinlar genelde tek seferlik lisansi tercih eder cunku ozellestirme ve kontrol istemektedir. Kucuk/orta yayinlar baslangic maliyeti dusuk oldugu icin SaaS modellerini secebilir.

Sik sorulan sorular

S: Ucretsiz haber scripti var mi?
C: Acik kaynak haber scriptleri vardir ama kurumsal yayinlar lisansli paketi tercih eder cunku haber ajansi entegrasyonu, AI modulleri ve uzun vadeli destek gerekir.

S: Hangi sirket en iyi haber yazilimini sunar?
C: Yayinin buyuklugune ve ozelliklerine gore degisir. Onemli olan tedarikcinin ozellestirme yapabilmesi, ajans entegrasyonuna sahip olmasi ve uzun vadeli destek vermesidir. Alesta WEB 2005ten beri bu pazarda hizmet veren bagimsiz tedarikcilerden biridir.

S: Mobil uygulama haber yaziliminin parcasi mi?
C: Modern haber yazilimlari iOS/Android native uygulama veya en az PWA olarak gelir.

S: Haber sitesi acmak icin SEO ne kadar onemli?
C: Hayati. Yayinin %60+ trafigi organik aramadan gelir. NewsArticle Schema, sitemap-news, AMP ve Google News uyumu olmazsa olmaz.

Sonuc

Turkcede "haber yazilimi", "haber scripti" ve "haber sistemi" terimleri ayni urunu uc ayri arama niyetiyle tanimlar. Yayincinin niyeti farkli olsa da tedarikci genelde ayni paketi sunar. Tedarikci secerken paketin sundugu modullerin (haber ajansi entegrasyonu, AI ile icerik, mobil uygulama, SEO, paywall) ihtiyaca uygunluguna bakmak gerekir.

Detayli karsilastirma ve canli demo icin: Alesta WEB Haber Scripti veya Haber Yazilimi Pillar Sayfa

Kaynak: Alesta WEB - 2005ten beri haber yazilimi, e-ticaret yazilimi ve kurumsal web cozumleri.

Turkish E-commerce: Why Local POS Integration Beats Stripe (Most of the Time)

Mahmut Gündüzalp — Sun, 24 May 2026 11:33:36 +0000

Turkish E-commerce: Why Local POS Integration Beats Stripe (Most of the Time)

If you're an English-speaking developer building e-commerce in any market, your default payment integration is Stripe. It's a great default. It's documented, it's fast to integrate, it has SDKs for every language, and the API surface is among the cleanest in the industry.

It's also the wrong default if your customers live in Turkey.

This is a write-up of what we learned running 200+ production e-commerce sites in Turkey over the last 18 months: why Stripe alone doesn't cut it, what the local payment landscape actually looks like, the unified interface pattern we use to manage 15+ bank gateways from a single PHP codebase, and the cost numbers that justify all the extra engineering work.

1. The Stripe Assumption (And Why It Breaks Here)

Stripe operates in Turkey. You can technically take TRY payments through Stripe. So why isn't that the end of the story?

Three reasons, in order of weight:

Reason 1: Transaction fees compound. Stripe charges around 1.4% + ₺1.40 per successful card transaction in TRY, with currency conversion and cross-border markups stacking on top in some flows. A native bank virtual POS gateway typically charges 0% transaction fee — the bank takes its cut from the merchant agreement at the bank level, not per-transaction. For a store doing ₺2M/year in volume, that's roughly ₺28,000/year that doesn't have to leave the merchant.

Reason 2: Installments (taksit) are a feature, not a payment method. Turkish consumers expect to see "3 ay taksit ile ₺X" alongside every product price. Installment plans are negotiated between the merchant and the issuing bank — each bank has its own installment rules, its own commission tiers, and its own "premium" cards that get extended installments. Stripe has no equivalent surface for this. You can simulate installments with a recurring subscription, but that's not what customers see at checkout, and conversion drops accordingly.

Reason 3: TRY-native ledger. Stripe settles internationally; even when collecting in TRY, the reconciliation layer is built around a multi-currency model that assumes you'll eventually want to convert. Most Turkish merchants want a Turkish lira ledger that matches their e-fatura (e-invoice) records line-for-line, with VAT broken out the way GİB (Turkish tax authority) expects it. Native bank POS does this natively.

The combined effect: Stripe works, but it bleeds money on transaction fees, kills your installment funnel, and adds a reconciliation step that your accountant doesn't want.

2. The Local Payment Landscape

Here's the actual list of payment surfaces a serious Turkish e-commerce store needs to support, at minimum:

Tier-1 bank virtual POS (direct integration with the issuing bank):

Garanti BBVA
İş Bankası
Akbank
Ziraat Bankası
Halkbank
VakıfBank
Yapı Kredi
TEB
DenizBank
QNB Finansbank

Tier-2 payment aggregators (one integration, many banks underneath):

iyzico (Visa-owned, biggest player)
PayTR
Param
Moka
Paycell (Turkcell)
Sipay
Hepsipay (Hepsiburada-owned)

Tier-3 alternative methods:

Papara (Turkish digital wallet)
BKM Express (interbank wallet)
Apple Pay / Google Pay (over local processors)
Cash on delivery (still ~15% of orders in some categories)
Bank transfer with auto-matching (havale eşleştirme)

That's 15+ direct gateways and at least 5 alternative payment surfaces. Realistically, a mature Turkish store integrates 5-8 of these — but the engineering problem is that any one of them might be the cheapest path on a given transaction, depending on the buyer's card BIN and the merchant's bank agreement.

3. The Interface That Unifies Them All

The architectural problem looks scary the first time you face it: 15 different APIs, 15 different XML/JSON formats, 15 different 3-D Secure callback patterns, 15 different error code sets, 15 different "test card" lists.

The solution we converged on (and which I'd recommend to anyone hitting this problem) is the classic adapter pattern: one interface, one set of value objects, one error taxonomy. Each gateway gets an adapter class.

interface PaymentGatewayInterface
{
    public function getCode(): string;
    public function getDisplayName(): string;

    public function preparePayment(PaymentRequest $req): PaymentPrepared;

    public function handleThreeDSCallback(array $callback): ThreeDSResult;

    public function captureAuthorized(string $txRef, Money $amount): CaptureResult;

    public function refund(string $txRef, Money $amount, ?string $reason = null): RefundResult;

    public function getInstallmentOptions(string $cardBin, Money $amount): array;
}

The PaymentRequest value object normalizes the input across all gateways: card BIN, amount in TRY minor units, installment count, merchant order reference, return URLs, customer billing address. Same call signature, regardless of which bank is on the other end.

Each adapter implementation translates this normalized request into whatever the bank expects — usually XML over HTTPS for tier-1 banks, JSON for aggregators, sometimes WSDL/SOAP for legacy stacks. The translation layer is the boring part. The interesting part is the next section.

4. 3-D Secure Callback: Handling 15 Different Protocols

3-D Secure is a regulatory requirement on most card transactions in Turkey since 2020. The flow looks the same from the customer side — you redirect to the bank, the customer enters an SMS code, they redirect back — but the integration side varies wildly.

Concrete differences across providers:

Callback method: POST vs GET vs both. iyzico does POST. Some legacy banks do GET. Some do POST but expect you to verify a hash on the next page load.
HMAC verification: SHA1, SHA256, SHA512, sometimes a custom hash with secret prefix. Order of fields in the hash payload matters and isn't always documented.
Status field naming: mdStatus, status, result, tdStatus, auth_result — different vocabulary, sometimes different value sets.
Status semantics: "1" can mean "3-D Secure success, proceed to auth" on one gateway and "fully authorized, capture done" on another. Confusing the two will silently capture funds without finishing 3-D, which is a compliance violation.

The pattern that saved us was a per-gateway ThreeDSValidator class that returns a normalized ThreeDSResult enum:

enum ThreeDSOutcome:
  AUTHORIZED            // captured, money on its way
  AUTHENTICATED_ONLY    // 3-D passed, auth still pending
  CHALLENGE_REQUIRED    // friction beyond 3-D (rare)
  REJECTED              // explicit fail
  TIMEOUT               // no response, treat as fail
  TAMPER_DETECTED       // HMAC failed, log + alert

The order routing layer doesn't care which bank just called us back. It cares only about which of those six outcomes happened. That decoupling is the single most valuable thing in the whole stack — it means adding a new gateway is a 200-line adapter and a test fixture, not a redesign.

5. Real Cost Comparison: Stripe vs Native (3-Year Data)

Numbers from a representative mid-sized merchant in our portfolio. Online fashion, ~₺3.2M annual volume, average basket ₺240, ~13,300 orders/year. Card mix: 78% Turkish-issued credit, 18% Turkish debit, 4% international.

Scenario A — Stripe-only:

Transaction fee: 1.4% + ₺1.40 on Turkish cards (after volume discount). Roughly ₺44,800 + ₺18,620 = ₺63,420/year in transaction fees.
Foreign cards (4%, ~₺128k volume): 2.9% + ₺2 = ₺3,712 + ₺1,064 = ₺4,776
Installment funnel: not available natively. Either skipped (conversion drops ~12-18% on baskets over ₺1,000) or hacked via off-platform subscription (compliance grey area).
Reconciliation: TRY/USD ledger split, manual e-invoice mapping.

Scenario B — iyzico + 4 direct bank gateways (Garanti, İş, Akbank, Ziraat):

Aggregator fee on iyzico-routed transactions (~30% of volume): 2.4% blended ≈ ₺23,040/year
Direct bank fees on routed transactions (~70% of volume): 0% transaction, bank takes monthly fixed fee ≈ ₺18,000/year total across 4 banks
Installment funnel: full native, all banks expose their installment offers
Reconciliation: TRY-native, line-for-line with e-arşiv records
Total: ₺41,040/year

Difference: ₺27,156/year in direct fees, plus the conversion lift from installments — which on this volume mix is worth roughly another ₺180-220k in additional revenue.

The catch is the engineering investment. Building and maintaining the gateway layer is real work — call it 60-80 engineering days for the first build, plus 10-15 days/year of maintenance as banks shuffle their APIs. For merchants under ~₺1M annual volume, Stripe is genuinely the right call: the savings don't outrun the engineering cost. Above that line, native wins, every time.

6. When Stripe Still Wins

Honest take: there are still cases where Stripe is the right answer even in Turkey.

You sell mostly to non-Turkish customers in TRY (export-heavy stores, language schools selling to expats). Stripe's multi-currency surface is genuinely useful, and you don't need installments.
You're pre-product-market-fit. Don't sink 60 days into a payment layer when you're not sure anyone wants to buy. Ship with iyzico (one integration, decent coverage) and migrate later if volume justifies it.
You operate B2B with invoice-based settlement. Card transactions are a tiny fraction of revenue; the payment gateway is not your bottleneck.
You're on a serverless/SaaS PHP-incompatible stack where the maintenance overhead of bank adapters falls on a team that doesn't have Turkish-language docs comprehension. Hiring local engineers for that is more expensive than the fees.

For everyone else — every Turkish-market store with national reach and >₺1M volume — local POS is not optional. It's table stakes.

7. Conclusion: Local Fintech Isn't Optional

The mistake we made early on was treating Turkish payments as "Stripe with a TRY currency code." That mental model produces a working store and a slowly bleeding P&L. The right mental model is: this is a market with its own payment culture, its own regulatory frame, and its own gateway ecosystem, and the engineering effort to plug into it is one of the highest-ROI investments a Turkish e-commerce engineering team can make.

If you're starting fresh, build the adapter layer from day one even if you only ship with one gateway initially. The interface costs almost nothing to write up front. Retrofitting it later — when your order layer has direct calls to iyzico_client->charge() scattered across 40 files — is the part that's painful.

For more on the broader Turkish e-commerce engineering stack (CMS, bot integrations, AI cost optimization), see my earlier post on building a multi-LLM news CMS and the React-to-HTMX migration writeup. Same production stack, different surface.

Working on Turkish e-commerce or news CMS infrastructure? I run Alesta WEB, an Şanlıurfa-based software shop building this kind of platform for the Turkish market since 2005. Happy to compare notes.