How to check/limit a sqlite database size efficiently?

I would like to check the size of a SQLite database and if it is too big, it will notify the user to stop insert data into it.

But how could I check the total number of rows, or the file size of the database efficiently? It is good to have some O(1) method so that I could check for every insertion the user submitted.

I am working on Qt mainly for Windows.