[benbjohnson]

Litestream/LiteFS author here. I agree that "cloud" is a bit ambiguous but Go & SQLite are quite powerful together and I don't think it's only for beginners. Both are fast and have low overhead. In addition to lower cost versus RDS, there's near-zero query latency which eliminates a lot of performance problems. You can comfortably run tens or hundreds of requests per second on minimal hardware (e.g. 256MB or 512MB instances). There's a lot of room for scaling up before you hit a performance ceiling.

[msolberg]

I just watched your gophercon video on SQLite in production after seeing it in the article. Great talk. Anyone else who's interested can watch here: https://www.youtube.com/watch?v=XcAYkriuQ1o

[benbjohnson]

Thanks!

[ehutch79]

Tens of requests a second?

[benbjohnson]

A request can have a large range of queries within it so I was trying to account for that. If your requests are lightweight and mostly reads, you can do 1,000+ req/sec on a 256MB instance. YMMV.

[randomdata]

He's being generous. Indeed, your service will be lucky if it sees tens of requests per day.

[ehutch79]

:-|

Normally I'm on the side of 'do you actually get that much traffic?' but yeah, a dashboard view can generate dozens of requests alone, each with multiple queries.

[tacitusarc]

Do you mean tens or hundreds of thousands of requests per second?

[benbjohnson]

There aren’t many apps that have 100,000+ req/sec and you certainly can’t run them on modest hardware.

If your app averages 100 req/sec then that’s 8.4M requests per day. That’s more than most applications out there.