That's why we have cloudwatch billing alarms :)

@hitko i just triggered the function several times over a cloudwatch eventbridge cron: max duration was 2.25 seconds, used storage was 55MB max.

using the price calculator without free tier, lambda should be free for my amount of ussage ?!

RoundUp (2250) = 2300 Duration rounded to nearest 100ms
31 requests x 2,300 ms x 0.001 ms to sec conversion factor = 71.30 total compute (seconds)
0.125 GB x 71.30 seconds = 8.91 total compute (GB-s)
8.91 GB-s x 0.0000166667 USD = 0.00 USD (monthly compute charges)
31 requests x 0.0000002 USD = 0.00 USD (monthly request charges)

@hitko thx for that, very helpful! i'm currently running on 128MB memory and i don't know it exactly, but it runs like 3-5 seconds at max. so it would be even lass than 1 cent ^^ did you use the calculator or where did you get that information?

@lknk "but it didn‘t sound like that‘s your use-case" that's true. it's a very simple project, like 70 lines of code :) so, i am looking for the best price/performance, but want to keep the option of scalability. might be best to go with aws either way.. ?!

@rooter either way, enjoy saturday and sunday then :D

@ScriptCoded yes, but why pay $5 when it could be even less? :)

@rooter your're very welcome, glad i could help with asking questions :) enjoy your weekend!

@rooter thx for your help, i appreciated it very much!

also, thx for book and hosting recommendation. didn't know about digital ocean droplets. but the design looks like AWS, doesn't it ?! :D

@rooter AWS pricing is worth a rant, actually ^^

@rooter Hey rooter! the last days i worked on this project and finished it last night *wohoo*. it's a simple python app, so i decided to not go with queueing. i don't expect it to block because it fetches 1 api endpoint, processes 1 json file and writes & transfers 1 csv file per day or per week (not yet decieded). but i will def. have a look into it for further projects and for knowledge ofc. i used the built-in ftplib and could establish a connection to a public test-ftp host. so that worked out fine for me as testing. what really grind my gears right now is to decide whtether to host it on AWS Lambda or even on Google Colaboration using AWS Cloud Watch or Google Cloud Scheduler for automatisation (i want to execute it once a day/week automated). do you have any experience in terms of ease of use and costs with any of these services?

@rooter i think a got it.. the only problem is, that i can't test it without a ftp server (not known yet). do you have any preferred Lib for writing tests and/or mock-tests to test the upload function against a mock or something like that?

and what is the point of using e.g. a queue? i could simply open my local file and stored it with storbinary to a specific path which a navigated to beforehand.

@rooter hi there, no, i was working on another project, didn't have time to check yet but appreciate your help. I'll let you know as soon as i verified it 👌

@EngineerCoding of course i want to leave professional. i just tought about something funny :)

@EmberQuill yes, totally :)

@C0D4 and stress in form of pain when you step on it :)

@gnog btw since we're talking about mistakes... i once forgot the where clause in my update statement :D luckily auto-commit was enabled ^^

@gnog shit :) anyways how can we cheer you up?

@alexbrooklyn i'm not familiar with your syntax then :P

@erandria thats not how work works.

@alexbrooklyn A transaction is the propagation of one or more changes to the database. E.g., if you are deleting a record from the table, then you are performing a transaction on that table. Most clients like sqldeveloper can rollback that transaction. But if its commited its commited.

Hory shet ... And you already commited the transaction?

but how?

The amount of incompetent profs is too damn high

@Stuxnet i guess that's only for US students. We only have 50% off on a premium account here in Swaziland. :( So, good for you :)

@Stuxnet i don't believe you. Even Spotify is 5$ per month on a student price base

@PrivateGER nope, i have a standard body like everybody else.

@PrivateGER within a few hours the nicotine is gone and there is no more physical withdrawal. Psychological habits subside after about 2 weeks, then you'll feel better. And if you have survived the first 6 months, the relapse rate is low.

@PrivateGER nope, there is no such thing like physical withdrawal, maybe max. the first few days. I smoked like 1-2 packs per day over 15 years. Is that enough for you to count as a smoker?

@Condor nothing special, tbh :) i set a goal (date) and just quit. It is your mind and motivation which needs to be ready. When you realise that smoking is kinda senseless and that you're harming everyone around you as well, then it will be easy for you too :)

@PrivateGER I faced it, as I said. It depends on your motivation, for me it was easy.