Adminer

Discussion in 'Coding, Scripting & Programming' started by H_Heisenberg, Sep 18, 2013.

  1. H_Heisenberg

    H_Heisenberg New Member

    53
    18
    Jun 18, 2013
    Hola,

    Do we have Adminer users here? It was formerly known was phpminadmin (not phpmyAdmin). It's written fully in PHP, only around 300 KB big and has all the features to manage databases. It has theme and plugins support. Supported DBS: MySQL, PostgreSQL, SQLite, MS SQL & Oracle.

    Compared to this phpMyAdmin is awefully bloated and full of stuff you might never really need.

    http://www.adminer.org/
     
    peterw, bizzard, drmike and 1 other person like this.
  2. MannDude

    MannDude Just a dude vpsBoard Founder Moderator

    5,036
    2,634
    Mar 8, 2013
    MannDude
    Looks pretty neat, actually. I've never used it, have heard of it, but have yet to use it. I may install it locally and give it tinker.

    You find it just as easy to use/navigate as PhpMyAdmin?
     
  3. clarity

    clarity Active Member

    351
    125
    May 15, 2013
    I use it, and I like it!

    It is simple to install, and it gets the job done for me rather quickly.
     
  4. WebSearchingPro

    WebSearchingPro VPS Peddler Verified Provider

    493
    143
    May 15, 2013
    Interesting, I'll have to give this a go next time I need to do some database work :)

    I normally just keep a phpmyadmin instance up somewhere with no config files and I just generate it as I need it. Of course with the general directory security, IP address whitelisting and random directory name.
     
  5. Sunshine

    Sunshine New Member

    31
    13
    May 15, 2013
    That does indeed look very nice. I like that it is just 1 single file.

    I'll have to give this one a try.
     
    Last edited by a moderator: Sep 18, 2013
  6. KuJoe

    KuJoe Well-Known Member Verified Provider

    1,761
    1,318
    May 17, 2013
    I've been using SQLBuddy as a quick phpMyAdmin replacement for some sites. I know it doesn't get updated but it works really nicely for my needs and I don't make it publicly accessible so I'm not worried about security for it.
     
  7. mikho

    mikho Not to be taken seriously, ever!

    963
    253
    May 15, 2013
    I use it on some of my servers, I like it because it's so easy to movin in/out of a web accessible directory when you need it.
     
  8. blergh

    blergh New Member Verified Provider

    654
    209
    Apr 10, 2013
    Used it, but prefer phpmyadmin.
     
  9. Sunshine

    Sunshine New Member

    31
    13
    May 15, 2013
    Even if it's not publicly accessible, you still need watch out for CSRF (unless you're running nothing else in the same browser at the same time, and you make sure to log out before visiting other sites) and XSS attacks due to insufficient escaping of data displayed to the browser (unless the database doesn't contain any user supplied data).


    But I probably don't have to tell you that :)

    And, realistically speaking, probably not much of an issue in your case anyway. I'm just nitpicking.
     
    Last edited by a moderator: Sep 18, 2013
  10. vanarp

    vanarp Active Member

    299
    32
    May 16, 2013
    I heard good things about SQLBuddy. How does it work with current MySQL/PHP versions?
     
  11. Francisco

    Francisco Company Lube Verified Provider

    2,476
    1,770
    May 15, 2013
    That's really slick!

    Personally I use navicat for now but if I ever need a web based one i'll use this.

    phpmyadmin is nice and all but I agree, it's quite heavy.

    Francisco
     
    zim likes this.
  12. Aldryic C'boas

    Aldryic C'boas The Pony

    2,313
    2,652
    Apr 18, 2013
    Aldryic
    I guess nobody uses mysql-client anymore :(
     
    libro22 and perennate like this.
  13. mikho

    mikho Not to be taken seriously, ever!

    963
    253
    May 15, 2013
    Still do, this is only a web version. :p
     
  14. perennate

    perennate New Member Verified Provider

    387
    106
    May 15, 2013
    At some point in the past I used phpmyadmin, but mysql in terminal looks so much nicer, not to mention is easier to use (why do I need a mouse to run a SELECT query ???).

    I can't figure out postgres though, at all...
     
    Last edited by a moderator: Sep 19, 2013
  15. bizzard

    bizzard Active Member

    239
    46
    May 16, 2013
    This one looks good and easy to handle. May be I'll give it a try for the next project.

    I have been using phpmyadmin for years, as I got familiar with it during my CPanel shared hosting days. Since webmin/virtualmin has an automated installer for phpmyadmin, still using it in our development/testing servers.
     
  16. Dylan

    Dylan Active Member

    232
    124
    May 13, 2013
    Adminer is pretty awesome. It's not as full-featured as phpMyAdmin and the UI isn't quite as slick but considering "installation" is literally just dropping a single php file in it's hard to really complain. Plus you don't have to worry about securing the installation with temporary symlinks or passworded directories... you can just delete the file when you're done with it.

    There's a demo here in case anyone misses the link on the adminer website: http://adminer.sourceforge.net/adminer.php?username=
     
  17. Novacha

    Novacha Content Contributer

    135
    63
    May 15, 2013
    I bought navicat for it's insanely expensive price, and it wasn't nearly as good as some of the open source alternatives. I use Sequel Pro (Free and Open Source) nearly every day now, and only use navicat for sqlite.
     
  18. wlanboy

    wlanboy Content Contributer

    2,126
    1,169
    May 16, 2013
    Thank you for the tipp.

    I like lightweight tools.

    Quite pricy.

    For SQlite I am using SQliteAdmin.
     
    peterw likes this.
  19. sv01

    sv01 Slow but sure

    426
    87
    May 17, 2013
    Love adminer :) use that tools for maintenance database for few month now. Simple and just work
     
  20. H_Heisenberg

    H_Heisenberg New Member

    53
    18
    Jun 18, 2013
    Yeah!

    It's quite easy to navigate. Not much different than phpMyAdmin, even easier at some points.

    Thanks for all your replies guys :).