Hi everybody!
I'm modelling an application that interacts with a sql database. A db gui handles all the events concerning the database. I'm thinking about having a temp database where I store data before inserting it into the main database. There will be alot of different activities in the database so I don't want to store data straight into the main database during day time.

So my question is if anyone have done something like this before and might confirm if it is a good idea or bad. Is there a known way to deal with this?

User gui -> DB gui -> Temp db - > Main db


thanx alot
Pete