Tested the cleaned-up codebase on Manifestoes dev, and found a couple of bugs (remaining includes of now-deleted file). Fixed those, and now I have a fully-working (AFAIK) Adaptive DB codebase which doesn't include the custom fields.
I've decided that the custom field code is a dead end; the performance penalties are too great for any payoff there might be, and it's far simpler and less time consuming to respond to user requests for minor changes in the db structure than it is to maintain the complexity of the custom field codebase. Accordingly, I've branched the original Adaptive DB code, which supports custom fields, into a branch called
customfieldsbranch, and eliminated (as far as I can tell) all custom field-related code from the trunk. I haven't been able to test any of this yet; it's an all-or-nothing thing. But it should be easy to test it with the Manifestoes dev db later this week.
JW reported a bug showing up in the Manifestoes project where dates prior to 1000 (e.g. 0996) were being highlighted as if incorrect, whereas they were in fact correct, and accepted by the db. Fixed the JS to allow anything between 0 and 4000. Haven't yet decided what, if anything, to do about BC dates.
This project aims to design a flexible online database which can be set up as very quickly for a researcher requiring a relational database, and is easy to modify and extend. The Web GUI provides tools for data-entry in as simple and convenient a manner as possible, while also allowing data-integrity checks. The application development sandbox is currently at https://hcmc.uvic.ca/people/martin/potluck/editor/index.php; and half a dozen UVic projects are already using the codebase. The code is managed through SVN here: https://revision.tapor.uvic.ca/svn/adaptivedb/.
|<< <||Current||> >>|