w.r.t. web2py migrations, I don't think the sqlite typing question is pertinent;
as I recall Massimo saying, (and indeed, as the code in gluon/sql.py: Table._migrate() shows) web2py does not do migrations in sqlite. In any case, both Python 2.5 an 2.6 embed sqlite3. On Fri, Sep 11, 2009 at 9:16 AM, Richard <[email protected]> wrote: > > has this changed since sqlite2? > SQLite is "typeless": http://www.sqlite.org/datatypes.html > > > On Sep 11, 7:01 pm, Fran <[email protected]> wrote: > > On Sep 11, 9:29 am, Richard <[email protected]> wrote: > > > > > Well, yesterday I changed a boolean type column to integer in my model > > > and all hell broke loose. > > > Fortunately all the boolean values were false so I was able to > > > manually enter postgres and do the update myself. > > > I never experienced such a problem with sqlite, perhaps because sqlite > > > is typeless (IIRC). > > > > sqlite isn't typeless:http://sqlite.org/datatype3.html > > > > I've had exactly this kind of problem with using sqlite...changing > > column types isn't supported. > > Adding extra columns, & not using columns is fine... > > > > F > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" 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/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
