Just use the command line interface. Where I do not have shell access, I sometimes create a webpage dedicated to just executing the queries I want and displaying the result. Of course, access to this webpage should be restricted.

    I wouldn't be posting this if I wasn't lazy enough to not want to use the command line. =P I want an actual interface. A desktop application would work as well, if there is a good [free] one, but I'd rather have a web application (for portability). I basically need a phpMyAdmin that isn't slow as crap and has at least a slightly better interface. If there is nothing good out there, I'll continue using PMA, but I was wondering if there was something better.

      SQLyog is pretty good if you don't mind installing a program to handle everything. Of course there is a free version of it.

        I wouldn't be posting this if I wasn't lazy enough to not want to use the command line.

        I am too lazy to install and use phpMyAdmin or some other such third party interface and risk it messing up.

          SQLyog is pretty good if you don't mind installing a program to handle everything. Of course there is a free version of it.

          Hmm, looks pretty nice, I'll consider trying the trial. Too bad it's commercial software. 🙁

          I am too lazy to install and use phpMyAdmin or some other such third party interface and risk it messing up.

          Well the way I look at is I'd rather take 5 minutes to extract the application and then have the rest be 10x easier. I'm using PMA for testing and development, so I want to be able to change a value in the database in a couple clicks. I don't want to have to type it out every little time, because then I'd be doing a lot of typing.

            I've never actually used it, but try : http://www.sqlitemanager.org/

            I think PHPMyAdmin is the more feature filled. If you think it can be improved why not contribute to the open source project?

            I created a prototype Ajax interface for it last summer however it didn't come to anything as I didn't have time to finish it off completely.

              7 days later

              I think PHPMyAdmin is the more feature filled. If you think it can be improved why not contribute to the open source project?

              Because I don't have the time. If I did I would have written my own app by now. I just need a quick little editor.

              In terms of features, I just need it to be able to do the basic stuff (update and alter tables and stuff), so I don't really care about the more "advanced" features of phpMyAdmin. I just hate typing everything out for every little change (and since I'm in the process of debugging and tweaking, I make a lot of those). Another reason I desire a GUI is that I like to visually see the tables. EXPLAIN queries don't really do that well...

              I'll try yours out, thanks.

              EDIT: Bah, that one uses SQLite... 🙁 I guess I'll just stick to PMA...

                4 years later

                I personally use DBTools Manager. There's a paid version and a free version. The only "annoyance" with the free version is it asks you to enter a code whenever it starts. Just click "no thanks" and you're good to go.

                  7 years later

                  Umm...yeah...last post before this was from 2011? Closing thread...

                    Write a Reply...