Could this be hosted easily on Firebase by adding Cloud Firestore as the db?

[krumholz]

I did a bit of digging and couldn't find the answer to my question.

Firebase hosting works for static files but sqlite/mongodb/postgres cannot be hosted there. I'm wondering what level of effort it would be to add Firestore as a db option?

This project is kick ass. Running locally is good but hosting this on production environments will push this project to insanely valuable.

[janober]

Have no experience at all with Firebase. So not sure. But if you say that only static files can be hosted there then I am not sure if it would work at all. If the Node.js process can read/write to that static file you can simply use SQLite as it runs within n8n and all it does is to write to a single file.

Sadly no not know anything about Firestore either. But n8n uses https://typeorm.io/ so all the databases it supports can also be supported by n8n without a lot of work. For all other ones, probably first an integration for TypeORM would have to be created.

[gorkamolero]

Hey guys,

I think the deal would be to make this work with Cloud functions for firebase, which is the part of firebase that works as a sort of backend for non-backend devs.

I've only seen this about TypeORM and cloud functions https://github.com/fireship-io/201-cloud-functions-sql-typeorm

[gorkamolero]

You can make all sort of calculations in response to certain triggers, like https requests. If you can make a GraphQL server run on Cloud Functions, you could probably do this

https://codeburst.io/graphql-on-cloud-functions-for-firebase-153fe7b02ea5

[krumholz]

@gorkamolero Yeah, I believe this would actually work as a Cloud Function. I did some research and did find a project that wrapped Cloud Firestore in an orm. Integrating that wrapper could be a start. https://github.com/wovalle/fireorm

@janober I investigated typeorm and they had no plans to add more nosql db's, as of about 8 months ago. Do you have any other thoughts about deploying to production environments? That feels like a valuable next step.

[RicardoE105]

Closing this. If case you want to make a feature request you can go to our community https://community.n8n.io/. Thanks.

[thibaultmol]

https://community.n8n.io/t/google-cloud-run-start-button/1503