Database management in a single PHP file
9 comments
·March 17, 2025herpderperator
acomjean
It’s still there and still very good. Our non profits web host has an install and it’s pretty good at browsing/ searching / dumping the tables.
Dbeaver is my stand alone app of choice. It’s Java based but has some nice features as well.
aaviator42
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
colecut
This is a really neat concept that I think would be fun to use.
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
hattmall
I like https://www.phpliteadmin.org/
For sqlite
geocrasher
I see adminer misused in malware on WordPress sites way too often. It's too bad its reputation is tarnished that way.
benoau
Another in this vein is "pgweb" for PostgreSQL, just need a binary to run its web interface.
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.