Looking for open source frontend database/web app creator… recommendations?

I’m searching for a good UI builder for a frontend web app that connects to a database. I thought it would be a simple Google search, but I’ve fallen into the rabbit hole of paid or niche software that’s outdated.

I’ve also looked at this list:
GitHub - awesome-selfhosted/awesome-selfhosted: A list of Free Software network services and web applications which can be hosted on your own servers

But most options are either paid or have restrictions in their free plans. I only need something for about 5-10 users, and I’m fine hosting and developing it on our LAN since I have a solid backup setup.

Right now, we’re using an MS Access database, which isn’t ideal.

If possible, I’m looking for something that:

  • Is available for Docker
  • Connects to MariaDB
  • Supports LDAP
  • Is easy to use

Is this too much to ask for, or am I looking at spending some money here?

Have you checked out NocoDB? It’s open-source and connects to multiple databases, including MariaDB. Pretty easy to set up with Docker as well.

Maybe try Xataface?

https://github.com/shannah/xataface

http://xataface.com/documentation/tutorial/getting_started

Have you considered this one? https://github.com/Neopric-Inc/NeoApps.AI-CodeGenerator

I’ll just leave Appsmith here.
It has everything you’re looking for except LDAP in the free community edition.
It’s available self-hosted and free.

If you’re fine with some hosting on your LAN, ILLA Cloud is an open-source option that’s quite popular for low-code app development. It’s also great for data visualization if you need that. Might be worth a shot!

@Malachi
Thanks for the suggestion! I hadn’t heard of ILLA Cloud before. I’ll definitely check it out, especially if it’s open-source. The data visualization sounds like a good fit for what I’m doing.

Retool is another one you might want to look into. It’s easy to build internal tools quickly, but it’s more suited for internal app building rather than larger external projects.

Hollis said:
Retool is another one you might want to look into. It’s easy to build internal tools quickly, but it’s more suited for internal app building rather than larger external projects.

I’ve heard good things about Retool. Do you know if it supports LDAP? That’s kind of a dealbreaker for us at this point.

@NickYoung
I think it might be a bit lacking in LDAP support unless you go for the enterprise edition. But worth checking if it’s a good fit otherwise!

Check out Budibase. It’s open-source and connects easily to various databases. It’s good for internal apps and might give you the customization you need for small teams.

Rain said:
Check out Budibase. It’s open-source and connects easily to various databases. It’s good for internal apps and might give you the customization you need for small teams.

Sounds like a good fit for internal tools. I’ll give Budibase a look as well. Thanks for the tip!