SQLite and PRAGMAs
lazarus / 16-Databases

----------------------------------------------------------------------
Человек_Борща · 2015-06-18 20:53

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 · 2015-06-18 21:06

Quote from: Человек_Борща on June 18, 2015, 10:53:20 pmGreetings!

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.