2006/10/30, Derek Atkins <[EMAIL PROTECTED]>: > Phil Longstaff <[EMAIL PROTECTED]> writes: > > >> Sorry, what I meant was that I didn't understand what you meant by > >> "small add-on".. I don't know GDA well-enough to know what that means > >> or how that would work. > >> > >> > Phil > > > > I haven't thought this through entirely, but these are my first > > thoughts. In order to specify the provider, we'll need the data URL to > > be sqlite://... or mysql://... or ... The current backend architecture > > is already plugin. Therefore, if I build a core backend built around > > libgda, then small wrapper backends for each sql db type, the core > > libgda piece can handle most of the heavy lifting, and the wrappers can > > adjust things as required (connection string, data type > > differences, ...). > > Ahh, so what you mean is that we'd have a "libgncgda" and then we'd > implement a "libgncmod-backend-sqlite" and "libgncmod-backend-mysql" > and "libgncmod-backend-pg" which all link against libgncgda? Or > perhaps libgncgda would have multiple QOF backends, one for each of > SQLite, MySQL, and PG? *ponders* > > So long as we can still have most of the code be shared, I suppose > that works..
Well, if you have a "preconfigured" DSN in gda (may using the graphical tool in libgnomedb) you just need to pass the "name" of the DSN, all the parameters is pre-difined when you create the datasource, even you can test and inspect the DSN using a GUI in libgnomedb. Then you can create a connection to a DB, and pass to GC that DSN using a sintax like: "gda://database", then if you avoid any specific SQL's or use just the API in gda you can access, read/write, and update any data in the database, even this is true for Oracle, MS SQL Server, MDB or any provider supported by GDA. > > > Phil > > -derek > > -- > Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory > Member, MIT Student Information Processing Board (SIPB) > URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH > [EMAIL PROTECTED] PGP key available > _______________________________________________ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > -- Trabajar, la mejor arma para tu superación "de grano en grano, se hace la arena" (R) (entrámite, pero para los cuates: LIBRE) _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel