[PD] MySQL Pd external?

[Roman Haefeli]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: This is a digitally signed message part
URL: <http://lists.puredata.info/pipermail/pd-list/attachments/20180123/a654e2e3/attachment.sig>