One Billion Cells – Another Multiplayer Demo with Clojure

andersmurphy

Oh, fun. I wasn't expecting this on here so soon. It's very MVP and currently running on a 5$ VPS.

Happy to answer any questions.

andersmurphy

And we're back on a 10$ VPS.

konsalexee

What is the full stack you are using? What parts also require scaling up? DB, bandwidth orrr?

andersmurphy

So the stack is datastar + clojure + sqlite + caddy on a hetzner VPS 2 core 2G.

The scaling was preemptive as it was hitting 150% CPU (out of 200%). Needed to power down to rescale.

Now it's hovering at around 200% (out of 400%). About 80kb/s and 10 disk iops.

Everything goes via a sqlite db.

spintin

[dead]

amadeuspagel

On mobile, when I click on one of the cells, my keyboard opens.

andersmurphy

So that you can type in the field. It does shift the layout which is annoying.

I put this together in a day and wasn't planning on it being on HN. So there's definitely some jank/UX polish.

For example the typing experience is nicer on chrome as the field sizes to the text.

Theofrastus

Has someone already animated Bad Apple on there?

Or played Doom, for that matter.

andersmurphy

I'm just heading off on holiday so if someone does... Please make a gif so I can watch it on my return.

There's a bad apple demo on the datastar site. Datastar's[1] streaming hypermedia is what makes this possible, that and good old Clojure and sqlite.

fambalamboni

[dead]

freilanzer

What the hell am I even looking at?

fambalamboni

[dead]