Hacker News new | ask | show | jobs
by eralpb 3205 days ago
I didn't know Python3 offers better performance to be honest, but Sqlite is a real ordeal for this t2.micro now ;)

(Switched to PostgreSQL in a hot-change fashion!)

2 comments

SQLite can handle a lot more than people think. The SQLite website uses it for production (https://www.sqlite.org/whentouse.html)
It can handle a lot of reads, but you'll have problems with multiple concurrent writes (at least with Python). I run read-heavy production websites on SQLite just fine, though.
How much do you pay for your t2.micro?
It's $9.50/month. Quite a lot of money for 1GB RAM, 1 vCPU.

https://aws.amazon.com/ec2/instance-types/t2/

It doesn't make sense if you are not orchestrating them heavily, really.
Even if you do, if you need lots of power, just get a cheap powerful VPS or even dedicated.

AWS advantage is infinite redundancy, you can fully automate failing servers. But it looks like you have to pay around 10X for that.

I think we are saying the same thing :)