rogerbinns / apsw

Another Python SQLite wrapper
https://rogerbinns.github.io/apsw/
Other
739 stars 97 forks source link

Revise logging levels #518

Closed rogerbinns closed 6 months ago

rogerbinns commented 6 months ago

SQLITE_SCHEMA currently comes out at ERROR level, but is not an error. It is normal to happen when using FTS5. WARNING isn't even useful because the developer has no control over which statements are cached, reused, or when. Even INFO seems a little heavy handed, because there is nothing meaningful you can do about this message - it is how SQLite operates.

SQLITE_NOTICE_RECOVER_WAL should be at INFO level since it is not a warning or error. as with all other SQLITE_NOTICE prefix messages.