Re: Keeping python code and database in sync

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.mixmin.net!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<prvs=31124e5b6=jeanmichel@sequans.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.029
X-Spam-Evidence	'H': 0.94; 'S': 0.00; 'schema': 0.05; 'subject:code': 0.07; 'ugly': 0.07; 'migration': 0.09; 'yeah,': 0.09; 'cc:addr:python-list': 0.11; 'django': 0.11; '"python': 0.16; "(it's": 0.16; '1.7': 0.16; 'smith"': 0.16; 'sqlalchemy': 0.16; 'subject:python': 0.16; 'cc:addr:python.org': 0.22; 'tend': 0.24; 'cc:20': 0.24; 'cc:no real name:20': 0.24; 'header:In- Reply-To:1': 0.27; 'probably': 0.32; 'critical': 0.32; '-----': 0.33; 'at:': 0.34; 'problem.': 0.35; 'but': 0.35; 'google': 0.35; 'thank': 0.38; 'others.': 0.38; 'moving': 0.39; 'most': 0.60; 'you.': 0.62; "you'll": 0.62; 'information': 0.63; 'such': 0.63; 'received:194': 0.64; 'provide': 0.64; 'notice:': 0.67; 'person,': 0.68; 'integrated': 0.69; 'privileged.': 0.69; 'disclose': 0.74; 'medium.': 0.91
X-IronPort-AV	E=Sophos;i="5.04,425,1406584800"; d="scan'208";a="3227171"
Date	Fri, 29 Aug 2014 18:49:36 +0200 (CEST)
From	Jean-Michel Pichavant <jeanmichel@sequans.com>
To	Roy Smith <roy@panix.com>
In-Reply-To	<roy-AE646E.10535529082014@news.panix.com>
Subject	Re: Keeping python code and database in sync
MIME-Version	1.0
X-Mailer	Zimbra 7.2.7_GA_2942 (ZimbraWebClient - GC35 (Linux)/7.2.7_GA_2942)
Content-Type	text/plain; charset="utf-8"
Content-Transfer-Encoding	base64
Cc	python-list@python.org
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.13612.1409331046.18130.python-list@python.org> (permalink)
Lines	20
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1409331046 news.xs4all.nl 2848 [2001:888:2000:d::a6]:34345
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:77279

Show key headers only | View raw


----- Original Message -----
> From: "Roy Smith" <roy@panix.com>
> 
> Yeah, schema migration is an ugly problem.  There's a number of tools
> to
> help here, most of which reduce the suckitude, but don't eliminate it
> completely.  Some things you might want to look at:
> 
> * SQLAlchemy Migrate
> * South (django-specific)
> * yoyo-migrations
> * alembic
> 
> Google for "python schema migration tools" and you'll probably find
> others.

Note that South is now fully integrated in django 1.7 (It's still ugly but it has been polished by the django team).
The OP may want to consider moving to such framework, they tend to provide working concepts on critical issues when it comes to webapp/database.

JM


-- IMPORTANT NOTICE: 

The contents of this email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information in any medium. Thank you.

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Keeping python code and database in sync Jean-Michel Pichavant <jeanmichel@sequans.com> - 2014-08-29 18:49 +0200

csiph-web