[wxPython-users] Re: OT - Python/Databases/wxPython

[Josiah Carlson]

Eli Golovinsky <gooli at tuzig.com> wrote:
> 
> You'll have to explain why using SVN as a backend doesn't seem to you 
> like a good idea. From what you've described it sounds like it would be 
> perfect, including the need for comments for every change (revision).
> 
> If you won't use SVN, I'd go for SQLite3 and I'd work with it via 
> SQLAlchemy which makes things easier to code. You seem to imply a 
> one-to-many relationship in you description of the tree control and 
> SQLAlchemy makes handling such things (and loading only what is needed) 
> quite simple.

I agree.  I've been meaning to switch to SQLAlchemy for a while now.
Also, a sqlite 3 binding ships with Python 2.5 .

 - Josiah


> Andrea Gavana wrote:
> > Hi All,
> > 
> >    sorry for the off-topic, but I thought that the wxPython list is
> > much friendlier than any other place to ask for suggestions. Please
> > feel free to kick me if the question is too much off-topic.
> > We are trying to keep track of all the modifications we make to some
> > input files for our reservoir simulator, in order to not lose the
> > history of our work and to be able to retrieve in the future old
> > results. The possible modifications are endless, so it happens that
> > after few months we are lost because we can not recover the exact
> > input file that generated a particular result.
> > So, noting that the SVN/CVS approach is not an alternative, I am
> > trying to build a database in which I will store the "fathers" input
> > files, and then all their children, with a possibility for the user to
> > add comments regarding the changes, link to output/result files and
> > other information. With this is mind, I will populate a wx.TreeCtrl
> > with all the input file names and display information only on user
> > request (i.e., the user double-click an item in the tree or something
> > like that).
> > If this is a viable approach, could someone please suggest a free, non
> > particularly complicated to use database with Python support which can
> > help me in tackling this problem?
> > If this is not a viable solution or some of you can envisage a better
> > approach, could you please share some comments about this issue?
> > 
> > Thank you for every hint.
> > 
> > Andrea.
> > 
> > "Imagination Is The Only Weapon In The War Against Reality."
> > http://xoomer.virgilio.it/infinity77/
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: wxPython-users-unsubscribe at lists.wxwidgets.org
> For additional commands, e-mail: wxPython-users-help at lists.wxwidgets.org