Go and SQLite in the Cloud

Re:Go and SQLite in the Cloud by benbjohnson on Wednesday December 07, 2022 @11:12AM (#33896074)

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.

[ Parent | on HN ]

Re:Go and SQLite in the Cloud by msolberg on Wednesday December 07, 2022 @05:28PM (#33901253)

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

[ Parent | on HN ]

Re:Go and SQLite in the Cloud by benbjohnson on Wednesday December 07, 2022 @06:39PM (#33901981)

Thanks!

[ Parent | on HN ]

Re:Go and SQLite in the Cloud by ehutch79 on Wednesday December 07, 2022 @11:48AM (#33896638)

Tens of requests a second?

[ Parent | on HN ]

Re:Go and SQLite in the Cloud by benbjohnson on Wednesday December 07, 2022 @12:06PM (#33896929)

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.

[ Parent | on HN ]

Re:Go and SQLite in the Cloud by randomdata on Wednesday December 07, 2022 @12:00PM (#33896847)

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

[ Parent | on HN ]

Re:Go and SQLite in the Cloud by ehutch79 on Wednesday December 07, 2022 @02:02PM (#33898632)

:-|

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.

[ Parent | on HN ]

Re:Go and SQLite in the Cloud by tacitusarc on Wednesday December 07, 2022 @11:53AM (#33896732)

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

[ Parent | on HN ]

Re:Go and SQLite in the Cloud by benbjohnson on Wednesday December 07, 2022 @12:03PM (#33896905)

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.

[ Parent | on HN ]