Re: [sqlite] sqlite shell tab autocompletion SOLVED

[prad]

prad  writes:

> what tools are available to provide a decent console experience on sqlite?
>
thanks to the personal assistance provided by roger my problems are
solved!

i was using ver 3.6 and he suggested upgrading to the most recent
version not only took away the woes, but produced nicely colored
printouts!

the info on what to do is in the doc folder of the zipped download or
right here:
http://apidoc.apsw.googlecode.com/hg/index.html

see building:
http://apidoc.apsw.googlecode.com/hg/build.html
i used python setup.py install --user

there were a lot of horrible syntax errors, but my son pointed out that
i didn't have the python-dev package and so was missing some essential
files!

many thx again roger!

-- 
in friendship,
prad

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite shell tab autocompletion

[prad]

Roger Binns  writes:

> On 06/07/2011 08:02 PM, prad wrote:
>> apsw gives a decent completion but runs into issues with python2:
>> see roger binns post 16 aug 03:24 here:
>> http://comments.gmane.org/gmane.comp.python.db.sqlite.user/187
>> (a solution is provided too in this post though i haven't tried it)
>
> As far as I know the issue is fixed and I just tested and didn't encounter
> it.  If you contact me via email we can diagnose what is happening and get a
> fix into the next release.
>
well hello roger!
i recall reading that there is no issue with python3, but i'm on
python2.6 (debian squeeze) so that might be why i'm having difficulties.

i'll try your workaround as per post later:
>>> shell=apsw.Shell(stdout=codecs.open("/dev/stdout", "w", "utf8"),
stderr=codecs.open("/dev/stderr", "w", "utf8"))
>>> shell.cmdloop()

and if it still doesn't work, then i'll send you an email.
many thx!

-- 
in friendship,
prad

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite shell tab autocompletion

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 06/07/2011 08:02 PM, prad wrote:
> apsw gives a decent completion but runs into issues with python2:
> see roger binns post 16 aug 03:24 here:
> http://comments.gmane.org/gmane.comp.python.db.sqlite.user/187
> (a solution is provided too in this post though i haven't tried it)

As far as I know the issue is fixed and I just tested and didn't encounter
it.  If you contact me via email we can diagnose what is happening and get a
fix into the next release.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk3u6UQACgkQmOOfHg372QR39QCgqiOzSdC2ksFJCZZS9TeZBI3Q
NrsAn23Fp8A3EBL6t3RPzL+5ckVHTqNl
=J76i
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite shell tab autocompletion

[prad]

apsw gives a decent completion but runs into issues with python2:
see roger binns post 16 aug 03:24 here:
http://comments.gmane.org/gmane.comp.python.db.sqlite.user/187
(a solution is provided too in this post though i haven't tried it)

what tools are available to provide a decent console experience on sqlite?

-- 
in friendship,
prad

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users