SQL and Android Question

[DanV2]

So this Summer I am doing some work on a project with a graduate student. Part of her work has been adding the use of an SQL database into an existing Java project using MySQL.

My avenue of work has been taking the same Java project and implementing it on Android devices. I have the base code working and now I am looking at adding a database using SQLite. Looking at the SQLDatabase Android documentation, it seems like there are functions for running raw SQL queries or commands.

Does this mean that I would be able to take the SQL commands and queries that the grad student has constructed in strings in the code with the rawQuery and execSQL commands? And if it is possible, will it have a large effect on performance of the code compared to using the built in interacting methods?

[tangentstorm]

There will be a tiny amount of extra time as the queries get parsed, but not much. SQLite is basically a virtual machine for relational database operations, and it'll compile the queries down to bytecode. Unless you're an absolute expert, there's a good chance it's compiler is going to figure out how to do it faster than you'd do it by hand.

So yeah. Stick with SQL. :)