Does Singlestore support transactions?
Yes, Singlestore supports transactions. You can use BEGIN to start a new transaction and COMMIT or ROLLBACK the transaction at its end.
Transactions are also supported in Singlestore's extensibility language where you can manually control the transaction flow using the BEGIN, COMMIT, and ROLLBACK commands.
NOTE: Most of the database clients allow you to use the auto-commit feature and open a new transaction automatically. Check your client reference manual for the exact behavior and auto-commit configuration.
From our documentation: