Looking for general frontend for DB app

TheMediocreOne@lemmy.dbzer0.com to Open Source@lemmy.ml – 26 points –

Hello, I am looking for a FOSS frontend for simple DB app.

Use case:

  • Let's have a simple DB in MySQL
  • I want the user to be able to browse via views
  • Create new inserts via some forms

Does something like that exist?

EDIT: Thanks all for suggestions, looks like what I am looking for is just a regular web app however simple I might think it is, there is near 0% chance I can just grab something off the internet and use it in this case.

21

You are viewing a single comment
View all comments

Phpmyadmin.

https://www.phpmyadmin.net/

You can also deploy it easily with docker to get it running quick.

Not for OP.

I usually use Adminer instead of phpMyAdmin.

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch,  MongoDB and others via plugin

I am looking for abstraction layer to hide DB internals. I am not looking for a frontend for DB, but for a "web app" which is only the DB itself. Like I said, I am not even sure something like that exists.

I don't understand - you want a layer to hide database internals but also a web app that "is only the db itself"?

Sounds like a web based spreadsheet. Being able to insert and edit data using friendly web forms but not needing to know SQL commands.

I don't think it does, because anything custom is just a regular web app.

Have a look at Grist or ToolJet or similar tools. I use the first in a very basic way and...it works!