On Tue, Oct 13, 2009 at 12:42:52AM -0700, Eric Day wrote: > We've decided to add the prepared statement API sooner than later, > and I've been looking into various ways of mapping variables in. There > are simple '?' with order of appearance determining order into the > array of vars, there are '$1', '$2', ... which would allow you to > repeat or do things out of order. Or the SQLite method of '?nnn' or > ':aaa' and also allow identifies. > > What are folks thoughts on PS APIs? Anything they really love or hate?
name binding is useful, at least from a code clarity PoV, although not necessarily the fastest thing in the world. lowest level, probably just access via number. the naming of parameters can easily be built on top of that... > We're also thinking of restricting vars to strings for now, but > possibly simple INT types. Other types could still be given as vars, > but they'd just be passed in as strings. if just ints, strings, blobs.... i'd be happy -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
