OESF | ELSI | pdaXrom | OpenZaurus | Zaurus Themes | Community Links | Ibiblio

IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Pysqlite Ipk?
wheaties.box
post Nov 4 2007, 08:36 PM
Post #1





Group: Members
Posts: 4
Joined: 4-November 07
Member No.: 20,897



Hi! I'm new to this site (obviously). I've recently installed python on my sl-5500 and I'm looking to develop some programs using sqlite. I've also installed the sqlite3_8.0.6.ipk (or something along those lines). Each time I try to do anything with sqlite, I'm told that I don't have pysqlite2. I know this is required, but I can't seem to find any ipk's for it anymore.

Does anyone have access to one or can you tell me where/how to get/build one?

Thanks!
Go to the top of the page
 
+Quote Post
freizugheit
post Nov 4 2007, 10:54 PM
Post #2





Group: Members
Posts: 409
Joined: 7-November 03
Member No.: 811



Try downloading sqlite-3.2.2 from http://www.killefiz.de/zaurus/showdetail.php?app=3874.

If it does not work, sqlite-3.0.8 from http://pyqplayer.sourceforge.net/cgi-bin/b...qPlayerDownload should work with Sharp ROM.
Go to the top of the page
 
+Quote Post
wheaties.box
post Nov 5 2007, 06:06 AM
Post #3





Group: Members
Posts: 4
Joined: 4-November 07
Member No.: 20,897



Thanks! I'll have to try that first link when I get home from work. The one I installed was from the second link. I hope it works! Even though I've had my Z since the day they were released, I'm still amazed at what it can do (and so are my friends biggrin.gif )

Thanks again
Go to the top of the page
 
+Quote Post
wheaties.box
post Nov 5 2007, 05:47 PM
Post #4





Group: Members
Posts: 4
Joined: 4-November 07
Member No.: 20,897



QUOTE(freizugheit @ Nov 4 2007, 11:54 PM) *
Try downloading sqlite-3.2.2 from http://www.killefiz.de/zaurus/showdetail.php?app=3874.

If it does not work, sqlite-3.0.8 from http://pyqplayer.sourceforge.net/cgi-bin/b...qPlayerDownload should work with Sharp ROM.

Dang it!!! The first link has a dead link to the ipk, and the second one doesn't seem to allow my python to use sqlite. Any ideas?
Go to the top of the page
 
+Quote Post
freizugheit
post Nov 5 2007, 06:14 PM
Post #5





Group: Members
Posts: 409
Joined: 7-November 03
Member No.: 811



Sqlite-3.2.2. is attached.
Attached File(s)
Attached File  sqlite3_3.2.2_arm.zip ( 351.85K ) Number of downloads: 13
 
Go to the top of the page
 
+Quote Post
wheaties.box
post Nov 5 2007, 06:41 PM
Post #6





Group: Members
Posts: 4
Joined: 4-November 07
Member No.: 20,897



QUOTE(freizugheit @ Nov 5 2007, 07:14 PM) *
Sqlite-3.2.2. is attached.

thanks! I'm still having issues getting it all to work, but my wife won't let me play with it any more tonight... maybe I'll be able to post more details tomorrow.
Go to the top of the page
 
+Quote Post
misha
post Feb 9 2008, 11:31 PM
Post #7





Group: Members
Posts: 7
Joined: 9-October 07
Member No.: 20,805



Hello,

I've been playing with libsqlite3 and pysqlite2. I've tried two approaches:

1) Use existing IPK for libsqlite3
2) Build my own

First, let me describe my endeavours with option 1. I used the IPK from here. This IPK (and the others I have seen around) don't seem to include pysqlite2, so I decided to cross-compile it myself. When I was done, and moved everything across to the Zaurus, I wasn't able to run the tests from pysqlite2. I got this error:

CODE
ImportError:  /opt/QtPalmtop/lib/python2.4/site-packages/pysqlite2/_sqlite.so: undefined symbol: sqlite3_enable_shared_cache


I decided to have a peek at the libsqlite3.so and see what symbols are there:

CODE
misha@poseidon:~/Desktop/package$ nm opt/QtPalmtop/lib/libsqlite3.so | grep enable_shared_code


The symbol isn't there. It's not part of the .so that was in the IPK that freizugheit attached to this post, either. Can someone explain why this symbol missing? Is it something that's really needed -- I can't seem to run the tests without it.

At this stage, I decided to try option 2. I built libsqlite3 with:

CODE
./configure --disable-tcl --disable-readline --host=arm


It wasn't able to pick up my cross-compiler by default, but I was able to modify the output Makefile to point it to the right location. After moving libsqlite3 libs and includes to the proper location, it all built. The one thing I found curious is that it built libsqlite3.a and libsqlite3.la files instead of an .so -- this means it's building as a static library, as opposed to dynamically loaded, right? I'm not 100% clear on what needs to happen here -- could someone clear it up?

I was able to build pysqlite2 against the libsqlite3.a and deploy it all to the Zaurus. The tests work partially, hanging after a little while:

CODE
$ /opt/QtPalmtop/bin/python            
from Python 2.4 (#1, Jan  5 2005, 19:21:20)
[GCC 2.95.1 19990816 (release)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> from pysqlite2 import test
>>> test.test()
...............................................................


At this stage it hangs indefinitely.

Can someone suggest what the problem may be here? Thanks in advance.

Cheers and regards,
Misha

PS. wheaties.box, did you end up getting this to work?
Go to the top of the page
 
+Quote Post
rolf
post Feb 10 2008, 06:58 AM
Post #8





Group: Members
Posts: 108
Joined: 5-October 04
Member No.: 4,884



I suggest using openembedded.org for compilation
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 24th November 2014 - 09:57 AM