- NVIDIA/SkillSpector
github-trending
Security scanner for AI agent skills. Detect vulnerabilities, malicious patterns, and security risks. SkillSpector Security scanner for AI agent skills. Detect vulnerabilities, malicious patterns, and security risks before installing agent skills. Overview AI agent skills (used by Claude Code, Codex CLI, Gemini CLI, etc.) execute with implicit trust and minimal vetting. Research shows that 26.1% of skills contain vulnerabilities and 5.2% show likely malicious intent. SkillSpector helps you answer: "Is this skill safe to install?" Documentation Development guide — Architecture, package layout, and how to extend the analyzer pipeline. Features Multi-format input: Scan Git repos, URLs, zip files, directories, or single files 64 vulnerability patterns across 16 categories: prompt injection, d…
- puppeteer/puppeteer
github-trending
JavaScript API for Chrome and Firefox Puppeteer Puppeteer is a JavaScript library which provides a high-level API to control Chrome or Firefox over the DevTools Protocol or WebDriver BiDi. Puppeteer runs in the headless (no visible UI) by default Get started | API | FAQ | Contributing | Troubleshooting Installation npm i puppeteer # Downloads compatible Chrome during installation. npm i puppeteer-core # Alternatively, install as a library, without downloading Chrome. :::note Modern package managers (including npm (see the RFC), pnpm, Yarn, Bun, and Deno) block dependency install scripts by default. If the install script is blocked, Puppeteer will not download the browser during installation, leading to runtime errors. You can manually download the required browsers after installation by r…
- pytest-dev/pytest
github-trending
The pytest framework makes it easy to write small tests, yet scales to support complex functional testing .. image:: https://github.com/pytest-dev/pytest/raw/main/doc/en/img/pytest_logo_curves.svg :target: https://docs.pytest.org/en/stable/ :align: center :height: 200 :alt: pytest .. image:: https://img.shields.io/pypi/v/pytest.svg :target: https://pypi.org/project/pytest/ .. image:: https://img.shields.io/conda/vn/conda-forge/pytest.svg :target: https://anaconda.org/conda-forge/pytest .. image:: https://img.shields.io/pypi/pyversions/pytest.svg :target: https://pypi.org/project/pytest/ .. image:: https://codecov.io/gh/pytest-dev/pytest/branch/main/graph/badge.svg :target: https://codecov.io/gh/pytest-dev/pytest :alt: Code coverage Status .. image:: https://github.com/pytest-dev/pytest/ac…
- cypress-io/cypress
github-trending
Fast, easy and reliable testing for anything that runs in a browser. Documentation | Changelog | Roadmap The web has evolved. Finally, testing has too. Fast, easy and reliable testing for anything that runs in a browser. Join us, we're hiring. What is Cypress? Installing Install Cypress for Mac, Linux, or Windows, then get started. npm install cypress --save-dev or yarn add cypress --dev or pnpm add cypress --save-dev Contributing - develop branch Please see our Contributing Guideline which explains repo organization, linting, testing, and other steps. License This project is licensed under the terms of the MIT license. Badges Configure a badge for your project's README to show your test status or test count in the Cypress Cloud. Or let the world know your project is using Cypress with th…
- Free-TV/IPTV
github-trending
M3U Playlist for free TV channels Free TV This is an M3U playlist for free TV channels around the World. Either free locally (over the air): Or free on the Internet: Plex TV Pluto TV (English, Spanish, French, Italian) Redbox Live TV Roku TV Samsung TV Plus Youtube live channels To use it point your IPTV player to https://raw.githubusercontent.com/Free-TV/IPTV/master/playlist.m3u8. Philosophy The main goals for this playlist are listed below. Quality over quantity The less channels we support the better. All channels should work well. As much as possible channels should be in HD, not SD. Only one URL per channel (no +1, no alternate feeds, no regional declinations) Only free channels If a channel is normally only available via commercial subscriptions it has nothing to do in this playlist…
- shiyu-coder/Kronos
github-trending
Kronos: A Foundation Model for the Language of Financial Markets Kronos: A Foundation Model for the Language of Financial Markets Deutsch | Español | Français | 日本語 | 한국어 | Português | Русский | 中文 Kronos is the first open-source foundation model for financial candlesticks (K-lines), trained on data from over 45 global exchanges. 📰 News 🚩 [2025.11.10] Kronos has been accpeted by AAAI 2026. 🚩 [2025.08.17] We have released the scripts for fine-tuning! Check them out to adapt Kronos to your own tasks. 🚩 [2025.08.02] Our paper is now available on arXiv! 📜 Introduction Kronos is a family of decoder-only foundation models, pre-trained specifically for the "language" of financial markets—K-line sequences. Unlike general-purpose TSFMs, Kronos is designed to handle the unique, high-noise char…
- swc-project/swc
github-trending
Rust-based platform for the Web Make the web (development) faster. SWC (stands for Speedy Web Compiler) is a super-fast TypeScript / JavaScript compiler written in Rust. It's a library for Rust and JavaScript at the same time. If you are using SWC from Rust, see rustdoc and for most users, your entry point for using the library will be parser. Also, SWC tries to ensure that If you select the latest version of each crates, it will work for rust users. MSRV of crates is currently 1.73. To update all SWC crates you use, you can run curl https://raw.githubusercontent.com/swc-project/swc/main/scripts/update-all-swc-crates.sh | bash -s. This script will update all dependencies to the latest version and run cargo build to ensure that everything works. Note that you need jq cargo upgrade command …
- freeCodeCamp/freeCodeCamp
github-trending
freeCodeCamp.org's open-source codebase and curriculum. Learn math, programming, and computer science for free. freeCodeCamp.org's open-source codebase and curriculum freeCodeCamp.org is a friendly community where you can learn to code for free. It is run by a donor-supported 501(c)(3) charity to help millions of busy adults transition into tech. Our community has already helped more than 100,000 people get their first developer job. Our full-stack web development and machine learning curriculum is completely free and self-paced. We have thousands of interactive coding challenges to help you expand your skills. Table of Contents Certifications The Learning Platform Reporting Bugs and Issues Reporting Security Issues and Responsible Disclosure Contributing Platform, Build and Deployment St…
- GorvGoyl/Clone-Wars
github-trending
100+ open-source clones of popular sites like Airbnb, Amazon, Instagram, Netflix, Tiktok, Spotify, Whatsapp, Youtube etc. See source code, demo links, tech stack, github stars. Clone Wars - Open source clones of popular sites 100+ open-source clones and alternatives of popular sites like Airbnb, Amazon, Instagram, Netflix, TikTok, Spotify, WhatsApp, YouTube, etc. List contains source code, tutorials, demo links, tech stack, and GitHub stars count. Great for learning purpose! -Made by Gourav Goyal See full tables with better view 👉 gourav.io/clone-wars I need your help to maintain this list up to date 🙏. See contribution Guide. I'm also looking for a maintainer to merge PRs of new clones. There are 2 tables: Clones with Tutorials Table Full-stack clones with link to free tutorials. Clone…
- Introduction-to-Autonomous-Robots/Introduction-to-Autonomous-Robots
github-trending
Introduction to Autonomous Robots Introduction-to-Autonomous-Robots An open textbook focusing on computational principles of autonomous robots. The source-code is released under Creative Commons 4.0 (CC-BY-NC-ND), whereas the print version is copyrighted by MIT Press. You are therefore permitted to use images and content from the book for non-commercial purposes (including teaching) with proper attribution, but you cannot post compiled versions of the book online. The book is available on Amazon Introduction to Autonomous Robots, you can also review it and/or rate it there. How to compile Due to copyright issues, we are not allowed to have a freely available PDF version of this book online. However, you can create one yourself if you so choose! In order to compile a PDF of this book yours…
- iptv-org/iptv
github-trending
Collection of publicly available IPTV channels from all over the world IPTV Collection of publicly available IPTV (Internet Protocol television) channels from all over the world. Table of contents 🚀 How to use? 📺 Playlists 🗓 EPG 🗄 Database 👨💻 API 📚 Resources 💬 Discussions ❓ FAQ 🛠 Contribution ⚖ Legal © License How to use? Simply paste the link to one of the playlists into any video player that supports live streaming and press Open. Playlists The main playlist containing all channels available in the repository can be found at: https://iptv-org.github.io/iptv/index.m3u Links to other playlists can be found in the PLAYLISTS.md file. EPG Electronic Program Guide for most of the channels can be downloaded using utilities published in the iptv-org/epg repository. Database All channe…
- andrewyng/aisuite
github-trending
Simple, unified interface to multiple Generative AI providers OpenCoworker An AI agent that lives on your desktop, built on aisuite. OpenCoworker is a desktop AI agent that can not only chat, but also do deep research and carry out tasks for you on your computer. It can read files (with permission) to gain context, read/send messages (slack, email, etc.), and create real deliverables like PDF reports, documents, spreadsheets. It also supports scheduled automations, such as providing you a daily news summary. Requires bringing your own API key (OpenAI, Anthropic, Google) or run fully local with Ollama. Your data stays on your machine. ⬇ Download for macOS macOS 13+ (Apple Silicon) ⬇ Download for Windows Windows 10/11 (x64) · Quickstart: — install, connect a model, first tasks, automations.…
- chatwoot/chatwoot
github-trending
Open-source live-chat, email support, omni-channel desk. An alternative to Intercom, Zendesk, Salesforce Service Cloud etc. 🔥💬 Chatwoot The modern customer support platform, an open-source alternative to Intercom, Zendesk, Salesforce Service Cloud etc. Chatwoot is the modern, open-source, and self-hosted customer support platform designed to help businesses deliver exceptional customer support experience. Built for scale and flexibility, Chatwoot gives you full control over your customer data while providing powerful tools to manage conversations across channels. ✨ Captain – AI Agent for Support Supercharge your support with Captain, Chatwoot’s AI agent. Captain helps automate responses, handle common queries, and reduce agent workload—ensuring customers get instant, accurate answers. W…
- meshery/meshery
github-trending
Meshery, the cloud native manager --> --> If you like Meshery, please ★ this repository to show your support! 🤩 MESHERY IS A CLOUD NATIVE COMPUTING FOUNDATION PROJECT A self-service engineering platform, Meshery, is the open source, cloud native manager that enables the design and management of all Kubernetes-based infrastructure and applications (multi-cloud). As an extensible platform, Meshery offers visual and collaborative GitOps, freeing you from the chains of YAML while managing Kubernetes multi-cluster deployments. --> Try Meshery in your browser using the Cloud Native Playground (teaser video) Project Overview Presentation --> Functionality Infrastructure Lifecycle Management Meshery manages the configuration, deployment, and operation of your Cloud services and Kubernetes cluste…
- music-assistant/server
github-trending
Music Assistant is a free, opensource Media library manager that connects to your streaming services and a wide range of connected speakers. The server is the beating heart, the core of Music Assistant and must run on an always-on device like a Raspberry Pi, a NAS or an Intel NUC or alike. Music Assistant Music Assistant Server Music Assistant is a free, opensource Media library manager that connects to your streaming services and a wide range of connected speakers. The server is the beating heart, the core of Music Assistant and must run on an always-on device like a Raspberry Pi, a NAS or an Intel NUC or alike. Documentation and support Documentation https://music-assistant.io Beta Documentation https://beta.music-assistant.io For issues, please go to the issue tracker. For feature requ…
- We're not just fighting AI
hn-ai· 15-jun
Article URL: https://sayyesdono.pagecord.com/were-not-just-fighting-ai Comments URL: https://news.ycombinator.com/item?id=48537915 Points: 1 # Comments: 0
- Fugee, an agentic AI assistant for displaced people and asylum seekers [video]
hn-ai· 15-jun
Article URL: https://www.youtube.com/watch?v=PYGzJZj7LfM Comments URL: https://news.ycombinator.com/item?id=48536689 Points: 2 # Comments: 0
- Show HN: I used Claude to build my son a Minecraft phonics game
hn-ai· 15-jun
Article URL: https://alexocallaghan.com/minecraft-phonics-game Comments URL: https://news.ycombinator.com/item?id=48537272 Points: 1 # Comments: 0
- AI Agents Don't Need SMS APIs. They Need Infrastructure
hn-ai· 15-jun
Article URL: https://blog.bridgexapi.io/from-rest-apis-to-mcp-making-messaging-infrastructure-ai-native Comments URL: https://news.ycombinator.com/item?id=48536724 Points: 2 # Comments: 0
- AI demands more engineering discipline. Not less
hn-ai· 15-jun
Article URL: https://charitydotwtf.substack.com/p/ai-demands-more-engineering-discipline Comments URL: https://news.ycombinator.com/item?id=48537577 Points: 1 # Comments: 0
- Show HN: Canopy – parallel, sandboxed Claude Code sessions on macOS
hn-ai· 15-jun
Article URL: https://github.com/juliensimon/canopy Comments URL: https://news.ycombinator.com/item?id=48538315 Points: 1 # Comments: 0
- Manticore-projects/aurscan: Scan AUR packages for malware using Claude LLM
hn-ai· 15-jun
Article URL: https://github.com/manticore-projects/aurscan/tree/main Comments URL: https://news.ycombinator.com/item?id=48538118 Points: 1 # Comments: 0
- Airis – A zero-install, local AI ecosystem with autonomous PC control
hn-ai· 15-jun
Article URL: https://github.com/Samael-1976/Airis Comments URL: https://news.ycombinator.com/item?id=48538227 Points: 1 # Comments: 0
- Show HN: AgentBridge – translate and govern calls between AI agent protocols
hn-ai· 15-jun
Article URL: https://github.com/shadowhunter-92/agentbridge Comments URL: https://news.ycombinator.com/item?id=48536823 Points: 1 # Comments: 0
- The Cloudflare for Autonomous AI Agents
hn-ai· 15-jun
Article URL: https://github.com/tkngate/tkngate Comments URL: https://news.ycombinator.com/item?id=48538373 Points: 1 # Comments: 0
- Token-warden is a thrifty office manager for your AI assistants
hn-ai· 15-jun
Article URL: https://github.com/vukkt/token-warden Comments URL: https://news.ycombinator.com/item?id=48537725 Points: 1 # Comments: 0
- Derbyshire officer investigated for using AI to create evidence in cases
hn-ai· 15-jun
Article URL: https://news.sky.com/story/derbyshire-police-officer-investigated-for-using-ai-to-create-evidence-in-multiple-cases-13553661?dcmp=snt-sf-twitter Comments URL: https://news.ycombinator.com/item?id=48538345 Points: 2 # Comments: 0
- Ask HN: What does your local LLM setup looks like?
hn-ai· 15-jun
What models and hardware you are using? For what purpose? What were the challenges? Any tricks that helped you in doing this? This might help new users like me setup theirs. Comments URL: https://news.ycombinator.com/item?id=48536531 Points: 3 # Comments: 3
- Ask HN: Should AI be used at all as a total beginner?
hn-ai· 15-jun
I aspire to be a game developer or hardware engineer. Life has been rocky because of my undiagnosed ADHD (currently in the process of getting a treatment for it) and trying to get my highschool diploma but now I wish to start my journey into making games or tinkering with hardware. A problem keeps nagging at the back of my mind though.. Should AI be used at the beginning stages of learning programming? I try to remain neutral in most cases when I don't know something concretely but the more I venture into this landscape of AI & try to understand it I feel like my head's going to explode from all of the new terms (e.g. AI vegan, who even came up with that??) and from all the vast opinions on LLMs. I only ask for some advice from you guys, I also seek disconfirming arguments as to avoid con…
- What I have done with Claude Code in the last 60 days being a non tech person
hn-ai· 15-jun
I am a non tech person. Currently working as Product Marketing in a Series B startup. I am a Non Tech person. What I have built:- - Custom wordpress theme live on - https://thelatexlab.com, page speed score is 95+. - Project Tracking micro SaaS using Next.js, Supabase, Vercel, Posthog, Google Auth - used by 45 Users -- Made Two more custom wordpress theme for other businessess. - Made $4K in last 2 months. I am just mind blown if a non tech person like me can do this much then what's the ceiling for people who are Technical. And what it will be in next 1-2 years. Excited and scared both. Comments URL: https://news.ycombinator.com/item?id=48537722 Points: 3 # Comments: 3
- Ask HN: Do you have AI psychosis?
hn-ai· 15-jun
Comments URL: https://news.ycombinator.com/item?id=48538013 Points: 2 # Comments: 3
- Show HN: I used Claude Mythos to build my startup in 1 day
hn-ai· 15-jun
This sounds clickbait, but it’s true: I used Claude Mythos to build the full site in 1 day. Then Anthropic removed the model, so I had to go back to Opus. Comments URL: https://news.ycombinator.com/item?id=48537239 Points: 3 # Comments: 1
- Botsitting, botshitting, and the hidden human labor of AI at work
hn-ai· 15-jun
Article URL: https://www.glean.com/work-ai-institute/reports/work-ai-index-report Comments URL: https://news.ycombinator.com/item?id=48537232 Points: 1 # Comments: 0
- 'Worst Example of Misconduct': Court Affirms Sanctions for Erroneous AI Cites
hn-ai· 15-jun
Article URL: https://www.law.com/therecorder/2026/06/12/worst-example-of-misconduct-appellate-court-affirms-sanctions-against-law-firm-for-erroneous-ai-cites/ Comments URL: https://news.ycombinator.com/item?id=48536671 Points: 2 # Comments: 0
- I think a global AI pause almost certainly won't happen
hn-ai· 15-jun
Article URL: https://www.lesswrong.com/posts/mtNZG7Ee6JfBKhE2H/why-i-think-a-global-ai-pause-almost-certainly-won-t-happen Comments URL: https://news.ycombinator.com/item?id=48537580 Points: 3 # Comments: 0
- AI Resume Builder
hn-ai· 15-jun
Article URL: https://www.thehumancapitalhub.com/ai-resume-builder Comments URL: https://news.ycombinator.com/item?id=48537152 Points: 1 # Comments: 1
- Is using AI in school cheating?
hn-ai· 15-jun
Article URL: https://www.totalnoise.ai/blog/educationandai/ Comments URL: https://news.ycombinator.com/item?id=48536463 Points: 2 # Comments: 1
- Building N8n AI Automation Workflows: What I Learned Creating a Masterclass
hn-ai· 15-jun
Article URL: https://www.udemy.com/course/n8n-ai-automation-masterclass-build-ai-chatbots-hindi/?referralCode=4BD749DF5E397FC80B4C Comments URL: https://news.ycombinator.com/item?id=48537696 Points: 1 # Comments: 4
- Anthropic Dispatches Staff to D.C., Racing to Resolve AI Export Restrictions
hn-ai· 15-jun
Article URL: https://www.wsj.com/tech/ai/anthropic-dispatches-staff-to-d-c-racing-to-resolve-ai-export-restrictions-71303d42 Comments URL: https://news.ycombinator.com/item?id=48538360 Points: 1 # Comments: 0
- I know I can, but should I? Capability vs. Intent in the AI Goldrush
hn-ai· 15-jun
Article URL: https://aibuilderseries.substack.com/p/i-know-i-can-but-should-i-capability Comments URL: https://news.ycombinator.com/item?id=48538359 Points: 1 # Comments: 0
- The AI layoff wave is becoming a powder keg
hn-ai· 15-jun
Article URL: https://techcrunch.com/2026/06/15/the-ai-layoff-wave-is-becoming-a-powder-keg/ Comments URL: https://news.ycombinator.com/item?id=48537992 Points: 2 # Comments: 0
- How to Be Good at AI Research
hn-ai· 15-jun
Article URL: https://twitter.com/i/status/2064686372737454155 Comments URL: https://news.ycombinator.com/item?id=48537773 Points: 1 # Comments: 0
- Owning Your Token Capital: Building the Enterprise AI Learning Loop
hn-ai· 15-jun
Article URL: https://twitter.com/LakshyAAAgrawal/status/2066392532540670354 Comments URL: https://news.ycombinator.com/item?id=48537840 Points: 1 # Comments: 0
- Employees are checking out of AI
hn-ai· 15-jun
Article URL: https://www.asymptotes.ai/notes/the-self-replacement-crisis Comments URL: https://news.ycombinator.com/item?id=48538283 Points: 1 # Comments: 0
- [AINews] Fable and Mythos officially too dangerous to release
latentspace· 13-jun
We are in the strangest timeline.
- OpenAI WebRTC Audio Session, now with document context
simonw· 12-jun
<p><strong><a href="https://tools.simonwillison.net/openai-webrtc">OpenAI WebRTC Audio Session, now with document context</a></strong></p> I built the first version of this tool <a href="https://simonwillison.net/2024/Dec/17/openai-webrtc/">in December 2024</a> to try out the then-new OpenAI WebRTC API for interacting with their realtime audio models.</p> <p>Last month OpenAI <a href="https://openai.com/index/advancing-voice-intelligence-with-new-models-in-the-api/">introduced a brand new model</a> to that API called <a href="https://developers.openai.com/api/docs/models/gpt-realtime-2">GPT‑Realtime‑2</a>, which they promoted as "our first voice model with GPT‑5‑class reasoning" - with a Sep 30, 2024 knowledge cut-off.</p> <p>I've been waiting for that model to show up in the ChatGPT iPho…
- luau-wasm 0.1a0
simonw· 13-jun
<p><strong>Release:</strong> <a href="https://github.com/simonw/luau-wasm/releases/tag/0.1a0">luau-wasm 0.1a0</a></p> <p>See <a href="https://simonwillison.net/2026/Jun/13/publishing-wasm-wheels/">Publishing WASM wheels to PyPI for use with Pyodide</a> for details.</p> <p>Tags: <a href="https://simonwillison.net/tags/lua">lua</a>, <a href="https://simonwillison.net/tags/webassembly">webassembly</a>, <a href="https://simonwillison.net/tags/pyodide">pyodide</a></p>
- Publishing WASM wheels to PyPI for use with Pyodide
simonw· 13-jun
<p>The <a href="https://blog.pyodide.org/posts/314-release/">Pyodide 314.0 release announcement</a> (via <a href="https://news.ycombinator.com/item?id=48462759">Hacker News</a>) includes news I've been looking forward to for a long time:</p> <blockquote> <p>You can now publish Python packages built for Pyodide (or any Python runtime compatible with <a href="https://pyodide.org/en/stable/development/abi.html">the PyEmscripten platform defined in PEP 783</a>) directly to PyPI and install them at runtime.</p> <p>Previously, the Pyodide maintainers had to maintain, build, and host over 300 packages ourselves. This created a significant burden on our maintainers and became a major bottleneck for the community, as every new package required manual review.</p> <p>Moving forward, package maintain…
- Quoting Andrew Singleton
simonw· 12-jun
<blockquote cite="https://www.mcsweeneys.net/articles/ai-economics-for-dummies"><p>Jenny owns a crematorium. John’s propane company gives her a $20 billion investment in return for 5 percent of her operation. Jenny throws $10 billion into the incinerator, then pays John $10 billion to buy propane to burn that money to ashes. John reports that his AI investments have generated $10 billion in revenue this quarter and that he owns 5 percent of a $100 billion business. A reporter from <em>Forbes</em> is assigned to profile John and Jenny, and over the course of his research, he becomes embroiled in a passionate but confusing three-way love affair with them, which eventually turns into a polyamorous common-law marriage. His profile is glowing, but light on financial details.</p></blockquote> <…
- Statement on the US government directive to suspend access to Fable 5 and Mythos 5
simonw· 13-jun
<p><strong><a href="https://www.anthropic.com/news/fable-mythos-access">Statement on the US government directive to suspend access to Fable 5 and Mythos 5</a></strong></p> Well this is <em>nuts</em>:</p> <blockquote> <p>The US government, citing national security authorities, has issued an export control directive to suspend all access to Fable 5 and Mythos 5 by any foreign national, whether inside or outside the United States, including foreign national Anthropic employees. The net effect of this order is that we must abruptly disable Fable 5 and Mythos 5 for <strong>all</strong> our customers to ensure compliance. <strong>Access to all other Anthropic models</strong> <strong>will not be affected.</strong></p> <p>We received the directive from the government today at 5:21pm (ET). The let…
- Why AI hasn’t replaced software engineers, and won’t
simonw· 14-jun
<p><strong><a href="https://www.normaltech.ai/p/why-ai-hasnt-replaced-software-engineers">Why AI hasn’t replaced software engineers, and won’t</a></strong></p> Arvind Narayanan and Sayash Kappor take on the question of AI job losses through the lens of a profession that is uniquely suited to AI disruption - software engineering.</p> <blockquote> <p>In this essay, we argue that there is enough evidence to reject the narrative that once AI capabilities reach a certain threshold, it will cause mass layoffs. Given that this is true even in a sector with very few regulatory barriers, most other professions are likely to be even more cushioned.</p> </blockquote> <p>The first good news is that the data still doesn't support the idea that AI is causing mass unemployment.</p> <blockquote> <p>In Ma…
- Quoting Julia Evans
simonw· 15-jun
<blockquote cite="https://wizardzines.com/comics/write-for-one-person/"><p>[...] Instead, I picture a specific person and I just write for them. Often this person is "me, but 3 years ago" or a good friend.</p></blockquote> <p class="cite">— <a href="https://wizardzines.com/comics/write-for-one-person/">Julia Evans</a>, write for 1 person</p> <p>Tags: <a href="https://simonwillison.net/tags/writing">writing</a>, <a href="https://simonwillison.net/tags/julia-evans">julia-evans</a></p>
- Mapping SQLite result columns back to their source `table.column`
simonw· 13-jun
<p><strong>Research:</strong> <a href="https://github.com/simonw/research/tree/main/sqlite-column-provenance#readme">Mapping SQLite result columns back to their source `table.column`</a></p> <p>It would be neat if arbitrary SQL queries in <a href="https://datasette.io/">Datasette</a> could be rendered with additional information based on which columns from which tables were included in the results.</p> <p>To build that, we would need to be able to look at a SQL query like <code>select users.name, orders.total from users join orders on orders.user_id = users.id</code> and programmatically identify the <code>table.column</code> for each result - navigating not just joins but also more complex syntax like CTEs.</p> <p>I decided to set Claude Code (Opus 4.8, since Fable is currently <a href="…