3 ms·
I got a little bit of assistance from Claude in figuring this out, but it pointed me in the right direction more than actually giving me the right sequence of c
by simonw 2y ago
I got a little bit of assistance from Claude in figuring this out, but it pointed me in the right direction more than actually giving me the right sequence of commands. Claude got me as far as:
gcc -o sqldiff sqldiff.c ../sqlite3.c -I.. -ldl -lpthread
Which was enough for me to figure out I needed to get the sqlite3.c amalgamation to build and then run gcc in the tool/ directory. I landed on this after a bit more poking:
gcc -o sqlite3-rsync sqlite3-rsync.c ../sqlite3.c -DSQLITE_ENABLE_DBPAGE_VTAB
I did have a much more useful interaction with an LLM later on: I was curious about the protocol used over SSH, so I copied the whole of this 1800 line C file:
https://github.com/sqlite/sqlite/blob/sqlite3-rsync/tool/sqlite3-rsync.c https://github.com/sqlite/sqlite/blob/sqlite3-rsync/tool/sql...
And pasted it into OpenAI o1-preview with the prompt "Explain the protocol over SSH part of this" - and got back a genuinely excellent high-level explanation of how that worked: https://chatgpt.com/share/6701450c-bc9c-8006-8c9e-468ab6f67e4b https://chatgpt.com/share/6701450c-bc9c-8006-8c9e-468ab6f67e...
- someone13 2y agoThat share link 404s for me, FWIW. I’d be interested in seeing it!
- simonw 2y agoWeird - https://chatgpt.com/share/6701450c-bc9c-8006-8c9e-468ab6f67e4b https://chatgpt.com/share/6701450c-bc9c-8006-8c9e-468ab6f67e... is working for me in a Chrome Incognito window. Here's a copy of the Markdown answer it gave me: https://gist.github.com/simonw/ffbf90e0602df04c2f6b387de42acba4 https://gist.github.com/simonw/ffbf90e0602df04c2f6b387de42ac...