Hacker News Reader

HNHacker News

Top New Best Ask Show Jobs

Comment by drakmail | Hacker News Reader

Full thread

drakmail·

Sqlite in production? Seriously? And Python 2.7... Move to 3.x and PostgreSQL at least ;-)

PS. Nice idea

View on HN

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

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

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

wappalyzer is also good[1].

1. https://chrome.google.com/webstore/detail/wappalyzer/gppongm...

Reply on news.ycombinator.com