Useful for testing: stackoverflow.com/questions/21819183/how-to-use-ctes-with-update-delete-on-sqlite
sqlite3 :memory: 'WITH t (i, j) AS (VALUES (1, -1), (2, -2)) SELECT * FROM t' Research group of the Department of Engineering science of the University of Oxford Updated 2025-07-14 +Created 1970-01-01
Published as: arxiv.org/pdf/2304.03442.pdf Generative Agents: Interactive Simulacra of Human Behavior by Park et al.
AI Agents Behaving Like Humans by Prompt Engineering (2023)
Source. Cool data embedded in the Bitcoin blockchain cryptograffiti.info Updated 2025-07-14 +Created 1970-01-01
twitter.com/cryptograffiti (marked as joined March 2014)
At some point it stopped using Bitcoin mainline and moved to Bitcoin Cash instead: www.newsbtc.com/news/bitcoin/cryptograffiti-rejects-bitcoin-core-bch-now-available-payment-method/ and therefore became useless. Existing indexes seem to have been broken as well.
Also, based on the timing of Figure "Erich Erstu", this service may be responsible for a large part of the raw JPEG images present in the blockchain from block 416527 (2016) onwards. This is also suggested by the comments at Figure "Tank Man".
A Quantitative Analysis of the Impact of Arbitrary Blockchain Content on Bitcoin gives the interesting insight that all its transactions seem to return change/fees to one or two given addresses, thus making it very easy to list all their uploads if they were consistent! So all we need are some starting points, which we have mostly due to ASCII mentions of the site on known inscriptions, all of which have a few common spent addresses at the very end:so we just have to solve get all Bitcoin transactions from and to a given address and we are done. Blockchair shows about 800 entries as of February 2024, between 4f94f97eb156b8563a213bb292314a0bd9c95b39afc521fc5965d050daab2a78 (2014-03-02) and ac5f4ea03597b43a72fb8ab42bd5384629f87f4f4abc534f38b8c15148ccaf9f (2017-10-12): blockchair.com/bitcoin/outputs?s=time(desc)&q=recipient(1MVpQJA7FtcDrwKC6zATkZvZcxqma4JixS)
- 4c903a377addab7c1e35a685d3dabc664199e406374b1e5ce2fc59e78fb5b754: 1MVpQJA7FtcDrwKC6zATkZvZcxqma4JixS
- 87aad85c6cd75a516789f364637d243c668e3424d031ae510e43c6edfe6ed206: 1MVpQJA7FtcDrwKC6zATkZvZcxqma4JixS
- c206e8fff656f07b27dac831ef9b956792bae4e76a2cb43f14f49f0298bf2c2f: 1MVpQJA7FtcDrwKC6zATkZvZcxqma4JixS
- ca4f11131eca6b4d61daf707a470cfccd1ef3d80a6f8b70f1f07616b451ca64e: 1MVpQJA7FtcDrwKC6zATkZvZcxqma4JixS
Other related transactions:
- tx 87aad85c6cd75a516789f364637d243c668e3424d031ae510e43c6edfe6ed206 block 474652 (2017-07-07) via cryptograffiti.info the default pandoc markdown pandoc.org/try markdown tutorial string! First, unseen in our ASCII dumps due to UTF-8 encoding::followed by:
Unicode test: `Ä Ö Õ Ü ä ö õ ü`.And if ends with:An h1 header ============ Paragraphs are separated by a blank line.Uploaded from http://cryptograffiti.info to demonstrate Markdown rendering.
TODO understand what these are:
- ae92dc4c31943955ad6e3e45a4eb0067f488fdd9aecca65c946460dd2a85488d
- 3020dbd7c850bf8c19ebacf670a2830fe50999a8b2560a202af21d536760eea4
- d65384a21cb1c327cc42416a0b1e2a78ad0296cb7a15312bdcd67ef169ecb309
- a3e3100d2b9a86e310430945c001df97a70626220a9e151208aecbb613f1f152
- a9c82ebc47fabd1eed7eeea7760d0a3c99288af3c3a17e396ec790fc280698a2
- 92bfd5c0fb0f24efa6ca568c4475f44e94dfc8d0d4d5da04dfafc6261bf17f45
- 73c22adb21b93f9220d00d2614a50350824be95b8ea966349e6f35fe5ac5537b
- 099c0fd06d18953c886121ff143ea0a20d0baf29999f424fa1ac707a81cf4987
- 3ad6677303fb6f700a4f2f977fe86e5324e0ddb0d3b33a649e513d7e88904e85
- 31a2ddaf4b146e021246e1f82e28121f5c9c8729620978309004515c7e559910
- adaae897fd286aefb64a69e88a53e9af17ee98611ea595c3c92d038f3274d723
- d8bf48e9ad3de62c695ff34a96e340912bd62e0a0282b94da6386b837c31a30d
TODO find the Shroud of Turin one.
- twitter.com/digitalnaut/status/1757464079076098212 vampire killed by cross of cryptographic evidence
Unlisted articles are being shown, click here to show only listed articles.