Csound Csound-dev Csound-tekno Search About

[Csnd] SQL database plugin opcodes

Date2020-03-18 22:40
FromRichard Knight
Subject[Csnd] SQL database plugin opcodes

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


Date2020-03-19 09:03
FromTarmo Johannes
SubjectRe: [Csnd] SQL database plugin opcodes
AttachmentsNone  None