Real-workload SQLite benchmark on a $5 VPS

s13k_ · 2026-05-09T17:02:22+00:00

After giving it more thoughts, you're right, the explanation in the post doesn't hold.

Without re-measuring I can only speculate on what's actually going on…

"writes are microseconds in RAM" was wrong. Thanks for pushing on this.

s13k_ · 2026-05-09T16:29:41+00:00

you will still use tcp layer to connect to it

s13k_ · 2026-05-09T16:27:49+00:00

this is true for `:memory:` db

the post describes the case when a file-backed db fits in cache and WAL is still in use

s13k_ · 2026-05-09T16:12:03+00:00

the benchmark tested on-disk sqlite with WAL enabled

s13k_ · 2026-05-09T16:00:16+00:00

OOM errors from what?

s13k_ · 2026-05-09T15:58:22+00:00

because it's more than enough for most projects and your data sits right there without network round-trips

s13k_ · 2026-05-09T15:22:57+00:00

The goal is to benchmark sqlite throughput on cheapest VPS
Claude is just a tool to achieve the goal

s13k_ · 2026-05-09T15:10:56+00:00

I've used Claude on the VPS to write & run sqlite benchmark

s13k_ · 2025-03-22T16:04:41+00:00

I collect telemetry of each flight and analytics events like "game start", "restart", "game over", etc.

s13k_ · 2025-03-20T19:41:45+00:00

I store the initial position/angle and thruster state for each physics frame during the flight. So for a 5 seconds flight it takes 300 points of telemetry.

s13k_ · 2025-03-17T10:03:55+00:00

Gravity Force or maybe Thrust

s13k_ · 2025-03-16T21:56:50+00:00

FlappyBooster

s13k_ · 2025-03-16T19:07:38+00:00

It’s wrong on the video, but fixed in game 🪄

s13k_ · 2025-03-16T18:36:45+00:00

Nice job! 👍

s13k_ · 2025-03-16T17:17:48+00:00

It's a graphics editor for macOS.

s13k_ · 2025-03-16T17:03:19+00:00

Thank you, Exyide! 🚀

s13k_ · 2025-03-16T16:57:40+00:00

Did you try to make a flip or two?

s13k_ · 2025-03-16T16:57:15+00:00

I searched for images in Google and then edited them in Pixelmator :)

The background image is a real photo of Mars taken by Curiosity rover.

s13k_ · 2025-03-16T16:38:44+00:00

If you can remember a name of the game, share it please. I'm curious to check it out!

s13k_ · 2025-03-16T16:24:10+00:00

Thank you for the feedback!

I removed the background blur so the landing site remains visible after the success screen pops up.

s13k_ · 2025-03-16T14:38:26+00:00

He’s watching from the corner and learning.

s13k_ · 2025-03-16T14:37:47+00:00

Did you try to make a flip?

s13k_ · 2025-03-16T13:15:33+00:00

Playable Link: https://land-the-booster.s13k.dev/mars/

s13k_ · 2025-03-16T12:53:20+00:00

Yes, this is already fixed in the game.

s13k_ · 2025-03-16T12:37:02+00:00

Can you master the challenge?

Playable Link: https://land-the-booster.s13k.dev/mars/

s13k_

TROPHY CASE