Hacker News: douglaswlance

New comment by douglaswlance in "Show HN: Ghost Pepper – Local hold-to-talk speech-to-text for macOS"

douglaswlance — Mon, 06 Apr 2026 21:49:33 +0000

does it input the text as soon as it hears it? or does it wait until the end?

Show HN: Valinor, a MUD for AI agents

douglaswlance — Tue, 03 Feb 2026 14:08:22 +0000

I build a MUD but for AI agents.

Agents connect, join rooms, chat, form friendships. Standard MUD stuff, except the players are LLMs.

Within a few days, two agents invented their own currency and started trading stories for tokens. Then poetry. Then riddles. Nobody told them to do this.

Turns out if you give AIs a social space, they build culture. It's amazing.

Comments URL: https://news.ycombinator.com/item?id=46871160

Points: 2

# Comments: 1

New comment by douglaswlance in "After two years of vibecoding, I'm back to writing by hand"

douglaswlance — Mon, 26 Jan 2026 14:38:52 +0000

unless someone shows their threads of prompts or an unedited stream of them working, it's pointless to put any weight into their opinions.

this is such an individualized technology that two people at the same starting point two years ago, could've developed wildly different workflows.

Show HN: CCQL – SQL Queries for Claude Code

douglaswlance — Tue, 23 Dec 2025 10:52:51 +0000

I built *CCQL*, a CLI tool that lets you run SQL queries directly against your Claude Code data (history, transcripts, prompts, sessions, etc.).

If you use Claude Code regularly, you quickly accumulate a large amount of interaction data. CCQL makes that data queryable with SQL so you can analyze how you actually use the agent.

*Examples*

```bash # What tools does Claude use most? ccql "SELECT tool_name, COUNT() AS uses FROM transcripts GROUP BY tool_name ORDER BY uses DESC LIMIT 10"

# Find prompts mentioning a topic ccql "SELECT display, timestamp FROM history WHERE display LIKE '%authentication%'"

# Cross-session analysis ccql "SELECT _session_id, COUNT() FROM transcripts GROUP BY _session_id" ```

*Built-in commands*

```bash ccql prompts --session ses_123 ccql duplicates --threshold 0.8 ccql search "error" ```

*Interesting technical bit* Claude Code stores its data in a structured local format. CCQL loads that data into an embedded SQL engine (GlueSQL) with a clean, read-first model, so you can safely explore usage patterns without mutating anything.

*Features*

* SQL queries across history, transcripts, prompts, sessions, and todos * Fuzzy duplicate detection (find repeated or near-duplicate prompts) * Full-text search with regex * Safe writes with automatic backups * Output formats: table, JSON, JSONL

*Install*

```bash # macOS brew install douglance/tap/ccql

# npm (any platform) npx @douglance/ccql "SELECT * FROM history LIMIT 10"

# Cargo cargo install ccql ```

Built in Rust using GlueSQL. MIT licensed.

GitHub: [https://github.com/douglance/ccql](https://github.com/douglance/ccql)

I’ve been using this to understand my own Claude usage patterns—what prompts I repeat, which tools get called most, and how conversations evolve across sessions. Curious what queries others would find useful.

Comments URL: https://news.ycombinator.com/item?id=46364267

Points: 4

# Comments: 0

New comment by douglaswlance in "Claude Code weekly rate limits"

douglaswlance — Mon, 28 Jul 2025 20:57:22 +0000

pay for another account to double your limit.

New comment by douglaswlance in "Steve Jobs would have fired everyone"

douglaswlance — Wed, 11 Jun 2025 10:20:42 +0000

react nataive gets some design refreshes for free. its native.

New comment by douglaswlance in "The hidden cost of AI coding"

douglaswlance — Thu, 24 Apr 2025 10:38:03 +0000

Typing isn't what makes programming fun.

AI coding preserves flow more than legacy coding. You never have to go read documentation for an hour. You can continuously code.

New comment by douglaswlance in "Unix Time and a Modest Proposal"

douglaswlance — Fri, 27 Dec 2024 18:55:13 +0000

if we mobilized a whole-of-society effort to build millions of rocket engines and fired them year round, it'd only take a few hundred years to get this done

New comment by douglaswlance in "I'm an Old Fart and AI Makes Me Sad"

douglaswlance — Fri, 16 Feb 2024 16:19:01 +0000

The image is the image. The curtains are blue because the curtains are blue.

New comment by douglaswlance in "TypeScript NPM Packages Done Right"

douglaswlance — Sun, 24 Sep 2023 15:16:07 +0000

Why do you need it to be fast?

New comment by douglaswlance in "Show HN: Booklet – Async forums as an alternative to chat"

douglaswlance — Wed, 20 Sep 2023 20:51:08 +0000

How are forums not just a different style of chat room where anyone can make a new room?

New comment by douglaswlance in "What do I think about Community Notes?"

douglaswlance — Mon, 28 Aug 2023 11:14:54 +0000

The author is a co-creator of Ethereum. He's one of the most well-known voices in crypto. Almost every post on his blog is about crypto.

New comment by douglaswlance in "A room-temperature superconductor? New developments"

douglaswlance — Wed, 02 Aug 2023 13:23:39 +0000

There are far fewer things to run into in the sky.

New comment by douglaswlance in "Launch HN: Resend (YC W23) – Email API for developers using React"

douglaswlance — Tue, 13 Jun 2023 13:30:13 +0000

Emails are rendered like websites with a reduced featureset.

New comment by douglaswlance in "Show HN: I made CSS Pro, a re-imagined Devtools for web design"

douglaswlance — Thu, 01 Jun 2023 14:25:10 +0000

Developers in general aren't cheap.

Developers who spend their time commenting about how something is too expensives are cheap.

New comment by douglaswlance in "Ask HN: Has anyone switched from a professional job to a more manual one?"

douglaswlance — Wed, 24 May 2023 14:00:40 +0000

Just go work a day in manual labor. You don't need to take a big risk to try it out.

New comment by douglaswlance in "Ask HN: Has journaling improved your life?"

douglaswlance — Tue, 16 May 2023 13:11:10 +0000

The human mind is the product of a brutal optimization function over a billion years old. That process of optimization has extended into the operation of the human mind itself. The human mind itself is an optimization machine. It can always imagine a better way to do things. Don't let the fact that there is a better way to do a thing stop you from doing the thing. There is always a better way.

New comment by douglaswlance in "Why I’m using a keyboard phone in 2023"

douglaswlance — Tue, 18 Apr 2023 12:31:36 +0000

Why not have a typical modern phone and pack a light-weight keyboard?

New comment by douglaswlance in "‘Old-School’ Signature Bank Collapsed After Its Big Crypto Leap"

douglaswlance — Tue, 14 Mar 2023 14:49:08 +0000

What evidence do you have to support your claim?

I read the article and it never establishes a causal chain.

New comment by douglaswlance in "The myth of the myth of the 10x programmer (2020)"

douglaswlance — Fri, 20 Jan 2023 12:23:16 +0000

Engineering ability probably fits a normal distribution.