loading...
Cover image for One open source project for admin panels, CRUD apps, & internal tools
Appsmith

One open source project for admin panels, CRUD apps, & internal tools

mohanarpit profile image Arpit Mohan Updated on ・2 min read

We’ve all spent time on building internal tools which could be CRUD apps, admin panels, or complex workflows.
These kind of internal tools are used for:

  1. Analytics and reporting
  2. Customer data views for sales & support teams
  3. Configuration managers for client-visible UI used by technical and non-technical people
  4. Multi-step data workflows which involve multiple participants(like content moderation tools or customer KYC at fin-tech startups)

These tools often aren’t very interesting to build because of the repetitive work involved like building UI, writing CRUD APIs, setting up authentication, & managing deployments. I decided to create Appsmith because I couldn’t find a project which did most of the work for me and also easily customizable.

How does Appsmith work?

  1. First setup Appsmith using Docker. Read instructions here for a 2 min setup process.(https://docs.appsmith.com/quick-start#docker). Or try our online sandbox

  2. Go to https://localhost or your machine’s public IP to see the login page. online sandbox.

  3. Create a new application and name it.
    Create an application

  4. Connect to a database or API. Today MySQL, Mongo, Postgres, and REST apis are supported. The gif below shows me connecting to an API.
    API creation

  5. Go to the canvas section and choose a UI widget. Appsmith ships with 16 components like tables, different charts, map viewer, forms, etc. In the example below I’ve used a table component.
    DnD table

  6. Modify the table property to display your query results by writing {{queryname.data}}. You can code in JS and use Lodash functions inside {{ }}.
    API-table

  7. Trigger an action through events like onClick, onTextchange, onSelectedrow, etc for CRUD operations.
    Event trigger

  8. Click deploy to see your app in a URL. (You can set up a custom domain in the setup script)
    Deploy

  9. Invite users after assigning them a role. They can sign up via a form login or with their Google/Github accounts. Make your app publicly viewable to allow access without a login.
    Share & invite

So this is how you build a simple app in less than 10mins. Access an app I built on Appsmith here.

Appsmith is the first open source project to build internal tools. If you like the project, please star our GitHub project.

What features should we add to Appsmith?

TL;DR: Appsmith is an open source framework to build apps for analytics, workflows or CRUD operations. Replace all your internal tools with one project. See GitHub repo or try an example app here.

Posted on by:

mohanarpit profile

Arpit Mohan

@mohanarpit

Co-founder & CTO, Appsmith. ❤️ Distributed Systems. 3X Founder - backed by YC, Sequoia Capital & Accel Partners. Strongly believe in the philosophy “Always be building"

Appsmith

Frontend-as a-service for developers to build custom apps.

Discussion

markdown guide
 

Great! This is really cool. I have seen an internal portal side project kept getting postponed due to lack of time from people with web dev skills. This solves that problem in a jiffy. Starred in github. I will try to use this sometime.

 

Thanks a lot Satish!

This is precisely why we built Appsmith. Too often there are tools that can be built to help a team or process in a company but it gets delayed because of other priorities. With Appsmith, there's no excuse 😄

 

Some queries out of curiosity. may be some of this will be answered if/when I try it out.

  1. Companies usually have a common authentication provider (say 'Okta') and all internal tools authenticate via SAML using that. These days they also insist no departments to have internal tools (even very simple) that handle authentication on their own for security reasons. Is there already a way to do that integration for app build with appsmith? or do you plan on adding that?

  2. How is the plans and pricing for your on-prem solution (or may be that's not yet decided? I will wait for your complete launch if that is the case).

  3. Can we use appsmith to build just the frontend alone and then code our own backend with full control? From the docs, I get a feeling that it comes with Mongo Db / set of supported databases and automatically builds backend API once we define the schema.

I'll try to answer each of your questions.

  1. We currently support Google, Github & form login. We are planning to add integrations to Okta, SAML & LDAP as well in the future. This is in the pipeline.

  2. For on-prem, it's free! 🎉 You can self-host the application by running a single installation script. Check out: docs.appsmith.com/quick-start#docker for details on self-hosting.

  3. Yes, you can absolutely build just the frontend while having full control of your backend code. You can integrate with any custom APIs that you already have. With DB integrations like Mongo/Postgresql, Appsmith doesn't really create any APIs. It allows you to run custom queries against the DB directly and use the results in the frontend app.

 

This is an amazing tool, it truly is a delight using this within few minutes I was able to do this, do you guys have a discord group?

app.appsmith.com/applications/5f41...

 

Hey Shriji

Thanks for checking out Appsmith! Great to see you build an app so quickly on the platform.

You can join our Discord group at: discord.gg/rBTTVJp

 
 

Thanks a lot Osinachi !

Wnat features you'd like to see in Appsmith?