Re: moving forward: thanks for feedback

As an addition to that I presume we are working of the following set of rules: http://www.backendmedia.com/MDB2/docs/xml_schema_documentation.html Regards Ian Warner Director Triangle Solutions Ltd Greg Beaver wrote:

Hello all, Thanks for all the great ideas and participation in the past couple of days. There have been enough new ideas it will take a while to sort through them all. For those of you who volunteered to help with pearweb, there is a simple task I would like to ask. One of the first steps in migrating pearweb to the next level is going to be making it easier to install the database and get it running. As such, the friendliest option I see at the moment is using MDB2_Schema and its ability to create and update databases as changes are made. To this end, I just committed pearweb/sql/pearweb_msb2schema.xml. This contains only the structure, but I envision also having a schema file containing sample data, that can be used to set up a working environment. Those with more MDB2_Schema experience can help by checking out the file, seeing if it really lines up appropriately with the .sql files in the same directory. One concern I have is that all mysql-specific sets are converted into simple text fields. If there is a way to tell MDB2_Schema to use a set type when installing to a mysql database, that would be very good to know. Otherwise, I'll go through the code and make sure that we are validating input properly in places where it may have relied upon the database constraints to catch errors. Those who have volunteered to help, it will be a little while before we are ready for your assistance, the code needs to be in a hackable state before the transition can happen. However, in the mean time, please set up pearweb on your development machine and familiarize yourself with it. Thanks, Greg