david on Nostr: Pretty sure I’ll be able to automate periodic syncing of neo4j with strfry running ...
Pretty sure I’ll be able to automate periodic syncing of neo4j with strfry running on same server.
✅ Modify the strfry export command so it creates a csv with event id, author, kind, and created_at (might add tags, or might omit tags and keep it simple)
✅ create bash shell script which runs cypher query using cypher-shell command which accesses the csv file and loads each line into neo4j
Not yet done but should be straightforward: Automate the above as either a systemd service or maybe as a cron job using pm2
The only thing I haven’t figured out yet: can I get strfry to export only those event ids that have been received since the last time the above steps were called? (since receivedAt, not since created_at)
I *think* strfry records receivedAt in LMDB but I’m not sure.
✅ Modify the strfry export command so it creates a csv with event id, author, kind, and created_at (might add tags, or might omit tags and keep it simple)
✅ create bash shell script which runs cypher query using cypher-shell command which accesses the csv file and loads each line into neo4j
Not yet done but should be straightforward: Automate the above as either a systemd service or maybe as a cron job using pm2
The only thing I haven’t figured out yet: can I get strfry to export only those event ids that have been received since the last time the above steps were called? (since receivedAt, not since created_at)
I *think* strfry records receivedAt in LMDB but I’m not sure.