Have some shell scripts working with sqlite. Receiving incoming payments from bank via HTTP API and pushing it into database. This script will start periodically, every single hour.
Want to prevent situation only few payments are written and script failed for some reason. Have read about sqlite transactions and understood so I should start every writing sequence with BEGIN; statement, than made all inserts and than COMMIT; statement. Is this all how it is working? Should I do something more to prevent such unwanted situation? thanks, L.
