Best tools for rapid web app development with MySQL on Mac OSX?
February 11, 2014 11:25 AM   Subscribe

I desperately need to pull together a web front-end for my MySQL database on Mac OSX 10.9.1. I have two days to do this, and have spent most of the day down a Python rabbit hole.

I was using MiddleKit for Python, and have spent the day down a rabbit hole of installing and configuring missing component after missing component.

Finally I arrive at installing MySQLdb for Python, and I have a choice of spending the next ten hours jumping through hoops to maybe possibly overcome the architecture incompatibility (or not) more here. After which I'm practically certain to have to jump through more hoops, and then more hoops and then more.

I'm at an "I don't want to do this for the rest of my life" crossroads. I need to accomplish my task within a couple of days, not a couple of months.

Does anybody have any recommendations? I'm all ears here.
posted by tel3path to Computers & Internet (18 answers total) 3 users marked this as a favorite
Best answer: If you need to do this within a couple of days and you don't already know how, you probably need to hire somebody to do it for you.

That said, an all-in-one guide like this one should get you a working development environment in less than a day.
posted by chrchr at 11:33 AM on February 11, 2014 [3 favorites]

"web front end" is a vague definition for a web application.

Does phpMyAdmin meet your needs? Maybe Adminer?
posted by artlung at 11:40 AM on February 11, 2014 [1 favorite]

Best answer: XAMPP install should take you about an hour and you will get PHPMyAdmin, which is a web front-end to MySQL. Login capability is built-in, via security settings.
posted by rada at 11:48 AM on February 11, 2014 [1 favorite]

I'm not exactly sure what your requirements are, but here is a one click solution for getting a php-mysql-apache development environment up and running.

Bitnami MAMP Stack

If thats not exactly what you need there are a bunch of other options available.

Bitnami Stacks

These stacks are just bundled software packages that are preconfigured to get you up and running immediately.
posted by axismundi at 11:51 AM on February 11, 2014

Response by poster: Sorry that haste got the better of me. I basically need to create a web form from which to insert, update and delete into - so far - a single table of a MySQL database. That's all at this point. I would prefer to use Python, but I guess this is no time to be choosy.
posted by tel3path at 12:08 PM on February 11, 2014

I don't know python options so well, but Django ( or Flask ( will likely do what you want. You could also google "python crud" for other potential options.
posted by disaster77 at 12:17 PM on February 11, 2014

Response by poster: chrchr, your all-in-one guide solved my immediate problem of the architecture incompatibility, so I'm already streets ahead of where I was a few minutes ago. Thank you.

I love you, MeFites.
posted by tel3path at 12:22 PM on February 11, 2014

A quick search for MySQL, CRUD, and Python came up with this as the first hit:

CRUD Operations with Python & MySQL

It might help you!
posted by backwards guitar at 1:13 PM on February 11, 2014

Response by poster: Okay, no, I spoke too soon. It is still not possible to install a version of MySQLdb with the right architecture for OS X Mavericks. If I can't do that, then nothing else I ever attempt with MySQL, CRUD, and Python will ever work.

On the one hand, I assume people run Django and MySQL on OS X Mavericks all the time.

On the other hand, I don't know if I have the hours or days to spend struggling with this tiny detail.
posted by tel3path at 1:33 PM on February 11, 2014

It is still not possible to install a version of MySQLdb with the right architecture for OS X Mavericks.

I'm doing Python development using MySQL and MySQLdb on OS X Mavericks right now. Getting MySQLdb set up was kind of a pain, but I can't recall the precise problem or how I fixed it. I think it involved compiling MySQLdb from source instead of downloading binaries.

Oh, I also had to set the DYLD_LIBRARY_PATH environment variable to include the directory in which MySQLdb got installed (/usr/local/mysql/lib/ in my case).
posted by jedicus at 2:11 PM on February 11, 2014

Does it *have* to be on your Mac, or would it be possible to get a VPS env on digital ocean and set it up that way? I do a lot of Django dev and so far have been far, far too lazy to set it up on my mac laptop, preferring to set it up on Ubuntu on a VPS. There'd be a lot more documentation that way, I think.
posted by foxfirefey at 2:42 PM on February 11, 2014

Have you tried downloading MAMP and installing it? That should get you a MySQL server that works no matter what, since it's compiled for OSX. Then you can deal with using python to login to the MySQL server.
posted by suedehead at 3:09 PM on February 11, 2014

(If you get the install problems solved... homebrew, then "brew install python mysql" maybe?)

Django Admin is a pretty cheap way to get a single table CRUD.

MeMail if you are still having trouble in the morning!
posted by gregglind at 4:38 PM on February 11, 2014

Since it sounds like you're comfortable with python, check out sandman. Basically an instant crud interface to *sql database.
posted by heliostatic at 5:53 PM on February 11, 2014

Yes, use homebrew to get mysql and python 2.7 installed (don't use the python that shipped with OS X.) If I recall correctly it will dump out a bunch of instructions for getting things running properly. Then pip install mysql-python. pip is a python package manager that should be installed along with the homebrew python.

Django's admin is a good way to go, although a little heavy, and that sandman app linked above looks promising also.
posted by evisceratordeath at 6:16 PM on February 11, 2014

Response by poster: Hey everyone, thanks for the plethora of great suggestions. I have marked as best answer all the ones I actually tried, but I'm sure I'm going to have lots of occasions to refer to this page in the future.

I went with the suggestion to try XAMPP and I'm now crudding away nicely using PHP. I had a bad experience trying to set up PHP a few years ago, including XAMPP, and despite what everyone says about PHP setup being a one-banana problem; but this time it actually was a one-banana problem.

Whereas I can't get the mysql-python component to play nice despite using homebrew and pip. I expect it just needs some elbow grease, but I'm gonna leave that to one side for now.

Heartfelt thanks to you all, including and especially those who offered help by MeMail
posted by tel3path at 9:56 AM on February 12, 2014

Response by poster: Okay, I spoke too soon. It is now impossible to restart MySQL for XAMPP.

I've spent the morning working through Google's solutions for this. Does ANYONE know why it's impossible to restart MySQL for XAMPP on OSX Mavericks?
posted by tel3path at 5:34 AM on February 13, 2014

Response by poster: And no sooner asked, than solved the secondary question as well.


The first task I ever had to do as a trainee was to build an installation program - and now I know why! No product I've ever shipped, if I've ever had any say over the installation process at all, has caused this much anguish. 3@#55!!!!
posted by tel3path at 6:08 AM on February 13, 2014

« Older How do you untangle the threads of a beat-up heart...   |   Ways To Show Time and Place Visually Newer »
This thread is closed to new comments.