[PD] Question about SQL Placeholder Implementation
matju at artengine.ca
Sat Dec 22 04:01:26 CET 2007
On Fri, 21 Dec 2007, Mike McGonagle wrote:
> Yes, I know that these things can be stored in a typeless manner, but the
> functions that bind the SQL statement with their placeholders can be of any
> type, as there are functions for the various datatypes.
Ok, cool then. :)
> This is not an issue of how the user sees these things, it is how the C code
> interfaces with the database.
> SQLite does. MySQL appears to as well. And yes, it is possible to just
> force everything to be a string/c-string and be done with it. SQLite
> actually stores everything as a string anyway, despite the defined types
> in the create statement.
I think that it's plenty good if you have separate calls for when an atom
is a float and when an atom is a symbol. It's not any more extra code and
I don't think that it's a good idea to use atom_string anyway.
_ _ __ ___ _____ ________ _____________ _____________________ ...
| Mathieu Bouchard - tél:+1.514.383.3801, Montréal QC Canada
More information about the Pd-list