What is the best way to store SQL queries?

Question

Android

Good afternoon. Please share your experience where you store sql queries. I used to create interfaces or abstract classes in which I created String constants of the form

CREATE TABLE IF NOT EXISTS "post" 
("_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ,
 "link" TEXT NOT NULL UNIQUE , 
"read" BOOL NOT NULL )

And then in the derived class SQLiteOpenHelper did the following

@Override
public void onCreate(SQLiteDatabase db) {
       db.execSQL(SomeClass.SQL_CREATE_TABLE);
}

Perhaps there are some better ways to store the requests themselves? Perhaps in a separate sql file or in resources? Perhaps even as a string-array in resources, if you want to create several tables in turn?

Answer 1

I store it as a sql script, along with the source files of the program, under the CVS version control system.

Answer 2

Always store queries in the form of stored procedures (Stored Procedure) in the used DBMS.