On Fri, Dec 9, 2016 at 11:05 PM, Roger Binns <[email protected]> wrote:
> On 09/12/16 06:29, [email protected] wrote: > > I'm writing to ask if it is possible to have table completion for SQL > queries in the interactive shell? > > The APSW shell (compatible with the SQLite one) has completion and > colouring: > > https://rogerbinns.github.io/apsw/shell.html > > Disclaimer: I am the author > > You don't need to know anything about python etc to use it. > > Implementing completion is also quite fun if anyone wants to discuss it > further. > I'd love to have completion in the SQLite shell. How did you implement completion in APSW? Given that you typically don't know the context (tables) involved when writing the select clause for example, do you just propose any column or declared functions? There even isn't a way to list declared functions, despite wishes for a pragma for it, so can't even provide completion in a generic way, especially with dynamically loaded modules. --DD _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
