6

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?

  • 1
    Are you just wanting a programmatic interface or do you want a full GUI? – Nick Wilde Apr 6 '14 at 13:19
  • @NickWilde either would be fine though it would be nice if there were a full gui – Lynob Apr 6 '14 at 13:28
  • So it must be for Python, or it simply must not be for PHP? --- And does it make sense to have both of your questions, MySQL and PostgreSQL, in the same question? – unor Apr 6 '14 at 13:40
  • 2
    Have you tried MySQL Workbench? It's a desktop GUI application that connects to a MySQL server on the network, optionally via an SSH tunnel (so your DB doesn't need to listen to anything else than localhost). Free, cross-platform. – Lukas Graf Apr 14 '14 at 18:41
  • 1
    I split the second question to softwarerecs.stackexchange.com/questions/3725/… – Nicolas Raoul Apr 30 '14 at 7:09
5

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.

6

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:

enter image description here

Visual Database Design:

enter image description here

Administration:

enter image description here

  • 1
    Be 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. – 2called-chaos May 4 '14 at 16:36
  • @2called-chaos Thanks, good to know! (maybe will be my tenth bug report there ;) ) – Franck Dernoncourt May 4 '14 at 16:48
4

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.

3

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. – Lynob Apr 29 '14 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. – dotancohen Apr 30 '14 at 6:06
  • I just resolved the issue mentioned above. Squeal now supports arbitrary SQL statements! – dotancohen May 2 '14 at 10:04
1

A tool that is well worth mentioning is HeidiSQL. It is really a Windows app but can be made cross platform with other programs like Wine. I use HeidiSQL for the majority of MySQL table queries and MySQL Workbench for the high-level database admnistration.

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.