Wow!   It works like a charm!
Thanks Niels and Stefan!


On Thu, Mar 13, 2014 at 9:21 AM, Niels Nes <Niels.Nes@cwi.nl> wrote:
On Thu, Mar 13, 2014 at 08:54:36AM +1300, Simon wrote:
> Hi Stefan,
>

Simon

Within the MonetDB sources (clients/python3) you can find a python3 module. I think
Gijs only put the python2.x code on pypi.

Niels

> It sounds like I could still use monetdb in python3.2 ?   Awesome!  
> And thank you very much for prompt reply.
>
> I have tried two methods installing python-monetdb.
>
> Ubuntu 12.04.04 LTS, default python is python 2.7.  I installed python
> 3.2 from ubuntu's official repo with simple 'apt-get install`.
>
> python-monetdb could work under python 2.7 but not under python 3.2.
>
> 1. Install via pip3
>  
> $ sudo pip3 install python-monetdb
>
> sudo pip3 install python-monetdb
> Downloading/unpacking python-monetdb
>   Downloading python-monetdb-11.16.0.7.tar.gz
>   Running setup.py (path:/tmp/pip_build_root/python-monetdb/setup.py)
> egg_info for package python-monetdb
>     
> Installing collected packages: python-monetdb
>   Running setup.py install for python-monetdb
>       File "/usr/local/lib/python3.2/dist-packages/monetdb/mapi.py",
> line 201
>         except ValueError, e:
>                          ^
>     SyntaxError: invalid syntax
>     
>     
> Successfully installed python-monetdb
> Cleaning up...
>
> $ python3
> Python 3.2.3 (default, Feb 27 2014, 21:31:18) 
> [GCC 4.6.3] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
> >>> import monetdb
> Traceback (most recent call last):
>   File "<stdin>", line 1, in <module>
>   File "/usr/local/lib/python3.2/dist-packages/monetdb/__init__.py",
> line 27, in <module>
>     from monetdb import sql
>   File "/usr/local/lib/python3.2/dist-packages/monetdb/sql/
> __init__.py", line 18, in <module>
>     from monetdb.sql.connections import Connection
>   File "/usr/local/lib/python3.2/dist-packages/monetdb/sql/
> connections.py", line 20, in <module>
>     from monetdb.sql import cursors
>   File "/usr/local/lib/python3.2/dist-packages/monetdb/sql/cursors.py",
> line 20, in <module>
>     from monetdb.sql import monetize, pythonize
>   File "/usr/local/lib/python3.2/dist-packages/monetdb/sql/
> monetize.py", line 27, in <module>
>     from monetdb.exceptions import ProgrammingError
>   File "/usr/local/lib/python3.2/dist-packages/monetdb/exceptions.py",
> line 22, in <module>
>     class Warning(StandardError):
> NameError: name 'StandardError' is not defined
> >>> 
>
> 2. Then, uninstall from pip3
>
> $ sudo pip3 uninstall python-monetdb    
>
> and install from tar:
>
> Download python-monetdb-11.16.0.7.tar.gz  from https://pypi.python.org/
> pypi/python-monetdb/11.16.0.7
>
> Extract the files and
>
> $ sudo python3 setup.py install
> [sudo] password for simon: 
> running install
> running build
> running build_py
> creating build
> creating build/lib
> creating build/lib/monetdb
> copying monetdb/control.py -> build/lib/monetdb
> copying monetdb/mapi.py -> build/lib/monetdb
> copying monetdb/exceptions.py -> build/lib/monetdb
> copying monetdb/__init__.py -> build/lib/monetdb
> creating build/lib/monetdb/sql
> copying monetdb/sql/connections.py -> build/lib/monetdb/sql
> copying monetdb/sql/cursors.py -> build/lib/monetdb/sql
> copying monetdb/sql/types.py -> build/lib/monetdb/sql
> copying monetdb/sql/converters.py -> build/lib/monetdb/sql
> copying monetdb/sql/monetize.py -> build/lib/monetdb/sql
> copying monetdb/sql/__init__.py -> build/lib/monetdb/sql
> copying monetdb/sql/pythonize.py -> build/lib/monetdb/sql
> running install_lib
> creating /usr/local/lib/python3.2/dist-packages/monetdb
> copying build/lib/monetdb/control.py -> /usr/local/lib/python3.2/
> dist-packages/monetdb
> creating /usr/local/lib/python3.2/dist-packages/monetdb/sql
> copying build/lib/monetdb/sql/connections.py -> /usr/local/lib/
> python3.2/dist-packages/monetdb/sql
> copying build/lib/monetdb/sql/cursors.py -> /usr/local/lib/python3.2/
> dist-packages/monetdb/sql
> copying build/lib/monetdb/sql/types.py -> /usr/local/lib/python3.2/
> dist-packages/monetdb/sql
> copying build/lib/monetdb/sql/converters.py -> /usr/local/lib/python3.2
> /dist-packages/monetdb/sql
> copying build/lib/monetdb/sql/monetize.py -> /usr/local/lib/python3.2/
> dist-packages/monetdb/sql
> copying build/lib/monetdb/sql/__init__.py -> /usr/local/lib/python3.2/
> dist-packages/monetdb/sql
> copying build/lib/monetdb/sql/pythonize.py -> /usr/local/lib/python3.2/
> dist-packages/monetdb/sql
> copying build/lib/monetdb/mapi.py -> /usr/local/lib/python3.2/
> dist-packages/monetdb
> copying build/lib/monetdb/exceptions.py -> /usr/local/lib/python3.2/
> dist-packages/monetdb
> copying build/lib/monetdb/__init__.py -> /usr/local/lib/python3.2/
> dist-packages/monetdb
> byte-compiling /usr/local/lib/python3.2/dist-packages/monetdb/
> control.py to control.cpython-32.pyc
> byte-compiling /usr/local/lib/python3.2/dist-packages/monetdb/sql/
> connections.py to connections.cpython-32.pyc
> byte-compiling /usr/local/lib/python3.2/dist-packages/monetdb/sql/
> cursors.py to cursors.cpython-32.pyc
> byte-compiling /usr/local/lib/python3.2/dist-packages/monetdb/sql/
> types.py to types.cpython-32.pyc
> byte-compiling /usr/local/lib/python3.2/dist-packages/monetdb/sql/
> converters.py to converters.cpython-32.pyc
> byte-compiling /usr/local/lib/python3.2/dist-packages/monetdb/sql/
> monetize.py to monetize.cpython-32.pyc
> byte-compiling /usr/local/lib/python3.2/dist-packages/monetdb/sql/
> __init__.py to __init__.cpython-32.pyc
> byte-compiling /usr/local/lib/python3.2/dist-packages/monetdb/sql/
> pythonize.py to pythonize.cpython-32.pyc
> byte-compiling /usr/local/lib/python3.2/dist-packages/monetdb/mapi.py
> to mapi.cpython-32.pyc
>   File "/usr/local/lib/python3.2/dist-packages/monetdb/mapi.py", line
> 201
>     except ValueError, e:
>                      ^
> SyntaxError: invalid syntax
>
> byte-compiling /usr/local/lib/python3.2/dist-packages/monetdb/
> exceptions.py to exceptions.cpython-32.pyc
> byte-compiling /usr/local/lib/python3.2/dist-packages/monetdb/
> __init__.py to __init__.cpython-32.pyc
> running install_egg_info
> Writing /usr/local/lib/python3.2/dist-packages/
> python_monetdb-11.16.0.7.egg-info
>
> $ python3
> Python 3.2.3 (default, Feb 27 2014, 21:31:18) 
> [GCC 4.6.3] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
> >>> import monetdb
> Traceback (most recent call last):
>   File "<stdin>", line 1, in <module>
>   File "monetdb/__init__.py", line 27, in <module>
>     from monetdb import sql
>   File "monetdb/sql/__init__.py", line 18, in <module>
>     from monetdb.sql.connections import Connection
>   File "monetdb/sql/connections.py", line 20, in <module>
>     from monetdb.sql import cursors
>   File "monetdb/sql/cursors.py", line 20, in <module>
>     from monetdb.sql import monetize, pythonize
>   File "monetdb/sql/monetize.py", line 27, in <module>
>     from monetdb.exceptions import ProgrammingError
>   File "monetdb/exceptions.py", line 22, in <module>
>     class Warning(StandardError):
> NameError: name 'StandardError' is not defined
> >>> 
>
>
> Actually I have tried to modify the codes a little such as change
> ''class Warning(StandardError)" to "class Warning(BaseException)",
>  change "except ValueError, e" to "except ValueError as e".  These two
> error messages disappeard but other error messages popped up.   
>
> By the way, monetdb is so fast that the performance is comparable to
> kdb+.   Cool!
>
> Regards,
> Simon
>
>
>
>
>
>
> On Wed, Mar 12, 2014 at 10:53 PM, Stefan Manegold <
> Stefan.Manegold@cwi.nl> wrote:
>
>     Dear Simon,
>
>     thank for your kind words about MonetB ;-)
>
>     I might overlook something obvious,
>     but could you please elaborate a bit more about
>     what is missing to use MonetDB with Python 3.2?
>
>     Thanks!
>     Stefan
>
>     ----- Simon <simon7199@gmail.com> wrote:
>     > Hi thanks for the great project.
>     >
>     > I just wonder when there would be python 3.2 support.   Is there
>     any way
>     > that we could use monetdb in python 3.2 before the official
>     package?
>     >
>     > Thanks again.
>     >
>     > Simon
>
>     --
>     | Stefan.Manegold@CWI.nl | DB Architectures   (DA) |
>     | www.CWI.nl/~manegold/  | Science Park 123 (L321) |
>     | +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |
>     _______________________________________________
>     users-list mailing list
>     users-list@monetdb.org
>     https://www.monetdb.org/mailman/listinfo/users-list
>
>

> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list


--
Niels Nes, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14,  phone ++31 20 592-4098     sip:4098@sip.cwi.nl
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes@cwi.nl

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list