Re: [PD] [psql] object hand-holding

2007-12-21 Thread Mathieu Bouchard
On Thu, 13 Dec 2007, Chris McCormick wrote: It would be way cool if gem was truly dataflow, with the [cube] or another geometry source at the top of the stack and then geometry/colour/texture modifiers all the way down until a [render] object. Imagine doing audio style filtering on geometry

Re: [PD] [psql] object hand-holding

2007-12-21 Thread Mathieu Bouchard
On Thu, 13 Dec 2007, Mike McGonagle wrote: As someone who has never really used Placeholders, the only sorts of things that I can see them being useful for are when you need to do a lot of inserts or deletes, or for other statements that will be executed repeatedly. From what I am gathering

Re: [PD] [psql] object hand-holding

2007-12-21 Thread IOhannes m zmölnig
IOhannes m zmölnig wrote: at least i am using kind-of regression tests in zexy and iemlib. this of course should read iemmatrix instead of iemlib sorry for the confusion. mfg.asdr IOhannes ___ PD-list@iem.at mailing list UNSUBSCRIBE and

Re: [PD] [psql] object hand-holding

2007-12-21 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: What we really need is regression testing, I think that would make it easier to convince Miller to accept patches, and would be a great tool for finding bugs. Matju started that project, any word on that Matju? No, I haven't done much

Re: [PD] [psql] object hand-holding

2007-12-21 Thread IOhannes m zmölnig
Mathieu Bouchard wrote: On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: What we really need is regression testing, I think that would make it easier to convince Miller to accept patches, and would be a great tool for finding bugs. Matju started that project, any word on that Matju?

Re: [PD] [psql] object hand-holding

2007-12-21 Thread Mike McGonagle
On 12/21/07, Mathieu Bouchard [EMAIL PROTECTED] wrote: On Thu, 13 Dec 2007, Mike McGonagle wrote: As someone who has never really used Placeholders, the only sorts of things that I can see them being useful for are when you need to do a lot of inserts or deletes, or for other statements

Re: [PD] [psql] object hand-holding

2007-12-21 Thread Mathieu Bouchard
On Fri, 21 Dec 2007, Mathieu Bouchard wrote: Regression testing is only for past bugs, but you must mean unit tests. Ok, I had never actually looked it up, only learned from other sources as the name for the process of adding a test for each new bug, and in that case, it's by opposition to

Re: [PD] [psql] object hand-holding

2007-12-21 Thread Mathieu Bouchard
On Fri, 21 Dec 2007, Mike McGonagle wrote: Well, this is one of those reasons why I am starting with using SQLite, I think it would be much easier than working with a networked database. And if someone is being 'dishonest', then they are only effecting themselves. When we're talking about

Re: [PD] [psql] object hand-holding

2007-12-16 Thread Mathieu Bouchard
On Fri, 14 Dec 2007, Hans-Christoph Steiner wrote: On Dec 13, 2007, at 8:31 PM, Chris McCormick wrote: One can dream I guess. I think that GEM is dataflow-ish, but it is representing OpenGL render chains rather than the physical shapes they generate... There's no way to stretch any

Re: [PD] [psql] object hand-holding

2007-12-14 Thread Hans-Christoph Steiner
On Dec 13, 2007, at 2:36 PM, Mathieu Bouchard wrote: On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: For a place where you are expecting a number, you can protect against a SQL injection attack by merely putting a [float] before the message box with the SQL in it. In other

Re: [PD] [psql] object hand-holding

2007-12-14 Thread Hans-Christoph Steiner
On Dec 13, 2007, at 3:50 PM, Mike McGonagle wrote: On Dec 13, 2007 1:59 PM, Mathieu Bouchard [EMAIL PROTECTED] wrote: On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: The other somewhat common style that I saw in my searches was printf patterns (%s, %f, etc). In Pd, [makefilename],

Re: [PD] [psql] object hand-holding

