Hi,

Very interesting! Can be extremely useful in many cases,  e.g. for sonification of some date handling organizing otherwise large set of data.
I did not try it out yet, though, still -  thanks a lot!

tarmo

Sent from Mailspring, the best free email app for work
On Mar 19 2020, at 12:40 am, Richard Knight <richard@1bpm.net> wrote:
Hi

I have created some SQL database query plugin opcodes for Csound which are available here as an initial beta version:
https://github.com/1bpm/csound-sqldb

Currently they support SQLite, MySQL and PostgreSQL. I have only been able to test on Linux so any further feedback would be appreciated. They will need a recent build of Csound from the develop branch on Github.
I have not encountered any operational problems when testing but conversely I am not completely sure on the best practices for using third party libraries in plugin opcodes, so again I would be grateful for any feedback in that regard.

There are several examples included and usage is outlined in OpcodeDocumentation.md
There are three approaches: i rate which works as expected, k rate which runs queries asynchronously given a trigger and returns a trigger when complete, and k rate blocking which are for non-realtime or special purposes (see doc/examples).

all the best
Richard
Csound mailing list Csound@listserv.heanet.ie https://listserv.heanet.ie/cgi-bin/wa?A0=CSOUND Send bugs reports to https://github.com/csound/csound/issues Discussions of bugs and features can be posted here
Csound mailing list Csound@listserv.heanet.ie https://listserv.heanet.ie/cgi-bin/wa?A0=CSOUND Send bugs reports to https://github.com/csound/csound/issues Discussions of bugs and features can be posted here