[DGD] DGD & MySQL

[Par Winzell]

On 9/18/08 7:23 AM, Per Newberg wrote:
> Greetings all!
> 
> This is the first time I write here.. so hi! :-)
> 
> My question is regarding DGD & SQL...
> 
> Have anyone tried doing anything like this? Making [My]SQL queries
> from within DGD & LPC code?

Unless you're really hungry to drop hundreds of hours of work into this, 
my recommendation would be to design a new minimal application-specific 
protocol that does precisely what you want and nothing else and contains 
no SQL or table names, just your own logical operations and references.

You write a DGD client for the protocol and you write a small Java 
server for it. The Java server takes requests from DGD (localhost 
connection) and translates them into SQL through JDBC, and mutates the 
results for DGD.

This way you get a storage-agnostic interface (maybe you'd want to 
switch to Berkeley DB at some point, for example) and you don't have to 
deal with actual database connectors.

Zell