Are there other consumers — a showcase or a website that needs to quickly provide data on available stocks?

For quick data retrieval of stock levels for a storefront or website, it is important to ensure low latency and high availability. Typically, caching and fast data storage are used for this purpose.

Possible approaches:

• In-memory cache (e.g., Redis) for instant access to current stock levels.
• CQRS approach: a separate read service optimized for fast queries, which receives updates from the main database through events.
• Use of specialized databases with fast read capabilities (e.g., key-value stores).

In Go, a separate service with REST/GRPC API can be implemented, which accesses the cache and updates data asynchronously when changes occur in the main system.

This approach allows serving a large number of requests with minimal delay, without overloading the main database.