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

Would there be downsides, and what would they be, to using a SQLite like database (Cloudflare's D1 for example) vs PostgreSQL for Kratos in production ?

I guess it would be the same downsides for any usecase with SQLite vs PostgreSQL.

generally with SQLite you will have issues with scaling, concurrency and maybe other stuff(?)

SQLite is mostly for quick testing; I am not sure if we have tested it for production use as well.

Maybe someone out there runs Kratos with SQLite without issues, but I haven't heard about it :thinking_face: