|
PHPmyadmin, sqlbudy, adminer all need php to run, I'm on a python debian server, I don't like to install php, is there a Mysql interface that doesn't require PHP. A secondary question: Is there a PostgreSQL interface that does not require PHP nor GTK? pgadmin requires GTK which I'm not going to install on a server. |
|||||||||||||||||
|
|
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. |
|||
|
|
|
If you want to minimize dependencies on the server, your best bet is sure to be enabling an SSL-only connection over the PostgreSQL protocol from your desktop/laptop. You can then use any software of your choice via the remote network protocol. If you don't want to expose PostgreSQL to the wider Internet, even SSL-only with a limited range of permitted source IPs, that's OK. You can use an ssh tunnel from your laptop/desktop into the server, with TCP/IP port forwarding. That way PostgreSQL only needs to listen to the loopback interface. (BTW, there's really no harm in installing extra client libraries, language runtimes, etc. Disk space is nearly free, and that's the only meaningful resource they use. It makes sense to avoid unnecessary services with listening ports, unnecessary setuid binaries, etc, but a plain old language runtime - it's really harmless). |
||||
|
|
|
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 |
||||
|
|
