On okt. 14, 10:09, Bruno Desthuilliers <bruno. [EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] a écrit : > (snip) > > > It is not convincing to look at an XML file alone. Let me give you an > > example. Glade is a GTK+ application for creating GTK+ GUI. It > > generates an XML file, that can be loaded in every programming > > language that has libglade binding. > > Similarly, there could be a > > database design tool to create a database, and save SQL/DML > > expressions into an XML config file. > > Why so ? What's wrong with a plain SQL file ? We already have a language > for RDBMS schema description, and the schema description is itself > stored in the RDBMS catalog so the SQL description can be regenerated > from the RDBMS. I just don't see the point of storing all this in XML. > > > Then you create the RDB command > > objects by loading the XML in your favourite language. > > I think programming languages are intended for describing neither relational > > databases nor GUIs. > > SQLAlchemy is an interesting attempt at integrating the relational model > in a programming language. > > Ok, I don't mean neither of us is necessarily right and the other wrong > - different POV, mostly, so I guess we can at least agree to disagree !-)
Plain SQL does not have a structure to easily handle metadata. XML has several parsers, transformators like xmlto. I am not going to reimplement relational stuff in XML or any programming language. In my approach relational model is described in SQL, processing is in a programming language, and XML is used for interchange data. That data is actually SQL, and metadata to create documentation. I have looked into SQLAlchemy. I have seen this: users_table = Table('users', metadata, Column('id', Integer, primary_key=True), Column('name', String), ... session.query(User, Address).filter(User.id==Address.user_id).filter(Address.email_address=='[EMAIL PROTECTED]').all() users_table = Table('users', metadata, Column('id', Integer, primary_key=True), Column('name', String), ... ...and I do not like it. My favourite programming language is python because of its simple and practical syntax. SQLAlchemy is something different, something like what I do in full time, and something I am fed up with. -- http://mail.python.org/mailman/listinfo/python-list