oh and btw, for those that don't know, one cannot add or remove columns from sqlite.
that's why I think the add & remove columns feature is significant... but keep in mind the button won't work on fulltext tables. It'll work on tables with column affinity, but the affinities will get wiped. Cheers Chris On Nov 27, 6:29 pm, Khookie <[EMAIL PROTECTED]> wrote: > Hi > > Sorry about not doing this sooner - I've had several significant > events happen in my life over the past few days. > > http://sqliteanalyzer.appspot.com/ > > 1. You can paste the below text into it. > > create table test (field1, field2) > insert into test values ('123', '456') > select * from test > > 2. select each line and click execute button (Alt+E works as well on > Chrome, but other browsers will most likely bring up the Edit menu) > > 3. try the add & remove column functionality. > > there's no backend code, so you can save the webpage and put it right > on whatever server you want to run queries on. > > if you could give it a go and let me know what you think, that'd be > great. it's actually been really useful for me debugging some apps > lately. > > Chris > > On Nov 26, 1:43 pm, "sutarsa giri" <[EMAIL PROTECTED]> wrote: > > > wow sound interesting, > > but where is the url? > > > thx b4, > > gede sutarsa > > > On Sun, Nov 23, 2008 at 2:26 PM, Khookie <[EMAIL PROTECTED]> wrote: > > > > Hi > > > > I wrote a web-based sqlite UI that can interact with Google Gears > > > databases. > > > > Noteworthy features: > > > * allows selection of text in textarea to run specifically - like how > > > SQL Server Query Analyzer works > > > * shows a nice resultset table with SELECT queries > > > * works in background via workerpool so UI is more responsive > > > * ability to add or remove columns from table > > > > I'm sure there's lots more that can be done, but I only add features > > > as the need arises from my work. > > > > I would like to contribute this code to a repository if anyone's > > > interested, but not exactly sure how. Can anyone give me some > > > direction on the process? > > > > Cheers > > > > Chris
