Supplier currency, selling currency and settlement currency are rarely the same. How to store money correctly, snapshot exchange rates, apply markup and rounding, handle refunds and keep FX exposure visible in a travel platform.
Vector search powers RAG and semantic search, but the database choice is often overstated. How to decide between an extension on your existing database and a dedicated vector engine, and what actually drives retrieval quality.
MySQL can carry serious transactional workloads when it is used well. A practical sequence for scaling: query and index design, connection management, read replicas, safe schema changes, partitioning and archiving.
Shared tables, schema per tenant or database per tenant? A practical guide to multi-tenant SaaS data isolation, tenant context, noisy neighbours, customisation and how to move between models as you grow.
