Is there a flashlite database like sqllite?

[elshorbagy76]

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

[abhi6492@gmail.com]

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.

[Risalmin]

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.

[elshorbagy76]

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

[abhi6492@gmail.com]

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.

[elshorbagy76]

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

[Risalmin]

I thought this thread is about using an on device database from Flash Lite?

[elshorbagy76]

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

[sajisoft]

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

[Risalmin]

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)

[sajisoft]

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

[SoulBlade]

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 ?

[sajisoft]

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

[chall3ng3r]

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 //