updating SQLAlchemy from 0.9.7 to 1.1
Guys, I have no experincing in upgrading or installing 3 party limbs into Python, full stop. I want to update to the latest SQLAlchemy as it appears you should at least be working with version 1.0 or above. I have problems with the tutorial code, I am guessing, it's to do with the earlier version.
But from what I can see is that if I use stash and enter
pip install SQLAlchemy
It should just work, I think
I wanted to ask first, as I really don't want screw up my current install
Ok, I got impatient and just did it. After running the pip cmd, it says it installed ok.
But print sqlalchemy.version still reports the same version 0.9.7
I did restart Pythonista, same result.
Any ideas appreciated
The installation process of SQLAlchemy is a bit involved and cannot be properly handled by stash pip. The OK message in this case is in fact a bug.
For this particular package, you need manual process. With StaSh, issue following four commands:
wget https://pypi.python.org/packages/source/S/SQLAlchemy/SQLAlchemy-1.0.11.tar.gz tar -zxvf SQLAlchemy-1.0.11.tar.gz mv SQLAlchemy-1.0.11/lib/sqlalchemy/ ~/Documents/site-packages rm -rf SQLAlchemy-1.0.11*
Restart and now you should be able to use 1.0.11.
Please note SQLAlchemy has optional C extensions for performance. It is not possible to installed them in Pythonista. We simply skipped them in above process. Anyway it seems that the builtin SQLAlchemy does not include C extensions either.
This post is deleted!last edited by
@ywangd, thank you. The third line has a extra space with the ~ in the path. But it does work after correcting it. I am getting version 1.0.11 now. This is great for me. Just wanted version 1.0 and above.