DB Table Processor?

[A. Shore]

Folks, I'm considering developing a particular app in Python - I've
been working in PHP for some years now - and it will be db-intensive.
Whether it's based on sqllite or mySQL is TBD as of right now.

One tool that's done me well in the past is a generalized table
processor, which I use as a way of getting early visualization into
the app's requirements. That is, given an existing schema, it will
generate or perform the C R U D functions on each table comprising
the schema, with no/little code needing to be written.

I've searched without success in trying to locate some - hopefully FOS
- py-based utility that will do this for me.

Thanks for any URL/information. AS

 

[Shawn Milochik]

It sounds like you're looking for SQLAlchemy.

http://www.sqlalchemy.org/

Enjoy!

Shawn

 

[Diez B. Roggisch]

It sounds like you're looking for SQLAlchemy.

http://www.sqlalchemy.org/

I'd rather say he looks for Django Admin or SPROX.

Diez

 

[Ed Leafe]

Folks, I'm considering developing a particular app in Python - I've
been working in PHP for some years now - and it will be db-intensive.
Whether it's based on sqllite or mySQL is TBD as of right now.

One tool that's done me well in the past is a generalized table
processor, which I use as a way of getting early visualization into
the app's requirements. That is, given an existing schema, it will
generate or perform the C R U D functions on each table comprising
the schema, with no/little code needing to be written.

I've searched without success in trying to locate some - hopefully FOS
- py-based utility that will do this for me.

If you prefer a rich client app instead of a browser-based app, you should look into Dabo. We have an AppWizard that creates a searchable CRUD app in less than a minute. You can view a screencast of the AppWizard in action at http://j.mp/6kRp0u. It works with MySQL, SQLite, PostgreSQL, and MS Sql Server.

More information can be found at http://dabodev.com


-- Ed Leafe