this post was submitted on 18 Apr 2024

25 points (100.0% liked)

Open Source

31128 readers

260 users here now

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.

founded 5 years ago

MODERATORS

[email protected]

Looking for general frontend for DB app (lemmy.dbzer0.com)

submitted 6 months ago* (last edited 6 months ago) by [email protected] to c/[email protected]

20 comments fedilink hide all child comments

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.

all 21 comments

sorted by: hot top controversial new old

[–] [email protected] 12 points 6 months ago (2 children)

Phpmyadmin.

https://www.phpmyadmin.net/

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

[–] [email protected] 5 points 6 months ago* (last edited 6 months ago)

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

[–] [email protected] 2 points 6 months ago (4 children)

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.

[–] [email protected] 2 points 6 months ago (1 children)

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

[–] [email protected] 2 points 6 months ago* (last edited 6 months ago)

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

[–] [email protected] 2 points 6 months ago

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

[–] [email protected] 1 points 6 months ago

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

[–] [email protected] 1 points 6 months ago

Ahh. Misunderstood.

[–] [email protected] 6 points 6 months ago

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

[–] [email protected] 5 points 6 months ago

Dbeaver?

[–] [email protected] 4 points 6 months ago

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.

[–] [email protected] 2 points 6 months ago (1 children)

What about nocodb? See this image. It's AGPL-3.0 licensed.

[–] [email protected] 2 points 6 months ago

That looks nice as well

[–] [email protected] 2 points 6 months ago

One day I was looking for something to make add records to db and crezte field, etc. Then I've found Rukodovitel, it's very easy to use and powerfull too, juste have look, you can build apps to manage db with this.

https://www.rukovoditel.net/

[–] [email protected] 1 points 6 months ago

Something like retool but open source?

[–] [email protected] 1 points 6 months ago

Budibase

[–] [email protected] 1 points 6 months ago (1 children)

I wouldn't know what to recommend, but... are you looking for a web based thing or a desktop app?

[–] [email protected] 1 points 6 months ago (1 children)

Web based. Basically, I am looking for a general web app which is working with DB.

[–] [email protected] 2 points 6 months ago (1 children)

Search for CRUD framework. They are available in many languages.

[–] [email protected] 1 points 6 months ago

Yes, sometimes we are just missing the right term. Thanks.