#jython IRC Log


IRC Log for 2016-07-25

Timestamps are in GMT/BST.

[0:25] * AndyBotwin (~Gustavo@unaffiliated/andybotwin) has joined #jython
[0:42] * BillSussman (~Gustavo@ has joined #jython
[0:43] * AndyBotwin (~Gustavo@unaffiliated/andybotwin) Quit (Ping timeout: 276 seconds)
[1:05] * BillSussman (~Gustavo@ Quit (Quit: Leaving)
[1:46] * AndyBotwin (~Gustavo@ has joined #jython
[1:46] * AndyBotwin (~Gustavo@ Quit (Changing host)
[1:46] * AndyBotwin (~Gustavo@unaffiliated/andybotwin) has joined #jython
[3:25] * lopex (uid4272@gateway/web/irccloud.com/x-uvirmucrtvvbhthp) Quit (Quit: Connection closed for inactivity)
[7:40] * BillSussman (~Gustavo@ has joined #jython
[7:41] * AndyBotwin (~Gustavo@unaffiliated/andybotwin) Quit (Ping timeout: 244 seconds)
[8:08] * cyraxjoe (~joe@2607:f0d0:1103:106:e::12c) Quit (Ping timeout: 250 seconds)
[8:10] * cyraxjoe (~joe@2607:f0d0:1103:106:e::12c) has joined #jython
[10:14] * lopex (uid4272@gateway/web/irccloud.com/x-cwhnhpvkpeeiepma) has joined #jython
[12:34] * TomA (~TomA@c-68-32-46-223.hsd1.mi.comcast.net) Quit (Remote host closed the connection)
[12:34] * TomA (~TomA@c-68-32-46-223.hsd1.mi.comcast.net) has joined #jython
[13:11] * maucar (~maurizioc@c-24-62-42-67.hsd1.ma.comcast.net) has joined #jython
[14:12] * nickmbailey (~nickmbail@cpe-70-117-83-204.austin.res.rr.com) has joined #jython
[14:19] * xemdetia (xemdetia@nat/ibm/x-olzpuuhcyzdsvixb) has joined #jython
[14:20] * stewori (~stefan@ip-95-222-166-90.hsi15.unitymediagroup.de) has joined #jython
[14:42] <jimbaker> nickmbailey, i was hoping to look at that bug, but i spent the weekend relaxing instead
[14:43] <jimbaker> (a good choice)
[14:55] <nickmbailey> jimbaker: :) well i did the same in austin
[14:56] <nickmbailey> we're testing the fix mentioned in the ticket to see if it causes any other weirdness
[14:57] <jimbaker> nickmbailey, ok, sounds good. i will chat more after i conduct an irc meeting, and join in another
[14:58] <nickmbailey> heh k
[14:58] <jimbaker> #craton is keeping me busy
[15:12] * nickmbailey (~nickmbail@cpe-70-117-83-204.austin.res.rr.com) Quit (Remote host closed the connection)
[15:32] * nickmbailey (~nickmbail@aus.internal.datastax.com) has joined #jython
[15:32] * nickmbailey (~nickmbail@aus.internal.datastax.com) Quit (Remote host closed the connection)
[15:32] * nickmbailey (~nickmbail@aus.internal.datastax.com) has joined #jython
[15:35] * patoff (~patoff@unaffiliated/patoff) has joined #jython
[15:36] <patoff> Hi all, question: I install jython 2.7 (from standalone, installer and compile from source) and in all case sqlite3 module is never there (erroimport). this is on Kali linux. Any idea what could be missing?
[15:37] * KevinFrench (~Gustavo@ has joined #jython
[15:38] * BillSussman (~Gustavo@ Quit (Ping timeout: 260 seconds)
[15:52] <agronholm> patoff: yes, the sqlite implementation from jython
[15:52] <agronholm> (there isn't one)
[15:53] * TomA_ (~TomA@c-68-32-46-223.hsd1.mi.comcast.net) has joined #jython
[15:53] * TomA (~TomA@c-68-32-46-223.hsd1.mi.comcast.net) Quit (Read error: Connection reset by peer)
[15:55] <patoff> http://www.jython.org/docs/library/cpython_only/sqlite3.html isn't that suppose to work?
[15:55] <patoff> (it does on other pc)
[15:55] <agronholm> are you telling me this works on another pc on jython?
[15:55] <agronholm> this documentation was copied from cpython verbatim
[15:55] <agronholm> you can see the cpython_only part in the url, right?
[15:56] <agronholm> these docs are obsolete anyway (they say 2.5.2)
[15:59] <patoff> well sqlite3 is included: https://github.com/jythontools/jython/search?utf8=%E2%9C%93&q=sqlite3
[15:59] <patoff> but yeah it does work on a different pc, I got a module (nltk) that use sqlite3
[16:00] <patoff> it works on a ubuntu by adding a sys path sys.path.append("/home/USER/.local/lib/python2.7/site-packages/")
[16:00] <agronholm> the tests (also copied from cpython) cover sqlite3 but there is no such module there
[16:00] <patoff> doing the same on the other pc just doesn't
[16:00] <patoff> kk
[16:00] <agronholm> patoff: are you saying that importing sqlite in jython on the other pc works?
[16:00] <agronholm> (sqlite3)
[16:03] <agronholm> patoff: what is your reason for using jython instead of another python implementation?
[16:05] <patoff> Using python inside burp suite product which use jython
[16:05] <agronholm> I see
[16:05] <patoff> like I said it works, for unknown reason when adding path on one pc and not the other so weird
[16:06] <agronholm> it's not possible for it to work on jython because sqlite3 has not been implemented in its standard library yet
[16:06] <agronholm> what path did you add?
[16:07] <patoff> so maybe I got a package that got update with sqlite3 without me knowing that could be a reason
[16:07] <patoff> path is paste above
[16:08] <agronholm> uh, what paste
[16:08] <patoff> [11:59] <patoff> it works on a ubuntu by adding a sys path sys.path.append("/home/USER/.local/lib/python2.7/site-packages/")
[16:09] <agronholm> there is an sqlite3 package there?
[16:11] <nickmbailey> we just use a jdbc sqlite lib on jython for sqlite access
[16:11] <nickmbailey> fwiw
[16:11] <jimbaker> yeah, that works quite well
[16:11] <agronholm> yup, until you want to use ORMs :)
[16:11] <jimbaker> the only challenge is the python sqlite module in the stdlib
[16:11] <nickmbailey> this one specifically https://github.com/xerial/sqlite-jdbc
[16:12] <nickmbailey> yeah our usage is pretty simplistic
[16:12] <nickmbailey> no orm needed
[16:12] <jimbaker> which as agronholm points out
[16:12] <patoff> Yeah think it is really a package I' m using which has been upgrade to use sqlite3 :(
[16:12] <jimbaker> is what python code tends to depend on
[16:12] <patoff> was in the wrong direction thinkin gsqlite3 was working because of that page: http://www.jython.org/docs/library/cpython_only/sqlite3.html
[16:13] <patoff> will try to downgrade and see the diff
[16:13] <patoff> Thanks for the help, been trying to make sqlite works for hours... lol
[16:17] <jimbaker> patoff, it will require approx a week of someone's time to implement, just to compare with your hours spent
[16:17] <jimbaker> (hoping someone will do it!)
[16:18] <patoff> Yeah
[16:18] <patoff> thought that because sqlite3 is core of python it will work
[16:18] <jimbaker> patoff, it depends on C code
[16:19] <jimbaker> so it has to be rewritten to at least have those C parts in python, using java apis from something like xerial
[16:19] <jimbaker> http://bugs.jython.org/issue1682864
[16:19] <jimbaker> (one of the oldest bugs in jython, based on that id)
[16:20] <patoff> Hahaha
[16:20] <patoff> Will keep it in reference in my code and when it is resolve other lib could be upgraded
[16:22] <agronholm> patoff: does the lib directly require the sqlite3 module?
[16:22] <agronholm> if not, sqlalchemy with zxjdbc could be used instead
[16:22] <agronholm> oh wait, no
[16:23] <agronholm> doesn't work with sqlite
[16:26] <patoff> yeah even that would be a pain adjusting it
[16:32] <stewori> Maybe you can use JyNI for the C-part, on linux it's at least worth a try.
[16:33] <stewori> And if it fails, share your finding in an issue on https://github.com/Stewori/JyNI
[16:33] * stewori (~stefan@ip-95-222-166-90.hsi15.unitymediagroup.de) has left #jython
[16:34] <agronholm> or rpyc or execnet for the sqlite3 requiring parts
[16:53] * TomA (~TomA@c-68-32-46-223.hsd1.mi.comcast.net) has joined #jython
[16:53] * TomA_ (~TomA@c-68-32-46-223.hsd1.mi.comcast.net) Quit (Read error: Connection reset by peer)
[19:36] * jimbaker (~jbaker@python/psf/jimbaker) Quit (Ping timeout: 244 seconds)
[19:40] * jimbaker (~jbaker@ has joined #jython
[19:41] * jimbaker (~jbaker@ Quit (Changing host)
[19:41] * jimbaker (~jbaker@python/psf/jimbaker) has joined #jython
[19:41] * ChanServ sets mode +o jimbaker
[20:11] * maucar (~maurizioc@c-24-62-42-67.hsd1.ma.comcast.net) Quit (Quit: Leaving)
[20:18] * BillSussman (~Gustavo@ has joined #jython
[20:19] * KevinFrench (~Gustavo@ Quit (Ping timeout: 250 seconds)
[21:00] * stewori (~stefan@ has joined #jython
[21:06] * TomA (~TomA@c-68-32-46-223.hsd1.mi.comcast.net) Quit (Remote host closed the connection)
[22:02] * nickmbailey (~nickmbail@aus.internal.datastax.com) Quit (Remote host closed the connection)
[22:03] * nickmbailey (~nickmbail@aus.internal.datastax.com) has joined #jython
[22:05] * xemdetia (xemdetia@nat/ibm/x-olzpuuhcyzdsvixb) Quit (Ping timeout: 258 seconds)
[22:07] * nickmbailey (~nickmbail@aus.internal.datastax.com) Quit (Ping timeout: 250 seconds)
[22:14] * nickmbailey (~nickmbail@cpe-70-117-83-204.austin.res.rr.com) has joined #jython
[22:34] * stewori (~stefan@ Quit (Read error: Connection reset by peer)
[23:32] * stewori (~stefan@ has joined #jython
[23:35] <stewori> patoff: I sponataneously tested using sqlite with JyNI and it works out of the box (except some minimal configurational effort)
[23:36] <stewori> I was able to import it and complete this tutorial: http://www.tutorialspoint.com/sqlite/sqlite_python.htm
[23:37] <stewori> Only one glitch: Iterator-support is not yet fully implemented, instead of "for row in cursor:" one must currently use "for row in cursor.fetchall():"
[23:38] <stewori> however I am currently adding this iterator stuff to solve a numpy-issue, should be done in a couple of days. I will ensure that this sqlite-thing will also work then
[23:39] <stewori> For Kalif linux you might need to build JyNI yourself, but that isn't very hard. Get in contact with me if you need support on this front.


These logs were automatically created by JythonLogBot on irc.freenode.net using a slightly modified version of the Java IRC LogBot.