Hector Dearman chromy

## CLAUDE_ONESHOT_SQLITE3_RO_VS_RW.md

      
              6 files
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                chromy
                / CLAUDE_ONESHOT_SQLITE3_RO_VS_RW.md
            
            
              Last active
              September 7, 2025 12:06
            
              
                One shot claude for sqlite3 demo ro vs. rw for :memory:
              
          
    One shot claude for sqlite3 demo ro vs. rw for :memory:

Prompt:

We need to make an repro to prove some behiour about sqlite3. We need to make a single C file which demonstrates it's possible to open two connections to the same in memory database one with read/write and one with read only. To prove this we should create the two connections then do three queries. One on the rw connection to create and populate a table. One on the ro connection to show it can see these rows and finally a query on the ro connection which attemtps (and fails) to write to this table. And each query we should printf and explanation of what is happening. Finally we should add a bash script which compiles and runs this file. Think super hard about this. Let do the first steps of this now.

Cost:
Total cost:            $0.78
Total duration (API):  4m 57.5s
Total duration (wall): 11m 10.8s


## app.py
import sys
from tempfile import TemporaryFile
from urllib.parse import urlparse, parse_qs, unquote
from http.server import HTTPServer, BaseHTTPRequestHandler
from .tasks_to_dot import exec_task, to_dot, exec_dot
import html
from tasklib import TaskWarrior

