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

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)

On 19 Sep 2013, at 3:50am, Bao Niu wrote: > After a thorough trial I've finally got this firefox add-on to work > properly. And it's great! It basically provides everything that I needed, > except for one: changing foreign key constraints from the gui. Is it > possible to do

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

After a thorough trial I've finally got this firefox add-on to work properly. And it's great! It basically provides everything that I needed, except for one: changing foreign key constraints from the gui. Is it possible to do it from sqlite manager add-on? And more generally, when a database is

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

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)

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)

It kinda is whe. All you nees is a select into Sent from Yahoo! Mail on Android ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

On Wed, 18 Sep 2013 20:46:47 +, Reid Thompson wrote: > >On Wed, 2013-09-18 at 11:02 -0700, Bao Niu wrote: > >> > > Is there a tool that allows you to graphically change sqlite schema as >> > simple >> > > as editing a spreadsheet? >

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

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

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

On Wed, 2013-09-18 at 11:02 -0700, Bao Niu wrote: > > > Is there a tool that allows you to graphically change sqlite schema as > > simple > > > as editing a spreadsheet? https://code.google.com/p/sqlite-manager/ should meet your needs ___

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

Linux is the only operating system. On Sep 18, 2013 5:03 AM, "Simon Slavin" wrote: > > On 18 Sep 2013, at 1:49am, niubao wrote: > > > Is there a tool that allows you to graphically change sqlite schema as > simple > > as editing a spreadsheet? > > What

Re: [sqlite] SQLite clusters?

At 15:58 17/09/2013, Jason H wrote: That's the whole point of using SQLite, it's not 'big iron' - it's a bunch of iron filings working together. I'm just suggesting the amount of work to get such a thing going is not that much work, but I wanted to float it here to see if there were any good

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

On 18 Sep 2013 at 01:49, niubao wrote: > 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 >

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

On 18 Sep 2013, at 1:49am, niubao wrote: > Is there a tool that allows you to graphically change sqlite schema as simple > as editing a spreadsheet? What Operating System ? Simon. ___ sqlite-users mailing list

[sqlite] sqlite4 LSM storage: how many pages will be read in point search?

Hi all I read and debug sqlite4 codes for several days, the use of factional cascading pointer will reduce the overall key comparison numbers in the point query, but it wouldn't decease the numbers of accessed pages. In other words, say, we have L levels in the LSM tree, we will access L Pages

Re: [sqlite] a tool that allows you to graphically change sqlite schema

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,