Ory is the largest open source community in the world for cloud software application security. We maintain advanced open source security software solving authentication, authorization, access control, application network security, and delegation. Ory implements a variety of industry and best-practice standards including OAuth 2.0 / OAuth 2.1, OpenID Connect, Zero Trust Networking, Google Zanzibar Policy Framework, FIDO2 U2F, WebAuthn, TOTP, and more.

Ory Community

what are the drawbacks running kratos with sqlite vs postgresql for example?

Hi <@U04FQJP7N6B> 
Reliability and tooling. PostgreSQL is designed to handle large amounts of data and the tooling built around it is better. E.g monitoring

Am not an db expert but personally I would switch to postgres once in production with actual customers.
For niche or personal projects SQLite is fine IMO