P.S. The correct version of the command for deletion of events is:
```
#!/usr/bin/env bash
sqlite3 /path/to/nostr-relay/nostr.db "DELETE FROM event WHERE created_at < CAST(strftime('%s', datetime('now', '-365 days')) as INTEGER);"
```
nostr:nevent1qvzqqqqqqypzpm756j3chngqqnf3qvdp09e2df4rkvh7duu489vvgltryhet35gxqywhwumn8ghj76twv3jhsetj9e3k7unpvdkx2tnnda3kjctv9uq3wamnwvaz7tmjv4kxz7fwwpexjmtpdshxuet59uq36amnwvaz7tmwdaehgu3dxqezu7tpdd5ksmmwdejjucm0d5hsqg9zvcws00ht5ax48ejjr4a9kqgss9dxp38kfr3t3dzyx3awunug2g7e747s
Login to reply