On 2/11/07, Ben Sizer <[EMAIL PROTECTED]> wrote: > > On Feb 11, 12:45 am, Tim Black <[EMAIL PROTECTED]> wrote: > > Anyone know if the following error has been fixed or a workaround has > > been discovered? > > > > F:\md\MyWebPages\arwd\developers\tg>tg-admin sql status > > Using database URI > > sqlite:///F|\md\MyWebPages\arwd\developers\tg/devdata.sqlite > > Database does not support reading columns > > Basically, it seems that SQLObject relies on a certain aspect of the > Python DB-API to retrieve the type information from a database cursor, > and pysqlite has a limitation meaning it doesn't fill this data in, > meaning SQLObject can't tell what type each column has. > > > I'm trying to upgrade my database to a new version without losing data > > I've already stored in it. > > If I'm not mistaken (which I may be mistaken about), you can add new > tables easily with SQLite, just not edit them. So one workaround > approach would be to create a new table with the amended format, copy > the data across, drop the old table, then rename the new table to the > old table's name. I expect most or all of this would have to be done > directly with SQL. > yes in fact it's an sqlite issue http://www.sqlite.org/faq.html#q13
alter table is supported but not fully in theory you could add columns to the end, but your better of with how they suggest on the faq above. > It may also be worth considering changing to a 'proper' relational > database, if only for this stage of development while your database is > changing. It still doesn't make upgrading as simple as it should be, > but it's easier than copying tables across while trying to maintain > correct auto-ids and the like. > yes indeed, sqlite is great for dev, not so great for prod. > -- > Ben Sizer > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
