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.
Dbeaver is my stand alone app of choice. It’s Java based but has some nice features as well.
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.
But then, I suppose PHP itself is good enough and the people using it never felt a need for anything new. Laravel solved the lack of application structure / design handrails, and Facebook solved or worked on the bigger issues around the language - typing and runtime performance.
Despite that, php has its limits, and it's important to know them, and the workarounds for most of them. What is also tricky is a total lack of support from Azure for example.
Looking at the usage, I thought this syntax was interesting:
//here's how we read a key $sx->readKey('username', $username);
Is there a reason you are requiring a variable to be passed by reference to the readKey function, instead of doing:
$username = $sx->readKey('username');
EDIT: ahh, I see you have a returnKey('key') function that works that way
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.
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.
For sqlite
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?
If you, like me, find yourself in possession of databases and need to quickly pull up a simple interface to visually browse them, Adminer is for you. If you need an application development and deployment stack you'll find Adminer solves only a small portion of it.
Curiously, all the things I used to love about the language I now consider major liabilities and footguns. Outside of wordpress I'd have a hard time recommending it—it's so different from other webserver setups you're likely to prolong your frustration. Not to mention it's an ugly language with an incredibly inconsistent runtime library.
Also, you can do it in C - sqlite's "amalgamation" is proof of that, but they use a bundler tooling IIRC.
There's also PsySH, https://psysh.org/, for being something other than a Common Lisp or BEAM interface it's a very nice REPL. Besides Picolisp and iex it's the interactive programming environment I use the most.
Simple and strait forward is always a winner.
Still a pretty nice tool.
Development evidently happens in the traditional sense with the project in a nicely defined tree.
The build process looks pretty gnarly, but it works! https://github.com/vrana/adminer/blob/master/compile.php