I’m working on distributing information across our campus, and trying to figure out the best way to give global access to a database in an easy manner.
I’ve been building PEAR Packages with built in connection info and building methods to get the data. But today, a different solution hit me like a ton of bricks.
Distribute the DB_DataObjects for the tables you want to distribute, and embed the read only connection details inside the PEAR Package.
I mean, once the database schema has been stabalized why not simply distribute the DB_DataObjects. This gives all the users easy methods for finding, searching, etc etc.
And if we need custom methods, we can place those right inside the class file for that dataobject.
Why this didn’t hit me before, I’m not sure. But this is obviously the simplest way to get the data for a public database out there.
