Hacker News new | ask | show | jobs
by drakmail 3206 days ago
Sqlite in production? Seriously? And Python 2.7... Move to 3.x and PostgreSQL at least ;-)

PS. Nice idea

2 comments

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!)

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 :)
how did you come to know which stack, the app is using..
I had the Debug mode on, which gives MANY information about the stack and all that :)
this makes sense...but still he knows which database you are using. I dont think debug errors give that information. Or does it???
With Django debug toolbar or even flask debug toolbar, you can have this can of information.
It does