×

Discussion Board

Results 1 to 14 of 14
  1. #1
    Registered User
    Join Date
    Nov 2008
    Location
    Egypt
    Posts
    122

    Is there a flashlite database like sqllite?

    Hello,
    I'm using XML files to store my data, is there another way to do this, like SQL lite or something?? Thank you.

  2. #2
    Registered User
    Join Date
    Nov 2010
    Posts
    31

    Thumbs up Re: Is there a flashlite database like sqllite?

    Quote Originally Posted by elshorbagy76 View Post
    Hello,
    I'm using XML files to store my data, is there another way to do this, like SQL lite or something?? Thank you.
    Hello elshorbagy76,
    If you want to store a data in something other place.
    Could be used .xls and .mdb files.

    Thanks.

  3. #3
    Regular Contributor
    Join Date
    May 2007
    Location
    Finland
    Posts
    134

    Re: Is there a flashlite database like sqllite?

    Quote Originally Posted by abhi6492@gmail.com View Post
    Could be used .xls and .mdb files.
    Very funny...

    If your data is stored on the server side, I suggest using a HTTP API to talk to the database. You can also do this so that it works on the device and you use localhost to access it.

  4. #4
    Registered User
    Join Date
    Nov 2008
    Location
    Egypt
    Posts
    122

    Re: Is there a flashlite database like sqllite?

    Could be used .xls and .mdb files.
    Why don't you try SQL server or Oracle database on Nokia devices, it works fine.

    If your data is stored on the server side
    no I'm storing my data on mobile phone. But thanks

  5. #5
    Registered User
    Join Date
    Nov 2010
    Posts
    31

    Re: Is there a flashlite database like sqllite?

    Why don't you try SQL server or Oracle database on Nokia devices, it works fine.
    Yes,
    It is. But, it's own choice.
    You could opened MS Access, MS Excel, FoxPro, dBase, File Maker Pro and any ODBC Compliant Database like Oracle, SQL Server on symbian based Mobile phone.
    By using Mobile Database Viewer Plus application.
    It's providing by ovi store.

  6. #6
    Registered User
    Join Date
    Nov 2008
    Location
    Egypt
    Posts
    122

    Re: Is there a flashlite database like sqllite?

    It is. But, it's own choice.
    You could opened MS Access, MS Excel, FoxPro, dBase, File Maker Pro and any ODBC Compliant Database like Oracle, SQL Server on symbian based Mobile phone.
    By using Mobile Database Viewer Plus application.
    It's providing by ovi store.
    Actually I thought you were joking .
    Where is that mobile Database? How can I download it?

    Thank you

  7. #7
    Regular Contributor
    Join Date
    May 2007
    Location
    Finland
    Posts
    134

    Re: Is there a flashlite database like sqllite?

    I thought this thread is about using an on device database from Flash Lite?
    Last edited by Risalmin; 2010-12-16 at 11:34.

  8. #8
    Registered User
    Join Date
    Nov 2008
    Location
    Egypt
    Posts
    122

    Re: Is there a flashlite database like sqllite?

    Yes, I want to use a database from Flashlite. What I understand here is that I can open database from flashlite through ODBC drivers.

  9. #9
    Nokia Developer Champion
    Join Date
    Jul 2008
    Location
    Pakistan
    Posts
    1,065

    Re: Is there a flashlite database like sqllite?

    Hi elshorbagy76,
    I used MySQL in one of my Flash Lite project. Flash Lite application can pass variables to PHP via GET or POST client requests and PHP can easily interact with MySQL database. It may helps if you wish to save/retrieve data via network .Here is an article which may helps you in this case :
    Flash Lite + PHP + MySQL

    Best Regards,
    SajiSoft

  10. #10
    Regular Contributor
    Join Date
    May 2007
    Location
    Finland
    Posts
    134

    Re: Is there a flashlite database like sqllite?

    So in this case you need to also create a server, running php adn MySQL on the device and connect to it using http://localhost/ ;o)

  11. #11
    Nokia Developer Champion
    Join Date
    Jul 2008
    Location
    Pakistan
    Posts
    1,065

    Re: Is there a flashlite database like sqllite?

    No need to add PHP functionality to the server then :P. Simply , create a local server that accepts the request, communicate with the MySQL and returns the response. But i must say Qt is far easy to use in this case.

    Best Regards,
    SajiSoft

  12. #12
    Registered User
    Join Date
    Nov 2007
    Location
    Ibadan, Nigeria
    Posts
    214

    Re: Is there a flashlite database like sqllite?

    Quote Originally Posted by sajisoft View Post
    No need to add PHP functionality to the server then :P. Simply , create a local server that accepts the request, communicate with the MySQL and returns the response. But i must say Qt is far easy to use in this case.

    Best Regards,
    SajiSoft
    I thought this thread was relating to developing a clientside in-device database,. *not* a serverside network-based one ?
    - David

  13. #13
    Nokia Developer Champion
    Join Date
    Jul 2008
    Location
    Pakistan
    Posts
    1,065

    Re: Is there a flashlite database like sqllite?

    I thought this thread was relating to developing a clientside in-device database,. *not* a serverside network-based one ?
    If you read my post (# 11) again then u will surely come to know that i am talking about a in-device database system not a network-based database system or may be i m not very much clear. Actually, in Flash Lite there is no such API which allow one to directly write or read SQL or MySQL etc Even we cant write to a text file using Pure AS in Flash Lite. So, what we have to do is to choose a language which provide these functionalities on device and then integrate that language with our Flash Lite Application.To integrate/Bridge Flash Lite with any such language we have two known ways i.e either create a local http server or local xml socket server like we have API Bridge which is nothing but a Local HTTP Server written in Symbian C++ that allow Flash Lite to access more platform services via HTTP requests.
    Yes! if we need something simple then i dont have anything as simple as local sharedObjects in mind and if i have to write any such application which allow Flash Lite to access MySQL without network then i will surely go for creating Local HTTP Server in Symbian C++ of mine or write an extension for the API Bridge because it is somewhat easy then creating the whole server. Hope its helps someone

    Best Regards,
    SajiSoft

  14. #14
    Regular Contributor
    Join Date
    Feb 2005
    Location
    Karachi, Pakistan
    Posts
    277

    Re: Is there a flashlite database like sqllite?

    Hi,

    Python for S60 have APIs for on-device DB which is available from Symbian OS. It's a limited kind of DB, but basic SQL queries work fine. Of course this can be done using Symbian C++ or Qt.

    But I favor Python for S60 as Flash Lite developers are not really expert with C++ and setting up the SDKs is quite a hassle (excluding Qt )

    // chall3ng3r //
    Faisal Iqbal (skype: chall3ng3r)
    Flash Mobile Specialist | Orison Technologies
    _____________________________________
    blog: F·L·A·S·H·I·S·M
    swf2go: www.swf2go.com

Similar Threads

  1. Replies: 2
    Last Post: 2010-11-09, 21:00
  2. Replies: 4
    Last Post: 2009-12-19, 15:35
  3. Limitation/Difference between standlone flashlite app & Webpage embedded flashlite ap
    By msathiskumar in forum [Archived] Flash Lite on Nokia Devices
    Replies: 7
    Last Post: 2009-03-16, 17:20
  4. SQLLITE & symbian os
    By debasish1234 in forum Symbian
    Replies: 4
    Last Post: 2005-03-19, 07:03

Posting Permissions

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