I got followed on Mastodon by someone named "Martin Hitler", who has on his timeline reposts of people like "Nate Higgers @NathanielHigger1488" ΰ² _ΰ² 
Yess, looks like I fixed the timezone issue in the posts table - post timestamps as seen in psql are no longer one hour behind the post timestamps in ActiveRecord, so "the number of posts created in the last 5 minutes" finally returns non-zero values ;) https://lab.martianbase.net/xrpc/com.atproto.sync.getBlob?did=did:plc:oio4hkxaop4ao4wz2pp3f4cr&cid=bafkreibgpvfwwxnw7jcjl6ttu7mwbmulcm3gpf7jeovxtx4ivuplyufawm
I hope this means "Make Atproto Great Again" https://lab.martianbase.net/xrpc/com.atproto.sync.getBlob?did=did:plc:oio4hkxaop4ao4wz2pp3f4cr&cid=bafkreif2axqmrxje7gye6mput5x32kyn4ktedmfvgh2ud3f5ss42zdgrgq
Question for #atdev who are streaming from the firehose and have some kind of queue+workers setup (Redis, ZeroMQ etc.): How do you handle the cursor if there's more than one worker, and one worker being at seq=X doesn't mean that everything before X was processed?
Long live the Great Eurocanadian North Atlantic Union! πŸ‡ͺπŸ‡ΊπŸ‡¨πŸ‡¦πŸ‡ͺπŸ‡ΊπŸ‡¨πŸ‡¦πŸ‡ͺπŸ‡ΊπŸ‡¨πŸ‡¦ πŸ’™β€οΈ RE:
Rug-pulled by the President of the United States, smh RE:
When you say you're still using X: https://lab.martianbase.net/xrpc/com.atproto.sync.getBlob?did=did:plc:oio4hkxaop4ao4wz2pp3f4cr&cid=bafkreieqqp5kncrjwphum26nra7374yg2rimrp57mi6x724bpuzu2iehye
Uh oh 😬 RE:
Please be true please be true πŸ™πŸ» RE:
Welp, I might have just found a bug in #Rails (ActiveRecord migrations)… 🫠 No timestamp precision here in sql https://lab.martianbase.net/xrpc/com.atproto.sync.getBlob?did=did:plc:oio4hkxaop4ao4wz2pp3f4cr&cid=bafkreifj3aspxbnv2j3qpifk3bpsayhgv2eevtts6tbywpynybiydxnq2i