But because it's sqlite it's a single writer. Everything gets batched as one transaction every 100ms. The operations on a single chunk gets squashed into a single write.
Even without the squashing sqlite can handle 10000-20000+ updates/s because of the transaction batching.
With the chunk based squashing all edits to a chunk in that 100ms window become one update, so it can scale quite well.
Datastar is amazing, I can't wait for the next big release.
Once everything clicks it becomes a force multiplier and a joy to work with, something that helped me in that regard is throwing a "data-json-signals" on an element so its easier to keep an eye on things.
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.
And we're back on a 10$ VPS.
What is the full stack you are using? What parts also require scaling up? DB, bandwidth orrr?
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.
How are you doing the throttling? I imagine one malicious player might do like 10000 iops to your DB.
So there's no rate limiting.
But because it's sqlite it's a single writer. Everything gets batched as one transaction every 100ms. The operations on a single chunk gets squashed into a single write.
Even without the squashing sqlite can handle 10000-20000+ updates/s because of the transaction batching.
With the chunk based squashing all edits to a chunk in that 100ms window become one update, so it can scale quite well.
But the question wasn't really if you can handle it, but more if someone could control the whole board themselves, I think?
Oh, I mean they could try. It's a very big board. Probably possible though if someone is sufficiently motivated.
I see a snake eating the 0,0 part now at least, heh.
Btw, if I add a ' to the string, it's impossible to override by othrs. At least in the UI on Firefox, the snake still ate it.
Anders’ blog is a joy to read.
[dead]
On mobile, when I click on one of the cells, my keyboard opens.
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.
What the hell am I even looking at?
Has someone already animated Bad Apple on there?
Or played Doom, for that matter.
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.
- [1] https://github.com/starfederation/datastar
Datastar is amazing, I can't wait for the next big release.
Once everything clicks it becomes a force multiplier and a joy to work with, something that helped me in that regard is throwing a "data-json-signals" on an element so its easier to keep an eye on things.
[dead]
[dead]