I agree with you. And I can understand why no one is interested in data base schema. That said, there are some advantage of using schema. Here is a quote: "Ownership of schemas and schema-owned objects is transferable and Overall, maintenance of database become easier and I will recommend the use of schemas if you’re working with more than 20 tables." Also, multiple application can use same schema with alteration. If there are one to many, many to many and lot of tables, sometimes its complicated to see in the code than to visually observing. Also going between different frameworks etc. Moving from one database to another etc, much easier when you have the schema in place to begin with.
On Wednesday, April 8, 2015 at 11:43:32 AM UTC-4, Richard wrote: > > Write model and see the schema with web2py graph model that rely > on pygraphviz... The rest is a waste of time!! > > :) > > > > On Wed, Apr 8, 2015 at 11:32 AM, Ron Chatterjee <achatte...@gmail.com > <javascript:>> wrote: > >> Because I ran across this link: >> >> >> http://www.vertabelo.com/blog/vertabelo-news/visual-design-of-sqlalchemy-models-in-6-steps >> >> So I was curious. If I use vertabelo or sqldesigner and save the database >> as an XML format, is there way to use sqlachemy to generate DAL syntax. I >> know I am making it more complicated than it needs to be. But I am trying >> to learn all the bells and whistles. Here is an old blog (scroll down) that >> shows how to do, but its not XML specific. >> >> http://www.web2py.com/AlterEgo/default/show/189 >> >> Again, this are for learning different ways to do things. Not necessarily >> a deal breaker or a method of work. >> >> >> >> >> On Wednesday, April 8, 2015 at 10:59:42 AM UTC-4, José Borba wrote: >>> >>> Ron, >>> XML is a data interchange format (like JSON, ASCII,...), not suitable to >>> storage data. >>> To storage data, use a database (of your choice). >>> >>> Best regards, >>> >>> 2015-04-08 11:54 GMT-03:00 Kiran Subbaraman <subbaram...@gmail.com>: >>> >>>> Won't a lxml based solution do? Am just trying to understand why you >>>> want DAL support for XML based file-storage? >>>> >>>> ________________________________________ >>>> Kiran Subbaraman >>>> http://subbaraman.wordpress.com/about/ >>>> >>>> >>>> On Wed, 08-04-2015 7:14 PM, Ron Chatterjee wrote: >>>> >>>>> Speaking of database, if I have the xml file for the database, does >>>>> anyone know how to use in web2py? fo I need yo use sqlachamy? >>>>> >>>>> >>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/web2py (Source code) >>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>> --- You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to web2py+un...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> José Ricardo Borba >>> >>> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web2py+un...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
