SQLite and PRAGMAs

[Человек_Борща]

Greetings!

When I must setup PRAGMAs? At each loading the database?
{
Open connection
Direct execute PRAGMAs?
}

or when I'm creating a new database?

How I can query PRAGMAs values?
For example: FREELIST_COUNT.

[taazz]

Greetings!

When I must setup PRAGMAs? At each loading the database?
{
Open connection
Direct execute PRAGMAs?
}

or when I'm creating a new database?

How I can query PRAGMAs values?
For example: FREELIST_COUNT.

depends on the pragma you want to run but if I"m not mistaken most pragma are connection bound which means that you need to call them after each connection opens for all connection if you use multiple connections in your application. For better info just reference the pragma you are interested in.