This is the situation. I'm in doubt where to integeate some functions for taking user input which then must be transfered in the production database.
I usually tend put everything in frontend application so database can be just a database, no other functions except storing and fetching data on demand.
I'm writing application for warehouse department and I need to integrate some business rules into new information system and I need some opinios before proceeding further.
So... what is the question exactly?
It sounds like you need a middle tier. But you really ought to be ask a question here rather than use us as a sounding board.
Sorry, I ment
Is better to use local application function like read_data() which will check if user has entered data correctly or is better to transfer data check to database software ?
Data check on database can be very unproducitve and balance between performance and security is big issue. Local application can be issue of SQL injection.
So I wanna know from other more advanced users what they think.