Programming

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.