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