TASK_PAGE = """<!doctype html>
<html lang=en>

## extract_bindings.ts
import {wgsl, linkBundle, bindBundle, extractBindings, bundleToAttributes} from "@use-gpu/shader/wgsl";

const bundle = bindBundle(wgsl`
struct VertexOut {
  @builtin(position) position : vec4f,
  @location(0) color : vec4f
}

struct Uniforms {
  modelViewProjectionMatrix : mat4x4<f32>,

## index.html
<html>

  <head>
  </head>
  <body>

  <script>

function openTrace(arrayBuffer, title) {
    const PERFETTO_ORIGIN = "https://ui.perfetto.dev";

## BUILD.gn
config("abseil_config") {
  include_dirs = [ "." ]
  configs = [ ":public_suppress_warnings_config" ]
}

config("public_suppress_warnings_config") {
  cflags = [ "-Wno-deprecated-builtins" ]
}

config("suppress_warnings_config") {

## index.html
<!doctype html>
<html lang="en-us">
<link rel="shortcut icon" href="data:image/x-icon;," type="image/x-icon">
<body>

<style>
pre {
  border: 1px solid #eee;
  margin: 10px 0;
  font-family: monospace;

## .block
license: gpl-3.0
height: 600

## README.md

      
              2 files
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                chromy
                / README.md
            
            
              Last active
              April 21, 2017 14:30
            
          
    Click to drag nodes. Dashed links are resolved suits; green links are licensing.
Thomson Reuters published a rather abysmal infographic showing the "bowl of spaghetti" that is current flurry of patent-related suits in the mobile communications industry. So, inspired by a comment by John Firebaugh, I remade the visualization to better convey the network. That company in the center? Yeah, it's the world's largest, so little wonder it has the most incoming suits.
Implemented in D3.js.

  
## HeapDumpViewer-TimelineRawData-20170125T203028
[{"pid":79498,"tid":1295,"ts":216941129400,"ph":"X","cat":"toplevel","name":"MessageLoop::RunTask","args":{"src_file":"../../third_party/WebKit/Source/platform/scheduler/base/task_queue_impl.cc","src_func":"PushOntoImmediateIncomingQueueLocked"},"dur":71,"tdur":60,"tts":1096954},
{"pid":79498,"tid":1295,"ts":216941129427,"ph":"X","cat":"toplevel","name":"TaskQueueManager::ProcessTaskFromWorkQueue","args":{"src_file":"../../base/trace_event/trace_log.cc","src_func":"SetEnabled"},"dur":14,"tdur":11,"tts":1096974},
{"pid":79498,"tid":1295,"ts":216941129447,"ph":"X","cat":"toplevel","name":"TaskQueueManager::ProcessTaskFromWorkQueue","args":{"src_file":"../../base/trace_event/trace_log.cc","src_func":"SetEnabled"},"dur":8,"tdur":5,"tts":1096994},
{"pid":79498,"tid":1295,"ts":216941129457,"ph":"X","cat":"toplevel","name":"TaskQueueManager::ProcessTaskFromWorkQueue","args":{"src_file":"../../base/trace_event/trace_log.cc","src_func":"SetEnabled"},"dur":8,"tdur":4,"tts":1097004},
{"pid":79498,"tid":17463,"ts":216941

## Traceback
Traceback (most recent call last):
  File "../project/bugs/cuda_broken_109e128133d6622d99d80fe99144cf269e1039bf.py", line 17, in <module>
    p()
  File "../project/bugs/cuda_broken_109e128133d6622d99d80fe99144cf269e1039bf.py", line 8, in p
    V = FunctionSpace(mesh, "CG", degree)
  File "/homes/hjd11/proj/Firedrake/PyOP2/pyop2/caching.py", line 161, in __new__
    obj = make_obj()
  File "/homes/hjd11/proj/Firedrake/PyOP2/pyop2/caching.py", line 142, in make_obj
    obj.__init__(*args, **kwargs)
  File "/homes/hjd11/proj/Firedrake/firedrake/firedrake/functionspace.py", line 518, in __init__
	import sys
	from tempfile import TemporaryFile
	from urllib.parse import urlparse, parse_qs, unquote
	from http.server import HTTPServer, BaseHTTPRequestHandler
	from .tasks_to_dot import exec_task, to_dot, exec_dot
	import html
	from tasklib import TaskWarrior

	TASK_PAGE = """<!doctype html>
	<html lang=en>
	import {wgsl, linkBundle, bindBundle, extractBindings, bundleToAttributes} from "@use-gpu/shader/wgsl";

	const bundle = bindBundle(wgsl`
	struct VertexOut {
	@builtin(position) position : vec4f,
	@location(0) color : vec4f
	}

	struct Uniforms {
	modelViewProjectionMatrix : mat4x4<f32>,
	<html>

	<head>
	</head>
	<body>

	<script>

	function openTrace(arrayBuffer, title) {
	const PERFETTO_ORIGIN = "https://ui.perfetto.dev";
	config("abseil_config") {
	include_dirs = [ "." ]
	configs = [ ":public_suppress_warnings_config" ]
	}

	config("public_suppress_warnings_config") {
	cflags = [ "-Wno-deprecated-builtins" ]
	}

	config("suppress_warnings_config") {
	<!doctype html>
	<html lang="en-us">
	<link rel="shortcut icon" href="data:image/x-icon;," type="image/x-icon">
	<body>

	<style>
	pre {
	border: 1px solid #eee;
	margin: 10px 0;
	font-family: monospace;
	[{"pid":79498,"tid":1295,"ts":216941129400,"ph":"X","cat":"toplevel","name":"MessageLoop::RunTask","args":{"src_file":"../../third_party/WebKit/Source/platform/scheduler/base/task_queue_impl.cc","src_func":"PushOntoImmediateIncomingQueueLocked"},"dur":71,"tdur":60,"tts":1096954},
	{"pid":79498,"tid":1295,"ts":216941129427,"ph":"X","cat":"toplevel","name":"TaskQueueManager::ProcessTaskFromWorkQueue","args":{"src_file":"../../base/trace_event/trace_log.cc","src_func":"SetEnabled"},"dur":14,"tdur":11,"tts":1096974},
	{"pid":79498,"tid":1295,"ts":216941129447,"ph":"X","cat":"toplevel","name":"TaskQueueManager::ProcessTaskFromWorkQueue","args":{"src_file":"../../base/trace_event/trace_log.cc","src_func":"SetEnabled"},"dur":8,"tdur":5,"tts":1096994},
	{"pid":79498,"tid":1295,"ts":216941129457,"ph":"X","cat":"toplevel","name":"TaskQueueManager::ProcessTaskFromWorkQueue","args":{"src_file":"../../base/trace_event/trace_log.cc","src_func":"SetEnabled"},"dur":8,"tdur":4,"tts":1097004},
	{"pid":79498,"tid":17463,"ts":216941
	Traceback (most recent call last):
	File "../project/bugs/cuda_broken_109e128133d6622d99d80fe99144cf269e1039bf.py", line 17, in <module>
	p()
	File "../project/bugs/cuda_broken_109e128133d6622d99d80fe99144cf269e1039bf.py", line 8, in p
	V = FunctionSpace(mesh, "CG", degree)
	File "/homes/hjd11/proj/Firedrake/PyOP2/pyop2/caching.py", line 161, in __new__
	obj = make_obj()
	File "/homes/hjd11/proj/Firedrake/PyOP2/pyop2/caching.py", line 142, in make_obj
	obj.__init__(args, *kwargs)
	File "/homes/hjd11/proj/Firedrake/firedrake/firedrake/functionspace.py", line 518, in __init__