Ask HN: Best (Low-/No-Code) Solution for Simple Web-Based Database Front Ends

• appsmith

  233 31,718 10.0 TypeScript

  Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.

  

I'm a founder of Appsmith that has already been mentioned here. It's an open source project to help you build CRUD UI on top on any database(MySQL, Postgres included) or API. We give UI components to create forms, charts, tables, etc.

GitHub link: https://github.com/appsmithorg/appsmith

• Directus

  208 25,517 9.9 TypeScript

  The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.

  

Someone mentioned https://directus.io/ to me for this use case the other day. I've not used it, but it looks good. Open source and self hostable or SaaS.

• SurveyJS

  surveyjs.io featured

  Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

  

• xataface

  3 133 4.2 PHP

  Framework for building data-driven web applications in PHP and MySQL

• Voyager

  21 11,667 1.6 PHP

  Voyager - The Missing Laravel Admin

  

• Metabase

  67 36,669 10.0 Clojure

  The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:

  

> I'm currently looking for a solution to provide (non-technical) team members with a way to interact with a SQL database ... While I'm generally willing to pay, I'd really prefer an open and self-hosted solution.

You should definitively check Metabase [0] then: it's open source, very easy to self-host, and democratize data access inside your team. We started using this for the same reason 3 years ago, I cannot recommend it more.

[0] https://github.com/metabase/metabase

• Strapi

  458 60,474 10.0 TypeScript

  🚀 Strapi is the leading open-source headless CMS. It’s 100% JavaScript/TypeScript, fully customizable and developer-first.

  

• react-admin

  65 24,059 9.9 TypeScript

  A frontend Framework for building data-driven applications running on top of REST/GraphQL APIs, using TypeScript, React and Material Design

  

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• decap-cms

  80 17,510 9.2 JavaScript

  A Git-based CMS for Static Site Generators

  

• django-project-template

  4 160 2.8 Python

  The Django project template I use, for installation with django-admin. (by skorokithakis)

That seems reasonable, though it looks like it's a few years old by now.

You can use my project template, it comes with the admin enabled out of the box:

https://github.com/skorokithakis/django-project-template

You just install that, add the TODOs that it says, and then run it with "./manage.py migrate; ./manage.py createsuperuser; ./manage.py runserver", and that's about it.

• superset

  137 58,956 9.9 TypeScript

  Apache Superset is a Data Visualization and Data Exploration Platform

  

Thank you all for the many great answers! Definitely a lot to look at! Currently Appsmith (and/or) Lowdefy seem to fit best for me.

In case you're interested, these are all the products/resources given so far:

http://superset.apache.org

• djangorestframework-dataclasses

  2 405 7.5 Python

  Dataclasses serializer for Django REST framework

Also see:

https://github.com/oxan/djangorestframework-dataclasses/issu...

on how this could work. The author wasn't interested, but I might pursue it in a fork.

• Forest Admin

  15 360 8.4 Ruby

  💎 Ruby on Rails agent for Forest Admin to integrate directly to your existing Ruby on Rails backend application.

  

I'm surprised nobody has mentioned Forest Admin (https://www.forestadmin.com/). They have a free tier that would work on simple scenarios.

• PostGUI

  2 424 0.0 JavaScript

  A React web application to query and share any PostgreSQL database.

And even the frontend is probably already written for the use-case that you have https://github.com/priyank-purohit/PostGUI

“ A React web application to query and share any PostgreSQL database”

• Baserow

  45 - - Python,JavaScript

  Open source no-code database and Airtable alternative. Create your own online database without technical experience. Performant with high volumes of data, can be self hosted and supports plugins (by bramw)

You might want to take a look at Baserow (https://baserow.io), which is an open source self hosted no-code database tool and Airtable alternative. It is not possible to interact with an existing database, but the databases and tables created are stored in a PostgreSQL database. It might be possible for you to migrate your existing MySQL data to Baserow. The repository: https://gitlab.com/bramw/baserow. It is build in Django and Vue.js.

• lowdefy

  49 2,556 9.6 JavaScript

  The config web stack for business apps - build internal tools, client portals, web apps, admin panels, dashboards, web sites, and CRUD apps with YAML or JSON.

  

Hi, We've built Lowdefy [0] for exactly this reason. It it is open-source, low-code and self hosted. On our team we have data analysts and implementation engineers (non-developers) creating apps in Lowdefy. With Lowdefy I would say that the minimum tech expertise required needs to be someone who can learn to write data queries.

We are currently working on SQL support and should have the first SQL connectors out next week. Please give me a shout if we can be of any assistance! gvw [at] lowdefy.com

[0] - https://lowdefy.com

• nifi

  35 4,429 9.9 Java

  Apache NiFi

  

• lottie-web

  31 29,685 6.2 JavaScript

  Render After Effects animations natively on Web, Android and iOS, and React Native. http://airbnb.io/lottie/

  

Library might be an overkill I guess. It is an absolute positioned element. There is a config for each step as to what to show at each step in the popup. The confetti animation at the end makes use of https://github.com/airbnb/lottie-web

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

Suggest a related project