dunithd / gaming-leaderboard Goto Github PK

On Mac OSX 14.1.1 (23B81) , when trying to run docker compose -f compose-clickhouse.yml up -d I was getting this error: chown: changing ownership of '/var/lib/clickhouse/'. After some research I solved it by appending:

volumes:
  clickhouse: null

And then changing the clickhouse volumes to clickhouse:/var/lib/clickhouse

In running your demo locally I noticed that "Active in last minute" was stuck at 0. I finally figured out that this is b/c now() was using UTC, not local, yet you are storing local timestamps.

To fix:

• In clickhouse.sql set created_at to DateTime('UTC') instead of DateTime
• In producer.py, use utcnow() => created_at = datetime.utcnow().strftime("%Y-%m-%d %H:%M:%S")

Thanks for a great demo overall!