4 ms·

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

eralpb 9y 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!)
- stefantheard 9y ago
  How much do you pay for your t2.micro?
  - olegkikin 9y ago
    It's $9.50/month. Quite a lot of money for 1GB RAM, 1 vCPU. https://aws.amazon.com/ec2/instance-types/t2/ https://aws.amazon.com/ec2/instance-types/t2/
    - egeozcan 9y ago
      It doesn't make sense if you are not orchestrating them heavily, really.
      - olegkikin 9y ago
        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.
        egeozcan 9y ago
        I think we are saying the same thing :)
- silly_giraffe 9y ago
  SQLite can handle a lot more than people think. The SQLite website uses it for production (https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html)
  - StavrosK 9y ago
    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.
fazkan 9y ago
how did you come to know which stack, the app is using..
- eralpb 9y ago
  I had the Debug mode on, which gives MANY information about the stack and all that :)
  - fazkan 9y ago
    this makes sense...but still he knows which database you are using. I dont think debug errors give that information. Or does it???
    - askz 9y ago
      With Django debug toolbar or even flask debug toolbar, you can have this can of information.
    - drakmail 9y ago
      It does
- binora 9y ago
  wappalyzer is also good[1]. 1. https://chrome.google.com/webstore/detail/wappalyzer/gppongmhjkpfnbhagpmjfkannfbllamg?hl=en https://chrome.google.com/webstore/detail/wappalyzer/gppongm...

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

stefantheard 9y ago
How much do you pay for your t2.micro?
- olegkikin 9y ago
  It's $9.50/month. Quite a lot of money for 1GB RAM, 1 vCPU. https://aws.amazon.com/ec2/instance-types/t2/ https://aws.amazon.com/ec2/instance-types/t2/
  - egeozcan 9y ago
    It doesn't make sense if you are not orchestrating them heavily, really.
    - olegkikin 9y ago
      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.
      - egeozcan 9y ago
        I think we are saying the same thing :)
silly_giraffe 9y ago
SQLite can handle a lot more than people think. The SQLite website uses it for production (https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html)
- StavrosK 9y ago
  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.

fazkan 9y ago

how did you come to know which stack, the app is using..

eralpb 9y ago
I had the Debug mode on, which gives MANY information about the stack and all that :)
- fazkan 9y ago
  this makes sense...but still he knows which database you are using. I dont think debug errors give that information. Or does it???
  - askz 9y ago
    With Django debug toolbar or even flask debug toolbar, you can have this can of information.
  - drakmail 9y ago
    It does
binora 9y ago
wappalyzer is also good[1]. 1. https://chrome.google.com/webstore/detail/wappalyzer/gppongmhjkpfnbhagpmjfkannfbllamg?hl=en https://chrome.google.com/webstore/detail/wappalyzer/gppongm...