[DGD] DGD & MySQL

[Noah Gibbs]

  Sure, but that'll still take most of the same effort.  The hard part is integrating DGD features like atomic functions with SQL features like transactions, as well as more fundamental stuff like storing all your DGD objects in some kind of SQL format.

--- On Thu, 9/18/08, Kurt Nordstrom <kurt at blar.net> wrote:

> From: Kurt Nordstrom <kurt at blar.net>
> Subject: Re: [DGD] DGD & MySQL
> To: "All about Dworkin's Game Driver" <dgd at dworkin.nl>
> Date: Thursday, September 18, 2008, 8:44 AM
> Embedding SQLite might be another viable alternative to
> MySQL too.
> 
> http://www.sqlite.org/
> 
> As they claim, self-contained, serverless and config-free.
> 
> -Kurt
> 
> > 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
> > ___________________________________________
> > https://mail.dworkin.nl/mailman/listinfo/dgd
> >
> 
> 
> ___________________________________________
> https://mail.dworkin.nl/mailman/listinfo/dgd