[PD] Question about SQL Placeholder Implementation

Mathieu Bouchard 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 mailing list