Ask HN: Optimal cloud service to run tiny website with back end Python + SQLite?

#1

Post by djoldman » Thu, Apr 23, 2020, 12:37 PM UTC

Web ninjas: What is your go-to cloud service for running a small website served with python + jinja2 + sqlite? The website does little besides searching an sqlite table, serving a form, and writing the form response to an sqlite table, all with minimal computation and bandwidth. Wants are:

  Low price
  Low maintenance time/cost
  Simplicity

My strengths do not include web development/servers but I know the basics. I'm particularly interested in the gotchas like: difficulties setting up SSL, transfer limits, and "X is perfect except that ____".

If I'm asking the wrong question or not providing enough info, please say so.

Re: Ask HN: Optimal cloud service to run tiny website with back end Python + SQLite?

#2

Post by znpy » Thu, Apr 23, 2020, 12:57 PM UTC

If you don't have too much load, heroku could be good for you, but you'll have to use postgresql. The free tier is nice though.

Re: Ask HN: Optimal cloud service to run tiny website with back end Python + SQLite?

#3

Post by codegladiator » Thu, Apr 23, 2020, 1:10 PM UTC

Linode/DigitalOcean

Re: Ask HN: Optimal cloud service to run tiny website with back end Python + SQLite?

#4

Post by karambahh » Thu, Apr 23, 2020, 1:12 PM UTC

Scaleway, with or without their DBaaS offer if you need more perf

Re: Ask HN: Optimal cloud service to run tiny website with back end Python + SQLite?

#5

Post by jklein11 » Thu, Apr 23, 2020, 2:33 PM UTC

how about a raspberry pi and dyndns?

Re: Ask HN: Optimal cloud service to run tiny website with back end Python + SQLite?

#6

Post by rasulkireev » Thu, Apr 23, 2020, 3:02 PM UTC

I've used DigitalOcean (ref link -> https://m.do.co/c/a2a2c0826ff3) to host my Django sites, both with postgresql and sqlite. It will take you some time to figure out how to host it.

Once you a succeed each subsequent time becomes much easier. Plus you get to learn a ton about server management.

There are fantastic posts that will help you.

https://www.digitalocean.com/community/tutorials/how-to-set-...

Re: Ask HN: Optimal cloud service to run tiny website with back end Python + SQLite?

#7

Post by kirubakaran » Thu, Apr 23, 2020, 3:05 PM UTC

How important is SQLite to you? I run https://crushentropy.com/ (high-res scheduling) on Google App Engine (Standard) with data persisted on Firebase. It costs me $0 per month.

Re: Ask HN: Optimal cloud service to run tiny website with back end Python + SQLite?

#8

Post by heavyset_go » Thu, Apr 23, 2020, 4:26 PM UTC

Oracle Cloud only if you can use a their free VPS tier. If you can't, then Heroku or a cloud free tier.

Re: Ask HN: Optimal cloud service to run tiny website with back end Python + SQLite?

#9

Post by paxpelus » Thu, Apr 23, 2020, 4:45 PM UTC

I hate messing with nginx and ssl configurations that why I tried caprover (https://caprover.com/) on a vultr server. It handles ssl through let's encrypt and it even includes some nice monitoring tool. It needs some familiarity with docker if you want to fully use its features but in general I am running it on 2 servers with success and I am very happy. I totally recommend it.

Re: Ask HN: Optimal cloud service to run tiny website with back end Python + SQLite?

#10

Post by joshmn » Thu, Apr 23, 2020, 5:01 PM UTC

Dokku + your favorite VPS: http://dokku.viewdocs.io/dokku/

Installation is a breeze and there are plugins. If you're at all familiar with Heroku's deploy, you'll love this. It's the closest thing I've found to `git push` without any thinking.