-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/15/2011 08:49 PM, romtek wrote: > I don't know about how things work in your world, but in mine requirements > for apps change sometimes, so I have to enter design stage after an app (may > be a website) has been released. Perhaps, you are a clairvoyant genius who > can foresee everything that would ever be required by your clients and also > produce defect-free software, but I have to work with my limitations, so I > modify my software as new requirements or bugs emerge :)
True, but I do as much design and anticipation up front as possible. The other thing I do is make sure I have plan for how changes are applied in production including rolling back. End users do not see column names so it is immaterial what they are named. SQLite has a user_version pragma which can be used to track the current revision of the schema. I have code that knows how to go between versions. For example some code knows how to go from 2 to 3 and another chunk knows how to go from 3 to 4. Consequently the code can be applied no matter what version they are currently on. I handle rollbacks via backups and other forms of checkpointing to get back to a known state. Changes are far more serious than the cosmetic internal name of a column. For example one to one relationships can change into one to many which requires creating new tables that can be joined and copying data around. At the end of the day though it is a series of SQL statements that do the schema transformation and data manipulation. > I've simply requested from SQLite devs to add an internal mechanism to > facilitate renaming columns, not a magic function. They will happily take your money for this important to you feature. And since SQLite is public domain you or anyone else can also code it up. The volume of responses is an indication that this feature is not simple, there are many corner cases and the actual need for it is rare. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk3Qp6UACgkQmOOfHg372QRAtgCgnD8KhtsCUBB80cGCkMBWlB5O wtYAn23XfCW8OHNCx5Na57z8YkfU32LP =JWIs -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