2007-12-14 Thread Hans-Christoph Steiner
On Dec 13, 2007, at 8:31 PM, Chris McCormick wrote: On Thu, Dec 13, 2007 at 03:12:18PM -0500, Mathieu Bouchard wrote: On Tue, 11 Dec 2007, IOhannes m zmoelnig wrote: i don't claim that Gem is a good example. however, i also don't see how the data-flow vs control-flow is especially bad in

Re: [PD] [psql] object hand-holding

2007-12-13 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: I started a pdpedia page on the topic, please add anything useful: http://wiki.puredata.info/en/proxy_objects You copied from my email. Emails are property of the sender unless otherwise specified. For publicly visible emails it doesn't seem

Re: [PD] [psql] object hand-holding

2007-12-13 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: For a place where you are expecting a number, you can protect against a SQL injection attack by merely putting a [float] before the message box with the SQL in it. In other situations, I think that Perl has a pretty decent idea: a SQL quote

Re: [PD] [psql] object hand-holding

2007-12-13 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: It is useful to represent the pieces in Pd space, so you can understand what's going on. That's one reason why I advocate having the core object represent the connection to the database rather than a query. Otherwise, it's starts to become

Re: [PD] [psql] object hand-holding

2007-12-13 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: The other somewhat common style that I saw in my searches was printf patterns (%s, %f, etc). In Pd, [makefilename], [makesymbol], [sprintf], and perhaps others use this syntax. The single ? notation seems to be supported by at least these,

Re: [PD] [psql] object hand-holding

2007-12-13 Thread Mathieu Bouchard
On Tue, 11 Dec 2007, Jamie Bullock wrote: I like this idea. What do you think about using an implicit receive-symbol, '$0-psql.1001', '$0-psql.1002' etc? No, because if you don't have an explicit receive-symbol, then you can't share database connections and logins in the way that you choose,

Re: [PD] [psql] object hand-holding

2007-12-13 Thread Roman Haefeli
On Thu, 2007-12-13 at 14:28 -0500, Mathieu Bouchard wrote: On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: I started a pdpedia page on the topic, please add anything useful: http://wiki.puredata.info/en/proxy_objects You copied from my email. Emails are property of the sender unless

Re: [PD] [psql] object hand-holding

2007-12-13 Thread Mathieu Bouchard
On Tue, 11 Dec 2007, IOhannes m zmoelnig wrote: i don't claim that Gem is a good example. however, i also don't see how the data-flow vs control-flow is especially bad in Gem. As long as you pass a gem message around that is only a pointer to a shared state that all objects modify, it's all

Re: [PD] [psql] object hand-holding

2007-12-13 Thread Mike McGonagle
On Dec 13, 2007 1:59 PM, Mathieu Bouchard [EMAIL PROTECTED] wrote: On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: The other somewhat common style that I saw in my searches was printf patterns (%s, %f, etc). In Pd, [makefilename], [makesymbol], [sprintf], and perhaps others use this

Re: [PD] [psql] object hand-holding

2007-12-13 Thread Chris McCormick
On Thu, Dec 13, 2007 at 03:12:18PM -0500, Mathieu Bouchard wrote: On Tue, 11 Dec 2007, IOhannes m zmoelnig wrote: i don't claim that Gem is a good example. however, i also don't see how the data-flow vs control-flow is especially bad in Gem. As long as you pass a gem message around that

Re: [PD] [psql] object hand-holding

2007-12-12 Thread Jamie Bullock
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

Re: [PD] [psql] object hand-holding

