New topic: Where to put your Database code??
<http://forums.realsoftware.com/viewtopic.php?t=33602> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message frankvanolffen Post subject: Where to put your Database code??Posted: Thu Apr 29, 2010 6:04 pm Joined: Wed Mar 26, 2008 6:48 pm Posts: 36 Hallo Everybody, Where to put your database code because if you put to much code the possibility is that you get a memory overload. So do you put it in the app window or in the window where you need your code or somewhere else? Greetings Frank. Top brisance Post subject: Re: Where to put your Database code??Posted: Thu Apr 29, 2010 8:40 pm Joined: Tue Oct 06, 2009 2:38 am Posts: 218 From a security standpoint, as much as possible, try to have the SQL code on the server and call them using stored procedures or triggers. So your own code just calls the stored procedure on the server. Where this is not possible, one must validate user input to minimize the risk of SQL injection attacks. _________________ Mike Ash: Getting Answers Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
