its just such a huge project, though. if a team of developers was
really all working with their own copies of the database, and someone
wanted to distribute a package that would "upgrade" everyone's copy
of the database, its not just ALTER statements....there would be data
migrations, temporary tables, all sorts of stuff to keep track of.
if i needed to distribute changes to an existing schema that didnt
involve dropping the whole thing and re-creating, writing out ALTER
statements is pretty easy....or just having an "alter()" syntax
object available to do it in a database-agnostic way. the
migrations idea strikes me like everything else about rails...it all
looks really nice until you get entrenched in a much bigger
project....all their small-project conveniences start to become
liabilities when you hit all the unfinished features, bugs, paradigms
that never took more complex scenarios into account.
I have no opposition for someone using SQLAlchemy as a basis for such
a tool if they want to give it a shot...id be glad that new tools are
being written. probably better left as a separate component.
On Jan 2, 2006, at 11:39 PM, Mark Ramm wrote:
The worst offender is
http://www.sqlobject.org/sqlobject-admin.html
Well, that may be the worst, and frankly I haven't been able to make
it work reliably. But the best project of that kind is is Rails
"Migrations," which handles incremental database schema upgrades in
development and production a hell of a lot easier than manual
creations of the necessary SQL table creations and updates for each
incremental release.
See http://wiki.rubyonrails.com/rails/pages/UnderstandingMigrations
for more information.
I think this really is amazingly useful, and it would be a wonderful
feature for people who do "agile" development in python. So I see it
as really worth doing, but it does seem like it does belong in a
separate project, or at least a set of functions that is mostly
orthogonal to the main SQLAlchemy functions.
--Mark Ramm
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through
log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD
SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