2007-12-12 Thread Hans-Christoph Steiner
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

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Jamie Bullock
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

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, IOhannes m zmoelnig wrote: while i basically agree with matju, that a consistent use of the data-flow paradigm should not be made the holy grail (if we don't want to end up fighting green knights), http://youtube.com/watch?v=2eMkth8FWno i do think that we should bear

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Jamie Bullock
On Mon, 2007-12-10 at 15:00 -0500, Mathieu Bouchard wrote: On Mon, 10 Dec 2007, Jamie Bullock wrote: Fair enough, I think I was probably stretching the point about using the [psql]-style of database connectivity requiring less objects. However, it's perfectly possible to have multiple

Re: [PD] [psql] object hand-holding (fwd)

2007-12-11 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: Try valgrind... best development tool of the decade, imho. Could you post some instructions on how to use valgrind to debug Pd related things on the dev docs wiki? It would be very useful: http://puredata.info/docs/developer You don't need

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Jamie Bullock
On Mon, 2007-12-10 at 16:43 -0500, Mathieu Bouchard wrote: On Mon, 10 Dec 2007, Mike McGonagle wrote: In one of the early prototypes I wrote for this, I set it up so that the connections were shared. Basically, when an object tried to open a connection, it would check if there was

Re: [PD] [psql] object hand-holding

2007-12-11 Thread IOhannes m zmoelnig
Mathieu Bouchard wrote: On Mon, 10 Dec 2007, IOhannes m zmoelnig wrote: i do think that we should bear data-flow (as opposed to control-flow) in mind and design objects accordingly. So do you want us to consider Gem as the bad example? i don't claim that Gem is a good example. however, i

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Jamie Bullock
On Mon, 2007-12-10 at 10:39 +0100, Frank Barknecht wrote: Hallo, Thomas Grill hat gesagt: // Thomas Grill wrote: it's unfortunate that you are not thrilled using flext. Since flext uses the PD api to get lists or other messages into secondary inlets there's nothing to stop you from

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Frank Barknecht
Hallo, Hans-Christoph Steiner hat gesagt: // Hans-Christoph Steiner wrote: From what I hear from Marius' struggles with pdlua, it's definitely not trivial, and I would say, I probably wouldn't call it easy either. If you read up on that thread, most of it is related to problems building

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Frank Barknecht
Hallo, Jamie Bullock hat gesagt: // Jamie Bullock wrote: Actually, please don't be quiet! When this was discussed some time ago, you mentioned Python as a solution, and my feeling was that if I write a piece and it uses some database connectivity, I don't really want to have to distribute a

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Hans-Christoph Steiner
On Dec 11, 2007, at 8:29 AM, Frank Barknecht wrote: Hallo, Jamie Bullock hat gesagt: // Jamie Bullock wrote: Actually, please don't be quiet! When this was discussed some time ago, you mentioned Python as a solution, and my feeling was that if I write a piece and it uses some

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Hans-Christoph Steiner
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

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Mike McGonagle
On Dec 11, 2007 2:45 PM, Hans-Christoph Steiner [EMAIL PROTECTED] wrote: That said, I think we have a solid interface sketched out, I think it's time to write some code and try it out. I've started porting the mysql external from Max to Pd. Let me know if you guys want specific help with

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Hans-Christoph Steiner
On Dec 11, 2007, at 3:45 PM, Hans-Christoph Steiner wrote: On Dec 11, 2007, at 8:29 AM, Frank Barknecht wrote: Hallo, Jamie Bullock hat gesagt: // Jamie Bullock wrote: Actually, please don't be quiet! When this was discussed some time ago, you mentioned Python as a solution, and my

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Hans-Christoph Steiner
I cc'ed the list since I think this is valuable discussion: On Dec 10, 2007, at 7:39 PM, Mike McGonagle wrote: On 12/10/07, Hans-Christoph Steiner [EMAIL PROTECTED] wrote: It is useful to represent the pieces in Pd space, so you can understand what's going on. That's one reason why I

Re: [PD] [psql] object hand-holding

2007-12-11 Thread Hans-Christoph Steiner
On Dec 11, 2007, at 5:27 PM, Mike McGonagle wrote: On Dec 11, 2007 2:45 PM, Hans-Christoph Steiner [EMAIL PROTECTED] wrote: That said, I think we have a solid interface sketched out, I think it's time to write some code and try it out. I've started porting the mysql external from Max to Pd.

Re: [PD] [psql] object hand-holding

2007-12-10 Thread IOhannes m zmoelnig
Thomas Grill wrote: There must be other externals using proxy inlets, probably zexy or other iem-based stuff. right: e.g. zexy's [mulitplex] (aka [mux]) uses proxy-inlets. there are 2 reasons why it is not in the externals-howto: #1 it would have complicated the howto needlessly #2 when i

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Jamie Bullock
On Sun, 2007-12-09 at 21:47 -0500, Mathieu Bouchard wrote: On Sun, 9 Dec 2007, Jamie Bullock wrote: Then I persuaded him that passing the queries as a list to the inlet would be more flexible. It also greatly reduces the number of objects required to send a query, if you have more than

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Jamie Bullock
On Sun, 2007-12-09 at 16:47 -0500, Hans-Christoph Steiner wrote: The addcomma, addsemi, adddollar messages are a workaround, for sure, but yeah, I suppose a more pd-ish one. I think that if SQL gets submitted only on the right/cold inlet, then we would not need those messages. They

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Frank Barknecht
Hallo, Thomas Grill hat gesagt: // Thomas Grill wrote: it's unfortunate that you are not thrilled using flext. Since flext uses the PD api to get lists or other messages into secondary inlets there's nothing to stop you from doing the same in psql. The magic words are proxy objects which

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Thomas Grill
Frank Barknecht schrieb: But as everyone knows that I don't really understand why a DB external has to be a C/C++ external, I'll better be quiet now. ;) Right. Over and out gr~~~ ___ PD-list@iem.at mailing list UNSUBSCRIBE and

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Thomas Grill
Mike McGonagle schrieb: On 12/9/07, *Thomas Grill* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Mike McGonagle schrieb: I know and it has been on my todo list for a long time. The point is that it hasn't made it to the top of this list since i don't need it. On the

