×

Discussion Board

Results 1 to 4 of 4
  1. #1
    Registered User
    Join Date
    Jan 2010
    Posts
    2

    Question Is there a way you can use sqlite from python?

    First of all sorry for my English.

    I've been looking for information on this forum about this issue but all I found well-formulated questions and few answers.
    The question is: is there a way to use sqlite from a program in Python (PyS60)?
    I had an import error when i did "import _sqlite3" (I'm using PyS60 1.9.7 and working on Nokia 5800 XpressMusic)
    I can not find any library in series 60 to make the binding between PyS60-Sqlite (as APSW, pysqlite ,...).
    Does anyone know about a project to make this binding?

    Thanks in advance
    Last edited by ttlaoc; 2010-01-19 at 11:09.

  2. #2
    Super Contributor
    Join Date
    Nov 2007
    Location
    Sertaozinho/Brazil
    Posts
    768

    Re: Is there a way you can use sqlite from python?

    Hello ttlaoc, welcome a board !

    How about e32db ? It is an option.
    http://pys60.garage.maemo.org/doc/s60/module-e32db.html

    Some useful wiki links about it:
    http://wiki.forum.nokia.com/index.ph...uide_for_PyS60
    http://wiki.forum.nokia.com/index.php/How_to_use_SQL

    And discussions:
    http://www.forum.nokia.com/forum/sho...d.php?t=163351 (pure python alternative)
    http://discussion.forum.nokia.com/fo...d.php?p=686145 (limitations)

    Please, search wiki and dibo for more references.

  3. #3
    Registered User
    Join Date
    Jan 2010
    Posts
    2

    Thumbs up Re: Is there a way you can use sqlite from python?

    Thanks a lot for your information

    I had read these documents some days ago and I thought the situation might have changed.
    e32db is a very interesting tool but I'm trying to port an application and I need sqlite features.
    However, I hasn't used e32db yet and I should speak from experience (I rely on what I have read only), so I'll do some tests.

    I have reread my first post and I think it sounds a bit rude, sorry, I need practice with English

    Again thanks for everything and greetings.

  4. #4
    Super Contributor
    Join Date
    Nov 2007
    Location
    Sertaozinho/Brazil
    Posts
    768

    Re: Is there a way you can use sqlite from python?

    Quote Originally Posted by ttlaoc View Post
    e32db is a very interesting tool but I'm trying to port an application and I need sqlite features.
    Since sqlite is highly portable you can try to create an extension module for it, using C.
    Qt has sqlite as well, it can be an alternative if Python is not a requisite. See some examples here. Or you can sniff the Qt code and take a look in how they have ported sqlite to Qt.

Similar Threads

  1. Please help installing Python libraries on S60
    By ericroijen in forum Symbian
    Replies: 11
    Last Post: 2009-07-18, 10:43
  2. Python for S60 1.9.4 is now released
    By tvijayan in forum Symbian
    Replies: 9
    Last Post: 2009-05-27, 10:39
  3. Python for S60 1.9.3 released
    By tvijayan in forum Symbian
    Replies: 40
    Last Post: 2009-04-03, 15:00
  4. Python for S60 1.9.2 released
    By tvijayan in forum Symbian
    Replies: 26
    Last Post: 2009-03-11, 09:28
  5. Python for S60 1.9.0 released
    By tvijayan in forum Symbian
    Replies: 48
    Last Post: 2009-01-27, 15:39

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
×