If you're going to use a database that does not support these features then you should come up with a data model that does not rely on them. For example, inste

If you're going to use a database that does not support these features then you should come up with a data model that does not rely on them. For example, instead of applying a bank account transfer as a database transaction that debits one account record and credits another, you create a new transaction record (account transaction, not database transaction.) Then account balances are a sum over these transaction records.