Re: [sqlite] A graphical tool to handle sqlite schema change(more than ALTER TABLE)

2013-09-18 Thread niubao
Thank you very much Simon, for your detailed and very clear explanation on this. I wonder if there is some materials, a tutorial or something, that are dedicated to SQLite schema change for beginners? There seems to be so many things to consider. -- View this message in context:

Re: [sqlite] A graphical tool to handle sqlite schema change(more than ALTER TABLE)

2013-09-18 Thread niubao
I'm sorry I don't quite understand your last reply, would you please explain a bit more? Thanks. On Wed, Sep 18, 2013 at 2:01 PM, Jason H [via SQLite] < ml-node+s1065341n7135...@n5.nabble.com> wrote: > It kinda is whe. All you nees is a select into > > Sent from Yahoo! Mail on Android > >

Re: [sqlite] A graphical tool to handle sqlite schema change(more than ALTER TABLE)

2013-09-18 Thread niubao
Thank you very much, i actually tried it earlier, but this Firefox tool does not allow me to change column names, and this is not a trivial feature that is missing. Am I missing something here? -- View this message in context:

Re: [sqlite] A graphical tool to handle sqlite schema change(more than ALTER TABLE)

2013-09-18 Thread niubao
Thank you very much, but this tool does not allow me to change column names, and this is not a trivial feature. Am I missing something here? On Sep 18, 2013 1:44 PM, "jreidthompson [via SQLite]" < ml-node+s1065341n71349...@n5.nabble.com> wrote: > > On Wed, 2013-09-18 at 11:02 -0700, Bao Niu

[sqlite] A graphical tool to handle sqlite schema change(more than ALTER TABLE)

2013-09-17 Thread niubao
Is there a tool that allows you to graphically change sqlite schema as simple as editing a spreadsheet? For example if I wanted to change a column name from "my_driving_hours" to "driving_time", instead of writing a line of code, I can just click on that column and type in the new name, letting