Part 1 LiteCLI has an optional feature to use LLM powered SQL generation to get answers from your database. The default LLM used by LiteCLI is OpenAI’s gpt-4o-mini. This can be changed to a different model including a local LLM running on Ollama. Here are the steps to show how to switch your LLM model. Run \llm to enable the feature. sqlite> \llm This will offer to enable this feature by installing the necessary libraries....
** This feature is ONLY enabled when it is used for the first time. ** LiteCLI v1.14.2 now has an LLM feature to help you write SQL. AsciinemaPlayer.create('/llm-in-litecli-1/litecli1.cast', document.getElementById('demo1'), { idleTimeLimit: 2, poster: 'npt:0:07', terminalFontSize: "15px", fit: false, }); Getting Started: Upgrade litecli to the latest version (at least v1.14.2 or higher). uv tool install litecli@latest Open a SQLite database with litecli. $ litecli your_database_file.db Run the special command \llm in the LiteCLI prompt....
Click is a python library for creating command line applications in Python. The llm tool created by Simon uses click and it has a lot of subcommands. eg: $ llm keys set openai Enter key: ... $ llm models default gpt-4o I am building a wrapper around this CLI tool that let’s me use it in an interactive REPL. I wanted autocompletion to help me remind the available subcommands and their appropriate nested subcommands....
During the late 1900s (1997) I learned about this theoretical concept called artificial intelligence, in high school. I asked my cousin (a CS college grad) about it. He explained that AI is a research field that is trying emulate a human brain but with a computer program. I wondered if that would be a nuisance? For instance, while I’m studying I get distracted and decide to start watching TV (Freewill?). What if the computer did the same?...