I'm about to create a parent and child table. In planning how to do CRUD operations on this data, I was wondering what is better design when it comes to deleting data.
I'm using SQLite. I know that with many databases, you can set up cascading deletes. Assuming I set up the relationships properly to support this type of feature, my question is as follows:
Is it better to use cascading delete feature when deleting parent records, or could I stick to using transactions, and manually delete from the parent/child tables myself, with rollbacks when something fails?
The front end is a web application. Any suggestions / articles you can point me to would be great.