connect icon indicating copy to clipboard operation
connect copied to clipboard

Allow sqlite max_page_count to be set

Open subramanivmk opened this issue 1 year ago • 1 comments

Allow setting max_page_count pragma for sqlite. This acts similar to limit in memory buffer. Once set will limit the db size to page_size * max_page_count. While page_size pragma can also be set, it requires a new db or VACUUM to be done, and also the default 4096 is recommended. For ref: https://www.sqlite.org/pragma.html#pragma_max_page_count, https://www.sqlite.org/limits.html

I've thought of adding field similar to limit in memory buffer that takes in bytes. The conversions of bytes to page_count wont be exact and might be confusing on what value was set, i'e maxPageCount = limit / page_size; unless page_size is also modified. Feedbacks are welcome.

subramanivmk avatar Apr 13 '24 23:04 subramanivmk

CLA assistant check
Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
You have signed the CLA already but the status is still pending? Let us recheck it.

CLAassistant avatar Jan 27 '25 14:01 CLAassistant