I'm working on a project that is using ExtJS to generate an interface for managing tables. It's still in the working phase, and the demo I have posted currently does not have a connection to a working database (it will eventually, using php + mysql). Here's the current url for the project I'm working on:
I've only been using ExtJS for less than a month, I am having some difficulty figuring out how allow the user to dynamically alter the database schema. I have no idea how to add a column to an editor grid, among other things. Currently the schema tabs are empty, but eventually I would like to allow users to add new fields and have those new fields appear as new columns in the database table tab.
I'm not looking to be spoonfed as much as I am looking for some examples of how it might be done, or other people's examples of doing something similar. Is there a tutorial of adding columns dynamically, and I guess I would need to alter the data model to add new rows once that has been done.
Do I reload the editor gird every time the user alters the 'database' (after the db is connected rather than loaded from json files) Any brilliant ideas out there for this dilema?
There are so many thing I want to do that are not complete that I am hoping someone can direct me to another site that has done something similar. I can't be the first one to try this concept. I relatively inexperienced and have done my best on my own to get this far based on what's available thru google, these forums, etc.
I also have some questions to the approach though - lets say I do figure out how to add a column, then I click add record. Obviously the store model type has to be updated to incorporate the new column, or remove the deleted column. I am trying to get this done for a demo in the next couple of weeks, am I in over my head here? I don't know where to start.
Any brilliant ideas, and even not so brilliant, would be appreciated.