Lightnews — Scholar-powered news

Reposted by Amjith

Julia Evans

@b0rk.social.jvns.ca.ap.brid.gy

Just discovered litecli (https://github.com/dbcli/litecli), it feels like a big improvement over the default SQLite REPL (autocompletion! support for multiline queries! syntax highlighting!)

November 7, 2024 at 2:39 PM

Amjith

@amjith.bsky.social

New project lead for mycli. Roland Walker is taking the reins of leading mycli.

www.mycli.net/new-project-...

New Project Lead for mycli

www.mycli.net

April 24, 2025 at 3:18 AM

Reposted by Amjith

Matt Brophy

@brophdawg11.com

“My account remains and I may return when the Nazis leave”

Absolute banger of a response 👏

Scott Hanselman 🌮 @scott.hanselman.com · Mar 4

Thanks very much I appreciate the word of support, but do note that I have no professional obligation to share material on Twitter. I was on Twitter for almost 20 years sharing information for free. My account remains and I may return when the Nazis leave

March 4, 2025 at 4:29 PM

Amjith

@amjith.bsky.social

@simonwillison.net and @alexgarcia.xyz I'd love to do a lightning talk to show how llm tool is used in LiteCLI to help with writing SQL queries. I filled out the google form to enroll in the office hours. I haven't heard back from you folks.

January 31, 2025 at 12:01 AM

Amjith

@amjith.bsky.social

Latest litecli release with a new LLM feature. Ask questions about your DB and get a SQL query from an LLM to answer.

amjith.com/blog/2025/ll...

LLM in Litecli

** 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', documen...

amjith.com

January 29, 2025 at 3:59 PM

Amjith

@amjith.bsky.social

@simonwillison.net Any chance I could get you to merge this very small PR to your llm tool?

github.com/simonw/llm/p...

Tests are passing and I'm happy to address any feedback you have.

Show the default model when listing all available models. by amjith · Pull Request #688 · simonw/llm

Show the current default model in the list of models in the list printed by llm models.

github.com

January 5, 2025 at 7:21 PM

Amjith

@amjith.bsky.social

Figured out how to autocomplete subcommands in a click based CLI.

amjith.com/blog/2025/au...

This is an intermediate step to embedding @simonwillison.net's llm tool in litecli to use LLMs to write SQL queries.

Auto-Completing Click Commands

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 mod...

amjith.com

January 5, 2025 at 3:09 AM

Amjith

@amjith.bsky.social

TIL: How to restart a Python CLI from within the CLI.

amjith.com/blog/2025/re...

Restart a Python CLI

A simple snippet to restart a Python CLI from within the CLI. import os import sys import click @click.command() def cli(): click.echo("CLI is running.") # Logic that determines when to restart if cli...

amjith.com

January 5, 2025 at 12:05 AM

Amjith

@amjith.bsky.social

@simonwillison.net How are you able to cross post your messages between twitter, bluesky and mastadon?

January 5, 2025 at 12:01 AM

Amjith

@amjith.bsky.social

@simonwillison.net Thoughts about listing the default model when invoking `llm models`?

Kinda like:
```
$ llm models
Default: gpt-4o
OpenAI Chat: gpt-4o (aliases: 4o)
OpenAI Chat: gpt-4o-mini (aliases: 4o-mini)
```

December 29, 2024 at 7:19 PM

Amjith

@amjith.bsky.social

Introducing LLMs to LiteCLI.

amjith.com/blog/2024/in...

Ask questions to your database and get back a SQL query to answer that question.

Introducing LLMs to Litecli

LiteCLI is a command-line client for SQLite databases that has auto-completion and syntax highlighting. I’ve added the ability to use an LLM to create a SQL query. Disclaimer: This is an EXPERIMENTAL ...

amjith.com

December 16, 2024 at 8:58 AM

Amjith

@amjith.bsky.social

Goodbye, Netflix.

amjith.com/blog/2024/go...

Goodbye Netflix

“People are exhausting. But you’re not people.” A direct quote from my teammate during a dinner at a conference. We became very good friends after that trip. Back in 2017 I joined Netflix and moved ou...

amjith.com

December 15, 2024 at 5:37 PM

Reposted by Amjith

Peter W🤓

@wang.social

American fascism. Bend the knee.

Makes you just want to vomit.

Bloomberg News @bloomberg.com · Dec 15

ABC has agreed to donate $15 million to Donald Trump’s future presidential foundation or museum to settle claims that one of its anchors defamed the president-elect in describing a past court verdict against him.

ABC Settles Trump Defamation Case With a $15 Million Donation

ABC has agreed to donate $15 million to Donald Trump’s future presidential foundation or museum to settle claims that one of its anchors defamed the president-elect in describing a past court verdict ...

www.bloomberg.com

December 15, 2024 at 2:49 AM

Amjith

@amjith.bsky.social

Experimenting with adding LLM support to litecli. Heavily inspired by
@simonwillison.net's sqlite-utils-ask plugin.

December 14, 2024 at 6:29 AM

Amjith

@amjith.bsky.social

This quote from @antirez 's blog post is absolute chef kiss.

"great use of AI is not making machines do what you can do better."

https://antirez.com/news/144

December 11, 2024 at 1:37 AM