Are you aware associated with a SQLite options (Portable/flatfile based/serverless) which have foreign key constraint and/or offer transaction support?

By version 3.6.19, SQLite supports foreign key constraints.

And so far as Yes, it already supports transactions? What have you are thinking about?