Windmill: Open-source alternative to Airplane, Superblocks, Retool

[simong]

Thanks for the suggestion. This has everything I miss in n8n.
I run it on coolify and it doesn't require much configuration.

[robi]

New docs for self-hosting link: https://www.windmill.dev/docs/advanced/self_host

This is very similar to what @andreasdueren is currently packaging, so a reuse of the pattern will be useful.

[canadaduane]

I've been dabbling with trying to create a Windmill on Cloudron container. It's more difficult than other apps. Some notes:

• There is a hard-coded set of ROLEs required of the postgres database: windmill_admin, and windmill_user. Windmill uses these in DB migration scripts as well as during runtime to control access and access levels (see this section). As far as I can tell, Cloudron's postgres does not offer flexibility to add new roles in the database.
• Windmill's LSP (Language Server Protocol) is itself a docker container with various programming languages (node, deno, python, etc.) pinned to certain versions. Because of these pinned versions, it is difficult to integrate into a single container along with the rest of Windmill. This suggests the docker Cloudron addon may be necessary.
• Windmill also runs workers within docker containers. This may also require the docker Cloudron addon.

In my effort to get most of Windmill running inside the same container, I have supervisord running with the following processes:

• caddy
• windmill-server
• windmill-worker

Caddy (or similar) is needed in order to act as reverse proxy for both windmill-server and the windmill-lsp container's websocket service.

The biggest issue at this point is the hard-coded windmill_admin and windmill_user postgres roles. I'm not sure how to get around this other than to create a separate postgres DB, unfortunately.

[robi]

@canadaduane said in Windmill: Open-source alternative to Airplane, Superblocks, Retool:

The biggest issue at this point is the hard-coded windmill_admin and windmill_user postgres roles. I'm not sure how to get around this other than to create a separate postgres DB, unfortunately.

The design here is clearly more suited towards isolated deployments, so it might be good to reach out to the devs to see if they can find a way to accommodate..

[canadaduane]

We have a working Windmill instance on Cloudron, (container) released with MIT license here:

https://github.com/halecraft/windmill-cloudron

The compromise we had to make here was to embed a Postgresql server inside the container, rather than connect to the one provided by Cloudron's postgres addon. Short of modifying Windmill itself, this was the only way we could give Windmill the full control over the Postgres instance that it needs / assumes it has.

[msbt]

@canadaduane cool, but it seems it's not yet available to the public

[canadaduane]

@msbt said in Windmill: Open-source alternative to Airplane, Superblocks, Retool:

@canadaduane cool, but it seems it's not yet available to the public

Oops! My MIT-licensed code is now public

[girish]

@canadaduane awesome, added to our internal list

[girish]

When building I got

Step 25/27 : COPY windmill/init-db-as-superuser.sql /app/code/init-db-as-superuser.sql
COPY failed: file not found in build context or excluded by .dockerignore: stat windmill/init-db-as-superuser.sql: file does not exist
Failed to build app. See log output above.

[drm237]

I don't have any reputation, so I can't upvote this yet, but I just wanted to mention my support for adding Windmill!

[drm237]

I submitted a pull request if anyone wants to give it a try: https://github.com/halecraft/windmill-cloudron/pull/1. It assumes that @canadaduane didn't update the init-db-as-superuser.sql file in their original build and instead fetches the original file from windmill.

[marcusquinn]

Nice. from me.

Looks like a true open-source alt to Pipedream: https://pipedream.com/