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.

12 points

Phpmyadmin.

https://www.phpmyadmin.net/

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

permalink
report
reply
5 points
*

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 MySQLMariaDBPostgreSQLSQLiteMS SQLOracleElasticsearch,  MongoDB and others via plugin

permalink
report
parent
reply
2 points

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.

permalink
report
parent
reply
2 points

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

permalink
report
parent
reply
2 points
*

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

permalink
report
parent
reply
2 points

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

permalink
report
parent
reply
1 point

Ahh. Misunderstood.

permalink
report
parent
reply
1 point

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

permalink
report
parent
reply
6 points

Pretty sure you’re looking for Django and specifically Django admin.

permalink
report
reply
5 points

Dbeaver?

permalink
report
reply
4 points

Are you looking for no-code back-end, like Pocketbase or Supabase?

permalink
report
reply
4 points

Cloudbeaver is a universal tool for connecting and working with databases. MariaDB, MySQL, Postgres and many more. Multiusersupport and SSH tunnels are possible too. It is the Webversion of DBeaver. The community edition is free and sources are on github.

permalink
report
reply

Open Source

!opensource@lemmy.ml

Create post

All about open source! Feel free to ask questions, and share news, and interesting stuff!

Useful Links

Rules

  • Posts must be relevant to the open source ideology
  • No NSFW content
  • No hate speech, bigotry, etc

Related Communities

Community icon from opensource.org, but we are not affiliated with them.

Community stats

  • 4.4K

    Monthly active users

  • 1.5K

    Posts

  • 25K

    Comments