phpMyAdmin, SQL Buddy, and Adminer all run on PHP. I'm on a Python Debian server and I'd rather not install PHP. Is there a mySQL interface that doesn't require PHP?
6 Answers
For a purely programmatic solution, I'd recommend the Oracle provided Python-MySQL Connector. It is GPL licensed or you can purchase a different license as well. I have only used it a bit so I can't comment on ease of use for advanced functionality but simple queries work fine and fast.
There is also quite good documentation including some examples available on the Oracle site.
I have read about a Python/MySQL GUI - although it does appear to be somewhat focused on plotting it does state that it supports creation and management (as well as analysis). Despite not having (yet) tried it from what I've read it looks quite good - and since it is open source and python if it is something close you can relatively easily extend it to do what you need.
answered Apr 6, 2014 at 13:59
You can use MySQL Workbench:
- free
- works on Windows/Linux/Mac
- straightforward to install (
- it's a desktop application, not a web interface. No need for PHP.
- syntax highlighting
- auto completion
- SQL documentation on the side
- in addition to the SQL Editor, you can design visually database (usual EER) and administer the database.
SQL Editor:
Visual Database Design:
Administration:
answered Apr 28, 2014 at 20:06
-
1Be careful if you use replication. We had the issue that if you changed data in MySQL Workbench it somehow bypassed replication. Don't know if it is still an issue but you may want to double check first. May 4, 2014 at 16:36
-
@2called-chaos Thanks, good to know! (maybe will be my tenth bug report there ;) ) May 4, 2014 at 16:48
An interface is a rather broad term, but if you are looking to manage your SQL databases with a GUI, SQuirreL is the most powerful and versatile option. It's not pretty, but once it's set up, it's one of the best tools out there.
I have used it for Oracle, Microsoft, MySQL and PostgreSQL databases with no issues.
It's a Java application, so it doesn't require GTK or anything else for that matter, and it will work on all platforms.
Alternatively, you can simply use mysql and psql commands from the command line over SSH. That's as simple as it gets, provided that you don't mind opening a terminal.
I'm developing a database explorer with a focus on breadth, not depth. It is written in Python 2, which is likely already installed on your server.
Right now it won't let you run arbitrary queries , but that is high on the feature list. Squeal now supports running arbitrary SQL queries!
Note that the application is in a very early stage of development. Depending on your perspective, that is good or bad. It likely does not yet support all the features that you need, but I am a very responsive developer and I'll add the features as you need them.
-
I like what you do, as long as it's running on linux and as long as linux supports python by default, we should create every server side software using python or lets say a programming language that is there by default like C, at least try to do it if we could, why forcing the server admin to install a language he doesn't need to run some software! great job.– LynobApr 29, 2014 at 22:46
-
Thanks. Here is the feature request for supporting arbitrary SQL statements, if you are interested. I'll try to get it resolved in the coming week. Apr 30, 2014 at 6:06
-
I just resolved the issue mentioned above. Squeal now supports arbitrary SQL statements! May 2, 2014 at 10:04
I can recommend Database Workbench - although it's a Window based tool, it works fine under Wine and is used by many users like that.
It includes design, debugging, management, migration and database browsing and editing tools.
localhost). Free, cross-platform.