Fast and dirty CRUD interface for SQLAlchemy?
I am studying software components for use in future development of a business logic web application. This will be written in Python and we target SQLAlchemy as an ORM. The application will be used by other software applications through a REST-like interface over http, possibly using web.py for this part.
For debugging, maintenance, etc. we need to access the MySQL database directly, but phpmyadmin is too low-level for standard tasks given the rich db structure modeled by SQLAlchemy, so I'm looking for a user-friendly CRUD interface that follows our SA models. It can be a web application or a local application (X11 or whatever) and it takes as little time as possible to execute.
So far, after some googling, I've found Camelot (Qt app) and RUM (WSGI webapp). Camelot is based on Elixir , and if we also use it in our project, we should be able to split the model definition between our application and Camelot just by adding some camel-specific stuff here and there, and we should eventually have Qt- interface with little effort. RUM on the other end seems to be declarative based , and we should probably base our application on that in order to use RUM. It's not clear to me yet how much effort it needs to add to get a working web interface using RUM.
I would like to know if anyone has any experience with Camelot and / or RUM, and if using one of the two implies the need to use its declarative layer (either elixir or, say, declarative) in order to be able to split the model code. without overriding it.
Any other guidance on how to get the CRUD interface would also be welcome.
source to share