Whoops! Missed the list on that one. Agreed, though. I think prepare statements should be on the todo list. And next...the WORLD! Keep rocking.
-Andrew Peace On Tue, Aug 18, 2009 at 1:12 PM, Oleg Broytmann<p...@phd.pp.ru> wrote: > On Tue, Aug 18, 2009 at 12:50:29PM -0400, Andrew Peace wrote: >> I don't get in on the list much (though I read every word :) > > So you don't want our conversation to be forwarded to the list? > >> but I >> figured I'd put in my two cents. I see a great reason to include a >> feature like this: prepared statements. >> http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html >> http://www.postgresql.org/docs/8.1/interactive/sql-prepare.html > > This requires generating a special PREPARE statement that's hard to > generate in SQLObject even with parametrized queries. More changes will be > required. I will add prepared statements to my TODO but at the very end. > >> http://sqlite.org/c3ref/stmt.html > > SQLObject uses PySQLite and PySQLite doesn't seem to export > prepare-related API. > > Oleg. > -- > Oleg Broytmann http://phd.pp.ru/ p...@phd.pp.ru > Programmers don't die, they just GOSUB without RETURN. > >From before: I don't get in on the list much (though I read every word :) but I figured I'd put in my two cents. I see a great reason to include a feature like this: prepared statements. It doesn't *appear* that SQLObject/SQLBuilder supports prepared statements, but they can be beneficial. I know in MySQL they help a great deal with preventing SQL injections so the developer doesn't have to worry about it (as much). Also, it allows the query to be parsed only once if it is used repeatedly. This could give a substantial performance boost for large data sets, especially with inserts, updates, and the like. In any case, the ability to use prepared statements in databases that support them would be nice :D Some links: http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html http://www.postgresql.org/docs/8.1/interactive/sql-prepare.html http://sqlite.org/c3ref/stmt.html ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
