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.

    • tun
      50·
      6 months ago6 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

    • TheMediocreOneOP
      20·
      6 months ago

      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.

      • catloafEnglish
        20·
        6 months ago

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

      • doeknius_gloek
        20·
        6 months ago

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

        • TimeSquirrel
          20·
          6 months ago6 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.

      • peregus
        10·
        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!

  • themoonisacheese
    60·
    6 months ago

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

  • LalSalaamComradeEnglish
    40·
    6 months ago

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

  • Morethanevil
    40·
    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.

  • wiltur
    20·
    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/

  • gomp
    10·
    6 months ago

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

    • TheMediocreOneOP
      10·
      6 months ago

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

      • joe_archer
        20·
        6 months ago

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

        • TheMediocreOneOP
          10·
          6 months ago

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