News for hackers. Stuff that matters.
Re:SQLite 3.8.0 Release with next-generation query planner by nraynaud on Tuesday August 27, 2013 @02:48AM (#6281877)
The stuff that would get rid of the SQL injection, is the database API, removing the general purpose query(string) function. And forcing some structure on the parameters. First a little breaking to get the easy injections out, and progressively forcing the whole host language mapping of the query, including the result schema. People will scream about the debugging, but they will gain a little bit of stuff in exchange (like projection in a variable, where clause re-use etc).

There are no comments on this comment yet.