×

Discussion Board

Results 1 to 8 of 8
  1. #1
    Registered User
    Join Date
    Feb 2007
    Posts
    1

    Smile Databases to use with Pys60

    Hello all,

    which databases I can use with pys60? sqlite ? symbian databases ?

    thanks for all,

    Ataliba

  2. #2
    Registered User
    Join Date
    Feb 2007
    Posts
    10

    Re: Databases to use with Pys60

    I feel symbian database because python module related for data management is written for symbian database



    Regards

    jillion

  3. #3
    Super Contributor
    Join Date
    May 2006
    Location
    Oulu, Finland
    Posts
    622

    Re: Databases to use with Pys60

    Hi ataliba,

    I think you could use both it just depend of you. The Symbian databases are ready to use, there shouldn't be any problems. I don't think that there has been any sqlite libraries ported for pyS60 (nothing that I can remember). But my first research on google gave me a link to a source code for Python 2.2 http://initd.org/tracker/pysqlite/wiki/pysqlite. You could give a trial to compile it for PyS60.

    After in term of performances I'm not sure which one would be the best. I think it also depends on how much data you have to store in you DB. Usually DB services are somewhere on a server, and you call some server scripts (php, jsp...) with some parameters to do what you have to do.

    I hope this helps.

    LFD
    Devices:
    Nokia E61 3rd Edition - pys60 1.4.0

    Tips and modules:
    http://www.lfdm.net/thesis

  4. #4
    Regular Contributor
    Join Date
    Apr 2004
    Posts
    107

    Question Re: Databases to use with Pys60

    Can I use existing databases, that were created with OPL on S80 9300i device?

  5. #5
    Regular Contributor
    Join Date
    Apr 2007
    Location
    Lublin, Poland
    Posts
    81

    Re: Databases to use with Pys60

    I'll allow myself to ask this in the current post:
    Is the PyS60 database implementation based on DBMS server? I.e. does it allow database sharing? It seems so, but some confirmation would be welcome.
    whatever happens happens

  6. #6
    Registered User
    Join Date
    Jun 2007
    Posts
    27

    Cool Re: Databases to use with Pys60

    Well, I had no experience with any kind of SQL or DBMS so i struggled with understanding e32db module. But I then found it easier to make my own database storing and query system and save it as a txt file.

    if you wanna know how just let me know. Basically you store key:value pairs with your own symbolic notation and then write a function to query by generating the key.

    It's not as easy as it sounds, because txt files store all the data as one string, and repeated .split() and .join() can introduce many unwanted characters and pollute the data.

  7. #7
    Regular Contributor
    Join Date
    Apr 2007
    Location
    Lublin, Poland
    Posts
    81

    Re: Databases to use with Pys60

    It's OK, I've used Symbian DBMS in C++ before. I was just curious whether databases created by Python e32db implementation can be shared or not (i.e. are they called through the server system or directly), but some tests show they can.
    Out of curiosity (again), do you support JOIN queries?
    whatever happens happens

  8. #8
    Super Contributor
    Join Date
    Dec 2004
    Posts
    643

    Re: Databases to use with Pys60

    The Symbian DBMS doesn't support JOINs, unfortunately.

Similar Threads

  1. Does PyS60 have Infrared module?
    By bandz_fab in forum Symbian
    Replies: 5
    Last Post: 2008-09-08, 13:52
  2. Does PyS60 have infrared or IrDA support?
    By bandz_fab in forum Symbian
    Replies: 3
    Last Post: 2007-11-25, 10:55
  3. Compiling Pys60 for other platforms
    By cassioli in forum Symbian
    Replies: 7
    Last Post: 2007-03-04, 16:58
  4. Replies: 2
    Last Post: 2007-02-19, 17:05
  5. Replies: 0
    Last Post: 2006-03-06, 11:56

Posting Permissions

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