Manage a local database without using queries

DangaTeo

Hi guys,
I would like to know if it was possible to manage a local database (.db) without using standard queries; for example to manage the creation or removal of tables and / or columns.

Thanks in advance.

jsulm

@DangaTeo What kind of local database?

DangaTeo

@jsulm Thank you for your reply; in my case it deals with simple SQLite database file, stored in local machine. At the moment i'm able to load this file in QSqlDatabase object with setDatabaseName public method.

JonB

@DangaTeo
OK, then what do you mean/desire by " without using standard queries"? If you are using SQLite, you have to go through its query language....

You can still use that to execute statements like CREATE TABLE, DROP TABLE etc. via QSqlDatabase queries --- they don't have to be e.g. just SELECT. There are loads of examples out there in Google.

DangaTeo

@JonB ok alright, what i said earlier was just a test i was doing. But my question is whether Qt has a library available that can handle databases without going through sql?

JonB

@DangaTeo
In a word, no. If the database has some dedicated, non-SQL interface library you would have to use that directly.

SGaist

Hi,

Are you looking for an ORM like QxOrm ?

DangaTeo

Thanks a lot to everyone;
I was looking for something integrated into Qt;
@SGaist I had seen other similar libraries before, however the one you recommended to me seems very interesting, I will definitely take a look it.
Thanks again.