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.