Who and how are people using sql to access databases stored online on maemo. As far as i can tell sqlite is for local persistance only. I am looking for a solution to have remote persistance.

I am working with Qt in windows using madde, qt creator and qt simulator i have been trying to get the qmysql driver to work but cannot find the folder to compile. So that i can add it to the qtsimulator. Also if i try to do on device debuging qmysql still doesnt exist. So how can poeple easily download an app that access a database if it doesnt exist.

i searched apt for libqt4-mysql but this sseems to have broken dependancies and im unsure how to fix stuf like that. or even if i can.

The following packages have unmet dependancies:
libqt4-sql-mysql: depends: libmysqlclient15off but is not going to be installed

python-pygame : Depends: libsdl-ttf2.0 (>= 2.0.9) but is not going to be installed.

Solved broken dependancies were stoping the other packages installing removed the apps with the conflicting libarys and tryed to reinstall worked a treat.

Are you sure connecting to a remote MySQL db is the best approach for whatever it is that you want to achieve (on a higher level) ? Doing that over the internet (or over wifi that has untrusted [or more specifically: othan than 100% trusted] devices on it) has huge security implications (the connections are not encrypted by default).

So think carefully; why is the db remote and why are you accessing it via raw SQL (instead of for example using some sort of RPC protocol, if you have remote end you depend on you might as well offload some smarts there and hide implementation details [like which SQL server to use or how the tables are actually organized] behind a clean API).

yep this is kinda what i have done. i know have my remote database with php front end being accessed using qnetworkrequest. this is still not very suitable because of the security risks of sending readable http requests.

basicaly im trying to build my self a global highscore back end beacuse there seems to be no ready to go soultion like android and iphone.

security is going to be a big issue because hackers seem to find highscore tables fun to hack.

Any input on a more secure way to interact with the php or with the database would be greatly appriciated.

You can access the mysql server directly using an SSL connection, also give your mysql user accounts the minimal privileges needed to get the job done. Or you can use https if you want to continue using your php frontend.

Do not access the SQL directly there is no need and it adds complexity and dependencies to your app.

Use https to access the web frontend and at the very least use a hash to verify the POSTs, example:

name=Foobar
score=3489437
md5=<md5 of name, score and a secret string known to the app and the server>

Of course for open source software the secret isn't one much longer (and https protects just from casual network sniffing) and disassembly is always possible.

This is actually pretty hard problem to solve if supposing the attackers have resources and interest to throw at it.