Use transit engine vs DB backend. What is more secure?

What is the difference between store a secret in Vault (using a DB backend) and use the transit secret engine and doing the DB insert in another application?
Is a secret stored by Vault more secure?

Of course, pressuming all the traffic between Vault, App and DB is secure.