Write the event with the data. Never split them.
Two writes that should succeed together will eventually fail separately.
Your order service saves the order to the database, then publishes an order.created event to a message broker.
One database or a real search stack
The real argument is not whether PostgreSQL can search text or whether Elasticsearch can store documents. Both can. The interesting question is where search complexity should live.
Production AI systems depend on far more than models and prompts.
Databases, APIs, licenses, and self-hosting
Strapi 5.60, Directus 12.6, and Payload 3.92 still separate the editor from the site, but the databases, licenses, and deploy steps in older tutorials no longer match. Checked 01/11/2026.
Quick reference to postgresql
A quick reference for day‑to‑day PostgreSQL work: connections, SQL syntax, psql meta-commands, performance, JSON, window functions, and more.
Essential SQL commands and operations
Here’s a concise SQL cheatsheet covering the most essential commands and operations:
