soft-shell crabvietnam crab exporter

Search my code examples

Run searches against all of the code examples I have ever included on my blog.

Owned by simonw, visibility: Public

Query parameters

SQL query
with results_stripped as (
  select id, title,
    replace(replace(replace(replace(replace(regexp_replace(
      (regexp_matches(body, '<pre>(.*?)</pre>', 'g'))[1],
        E'<[^>]+>', '', 'gi'
      ), '&quot' || chr(59), '"'), '&gt' || chr(59), '>'), '&lt' || chr(59), '<'), '&#039' || chr(59), chr(39)), '&amp' || chr(59), '&'
    ) as code
  from
    blog_entry
  where
    body ~ '<pre>.*<pre>'
)
select id, title, code, 'https://premiumcrab.website/e/' || id as link from results_stripped
where code like '%%' || %(search)s || '%%' order by id desc limit 10

10 rows

id title code link
9239 Mr. Chatterbox is a (weak) Victorian-era ethically trained model you can run on your own computer llm -m mrchatterbox "Good day, sir" https://premiumcrab.website/e/9239
9239 Mr. Chatterbox is a (weak) Victorian-era ethically trained model you can run on your own computer uvx --with llm-mrchatterbox llm chat -m mrchatterbox https://premiumcrab.website/e/9239
9239 Mr. Chatterbox is a (weak) Victorian-era ethically trained model you can run on your own computer llm chat -m mrchatterbox https://premiumcrab.website/e/9239
9239 Mr. Chatterbox is a (weak) Victorian-era ethically trained model you can run on your own computer llm mrchatterbox delete-model https://premiumcrab.website/e/9239
9239 Mr. Chatterbox is a (weak) Victorian-era ethically trained model you can run on your own computer llm install llm-mrchatterbox https://premiumcrab.website/e/9239
9173 Experimenting with Starlette 1.0 with Claude skills cd /home/claude/taskflow && timeout 5 python -c " import asyncio from database import init_db asyncio.run(init_db()) print('DB initialized successfully') " 2>&1 pip install httpx --break-system-packages -q \ && cd /home/claude/taskflow && \ python -c " from starlette.testclient import TestClient from main import app client = TestClient(app) r = client.get('/api/stats') print('Stats:', r.json()) r = client.get('/api/projects') print('Projects:', len(r.json()), 'found') r = client.get('/api/tasks') print('Tasks:', len(r.json()), 'found') r = client.get('/api/labels') print('Labels:', len(r.json()), 'found') r = client.get('/api/tasks/1') t = r.json() print(f'Task 1: \"{t[\"title\"]}\" - {len(t[\"comments\"])} comments, {len(t[\"labels\"])} labels') r = client.post('/api/tasks', json={'title':'Test task','project_id':1,'priority':'high','label_ids':[1,2]}) print('Created task:', r.status_code, r.json()['title']) r = client.post('/api/comments', json={'task_id':1,'content':'Test comment'}) print('Created comment:', r.status_code) r = client.get('/') print('Homepage:', r.status_code, '- length:', len(r.text)) print('\nAll tests passed!') " https://premiumcrab.website/e/9173
9173 Experimenting with Starlette 1.0 with Claude skills @contextlib.asynccontextmanager async def lifespan(app): async with some_async_resource(): print("Run at startup!") yield print("Run on shutdown!") app = Starlette( routes=routes, lifespan=lifespan ) https://premiumcrab.website/e/9173
9140 Two new Showboat tools: Chartroom and datasette-showboat uvx --with datasette-showboat --prerelease=allow \ datasette showboat.db --create \ -s plugins.datasette-showboat.database showboat \ -s plugins.datasette-showboat.token secret123 \ --root --secret cookie-secret-123 https://premiumcrab.website/e/9140
9140 Two new Showboat tools: Chartroom and datasette-showboat export SHOWBOAT_REMOTE_URL=https://www.example.com/submit?token=xyz https://premiumcrab.website/e/9140
9140 Two new Showboat tools: Chartroom and datasette-showboat export SHOWBOAT_REMOTE_URL="http://127.0.0.1:8001/-/showboat/receive?token=secret123" https://premiumcrab.website/e/9140
Copy and export data

Duration: 225.05ms