from Hacker News

Adminer: Database management in a single PHP file

by ustad on 3/17/25, 9:30 AM with 34 comments

  • by mcint on 3/20/25, 7:06 AM

    Can we update the title with the project name, adminer?

    I've gently relied on this tool, it's basically delightful to use. Simple to deploy, doesn't fight the protocol and software stack it can be deployed alongside for securing, using. A shining, straightforward FOSS success.

  • by herpderperator on 3/20/25, 3:14 AM

    phpMyAdmin was (is?) such a great tool and really got me into SQL/MySQL over a decade ago. Not to mention the whole PHP stack was so fun to use and let you iterate quickly and just build stuff with an immediate feedback loop - just reload the page and your updated server-side code is executed.
  • by aaviator42 on 3/20/25, 2:30 AM

    In the same vein, I have a single-file library which allows you to use flat files as key-value DBs. Uses SQLite under the hood. Sharing in case someone finds it useful: https://github.com/aaviator42/storx
  • by mrweasel on 3/20/25, 9:33 AM

    When I do a Docker-compose development setup, I frequently just throw in an adminner container, just in case. It's a super simple and very well done project.
  • by kenfai on 3/20/25, 5:53 AM

    I'm happy to finally see this got updated a month ago.

    I thought this project was abandoned as the last update that doesn't support the more recent PHP version was in 2021.

    In my opinion, this is the best single-file DB management tool for quick one-off edit or development purposes since phpMyAdmin.

  • by benoau on 3/20/25, 12:51 AM

    Another in this vein is "pgweb" for PostgreSQL, just need a binary to run its web interface.

    https://github.com/sosedoff/pgweb

  • by hattmall on 3/20/25, 2:46 AM

  • by yu3zhou4 on 3/20/25, 8:57 AM

    Nostalgia hits when I see PHP + MySQL stack. My journey with building things started with XAMPP (looks like it still exists and is maintained https://www.apachefriends.org/). There was a very convenient way for administering DB with their admin panel. In retrospection, despite I had 0 real knowledge in programming and it was like 2009-2010 or so, I think it was easier to build thing with this stack than to build things today. On the other hand, nothing prevents me to start using it again, at least for personal projects.

    Does anyone have an experience and can compare Adminer to XAMPP admin panel and modern stack (Supabase and similar)? Or PHP vs React+Node or Python+Django?

  • by theanonymousone on 3/20/25, 7:19 AM

    This "in a single file" property is probably the most unique, and maybe the most enviable feature of PHP. I don't think you can do it in any other language, except maybe by jumping through hoops (e.g. jbang and uv come close).
  • by geocrasher on 3/20/25, 3:12 AM

    I see adminer misused in malware on WordPress sites way too often. It's too bad its reputation is tarnished that way.
  • by simmo9000 on 3/20/25, 7:29 AM

    Less than a minute to install deploy and use. Could not be easier, well done.

    Simple and strait forward is always a winner.

  • by Jotalea on 3/20/25, 11:26 AM

    "single" PHP file.

    Still a pretty nice tool.

  • by krypttr on 3/20/25, 7:56 AM

    Wow. We have gone full circle.
  • by knowitnone on 3/20/25, 1:22 AM