Forum Archive

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.

Did you install it into site-packages?

@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.