-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/15/2011 07:48 PM, romtek wrote: > I was describing what I have to do during design time, which often happens > after a website has been launched and is operational.
Huh? You launch and have a site in production and then you design it? > I sometimes need to > add/modify features, and that sometimes requires that DB schema be changed. > So, I want the tool I use to let me do this easily. You as a developer have a schema, triggers, indices, queries, templates and other code that all work together. You also need need to have a plan for how changes are made (and rolled back) in production. SQLite does not come with a magic function that does this. No one else has written anything that precisely meets your needs because every situation and code base is sufficiently different. Your options are: - - Drop SQLite and use something else (note the 'Lite' in the name) - - Avoid renaming columns once deployed (also makes code less brittle) - - Write code that precisely meets your needs which generates sequences of SQL as outlined in the many responses - - Cobble together some other tools that do parts of this - - Pay the SQLite team or some other developer to implement this functionality Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk3Qk2QACgkQmOOfHg372QRsUACgre0eRVSQRht0lhVmsichQ9MN 474An3lwDT5aLfXkgx+B2o+iKevJN4cw =bUiG -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
