[PD] MySQL Pd external?

[Christof Ressi]

> I'm not sure SQL and Pd go well together so nicely.

sadly, Pd doesn't go well together with most other languages.... but SQL is not so bad in this context, compare that to assembling JS or PHP statements in Pd! (it's all possible with [list tosymbol], but it's a pain.) 
I think simple single SQL statements would work quite fine as Pd lists (the trailing semicolon could be ommited). 
anyhow, I would consider such an external useful very simple database interaction, for everything else an approach like yours or Thomas' is definitely preferable!

> Gesendet: Dienstag, 23. Januar 2018 um 12:22 Uhr
> Von: "Roman Haefeli" <reduzent at gmail.com>
> An: pd-list <pd-list at iem.at>
> Betreff: Re: [PD] MySQL Pd external?
>
> On Mon, 2018-01-22 at 18:32 +0100, Christof Ressi wrote:
> > does anyone know a Pd external which connects to a MySQL database and
> > performs SQL commands? 
> 
> Last time I was looking for a mysql external, I ended up using
> purest_json calling some simple php script that abstracted out all the
> database handling. It turned out I liked that approach more than I
> would have by using some SQL external in Pd directly. This way I hadn't
> to think about SQL anymore in the Pd realm and was able to use a
> simplified interface that allowed to focus at the task at hand.
> 
> I'm not sure SQL and Pd go well together so nicely. The question of
> blocking audio in synchronous request is only one aspect. Another is
> the limitation of what you can express in Pd messages and what you need
> in SQL. How are you going to express something like this in Pd:
> 
> START TRANSACTION;
> UPDATE passwords set algo = 'sha512' where hash like '$6%';
> DELETE FROM passwords where algo = 'md5';
> COMMIT;
> 
> (Consider the '$6' and  the semicolons. Ok, that's a pretty made up
> example, but you get the idea)
> 
> Roman
> _______________________________________________
> Pd-list at lists.iem.at mailing list
> UNSUBSCRIBE and account-management -> https://lists.puredata.info/listinfo/pd-list
>