[PD] [psql] object hand-holding

Hans-Christoph Steiner hans at eds.org
Thu Dec 13 03:15:12 CET 2007

On Dec 12, 2007, at 11:52 AM, Jamie Bullock wrote:

> On Tue, 2007-12-11 at 15:48 -0500, Hans-Christoph Steiner wrote:
>> On Dec 11, 2007, at 3:59 AM, Jamie Bullock wrote:
>>> On Mon, 2007-12-10 at 18:07 -0500, Hans-Christoph Steiner wrote:
>>>> It seems many things use the "?" alone as the unnamed placeholder,
>>>> but
>>>> I only saw MySQL using ?name for named placeholders.  It does seem
>>>> like a nicer syntax rather than using a different character.
>>>> Perhaps,
>>>> we should follow pgsql and use "$" and "$name", since "$" is
>>>> already a
>>>> marker for replacement vars in Pd.  I suppose that could get
>>>> confusing
>>>> in something like:
>>>> SELECT id, ABS(($duration - $1)/$2) AS error FROM datatable  
>>>> error LIMIT 1
>>> I vote that we use "?" as a placeholder, and only support unnamed
>>> placeholders. We can use this to convert to whatever the db-specific
>>> placeholder system is inside the external.
>> I am ok with using ?name for placeholders, but I think we should also
>> support the plain ? with the list input.  I am fine if that happens
>> later tho.  I'd like to get something working soon, we've done a lot
>> of talking :).
> I agree about getting on with it. However, I probably won't be able to
> commit any coding time to [psql] until after Christmas. This might be
> sensible though - I suggest we get the interface to one of the objects
> 'right' first and then copy this in the others. Mike seems to be  
> pretty
> active on the SQLite one, so I suggest we let that take the lead and
> follow that.

Sounds like a plan :)



Looking at things from a more basic level, you can come up with a  
more direct solution... It may sound small in theory, but it in  
practice, it can change entire economies.     - Amy Smith

More information about the Pd-list mailing list