Tooljet - Build and Deploy Internal Tools

[JLX89]

ToolJet is an open-source low-code framework to build and deploy internal tools quickly without much effort from the engineering teams. You can connect to your data sources, such as databases (like PostgreSQL, MongoDB, Elasticsearch, etc), API endpoints (ToolJet supports importing OpenAPI spec & OAuth2 authorization), and external services (like Stripe, Slack, Google Sheets, Airtable) and use our pre-built UI widgets to build internal tools.

Link: https://github.com/ToolJet/ToolJet
Docker: https://docs.tooljet.com/docs/setup/docker/

[plusone-nick]

@JLX89 +1

[jan.reinhardt]

@JLX89 Very cool, +1

[ApplegateR]

@JLX89 that some real cool +1

[micmc]

Here's an example on how to build an app for exploring and uploading files on S3.

https://blog.tooljet.com/building-an-app-to-view-and-upload-files-in-aws-s3-bucket/

[kallados]

Oje next one... Where is the benefit to loose Time with "few same tools"? Sorry. N8N work great. More different Apps are helpful, and not just put next one and next one and next... and all time the same App.

[micmc]

@kallados said in Tooljet - Build and Deploy Internal Tools:

Oje next one... Where is the benefit to loose Time with "few same tools"? Sorry. N8N work great. More different Apps are helpful, and not just put next one and next one and next... and all time the same App.

Not too sure of what you complain about, this app has nothing to do with N8n if you look carefully.

[kallados]

@micmc Sure, you are right! I got it wrong before. Thanks for the tip. Looks pretty cool after all.

[JLX89]

@JLX89 said in Tooljet - Build and Deploy Internal Tools:

https://github.com/ToolJet/ToolJet

Tooljet just announced Version 2.0 has been released!

Link: https://blog.tooljet.com/announcing-tooljet-2-0/

[nj]

I'm thinking of packaging Tooljet next. How can I tell if folks really need it? Please upvote if you think Tooljet would be useful to you.

[nj]

Here you go, @JLX89 ! Tooljet Cloudron app on Github.

Building the app seems to take a lot of time and resources. So, if you want to try the package pre-built by me, see instructions on the Github README.

This is the first release, so expect some bugs. SMTP is configured. SSO is only supported in enterprise version, but there might be a workaround using Keycloak. I'll keep updating.

[girish]

@nj How has your experience been with Tooljet ? Does it work well to deploy simple apps?

[nj]

@girish It looks good; I was able to create our team dashboard to show list of our staff. One of our backend developers created his dashboard to show usage of various resources at a single place using DigitalOcean API. Another guy created a dashboard to display daily user signups using our internal API.. overall experience has been good.

Tooljet lets you create a "dashboard" sort of place. Unlike nocode or baserow where you see one kind of data, with Tooljet we are using charts, input fields, action buttons, etc.

Overall experience has been good but we're still learning to use it. Also, packaging it took merely a few hours. The only concern was that the npm build crashes if you're low on memory and cpu cores dedicated for the build process.

[girish]

@nj composer has the same issue in LAMP app. One has to bump up memory a lot . I guess that's fine.

[andreasdueren]

@nj I'm also interested in Tooljet, are you still using it?

[simong]

If anyone is interested, here is a working setup in coolify:

• create project and add a postgres and redis database
• create a "docker compose empty" service
• Enable Connect To Predefined Network
• add the docker compose and env
• to generate the secrets, use the script on any pc (insert anything when asked for db infos):

curl -LO https://tooljet-deployments.s3.us-west-1.amazonaws.com/docker/.env.external.example
curl -LO https://tooljet-deployments.s3.us-west-1.amazonaws.com/docker/external.sh && chmod +x external.sh
mv .env.external.example .env && ./external.sh

• you can use the standard postgres db for tooljet, for tooljet db you can use any name, the database will be created on launch
• enter the url you want to use at the service settings (https://example.com:3000)

docker compose:

services:
  tooljet:
    tty: true
    stdin_open: true
    container_name: Tooljet-app
    image: 'tooljet/tooljet:ee-lts-latest'
    restart: always
    env_file: .env
    deploy:
      resources:
        limits:
          cpus: '2'
          memory: 4G
    environment:
      SERVE_CLIENT: 'true'
      PORT: '3000'
    command: 'npm run start:prod'
    healthcheck:
      test:
        - CMD-SHELL
        - 'wget -qO- http://127.0.0.1:3000/'
      interval: 30s
      timeout: 50s
      retries: 10
  postgrest:
    image: 'postgrest/postgrest:v12.2.0'
    restart: always
    env_file: .env
    deploy:
      resources:
        limits:
          cpus: '2'
          memory: 2G
    environment:
      - PGRST_SERVER_PORT=80
      - PGRST_DB_PRE_CONFIG=postgrest.pre_config

ENV:

TOOLJET_HOST=https://example.com
LOCKBOX_MASTER_KEY=(use env generator)
SECRET_KEY_BASE=(use env generator)
ORM_LOGGING=all
DATABASE_URL=(COPY DB URL FROM COOLIFY)?sslmode=disable
ENABLE_TOOLJET_DB=true
TOOLJET_DB_URL=(COPY DB URL FROM COOLIFY)?sslmode=disable
PGRST_DB_URI=(COPY DB URL FROM COOLIFY)?sslmode=disable
PGRST_HOST=postgrest
PGRST_JWT_SECRET=(use env generator)
REDIS_URL=(COPY REDIS URL FROM COOLIFY)
CHECK_FOR_UPDATES=true
DISABLE_SIGNUPS=true
USER_SESSION_EXPIRY=2880
COMMENT_FEATURE_ENABLE=true
ENABLE_MULTIPLAYER_EDITING=true
ENABLE_MARKETPLACE_FEATURE=true
DISABLE_TELEMETRY=true
DEPLOYMENT_PLATFORM=docker
LANGUAGE=en