<br><br><div class="gmail_quote">On Jan 4, 2008 1:31 AM, Hans-Christoph Steiner <<a href="mailto:hans@eds.org">hans@eds.org</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div style="word-wrap:break-word"><div><div class="Ih2E3d"><div><br></div></div><div>I just had a look at ftm.sqlite.help.pd. They use a custom and very specialized message box to deal with the comma issue. I think your technique of handling the commas is much more natural to deal with, and probably more flexible.
</div></div></div></blockquote><div><br class="webkit-block-placeholder"></div><div>Well, I will say that I like the fact of using the COLD inlet for the SQL, it removes all the "wrapping" keywords, as you said. I also think that it will make for the Programmatic generation of SQL much easier. One thing I was playing with, I kind of discovered that it would be best to encourage everyone using dynamic generation to do the whole thing into a single message box that is then passed to the Query object in one fell swoop. The mechanics of trying to stuff SQL into the Query object in smaller chunks might get a little confusing. At least with the use of a single message box, you can see the whole of the SQL statement before it gets sent.
</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div style="word-wrap:break-word"><div><div></div><div><br></div><div>The part that I still can't see a clear way to deal with is handling the queries and the results. I had one thought inspired by your send/receive symbols. Perhaps the first argument to the [sql_query] object would be like your send/receive symbol, except that it would be the selector in all of the results returned from that query. Then there could be one database object that outputs the query data thru an outlet, and the results would still be sortable using [route].
</div></div></div></blockquote><div><br class="webkit-block-placeholder"></div><div>I have created an example. I also made some changes to the Database object to allow it to recognize a NULL value from the database. NULL's I think will be one datatype that is kind of difficult to deal with, as a Float object can only be returned as a NULL as in the following:
</div><div><br class="webkit-block-placeholder"></div><div><br class="webkit-block-placeholder"></div><div>select max(id) from table;</div><div><br class="webkit-block-placeholder"></div><div>AND, there is no data in 'table'. This will return a NULL value, and NOT 0. I also think that it should be left to the person designing the database and the PD stuff using a Database object to worry about the differences. The reason behind that is that a User will understand the schema of their database, and should program accordingly.
</div><div><br></div><div>I am going to post this up on the Pure Data site, as I still have yet to figure out the CVS stuff. I will do that this afternoon.</div><div><br class="webkit-block-placeholder"></div><div><br class="webkit-block-placeholder">
</div><div>Mike</div><div><br class="webkit-block-placeholder"></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div style="word-wrap:break-word"><div>
<div></div><div><br></div><div>.hc</div><div><div></div><div class="Wj3C7c"><div><br></div><div><br></div><div><br></div><br><blockquote type="cite"><div class="gmail_quote"><div> </div><div><br></div><div>Mike</div><div>
<br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <br><br>.hc<br><div><div></div><div><br>On Thu, 3 Jan 2008, Mike McGonagle wrote:<br><br>> So, it would appear that I am wrong, it is for PD, but in the README, it
<br>> says it is not working...<br>> <a href="http://ftm.cvs.sourceforge.net/ftm/ftm-sql/pd/README.txt?revision=1.1&view=markup" target="_blank">http://ftm.cvs.sourceforge.net/ftm/ftm-sql/pd/README.txt?revision=1.1&view=markup
</a><br>><br>> It also goes through another Database Layer, rather than compiling directly <br>> into the external. I still can't figure out its API in PD...<br>><br>><br>> Mike<br>><br>> PS, sorry for all these messages...
<br>><br>> On Jan 3, 2008 1:40 PM, Mike McGonagle <<a href="mailto:mjmogo@gmail.com" target="_blank"> mjmogo@gmail.com</a>> wrote:<br>><br>>> <a href="http://puredata.info/community/projects/software/ftm/" target="_blank">
http://puredata.info/community/projects/software/ftm/</a><br>>> Hans,<br>>><br> >> This is the URL for the FTM stuff on the PureData site. It appears that<br>>> this code is still Max specific, and there are a lot of Macros so I can't
<br>>> really tell what is going on at first glance. <br>>><br>>> I don't have Max, so if you know anyone that might be using this, and they<br>>> could send some screen shots of what they have, that would be really useful.
<br>>> IOhannes says he doesn't have Max either, so I don't know anyone who might <br>>> have access to these things.<br>>><br>>><br>>> Mike<br>>><br>>><br>>> On Jan 3, 2008 1:13 AM, Hans-Christoph Steiner <
<a href="mailto:hans@eds.org" target="_blank">hans@eds.org</a>> wrote: <br>>><br>>>><br>>>> You should have CVS access now, so if you check this into CVS, then it<br>>>> shouldn't be too hard to add it to the nightly builds. That certainly makes
<br>>>> it easier for people to test it. <br>>>><br>>>> .hc<br>>>><br>>>> On Jan 2, 2008, at 8:19 AM, Mike McGonagle wrote:<br>>>><br>>>> Ed,<br>>>><br>
>>> I really doubt that anyone has tried this yet, as this is just the first <br>>>> release, and even that is very preliminary. We are still trying to get the<br>>>> programming interface down in PD.
<br>>>> You may be able to try taking a basic makefile from some other external. <br>>>> The only difference here is that you also need to compile the Sqlite3 code<br>>>> into an object file. It then gets linked up with the SQLdb object. You may,
<br>>>> depending on what 'warning' you ask for, see a lot of message. I have yet to <br>>>> find any troubles with the resulting compiled objects. You can check with<br>>>> the SQLite site for details, but probably won't need to...
<br>>>><br>>>> I do have access to a Ubuntu (GG) install, so I can try to figure <br>>>> something out there, but that won't happen for a few days.<br>>>><br>>>> BUT, if anyone does create a makefile, please forward it to me, and I
<br>>>> can add it to the main makefile. <br>>>><br>>>><br>>>> Mike<br>>>><br>>>><br>>>> On Jan 2, 2008 9:49 AM, Ed Kelly < <a href="mailto:morph_2016@yahoo.co.uk" target="_blank">
morph_2016@yahoo.co.uk</a>> wrote:<br> >>><br>>>>> Hi there,<br>>>>><br>>>>> has anyone had any experience of compiling Mogo's SQLdb v0.0 for<br>>>>> linux? The makefile refers to the OSX SDK...
<br>>>>> <br>>>>> peace,<br>>>>> Ed<br>>>>><br>>>>> Lone Shark "Aviation" out now on <a href="http://www.pyramidtransmissions.com" target="_blank">http://www.pyramidtransmissions.com
</a><br>>>>> <a href="http://www.myspace.com/sharktracks" target="_blank">http://www.myspace.com/sharktracks</a><br>>>>><br>>>>> ------------------------------<br>>>>> Support the World Aids Awareness campaign this month with Yahoo! for
<br></div></div>>>>> Good<<a href="http://us.rd.yahoo.com/mailuk/taglines/isp/control/*http://us.rd.yahoo.com/evt=51947/*http://uk.promotions.yahoo.com/forgood/" target="_blank">http://us.rd.yahoo.com/mailuk/taglines/isp/control/*http://us.rd.yahoo.com/evt=51947/*http://uk.promotions.yahoo.com/forgood/
</a>><br>>>>><br>>>>> _______________________________________________<br><div>>>>> <a href="mailto:PD-list@iem.at" target="_blank">PD-list@iem.at</a> mailing list<br>>>>> UNSUBSCRIBE and account-management ->
<a href="http://lists.puredata.info/listinfo/pd-list" target="_blank">http://lists.puredata.info/listinfo/pd-list</a><br>>>>><br>>>>><br>>>>><br>>>><br>>>><br>>>> --
<br>>>> Peace may sound simple?one beautiful word? but it requires everything we<br>>>> have, every quality, every strength, every dream, every high ideal.<br>>>> ?Yehudi Menuhin (1916?1999), musician
<br>>>> _______________________________________________<br>>>> <a href="mailto:PD-list@iem.at" target="_blank">PD-list@iem.at</a> mailing list<br>>>> UNSUBSCRIBE and account-management -><br>
>>> <a href="http://lists.puredata.info/listinfo/pd-list" target="_blank"> http://lists.puredata.info/listinfo/pd-list</a><br>>>><br>>>><br>>>><br>>>><br>>>><br>>>> ----------------------------------------------------------------------------
<br> >>><br>>>> Looking at things from a more basic level, you can come up with a more<br>>>> direct solution... It may sound small in theory, but it in practice, it can<br>>>> change entire economies. - Amy Smith
<br>>>><br>>>><br>>>><br>>><br>>><br>>> --<br>>> Peace may sound simple?one beautiful word? but it requires everything we<br>>> have, every quality, every strength, every dream, every high ideal.
<br>>> ?Yehudi Menuhin (1916?1999), musician<br>>><br>><br>><br>><br>> --<br>> Peace may sound simple?one beautiful word? but it requires everything we<br>> have, every quality, every strength, every dream, every high ideal.
<br>> ?Yehudi Menuhin (1916?1999), musician<br>><br><br></div> zen<br> \<br> \<br> \ [D [D [D [D<br></blockquote></div><br><br clear="all"><br>-- <br>Peace may sound simple—one beautiful word— but it requires everything we have, every quality, every strength, every dream, every high ideal.
<br>—Yehudi Menuhin (1916–1999), musician</blockquote></div></div></div><br><div> <span style="border-collapse:separate;border-spacing:0px 0px;color:rgb(0, 0, 0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<br><div><br></div><div><br></div><div><br></div><div>----------------------------------------------------------------------------<br></div><div><br></div><div>'You people have such restrictive dress for women,' she said, hobbling away in three inch heels and panty hose to finish out another pink-collar temp pool day. - "Hijab Scene #2", by Mohja Kahf
</div><br></span> </div><br></div></blockquote></div><br><br clear="all"><br>-- <br>Peace may sound simple—one beautiful word— but it requires everything we have, every quality, every strength, every dream, every high ideal.
<br>—Yehudi Menuhin (1916–1999), musician