Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Adminer: Database management in a single PHP file

github.com

Post reply on HN
Print view View original

11–20 of 36 posts

Re: Adminer: Database management in a single PHP file

#11

Post by Tostino »

herpderperator wrote: post #8

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.

It was the first tool I ever used when I was learning about how to manage a private lineage 2 server in like 2005. Had a MySQL backend and the tutorials I was following had me using phpMyAdmin. I remember fixing a performance problem by changing a setting that (I had no idea what the implications were at the time) got rid of durability entirely on a number of tables, and months later I had to restore from an earlier backup with data loss because of data corruption.

Your right though, the interface really wasn't too terrible. Was definitely better than what was available for Postgres even a few years later when I first had contact with that.

Re: Adminer: Database management in a single PHP file

#12

Post by kenfai »

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.

Re: Adminer: Database management in a single PHP file

#14

Post by mcint »

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.

Re: Adminer: Database management in a single PHP file

#16

Post by adrenalinee »

kenfai wrote: post #12

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.

Agree. I've been using this for almost ten years now, and I still impressed at how clean and fast it is.

Sometimes ppl ask why dont just use phpMyAdmin, but most of the time I need to access the database is only for a quick update, peek some data, or a simple query.

Re: Adminer: Database management in a single PHP file

#19

Post by darkwater »

dewey wrote: post #13
geocrasher wrote: post #7

I see adminer misused in malware on WordPress sites way too often. It's too bad its reputation is tarnished that way.

So are "ssh", "curl" and file uploads. I don't think it has any impact on the reputation of the tool.

Actually I think it more as a testament to the tool easy of use and deploy, and to its reliability. Otherwise malwares wouldn't use it.

Re: Adminer: Database management in a single PHP file

#20

Post by foul »

theanonymousone wrote: post #15

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).

You can bundle everything in a file in most programming languages. You may find it useful (for sysadmin purposes) only with scripting languages, because with compiled ones you generally "bundle" most of the software in the executable file.
Post reply on HN