With n8n you don’t pay for executions like Lambda. You only pay for hosting this solution with unlimited workflows executions.
It depends. Do you want to control everything or not? Opensource usually needs more support by yourself.
Process automation visually. I didn’t tested it with low-cost servers. But it depends on what are you trying to do. Moving lots of data? With lots I mean 1M rows per day. Usually big data movements need another strategy.
You have node-red. This is opensource. But solutions are endless. Lots of them have a free use license.
Sure. You can use JSON files located in an S3 bucket. Or read XML and CSV files in Dropbox to process found data.
Not necessary. You can run n8n with sqlite. A file system database.
Google sheet and Airtable are supported. So you can use them as a datasource if you want.
Okay, but the question is whether this is a good solution? For a beginner it is better to create a simple project with a lot of data on the basis of such files or it completely replaces the need for a database?
The sheet table also seems to be readable. Why should I use a database that I do not understand when it can be a sheet. However, sheets are not popular and everyone does projects based on popular databases. Why?
Do you have an existing MySQL(or similar database)? Or you usually work with excel/csv/json files?
Databases make sense when you have big files. It’s not handy to work with files when you have a lot of rows.
But this depends on your current working method. And I assume you work with files (CSV or XLS).
That kind of files can be processed using N8N.
Other people work with GoogleSheets, but this only suits with small amounts of data in your sheet.
So, that’s why I say that it depends. The main thing is to know which is the best method that better suits your current needs.
As far as I know each sheet can have 1000 rows but in each sheet I can have unlimited number of documents. What is the problem that I can not have multiple data there?