Re: [sqlite] SQLite "Frontend"?

2013-10-28 Thread Dan Kennedy 

On 10/28/2013 02:19 AM, Tim Streater wrote:

On 27 Oct 2013 at 18:29, Ulrich Goebel  wrote:


What I'm looking for is a bash-like frontend for SQLite. The sqlite3
does in principle what I want, but to test queries it would be very nice
to have a history of the commands entered, so the can be recalled an
edidet later by the arrow-keys. At the time I have to hack the entire
command again - and that is ab bit ...

You need to add:

#define HAVE_READLINE 1

near the start of shell.c, and rebuild the shell along with the latest 
amalgamation and the library that has the right version of, what is it, readln? 
Something like that. No need for a frontend at all.

--
Cheers  --  Tim


I don't think the binaries on the website are linked to readline. But
if the OP grabs the amalgamation package and does "./configure && make
install", I think there is a pretty good chance the installed shell
will.

Dan.


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

Re: [sqlite] SQLite "Frontend"?

2013-10-27 Thread Tim Streater 
On 27 Oct 2013 at 18:29, Ulrich Goebel  wrote: 

> What I'm looking for is a bash-like frontend for SQLite. The sqlite3
> does in principle what I want, but to test queries it would be very nice
> to have a history of the commands entered, so the can be recalled an
> edidet later by the arrow-keys. At the time I have to hack the entire
> command again - and that is ab bit ...

You need to add:

   #define HAVE_READLINE 1

near the start of shell.c, and rebuild the shell along with the latest 
amalgamation and the library that has the right version of, what is it, readln? 
Something like that. No need for a frontend at all.

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