Great idea. It should be usefull even in this form. Just one feature-request - activity logging. If other factor threads are calling sql-command or sql-query - showing requests and responses in formatted manner.
On Wed, May 6, 2009 at 3:48 PM, Diego Martinelli <[email protected]> wrote: > Hi all, > playing around with the db vocabs I ended up writing a little tool for > quick db testing and management in an sqlplus style (I called it > sqlplus because I work with oracle by day) directly in the listener. > A quick example (the output is actually formatted with a > tabular-output, sorry for bad indentation): > > ( scratchpad ) "counter.db" <sqlite-db> sqlplus > sqlplus> show > Tables Temporary? > ASIDES N > CONVERSATIONS N > PERMITS N > SESSIONS N > USERS N > test N > > sqlplus> describe users > Id Field Type Null? Default Pk > 0 USERNAME text Y 1 > 1 REALNAME text Y 0 > 2 PASSWORD blob N 0 > 3 SALT integer N 0 > 4 EMAIL text Y 0 > 5 TICKET text Y 0 > 6 CAPABILITIES blob Y 0 > 7 PROFILE blob Y 0 > 8 DELETED integer N 0 > > sqlplus> insert into test values ( 'zz', 666, 'OMG' ) > Ok. > > sqlplus> select * from test > A 0 lol > B 0 lol > zz 666 OMG > > sqlplus> bye > ( scratchpad ) > > The output is properly formatted and I added some colors (the 'Ok.' > message has actually a green background). > > Before pushing to github, I'd like to hear some feature requests if > you think this would be useful. > By now, I added 'show tables' and 'describe table' commands. It is > supposed to work in a db independent manner. > > Bye, > Diego > > ------------------------------------------------------------------------------ > The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your > production scanning environment may not be a perfect world - but thanks to > Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 > Series Scanner you'll get full speed at 300 dpi even with all image > processing features enabled. http://p.sf.net/sfu/kodak-com > _______________________________________________ > Factor-talk mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/factor-talk > ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ Factor-talk mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/factor-talk
