---
title: "sqlite-utils command-line tool - sqlite-utils"
description: "!https://sqlite-utils.datasette.io/en/stable/cli.html#querying-data-directly-using-an-in-memory-database"
date: 2023-07-28
published: true
tags:
  - data
  - database
  - json
  - python
  - sql
  - sqlite
  - thought
template: link
---


<div class="embed-card embed-card-external">
  <a href="https://sqlite-utils.datasette.io/en/stable/cli.html#querying-data-directly-using-an-in-memory-database" class="embed-card-link" target="_blank" rel="noopener noreferrer">
    <div class="embed-card-content">
      <div class="embed-card-title">sqlite-utils command-line tool - sqlite-utils</div>
      <div class="embed-card-meta">sqlite-utils.datasette.io</div>
    </div>
  </a>
</div>


I want to like jq, but I think Simon is selling me on sqlite, maybe its just me but this looks readable, hackable, editable, memorizable.  Everytime I try jq, and its 5 minutes fussing with it just to get the most basic thing to work.  I know enough sql out of the gate to make this work off the top of my head


``` bash
curl  https://thoughts.waylonwalker.com/posts/ | sqlite-utils memory - 'select title, message from stdin where stdin.tags like "%python%"' | jq
```