I've loaded up neo4j with a pretty big amount of the follow graph. Anybody got a query they want me to run?

Does it count as inventing it if you Google and find out it already exists

watching htop while I run neo4j commands with the same energy that other people watch sports

We're in business. 4.9M nodes, 348M follows, imported into neo4j in 11.5min Listing my follows takes 775ms. Listing all my followers takes 1236ms.

neo4j import tool has a --bad-tolerance flag, which more software should have

I feel differently about it now but back in ‘04 I did download a car

[code talk] #atproto I now have a snapshot dataset of ~4.8M car files - users that hit the new relay since it was started. I rigged up a node cluster (12 workers) that runs through the car files and dumps the follow graph into 12 different CSVs. Throughput bounces btwn 200-400ps https://morel.us-east.host.bsky.network/xrpc/com.atproto.sync.getBlob?did=did:plc:ragtjsm2j2vknwkz3zp4oxrd&cid=bafkreib3qnlh4bydtfrxmiu4f76ygmqsuzelu2m7vihnwyvfawdg4cs6cy

Oh cool, the voice actor from Alters is here RE:

Just finished Alters. Game of the year so far for me It's a blend of base management, cosmic horror survival, and branching-choice narrative. I enjoyed the gameplay all the way till the end, and found it challenging in a good way https://morel.us-east.host.bsky.network/xrpc/com.atproto.sync.getBlob?did=did:plc:ragtjsm2j2vknwkz3zp4oxrd&cid=bafkreihxvggt3ofpnurkqbgxk6txtnu5v6fexxlqheqawcwpr5udkrojma