[pmwiki-users] DataQuery (ADODB front-end) development page

The Editor editor at fast.st
Wed Oct 11 04:24:01 CDT 2006


Looking very good Ben!  And really excited it should be able to work
so seamlessly with ZAP forms.  Don't know a lot about the internal
nuts and bolts of databases, but after having looked at your cookbook
page, here's a few thoughts:

1) When you save the page, is the entire page contents save as one
database field?  Or does your template system somehow break it up into
various fields in the record? This has bearings of course on how ZAP
forms will interface--but I didn't see much documentation on how the
templates work, or what they do. Or how the data is structured on the
database.

2) Similarly, how do you run the actual queries and what kind of
queries can you use?  Just the ones you specified, or any kind of
mysql query?  And if so, how?  Are you sure you want to try and
imitate pagelist?  Why not use a more transparent query system?
Perhaps by avoiding the imitate pagelist goal, you could solve the
performance problem. You would also have your searching problems
basically solved.  Most admins using this are probably going to be
able to construct at least simple queries easily enough. Set up a doc
page in the recipe for samples and tips.

3) I'm wondering if the edit function shouldn't work natively with
PmWiki.  It seems you already have it working for reading pages, why
not do something similar for writing pages? Or would that make it
impossible for PmWiki to distinguish between writing a new page and
writing a database page?  Perhaps a hook could be inserted in PmWiki
for something like dbase:group.name, to specify it goes to the dbase.
Another option might be to use a different action for updating a
database record, but then you have to create your own form and saving
process.  Also what about diffs?  Deleting?

Anyway, would help more but my hands are full with ZAP right now.  But
I'll follow this thread and if I can suggest an idea here or there, I
will.  This will be a powerful recipe if you can get it finished.
Keep up the good work.

Cheers,
Caveman




More information about the pmwiki-users mailing list