Ask Your Question
2

why is mysql required? [fixed]

asked Aug 29 '10

omat gravatar image omat
67 2 6

updated Oct 25 '10

Evgeny gravatar image Evgeny flag of Chile
4735 29 43 58
http://askbot.org/

why is mysql required to get askbot up and running? why doesn't it support all the database back-ends supported by django?

most people, like myself, have already their version of django and database system setup in their development environment. i think those should be excluded from the requirements.

cheers,

omat

Comments

on my local environment i have django1.1 and 1.2 but i favor 1.2 for new projects. postgres as the db back-end. i am on mac os x and couldn't even install mysql via pip. omat (Aug 30 '10)
askbot may just work with django1.2 but I have not tested that yet. The test suit does not yet cover everything, so I cannot make claims of supporting a wide spectrum of components. It would be awesome if you try on 1.2 and give your feedback. Evgeny (Aug 30 '10)
thanks evgeny. i would like to test for django 1.2 but i couldn't install askbot without the dependencies and simply copying did not work due to dependencies too. i will let you know if i can manage to get it running. omat (Aug 31 '10)
there are ways around it - you can replace one dependency at a time to see what causes problems, or you can use --prefix option (maybe along with "develop" instead of "install" when you run setup.py and install deps into a custom location). You'll have to chang PYTHONPATH and if needed django.wsgi Evgeny (Aug 31 '10)
fyi, i have been using askbot locally with django 1.2 for a day, i didn't test every functionality but it is running fine so far. omat (Sep 08 '10)
see 3 more comments

2 Answers

Sort by ยป oldest newest most voted
2
omat has selected this answer as correct

answered Aug 29 '10

Evgeny gravatar image Evgeny flag of Chile
4735 29 43 58
http://askbot.org/

updated Oct 25 '10

Agreed, indeed more databases should be supported and testing on postrgres is on a todo shortlist.

Askbot now works on postgres. Thanks for bringing this up.

edit: also full text search with ranking by relevance is now working in postrges.

link

Comments

thanks. good to hear that. i am using postgres. omat (Aug 30 '10)
how about leaving full text search to sth. like solr (http://lucene.apache.org/solr/) ? omat (Aug 30 '10)
It's a good idea, solr seems to be actively supported but adding it as a requirement may not be wise - because it'll make the system harder to install and configure. Evgeny (Aug 30 '10)
what I meant to say - solr may be supported as an option Evgeny (Aug 30 '10)
thanks for the update. still it is not possible to install askbot at first place via pip or easy-install if mysql is not setup in the environment. i couldn't find where this requirement comes from but an `EnvironmentError: mysql_config not found` is raised. omat (Sep 06 '10)
see 4 more comments
1

answered Sep 11 '10

Evgeny gravatar image Evgeny flag of Chile
4735 29 43 58
http://askbot.org/

updated Sep 11 '10

Of course MySQL should not be required as well as some other dependencies and looks like it's actually possible to run askbot on sqlite (thanks to Onur) and postgres.

The problem that we have to solve here is how to satisfy different needs without getting in the users' way too much. One can imagine the following scenarios:

  • someone wants a "turn key" running forum
  • or instead they want to just get the askbot app alone and are willing to tinker with details of installation
  • select a database engine from a "pre-approved" list (there are quite specific version and config requirements even for MySQL - to make full text search work, for postgres FTS there is also a specific version requirement)
  • user may want to try a different database engine (perhaps one that was not yet tested)
  • install askbot in local directory (good idea if user wants to tweak skins or develop code - and in this case checkout is highly advised) or system directory (for production use only)
  • or they might want to install into a virtual environment
  • or (for shared hosts) - install into an alternate location - with or without things like django and database adapters
  • use a different version of Django (even one that was not tested with askbot yet)

What would really be great is to come up with a flexible setup.py script and the follow-up deployment script, otherwise there is no way to make adoption of askbot easy for most users.

link

Comments

imo, setup script should not just copy a standard file, but let django-admin build the file, because its format changes from version to version. also secret key is randomized. then add askbot specific attributes to the settings file. maybe we should open a separate question to discuss this. omat (Sep 13 '10)
sounds like a ripe theme for a discussion! Evgeny (Sep 13 '10)

Your answer

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
[hide preview]

Question tools

Follow
2 followers

subscribe to rss feed

Stats

Asked: Aug 29 '10

Seen: 262 times

Last updated: Oct 25 '10