not possible:
- workloads over 15m for lambda last time I checked, unsure on other providers
- if you are looking to do anything stateful
possible but not ideal/inconveniences:
- cold starts can hamper latency sensitive apps (language dependant + there are things you can do)
- if you have consistent traffic its not very good value for money
- if you value local debugging
I think a lot of people in office jobs day dream about this sort of thing. My father-in-law is a third generation farmer producing ultra fine wool. I am a source of free labour at shearing time and I will tell you that when I treat myself to a sleep in on Monday morning and roll out of bed for standup at 9:30 I sit there with the biggest shit-eating grin on my face meanwhile my father in law is already 4 hours in to his 12+ hour day.
Also if I was to go into farming I'd have to do something with crops/fruits/vegetables. I am a bit of a softie but the realities of livestock husbandry when met with the economics of farming can be quite confronting.
I didn't mind prisma for managing the schema etc but also seen your linked github issue. I found other people recommend combining Prisma with Kysley. I have only used this in toy projects so take this with a grain of salt.
possible but not ideal/inconveniences: - cold starts can hamper latency sensitive apps (language dependant + there are things you can do) - if you have consistent traffic its not very good value for money - if you value local debugging