Live data from Hacker News

Adminer: Database management in a single PHP file

github.com

1–10 of 36 posts

Re: Adminer: Database management in a single PHP file

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

Re: Adminer: Database management in a single PHP file

#9

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

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

Re: Adminer: Database management in a single PHP file

#10

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

Post reply on HN