GET/blog
Notes
Programming, economics and fintech: my personal, subjective takes.
- Uzbek football, 22 November: Neftchi host Al-Hilal tomorrow, title trophy heads to Fergana on 28 NovemberNeftchi face Al-Hilal in the ACL Elite on 23 November, and the league says the Superliga trophy will be at Istiqlol Stadium on 28 November. Wins for Nasaf and Sogdiana; the U-17s meet Jamaica tomorrow.Football
- Salary on any card: Uzbekistan's central bank launches a Funds Distribution Center — registries, digital signatures and engineering questionsSince 18 November, private-sector employees can receive pay on a card or e-wallet of their choice. How the system works, what is still unclear, and what payment-system developers should prepare for.Fintech
- Don't take a webhook at its word: HMAC signatures, replay protection, duplicates and a queueYour provider sends the same event three times, sometimes out of order, and sometimes it wasn't the provider at all. A step-by-step guide to receiving webhooks in Django and Celery safely and with exactly-once effects.Programming
- In their file, not in our database: daily payment reconciliation against the provider and the bankThe provider paid out, the total doesn't match your database — which payment is it? Daily reconciliation on Django and PostgreSQL: mismatch kinds, safe auto-closing, the ledger and alerts.Fintech
- Uzbek football, 21 November: Navbahor delay Neftchi's title, U-17s lose to Côte d'IvoireNavbahor beat Neftchi 3-2 in the valley derby, so the title race goes to the final rounds. Lokomotiv edged Pakhtakor 2-1 and the U-17s lost 2-1 to Côte d'Ivoire.Football
- Uzbek football, 20 November: Neftchi can clinch the title in Namangan, U-17s face Côte d'IvoireA Neftchi win over Navbahor, combined with Pakhtakor failing to win, would settle the Superliga title early. Tonight Uzbekistan's U-17s open their World Cup.Football
- Uzbek football, 19 November: U-17 World Cup begins, Fayzullayev suffers ankle injuryThe U-17 World Cup is under way in Qatar, with Uzbekistan facing Côte d'Ivoire tomorrow. Abbosbek Fayzullayev has a right ankle injury, and Superliga Round 28 starts today.Football
- SHA-256 won't save your passwords: salt, pepper, Argon2id and Django's automatic rehashingWhy do "hashed" passwords from a leaked table get cracked within hours? Slow hash functions, Django's PASSWORD_HASHERS, wrapping legacy hashes, brute-force limits and constant-time comparison.Programming
- You logged out, the token didn't: sessions vs JWT, refresh tokens and revocationA JWT with a valid signature gets accepted even after "log out of all devices". How sessions and JWTs work inside, refresh token rotation, denylists, token versions and where to store tokens, with Django code.Programming
- What really happens inside 'Sign in with Google': OAuth 2.0, OpenID Connect and PKCEAn email or token arriving at your backend is not proof. The Authorization Code + PKCE flow, access token vs ID token, and verifying an ID token in Django properly: signature, aud, iss, exp.Programming
- Uzbekistan's central bank: 278.3bn soums lost to card fraud in nine months, malware APKs top the case countCardblock data for 1 January–1 October shows 113.1bn soums blocked. What the numbers say and what payment engineers should take from them.Fintech
- Uzbek football, 18 November: Esanov double beats Saudi Arabia, women's team open campUzbekistan beat Saudi Arabia 2-1 in Doha with both goals from Sherzod Esanov, their first win over the Saudis since 2015.Football
- The 403 is gone, the hole remains: CSRF vs CORS and why you need bothCORS doesn't stop a request, it only hides the response from the script. How SameSite, CSRF tokens, the Origin check and preflight work, and how to set up CSRF_TRUSTED_ORIGINS and django-cors-headers in Django without opening a hole.Programming
- Uzbek football, 17 November: Saudi Arabia friendly tonight, U-20s beat Venezuela 5-2, Guliston stadium works stallUzbekistan play Saudi Arabia in Doha at 20:30 tonight, with sources split on Shomurodov's involvement. The U-20s beat Venezuela 5-2, while Guliston's stadium is behind schedule.Football
- Uzbek football, 16 November: Saudi Arabia friendly in Doha tomorrow, Abdumajidov to join BrestUzbekistan face Saudi Arabia in Doha on 17 November. Pakhtakor defender Muhammadrasul Abdumajidov becomes a Brest player from 1 January, and Neftchi could clinch the Superliga title as early as 20 November.Football
- "200 OK" with an error inside: status codes, RFC 9457 problem+json and API error design in DjangoThe client never saw "success": false and showed a green checkmark. When to use 400/401/403/404/409/422/429, problem+json, field-level validation errors, and one exception handler that never leaks internals.Programming
- Uzbek football, 15 November: Neftchi beat Bunyodkor 4-0 in the fog and edge closer to the titleNeftchi beat Bunyodkor 4-0 in a rearranged game to go five points clear of Pakhtakor. Plus reactions to the Russia friendly and tomorrow's U-20 game.Football
- Uzbek football, 14 November: Neftchi v Bunyodkor in Fergana, U-20s draw 2-2 with VenezuelaSuperliga leaders Neftchi host Bunyodkor tonight in a rescheduled Round 26 game. Uzbekistan's U-20s drew 2-2 with Venezuela, and the U19 championship reaches the quarter-finals.Football
- Uzbek football, 13 November: from 2-0 up to 2-3 down against Russia, FIFA ranking slipsUzbekistan led Russia 2-0 in Tashkent but lost 3-2 after a Komlichenko brace and a Miranchuk winner. Next up: Saudi Arabia in Doha on 17 November.Football
- Uzbek football, 12 November: Russia in Tashkent tonight, women's team drawn with Japan and Australia in Olympic qualifyingUzbekistan host Russia at Pakhtakor tonight at 20:00 without the injured Khusanov. The women's team was drawn with Japan, Australia and Chinese Taipei in LA 2028 qualifying.Football
- The migration that froze the site: lock queues, NOT VALID, CONCURRENTLY and the two-deploy ruleEven a one-millisecond ALTER TABLE can stall every request. Which DDL locks what, and how to add NOT NULL columns, build indexes and drop columns in Django without downtime.Programming
- Crédit Mutuel Arkéa cyberattack: about €100m taken from the bank's own account via a provider's platformThe French bank confirmed an attack that entered through a third-party provider, moved money from its own account and converted it to crypto. The bank says customer assets are unaffected.Fintech
- Idempotency keys: how a lost response turns into a double charge, and how to stop itThe response got lost, the client retried, and the customer paid twice. Idempotency-Key, a PostgreSQL unique constraint and one transaction make retries safe: a full Django implementation, compared with Stripe's approach.Fintech
- One key expires, a thousand queries hit the database: Redis caching patterns, TTL and cache stampedeWhat happens in the second a hot cache key expires, and how to tame it: cache-aside, write-through, jitter, locks, XFetch early refresh and invalidation in on_commit.Programming
- TBC Uzbekistan Q3: net profit down 61%, NPL at 11.8%, while payments grew 46.5%TBC Uzbekistan's Q3 net profit fell to GEL 15.9 million and its NPL ratio reached 11.8%. What it means for digital lending, regulation and engineers building credit systems.Fintech
- Cache invalidation: the key was deleted, the page still shows the old priceWhy deleting the cache in post_save puts the old price right back, how on_commit fixes it, generation keys for whole groups, and what to do about local caches in 12 workers.Programming
- When a Celery task runs twice: acks_late, retries and idempotent tasksA worker died mid-deploy and the customer got the cashback twice. When Celery sends the ack, how retries work, and what it takes for a task to survive being run again.Programming
- Transactional outbox: the order committed, the event vanishedWriting to the database and then publishing to a broker is a write to two systems, and if the process dies in between, the event silently disappears. Here's how an outbox table, a SKIP LOCKED relay and an idempotent consumer close that gap.Programming
- When the balance column lies: a double-entry ledger in PostgreSQL and DjangoA single balance column can't tell you where money came from or where it went. Accounts, entries and postings, debit = credit enforced by a PostgreSQL trigger, reversals and snapshots: an honest ledger in Django.Fintech
- Coinbase wins final OCC approval for a national trust bank: federal custody, no depositsThe OCC gave Coinbase National Trust Company final approval on November 6. It is a federal framework for institutional custody, not a retail bank, and a bankers' lawsuit against the OCC is ongoing.Fintech
- Uzbek football, 11 November: Guliston win First League, Russia arrive in Tashkent without Golovin and OsipenkoGuliston beat Qoraqalpog'iston FA 4-0 to win the First League final, while Russia have lost Osipenko and Golovin ahead of the 12 November friendly in Tashkent.Football
- Uzbek football, 10 November: Tajik referee for the Russia friendly, Pro League season endsTajik referee Gulmurodi Sa'dullo will take charge of Uzbekistan vs Russia (12 Nov, 20:00) as Shomurodov joins the camp. The Pro League season is over and the play-off schedule is out.Football
- Uzbek football, 9 November: Cannavaro names 30 for Russia friendly, Khusanov left outCannavaro has named a 30-man squad for the November camp, with Khusanov left out to continue his recovery. In Superliga Round 27, Neftchi beat OKMK with a 98th-minute winner.Football
- Uzbek football, 8 November: Nasaf women reach AFC quarter-finals, Lokomotiv win 3-1 in AndijanNasaf's women beat Kaya FC-Iloilo 4-0 to reach the AFC Women's Champions League quarter-finals. In Superliga matchday 27, Lokomotiv won 3-1 at Andijon and Navbahor extended their unbeaten run to 15.Football
- Uzbek football, 7 November: Cannavaro dreams of the Italy job, Dinamo beat SogdianaFabio Cannavaro told Sky Sport Italia he dreams of one day coaching Italy. The U-17s beat Lokomotiv 4-1 and Dinamo won 3-1 in Zomin.Football
- Uzbek football, 6 November: Khorazm beat Bunyodkor for the first time, Karpin on the Tashkent friendlyKhorazm won 2-1 away at Bunyodkor in Superliga Round 27, their first-ever win over them. Karpin called the Uzbekistan friendly an achievement for Russia.Football
- Uzbek football, 5 November: Nasaf come from 0-2 down to win in Kuwait, Russia friendly time setNasaf came from 0-2 down to beat Kuwait SC 3-2 in the AFC Champions League Two, with Abdixoliqov scoring twice. Uzbekistan host Russia in Tashkent on 12 November at 20:00.Football
- Binance resumes withdrawals after $6.3bn hack: a 20-minute attack and lessons for payments engineersAfter the record 29 October attack, Binance reopened withdrawals in phases from 1 November, with $3.64bn in net outflows on day one. What it teaches about hot wallets, limits and production access.Fintech
- OFFSET 200,000: why page 10,000 is slow and how keyset pagination fixes itOFFSET still reads every row it skips and shifts your pages whenever new rows arrive. Keyset pagination on (created_at, id), base64 cursors, the real cost of COUNT(*), and a complete Django implementation.Programming
- Uzbek football, 4 November: UFA denies Cannavaro exit, Nasaf play in KuwaitThe UFA has denied reports that Fabio Cannavaro is leaving the national team, saying his contract stands. The Russia friendly is on 12 November at 20:00, and Nasaf visit Kuwait SC tonight.Football
- Uzbek football, 3 November: Asian Cup moved to December 2027, Pakhtakor beaten 2-6 by Al NassrThe AFC has moved the Asian Cup to 23 December 2027 – 21 January 2028. In the ACL Elite, Pakhtakor lost 2-6 at home to Al Nassr and Neftchi drew 2-2 with Tractor.Football
- Connection pooling: "too many clients", CONN_MAX_AGE, the psycopg pool and PgBouncerYou scaled from 4 pods to 16 and PostgreSQL answered "too many clients". Why a connection is expensive, how Django manages it, and when you need CONN_MAX_AGE, the psycopg pool or PgBouncer.Programming
- 0.1 + 0.2 ≠ 0.3: storing money as Decimal and minor units, rounding, and the lost tiyinMoney stored as float drifts by a few cents by month end. How Decimal and minor units work, when HALF_UP and banker's rounding disagree, and how to split fees without losing a cent, with a Django model.Fintech
- MVCC and VACUUM: you deleted the rows, the table didn't shrinkIn PostgreSQL an UPDATE writes a new row and a DELETE erases nothing. A look under the hood at dead tuples, bloat, autovacuum, and how one forgotten transaction bloats the whole database.Programming
- Uzbek football, November 2: Pakhtakor host Al-Nassr without Ronaldo, Shomurodov hits eighth goalPakhtakor host an Al-Nassr side without Ronaldo, Coman and Simakan in the ACL Elite tonight, while Neftchi face Tractor in Muscat. In the Superliga, Navbahor won the derby against Andijon.Football
- Race conditions and select_for_update: two requests, one last ticketTwo requests read the same stock and sell the last ticket twice. Atomic UPDATE with F(), select_for_update, nowait, skip_locked, deadlocks and optimistic locking with a version column, explained from inside PostgreSQL.Programming
- Five central banks agree to link QR payment systems: a mechanism by end-2026, no launch date yetThe central banks of Uzbekistan, Kazakhstan, Kyrgyzstan, Tajikistan and Azerbaijan will design a way to link their national QR systems by year-end. What it means for users, merchants and payment engineers.Fintech
- Uzbek football, October 31: Pakhtakor win 121-minute thriller in Urgench, Ronaldo's Tashkent trip in doubtPakhtakor beat Xorazm 1-0 in Super League Round 26 after a late VAR-disallowed equaliser. Sports.uz reports Al-Nassr left Ronaldo out of the squad for Tashkent.Football
- Uzbek football, 30 October: U-15s finish 42nd at FIFA festival, Bahodir Ahmedov back in charge of futsal teamUzbekistan's U-15s finished 42nd of 189 at the FIFA festival, and Bahodir Ahmedov is the new futsal head coach. Pakhtakor host Al Nassr on 2 November.Football
- Isolation levels: five anomalies in two psql windows and the 50,000 that vanishedBoth requests committed, no errors, and part of the money is gone. We reproduce every anomaly from dirty read to write skew in two psql sessions and retry serialization failures properly in Django.Programming
- Uzbekistan's central bank approves national payment switch rules: som payments move to one infrastructure from 25 January 2027The regulation sets out participants, net clearing, liquidity tools and a 30-working-day onboarding process. Here is what it means for engineers building payment systems.Fintech
- N+1 in Django: one page, 500 queries — select_related, prefetch_related and counting queriesThe page is instant on your laptop and crawls in production, because the template quietly hits the database on every row. How to find N+1, lock the fix in with a test, and when to reach for select_related versus prefetch_related.Programming
- Uzbek football, October 29: Nasaf lose to Kuwait SC, U-15s beat Guatemala 4-1Nasaf fell 1-0 at home to Kuwait SC for a second straight ACL Two defeat, while Uzbekistan's U-15s beat Guatemala 4-1 in Baku.Football
- About 10 banks queue for Islamic licences in Uzbekistan: why compliance is the real filter and what it means for engineersAccording to @bnn_uz, about 10 banks have applied for an additional Islamic finance licence. What the rules require, who got the first licence, and what core banking teams will need to rethink.Fintech
- Average 7.3 million, median 4.2 million: Uzbekistan publishes its first median wageUzbekistan's statistics committee has published a median wage for the first time. What the number shows, why it can't be compared directly with the average, and what it has in common with p50 latency.Economics
- PostgreSQL indexes and EXPLAIN ANALYZE: reading 400,000 rows to show 20There is an index, yet the biggest merchant's dashboard is still slow. How to read an EXPLAIN ANALYZE plan, what's inside a B-tree, and how one composite index fixes the query, with real plans.Programming
- Hi! What this blog is about and what's coming every dayOne deep backend or fintech article every day, plus a take on fintech news every other day. The plan for the first weeks and how to follow along.Thoughts