From: Ian B. <ia...@co...> - 2003-03-31 18:20:56
|
I added some stuff to CVS for adding and removing columns on the fly (including doing an ALTER), as well as crude support for creating a class from the schema directly. It only works for MySQL, I'll have to look up the Postgres ALTER (probably easy), and my understanding is that database introspection in Postgres is a lot harder than MySQL. I have to figure out how to do tableExists in Postgres too... Anyway, this is all part of a larger plan to integrate FunFormKit with SQLObject, and create a generic through-the-web database interface, including database building (for Access-like functionality). Integrated with a simple permission model, you could phrase all sorts of applications this way -- surveys, registration, mailing lists, etc. Still a bunch of steps left, though... Ian |