[PD-dev] Project Outline for SQL External

[Mike McGonagle]

Hello all,

Over the past month and a half, I have been dealing with MySQL and
working with SQL. I was wondering if anyone had thought about making
an external for PD to access a database via SQL, and it appears that
there have been a couple of attempts, but nothing that seems to have
come to fruition.

The one project that I have got the source (sqlsingle) for was to
connect up to a Postgres database, and I suspect that part of the
complexity in writing this external might have stemmed from dealing
with the Connectivity level and the SQL level all within the same
object. One of the things that I have been considering is to write two
different externals, one to handle the connectivity (probably using
ODBC, instead of connecting directly to a specific database), and
another that would be used to post SQL to the database.