Re: [PD] [psql] object hand-holding (fwd)

2007-12-10 Thread Hans-Christoph Steiner
On Dec 9, 2007, at 8:27 PM, Mathieu Bouchard wrote: -- Forwarded message -- Date: Sun, 9 Dec 2007 20:23:16 -0500 (EST) From: Mathieu Bouchard [EMAIL PROTECTED] To: Mike McGonagle [EMAIL PROTECTED] Subject: Re: [PD] [psql] object hand-holding On Sun, 9 Dec 2007, Mike

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
On Dec 9, 2007, at 9:41 PM, Mathieu Bouchard wrote: On Sat, 8 Dec 2007, Hans-Christoph Steiner wrote: I'm not a big fan of [expr]'s syntax since it is custom syntax that is not used anywhere else in Pd. A precedent has to start somewhere :) I believe that the goal is to make an

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
On Dec 10, 2007, at 6:14 AM, Thomas Grill wrote: Frank Barknecht schrieb: But as everyone knows that I don't really understand why a DB external has to be a C/C++ external, I'll better be quiet now. ;) Right. Over and out Basically, only C and Pd externals have proven easy to manage.

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mike McGonagle
On Dec 10, 2007 2:40 AM, IOhannes m zmoelnig [EMAIL PROTECTED] wrote: Thomas Grill wrote: There must be other externals using proxy inlets, probably zexy or other iem-based stuff. right: e.g. zexy's [mulitplex] (aka [mux]) uses proxy-inlets. there are 2 reasons why it is not in the

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
On Dec 10, 2007, at 6:47 AM, Thomas Grill wrote: Mike McGonagle schrieb: On 12/9/07, *Thomas Grill* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Mike McGonagle schrieb: I know and it has been on my todo list for a long time. The point is that it hasn't made it to

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mike McGonagle
On Dec 10, 2007 3:21 AM, Jamie Bullock [EMAIL PROTECTED] wrote: On Sun, 2007-12-09 at 21:47 -0500, Mathieu Bouchard wrote: On Sun, 9 Dec 2007, Jamie Bullock wrote: Then I persuaded him that passing the queries as a list to the inlet would be more flexible. It also greatly reduces the

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
On Dec 9, 2007, at 9:53 PM, Mathieu Bouchard wrote: On Sun, 9 Dec 2007, Mike McGonagle wrote: Well, this is not something that is within reach of many people. We need to understand not just PD's internals, but how flext uses them, and we also need to know how to integrate these things

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mike McGonagle
Hans, I still have yet to learn about the WIKI stuff, but I posted a Inlet Proxy example on my page ( http://puredata.info/Members/mjmogo ). I don't know if you want to just put a link, or move the file to the Proxy page you created, either way works for me. Thanks, Mike On Dec 10, 2007 10:05

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Frank Barknecht
Hallo, Hans-Christoph Steiner hat gesagt: // Hans-Christoph Steiner wrote: On Dec 10, 2007, at 6:14 AM, Thomas Grill wrote: Frank Barknecht schrieb: But as everyone knows that I don't really understand why a DB external has to be a C/C++ external, I'll better be quiet now. ;)

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
On Dec 10, 2007, at 4:21 AM, Jamie Bullock wrote: On Sun, 2007-12-09 at 21:47 -0500, Mathieu Bouchard wrote: On Sun, 9 Dec 2007, Jamie Bullock wrote: Then I persuaded him that passing the queries as a list to the inlet would be more flexible. It also greatly reduces the number of objects

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Claude Heiland-Allen
Frank Barknecht wrote: Hallo, Hans-Christoph Steiner hat gesagt: // Hans-Christoph Steiner wrote: On Dec 10, 2007, at 6:14 AM, Thomas Grill wrote: Frank Barknecht schrieb: But as everyone knows that I don't really understand why a DB external has to be a C/C++ external, I'll better

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Hans-Christoph Steiner wrote: Too often reducing effort is equated with typing shortcuts and things along that line. I think putting everything into the [psql] object box is version of this. Things are a bigger concerns in the push to reduce effort are: - reducing bugs!

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Jamie Bullock wrote: The way you are suggesting always requires at least 2 objects per query: an object to build the query and a message to send it. I assumed that there would always be one variable part per query, so that there's always a float or symbol or list coming

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Frank Barknecht
Hallo, Claude Heiland-Allen hat gesagt: // Claude Heiland-Allen wrote: Not quite as easy as abstractions - you still have to restart Pd. Well, yes. But still the lua loader allows users to get the same power as developers have without the need to learn and setup all the stuff that's required to

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Mike McGonagle wrote: Could someone please explain that IMPORTANCE of worrying about SQL injection? Just how would it effect users of PD? We don't know what pd users will do with [psql]. Do you? _ _ __ ___ _ _ _ ... | Mathieu

Re: [PD] [psql] object hand-holding (fwd)

2007-12-10 Thread Mathieu Bouchard
-- Forwarded message -- Date: Mon, 10 Dec 2007 11:52:25 -0500 (EST) From: Mathieu Bouchard [EMAIL PROTECTED] To: Mike McGonagle [EMAIL PROTECTED] Subject: Re: [PD] [psql] object hand-holding On Mon, 10 Dec 2007, Mike McGonagle wrote: While I think I understand what you

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Jamie Bullock
On Mon, 2007-12-10 at 12:18 -0500, Mathieu Bouchard wrote: This almost *never* happens. As long as what you do in Pd is regular read-write activities involving tables that contain data that you only want to see a small part of at a time, you need variable atoms in almost any query:

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mike McGonagle
On 12/10/07, Mathieu Bouchard [EMAIL PROTECTED] wrote: On Mon, 10 Dec 2007, Mike McGonagle wrote: Could someone please explain that IMPORTANCE of worrying about SQL injection? Just how would it effect users of PD? We don't know what pd users will do with [psql]. Do you? I guess what I

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Jamie Bullock
On Mon, 2007-12-10 at 09:55 -0600, Mike McGonagle wrote: Well, Jamie, at the same time, I think that Mathieu might be refering how the output is handled from the 'sql' external. That is the part that would make having just a single instance of a database object difficult at best to work

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mike McGonagle
On 12/10/07, Jamie Bullock [EMAIL PROTECTED] wrote: PREPARE uses the '$' character as its placeholder identifier, and '$1' Jamie, after thinking about this, I don't think we should worry about the specifics of the characters that we use, as long as we can agree on what gets entered into a PD

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mike McGonagle
On a different note, has anyone given any thought to handling Blobs? I know that in SQLite, they store the data as binary strings, but I am not quite certain how the external would handle the actual data going into and coming out of it. Mike ___

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Mike McGonagle wrote: I guess what I am getting at is that I don't see how we can prevent people from using this maliciously. Using true placeholders or other form of automatic quoting. If they are creating the SQL and putting the data into it, how can we stop them from

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Martin Peach
If you have applied the add string support patch you can use the blob atom, which is essentially a pointer to, and the length of, a binary string. The string can be anything at all. Martin Mike McGonagle wrote: To: pd-list@iem.at Subject: Re: [PD] [psql] object hand-holding Date: Mon, 10 Dec

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Jamie Bullock wrote: On Mon, 2007-12-10 at 12:18 -0500, Mathieu Bouchard wrote: This almost *never* happens. I take your point, but I think you are exaggerating slightly. Not in this context. We're only looking at the average query; I don't even mean an actual query,

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Jamie Bullock wrote: Fair enough, I think I was probably stretching the point about using the [psql]-style of database connectivity requiring less objects. However, it's perfectly possible to have multiple [psql] instances connected to the same database, so the routing

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
On Dec 10, 2007, at 11:43 AM, Frank Barknecht wrote: Hallo, Hans-Christoph Steiner hat gesagt: // Hans-Christoph Steiner wrote: On Dec 10, 2007, at 6:14 AM, Thomas Grill wrote: Frank Barknecht schrieb: But as everyone knows that I don't really understand why a DB external has to be a

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mike McGonagle
to, and the length of, a binary string. The string can be anything at all. Martin Mike McGonagle wrote: To: pd-list@iem.at Subject: Re: [PD] [psql] object hand-holding Date: Mon, 10 Dec 2007 13:29:16 -0600 On a different note, has anyone given any thought to handling Blobs? I know that in SQLite

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mike McGonagle
On 12/10/07, Mathieu Bouchard [EMAIL PROTECTED] wrote: But it requires multiple logins, perhaps many at once, which might be wasteful. For sharing database connections between several [psql] objects, what do you think would be the best ways to do it? This is supposing that several different

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
Very nice, thanks for making the example, I linked to it from the wiki page. .hc On Dec 10, 2007, at 11:30 AM, Mike McGonagle wrote: Hans, I still have yet to learn about the WIKI stuff, but I posted a Inlet Proxy example on my page ( http://puredata.info/Members/ mjmogo ). I don't know

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
On Dec 10, 2007, at 1:43 PM, Mike McGonagle wrote: On 12/10/07, Mathieu Bouchard [EMAIL PROTECTED] wrote: On Mon, 10 Dec 2007, Mike McGonagle wrote: Could someone please explain that IMPORTANCE of worrying about SQL injection? Just how would it effect users of PD? We don't know what pd

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
On Dec 10, 2007, at 1:42 PM, Jamie Bullock wrote: On Mon, 2007-12-10 at 12:18 -0500, Mathieu Bouchard wrote: This almost *never* happens. As long as what you do in Pd is regular read-write activities involving tables that contain data that you only want to see a small part of at a

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Mathieu Bouchard
On Mon, 10 Dec 2007, Mike McGonagle wrote: In one of the early prototypes I wrote for this, I set it up so that the connections were shared. Basically, when an object tried to open a connection, it would check if there was already one open, and if so, it would use that. Else it would create a

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Martin Peach
It probably would end up in vanilla if there was a demand for it, although Miller doesn't seem to like the idea, needs more convincing ;) Martin Mike McGonagle wrote: To: Martin Peach [EMAIL PROTECTED] CC: pd-list@iem.at Subject: Re: [PD] [psql] object hand-holding Date: Mon, 10 Dec 2007 14

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
On Dec 10, 2007, at 3:30 PM, Mike McGonagle wrote: On 12/10/07, Mathieu Bouchard [EMAIL PROTECTED] wrote: But it requires multiple logins, perhaps many at once, which might be wasteful. For sharing database connections between several [psql] objects, what do you think would be the best ways

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
On Dec 10, 2007, at 2:55 PM, Mathieu Bouchard wrote: On Mon, 10 Dec 2007, Jamie Bullock wrote: On Mon, 2007-12-10 at 12:18 -0500, Mathieu Bouchard wrote: This almost *never* happens. I take your point, but I think you are exaggerating slightly. Not in this context. We're only looking at

Re: [PD] [psql] object hand-holding

2007-12-10 Thread Hans-Christoph Steiner
Peach wrote: It probably would end up in vanilla if there was a demand for it, although Miller doesn't seem to like the idea, needs more convincing ;) Martin Mike McGonagle wrote: To: Martin Peach [EMAIL PROTECTED] CC: pd-list@iem.at Subject: Re: [PD] [psql] object hand-holding Date

Re: [PD] [psql] object hand-holding

2007-12-09 Thread Jamie Bullock
Hi Hans, I like this idea of a hot and cold inlet, and I can see where you are going with making the database access objects more pd-like. I also agree that the sql/sqlend delimiters are a rather inelegant workaround for Pd's lack of a string type. What you suggest shouldn't be too hard to

Re: [PD] [psql] object hand-holding

2007-12-09 Thread Jamie Bullock
On Sat, 2007-12-08 at 00:51 -0500, Mathieu Bouchard wrote: The only SQL interface I'd really be happy to use (if I had to use SQL) is something using placeholders, sort of like [expr], but perhaps written in the usual SQL style: [sql select * from candies where flavour=? and colour=?]

Re: [PD] [psql] object hand-holding

2007-12-09 Thread Hans-Christoph Steiner
The addcomma, addsemi, adddollar messages are a workaround, for sure, but yeah, I suppose a more pd-ish one. I think that if SQL gets submitted only on the right/cold inlet, then we would not need those messages. They might come in handy though, so they could be added later. bang for

Re: [PD] [psql] object hand-holding

2007-12-09 Thread Mike McGonagle
Ok, so I spent the weekend just trying to figure out if what Hans described is POSSIBLE at all... And NO, it is not possible in Plain Vanilla PD. You can't create a second inlet that will take arbitrary selectors. According to the 'pd-external-HOWTO.pdf' (by IOhannes), page 32; It is not possible

Re: [PD] [psql] object hand-holding

2007-12-09 Thread Thomas Grill
Hi Mike, it's unfortunate that you are not thrilled using flext. Since flext uses the PD api to get lists or other messages into secondary inlets there's nothing to stop you from doing the same in psql. The magic words are proxy objects which you might find in the mailing list archive (or the

Re: [PD] [psql] object hand-holding

2007-12-09 Thread Thomas Grill
Mike McGonagle schrieb: One of the things that I have heard mention is that it would be nice to have flext as part of the Extended build. That would be a good thing, as we could take advantage of all the externals that use flext, without having to compile them ourselves. Also, it is not

Re: [PD] [psql] object hand-holding

2007-12-09 Thread Mike McGonagle
On 12/9/07, Thomas Grill [EMAIL PROTECTED] wrote: Mike McGonagle schrieb: I know and it has been on my todo list for a long time. The point is that it hasn't made it to the top of this list since i don't need it. On the other hand it doesn't seem so important in general that any other person

Re: [PD] [psql] object hand-holding (fwd)

2007-12-09 Thread Mathieu Bouchard
-- Forwarded message -- Date: Sun, 9 Dec 2007 20:23:16 -0500 (EST) From: Mathieu Bouchard [EMAIL PROTECTED] To: Mike McGonagle [EMAIL PROTECTED] Subject: Re: [PD] [psql] object hand-holding On Sun, 9 Dec 2007, Mike McGonagle wrote: On 12/7/07, Mathieu Bouchard [EMAIL PROTECTED

Re: [PD] [psql] object hand-holding

2007-12-09 Thread Mathieu Bouchard
On Sat, 8 Dec 2007, Hans-Christoph Steiner wrote: I'm not a big fan of [expr]'s syntax since it is custom syntax that is not used anywhere else in Pd. A precedent has to start somewhere :) I believe that the goal is to make an interface that is effortless to use rather than try to be more

Re: [PD] [psql] object hand-holding

2007-12-09 Thread Mathieu Bouchard
On Sun, 9 Dec 2007, Jamie Bullock wrote: Then I persuaded him that passing the queries as a list to the inlet would be more flexible. It also greatly reduces the number of objects required to send a query, if you have more than one query. I don't understand the latter part. How does it work?

Re: [PD] [psql] object hand-holding

2007-12-09 Thread Mathieu Bouchard
On Sun, 9 Dec 2007, Mike McGonagle wrote: Well, this is not something that is within reach of many people. We need to understand not just PD's internals, but how flext uses them, and we also need to know how to integrate these things with the extended nightly builds. Not quite certain how

Re: [PD] [psql] object hand-holding

2007-12-09 Thread Mike McGonagle
On 12/9/07, Mathieu Bouchard [EMAIL PROTECTED] wrote: On Sun, 9 Dec 2007, Mike McGonagle wrote: Well, this is not something that is within reach of many people. We need to understand not just PD's internals, but how flext uses them, and we also need to know how to integrate these things

Re: [PD] [psql] object hand-holding (fwd)

2007-12-09 Thread Mathieu Bouchard
-- Forwarded message -- Date: Sun, 9 Dec 2007 22:05:05 -0500 (EST) From: Mathieu Bouchard [EMAIL PROTECTED] To: Mike McGonagle [EMAIL PROTECTED] Subject: Re: [PD] [psql] object hand-holding On Sun, 9 Dec 2007, Mike McGonagle wrote: Actually, we do support placeholders in using

Re: [PD] [psql] object hand-holding

2007-12-08 Thread IOhannes m zmoelnig
[EMAIL PROTECTED] wrote: i installed postgresql, and got it running, created a user for myself, compiled [psql] from postlude (i'm using pd-extended from cvs). i opened up the psql-help file and started with the first instruction, and it created the database fine, i moved to the second

Re: [PD] [psql] object hand-holding

2007-12-08 Thread Hans-Christoph Steiner
I'm not a big fan of [expr]'s syntax since it is custom syntax that is not used anywhere else in Pd. Instead, you could achieve the same result by using the interface I described, then embedded your SQL statements with [sql] into a subpatch or an abstraction. This just about any regular

Re: [PD] [psql] object hand-holding

2007-12-07 Thread Mike McGonagle
So, it looks like, from your prototype, that an SQL statement without comma's could be used on the Hot inlet, while those with comma's would have to go into the Cold inlet? To me, that seems kind of clunky. Also, I still don't see how the external would know where the end of the SQL statement

Re: [PD] [psql] object hand-holding

2007-12-07 Thread Jamie Bullock
Hi Andy, On Fri, 2007-12-07 at 16:12 -0500, [EMAIL PROTECTED] wrote: i installed postgresql, and got it running, created a user for myself, compiled [psql] from postlude (i'm using pd-extended from cvs). i opened up the psql-help file and started with the first instruction, and it created

Re: [PD] [psql] object hand-holding

2007-12-07 Thread Mike McGonagle
Andy, have you had a chance to check out the SQLite external yet? You can get a copy of it here ( http://puredata.info/Members/mjmogo ), the latest version is 0.13. While this is still under developement, it is based on the work of Jamie (and others), as far as how the SQL is handled. They are not

[PD] [psql] object hand-holding

2007-12-07 Thread andy . graybeal
i installed postgresql, and got it running, created a user for myself, compiled [psql] from postlude (i'm using pd-extended from cvs). i opened up the psql-help file and started with the first instruction, and it created the database fine, i moved to the second command and get this error: psql:

Re: [PD] [psql] object hand-holding

2007-12-07 Thread Mathieu Bouchard
On Fri, 7 Dec 2007, Hans-Christoph Steiner wrote: That is done by sending the [submit( message to the hot inlet. Or do you mean having multiple SQL calls separated by semi-colons? If you wanted to add semicolons, there would have to be a special message, I think we could just reuse the

  1   2   >